BI Architect Available for Consulting work

[CognosBiDivision]

SAM                                                          

Objective
To fulfill Business Intelligence needs of Customers as an Independent Contractor that can assist large and small customers with all of their BI needs. Services offered include on-site and off-site on hourly or fixed bid basis.

Professional Summary:
§   Over 12 years of IT experience in Software Application Design, Development, Testing, Documentation and implementation of data warehousing applications and experience in OLAP tools, with a focus on multi-dimensional database star schema modeling.
§   Established the BI division for the company. Contribution covered all aspects of the BI division from BI product evaluation, and recommendation through installation, administration, maintenance of Cognos, implementation of various BI systems for the company and also hiring, and training of team members.
§   Worked on Planning, Evolution and selection of BI software with Business Sponsors and Stakeholders to fulfill the growing needs of Strategic, Middle and Operational Management.
§   Installed, Configured and Administered of Cognos series 8 / 10 Suite.
§   Installed, Configured and Upgraded Cognos under Windows and Linux environments. Employed Windows Server 2008/R2 and Red Hat Linux ver 5.0
§   Installed, Administered and Supported Cognos for multiple environments such as Production, Development, QA and Staging environment, and Corporate Training environments.
§   Architect the BI Cognos environment of the Cognos software versions 8.3, 8.4 and 10.1 in both Linux and Windows environments.
§   Expertise with Cognos tools such as Cognos 10.1/8.4.1/8.4/8.3 Business Intelligence, ReportNet 1.1 (Framework Manager, Report Studio, Query Studio, Analysis, Event Studio, Data Manager) Cognos Series 7.3 (Impromptu, Power Play; Impromptu Web Reports (IWR), Access Manager, and Server Administration on Enterprise, Upfront and IWR Servers).
§   Designed and analyzed Business and Technical BI Models
§   Well-versed in developing reporting applications using Cognos 8 Business Intelligence components like Framework Manager, Report Studio, Query Studio, Analysis Studio, Metrics Studio, event studio, and Cognos Connection.
§   Deliver advanced / complex reporting solutions such as Dashboards and Standardized Reporting (including the bursting of reports globally) using Cognos. Created complex Dashboards with Area charts, Pie charts, Cross tabs and Multi prompts in Report Studio.
§   Developed Framework Manager models against relational model and dimensional models – (layers, star schema, cardinality, relationships, query subjects), create and publishing packages.
§   Extensive experience in developing multidimensional OLAP cubes in power play transformer using various data sources and published in Cognos connection.
§   Experience in Report Authoring using cascading prompts, conditional formatting, drill-through reports, bursting and HTML Scripting.
§   Responsible for designing and developing Schemas using Entity Relationships, Data Modeling, Normalization, creating Tables, Views, Indexes, Sequences and coding.
§   Extensive knowledge in various Internet related platforms with specialization in SQL, PL/SQL, VB, HTML, DHTML, and XML.
§   Working knowledge on ETL tools like Informatics, SSIS, Data stage in designing data warehousing.  Good knowledge in Business insight and Cognos 10. Knowledge in Cognos planning Application (TM1).
§   Provided Training on BI to new team members and end users alike.
§   Strong Inter personal communication skills, Ability to provide appropriate attention to details and effective troubleshooting skills, and ability to work in a team.