Summary

• A team leader, Business Analyst, Cognos software Developer and Administrator possessing over 12 years experience.
• Exceeding experience with report writing Dashboard reports, Multi tab etc. , cube development, administration, upgrading, modeling and the full lifecycle of Cognos products.
• Possesses extensive knowledge working with Cognos migration and conversion projects and tools as well as user training skills.
• Demonstrates excellence in interpersonal and conceptual skills with a professional service oriented attitude.
• Develops business solutions that synthesize business needs into practical design.
• Strong analytical, problem solving and design abilities.
• Quick to learn local tools and possesses self-study discipline.
• Works effectively as a group member or a team leader and nurtures a cooperative effort.
• Displays high sense of urgency and responsiveness to client needs.
• Recognizes how various phases of project depend on one another.

Technical Skills

Professional Experience:

Confidential

Sr. BI Cognos Specialist

• Responsible for converting Cognos 7 AM to AD security in Cognos BI 8.x and Cognos 10.1.
• Designed/Migrated/Installed Cognos BI 8.3 to Cognos BI 8.4 64-bit as well as Upgraded to Cognos BI 10.1 64-bit in Windows 2008 64-bit development, quality assurance, disaster recovery, testing and production environments including SSO, IIS7, Fix Packs and customization
• Created and updated Cognos 8.x and Cognos 10.1 models using Framework Manager
• Published packages and managed the Cognos Portal including security
• Managed team members as well as gathered requirements, documented and created quarterly and annual Statutory and Statistical reports for finance/legal departments on an ongoing bases.
• Trained US employees on Cognos reporting in class and using web technologies.
• Troubleshooted issues and managed smooth daily operations, help desk tickets in reporting as well as in regard of the whole Cognos BI environment.

Confidential

Sr. BI Consultant

Role: Cognos 8.3 Migration Project Manager

• Installed Cognos 7.4 and 8.3 servers for migration project. Used migration tools migratetoc8 and deploytoc8 for the process of migrating Impromptu catalogs, Framework Manager models, Impromptu reports.
• Migrated cubes from Cognos 7.3 to Cognos 8.3.
• Conducted pilot testing and created all documentation, templates, and project plan.
• Led daily tasks and operations of project including coordinating and supervising work between onsite/offshore teams and managers.
• Utilized SQL queries to test, verify, optimize and debug migrated report outputs as well as unit tested reports and cubes.
• Coordinated deployment of all objects migrated from the Cognos 8.3 Development environment to QA and Production environments.

Project Technologies: Cognos BI 8.3, Framework Manager 8.3, Transformer 8.3, IIS 6, Impromptu 7.4 and 7.3, Transformer 7.3 and 8.3, Cognos migration tools 7.4 and 8.3, SQL scripting

Confidential

Role: Cognos 8.3 Content and Server Administration, Report Author, Framework Manager and Transformer Consultant/Trainer

• Installed all web and client Cognos 8.3 application components in a multi-server environment.
• Created customized training material and developer/user manuals for Cognos 8.3 Content and Server Administration, Report Author, and Transformer trainings for SDPBC that has 15000 users and over 65 servers for the Cognos Production environment.
• Based on their existing model, created multiple Dashboard and Multi-tab reports to demonstrate how they can be developed in Cognos 8.3. and conducted Cognos 8.3 Content and Server Administration, Report Author, Transformer and Framework Manager trainings.
• Supervised and troubleshooted the installation of the development environment completed by two of the client employees.

Project Technologies: SQL Server 2005, Cognos BI 8.3 Suite, Dashboard and Multi-tab reporting, Framework Manager 8.3, Relational and Dimensional modeling, Star and Snowflake Schema, DW concepts, Metrics Designer 8.3, Data Modeler 8.3, Transformer 8.3, ReportNet, IIS 6, SQL queries

Confidential

Role: Cognos Consultant

• Collected and revised report requirements from business for new Financial Report package.
• Designed database tables based on reporting needs. Analyzed and debugged data issues using SQL queries.
• Applied additional tables, joins, folders and calculations to Impromptu catalog, created new reports and published and tested functionality and data.
• Troubleshooted issues with transformer models and cube builds.

Project Technologies: SQL Server 2005, Star Schema, Impromptu, IWR, Upfront, PPES, Transformer, SQL queries

Confidential

Cognos Administrator - Consultant

• Involved in extensive debugging and analysis of data and report issues using SQL queries.
• Acted as a Cognos Administrator for a Series7 and Series8 environment with over 1800 users, more than 300 Impromptu Web Reports and 35 PowerCubes and Scorecards.
• Maintained system and server performance, including disk usage, memory monitoring, services, statistic reporting etc. on an AIX platform.
• Published all reporting objects to Cognos7 and Cognos8 Production environments, including deployment through Development and Quality operating on Unix.
• Configured and documented servers and components. Managed all Cognos environments, including security. Synchronized production and development Directory Servers.
• Troubleshooted Cognos environment issues and documented and tracked issues for root cause identification and resolution.
• Managed Impromptu catalog folders for 18 catalogs and created Framework Manager Relational and Dimensional models using Oracle 10g DW as a data source.

Confidential

Role: Business Analyst

• Performed as a Cognos Technical Business Analyst as part of the Report Framework Team for the G2 Technologies global Merck project.
• Worked with Business Analysts from across the company to gather, revise and create Functional Report Specifications along with converting them into Report Design Specification documents by creating the design, layout, data source of ReportNet and executive Dashboard reports.
• Implemented Framework Manager Models and created various types of reports.
• Coordinated work and resolved tasks between all teams involved.

Confidential

Role: Cognos8 Consultant

• Led effort of revising and authoring report requirements/documents for the Inventory report package.
• Designed and created Framework Manager Relational and Dimensional Models as well as assessed, resolved, and implemented changes that had to be prepared in an MS SQL Server 2005 Database.
• Created drill-through, drill-down and Dashboard reports.

Project Technologies: SQL Server 2005, Star and Snowflake Schema, Cognos BI Version 8.1 Suite and Framework Manager 8.1, Crystal

Confidential

Role: Cognos Consultant

• Defined business and functional requirements and developed Product Satisfaction Survey reporting package.
• Revised and authored Impromptu and PowerPlay reports obtaining requirements from internal customers. involving data mining, troubleshooting, data testing and resolving data issues using SQL queries. Performed unit testing of reports.
• Designed cubes and drill through reports for analyzing and picking statistical information, trends and patterns from data.

Project Technologies: PowerPlay 7.3, PowerPlay Enterprise Server 7.3, PowerPlay Transformer 7.3, IWR 7.3, Impromptu Administrator 7.3, Cognos Upfront

• As part of a team, responsible for authoring Impromptu 7.3 and PowerPlay 7.3 reports using high and low level business requirement documents.
• Performed data testing, applied customer feedback to all reports.
• Solely in charge of creating, maintaining and updating Impromptu catalogs using Oracle 9i as the source DW.
• Designed and managed all formatting standards applied to standard report sets of whole company.
• As a team member, created and managed Upfront security.