SUMMARY

• Nine plus years of IT experience in analysis, design, development, customization, testing and implementation of Data Warehousing and Business Intelligence applications.
• Experience in complete Software Development Life Cycle (SDLC) using Agile and Waterfall models.
• Very strong in data warehousing concepts including dimensions, facts, star schema, and snowflake schema.
• Extensive hands on experience in Installation, Configuration and Administration of IBM Cognos BI products.
• Experience in building Complex Framework Manager Models including Relational and DMR (Dimensionally Modeled Relational) and publishing packages to Cognos connection.
• Experience in building multi - dimensional models and OLAP Power Cubes using Cognos PowerPlay Transformer.
• Experience in implementing various Cognos features like creating filters, prompts, macros, drill-through, master-detail, drill-up and drill-down, report bursting, page sets, HTML objects.
• Experience in writing complex SQL queries, performance tuning, and troubleshooting in Oracle, DB2 and SQL Server database management systems.
• Experienced in Administrator tasks such as creating data source connections, publishing packages, scheduling reports, creation of users and groups, assigning security and deployment of packages/reports in different environments.
• Experience in building various types of reports including List, Cross-tab, Chart, Repeater, Dashboards, Scorecards, and other complex uneven pattern layouts.
• Experienced in Migrating reports from Cognos 7 series to IBM Cognos 8/10 BI and upgraded the models/reports from ReportNet to IBM Cognos 8/10 BI.
• Experienced in Leading the team and Managed the offshore & onsite Model.
• Experience in executing in fast-paced environment with tight deadlines.
• Professionally trained in Virtual View Manager 10, IBM Cognos Planning, TM1, Dynamic Cubes, Cognos Analytics, Tableau and knowledge in SAP Business Objects.
• Competent in Presentation, Documentation, Training and Support.
• Excellent written & oral communication skills and ability to learn things quickly.

TECHNICAL SKILLS

Business Intelligence Tools: IBM Cognos Suite 8/8.2/8.4/10.1/10.2 (Business Insight, Business Insight Advanced, Query Studio, Report Studio, Analysis Studio, Event Studio, Power play Studio, Metric Studio, Framework Manager, Cognos Connection, Cognos Configuration, OLAP Builder, Power play Client), Cognos 7.3,7.4 (Impromptu, Power play, Transformer, Upfront, Access Manager), Report Net 1.1, Upgrade Manager

Operating System: Windows 2008/2003/2000/ NT/XP/7, Unix

ETL Tools: Data Stage, Informatica Power Center

RDBMS: Oracle 7.x/8i/9i/10g, MS Access, MS SQL Server, DB2

PROFESSIONAL EXPERIENCE

Confidential, Suwanee, GA

Cognos Consultant

Responsibilities:

• Collaborate with Business Analysts and end users in gathering the requirements.
• Analyze the requirements and Build Framework models/packages to meet business requirements.
• Design and develop complex multi-object reports/dash boards using lists, cross-tabs, charts, visualizations, etc.
• Explicitly used complex HTML/Java scripts to meet the customized business requirements.
• Tune the performance of reports for optimization.
• Research and provide technical solutions to the outstanding issues and document the solutions.
• Provide guidance on best practices for setting up and deploying Cognos reporting solutions.

Environment: Windows 7, IBM Cognos 10.2.2 Framework Manager, Report Studio, Query Studio, Cognos Connection, SQL Server, DB2

Confidential, Bloomington, IL

Solution Designer

Responsibilities:

• Responsible for delivering the Proof of Concepts for Cognos BI Solutions and overall technical implementation of multiple BI projects in parallel.
• Analyze the requirements, lead and provide the technical direction to Cognos development team in converting SAP Business Objects reports to IBM Cognos 10.
• Lead the Cognos conversion project and coordinate with onsite-offshore teams.
• Establish the new Cognos environment/ architecture and implement scheduling through Control M, bursting, archiving to Control D system and Cognos Content archival features.
• Create Control M jobs for scheduling based off the events triggered from ETL using Cognos SDK.
• Build Framework Manager models and Transformer Cubes that meets business requirements.
• Design/develop complex reports and dashboards like burst, drill-through, multi-tab and customized reports with prompts as per Business Objects requirements.
• Build and publish Powerplay Cubes and create the Power play reports for analysis.
• Research and provide technical solutions to the outstanding issues and document the solutions.
• Provide guidance on best practices for setting up and deploying Cognos reporting solutions.
• Coordinate the meetings as needed to plan, develop and document the implementation plan.
• Train/mentor other the BO team as appropriate to facilitate Cognos professional development

Environment: Windows 7, IBM Cognos 10.2.2 Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos Connection, Power play Transformer, Power play Studio, Cognos BI OLAP Builder 10.2.2, Power play Client, Business Objects XI 3.1 suite, DB2

Confidential, P eoria, IL

Senior Cognos Developer

Responsibilities:

• Performed requirement analysis, designed and documented the report requirements and created micro design document for the project.
• Built Framework models/packages using stored procedures to meet business requirements.
• Designed and developed complex multi-object reports/dash boards using lists, cross-tab, charts, drill-through functionalities.
• Explicitly used complex HTML/Java scripts to meet the customization of business requirements.
• Tuned for the performance of reports for optimization.
• Worked closely with the business in resolving the outstanding issues.

Environment: Windows XP, IBM Virtual View Manager 10, IBM Cognos 10.1 Report Studio, Business Insight, Business Insight Advanced, Framework Manager, Cognos Connection, DB2, Oracle

Confidential, M emphis, TN

Lead Cognos Developer

Responsibilities:

• Led and mentored the onsite/ offshore teams to implement Cognos BI solutions.
• Designed and developed the models/packages and built dashboards/complex reports using Java to accommodate the advanced features like Dynamic Column Sorting, Expand/Collapse.
• Deployed the Cognos packages /reports from one environment to other.
• Tuned the performance of the reports and tested for the User Acceptance.
• Provided user trainings and demonstrated the advanced Cognos features to the business users.

Environment: Windows XP, IBM Cognos Suite 8.4, Oracle 10g, DB2.

Cognos Developer

Responsibilities:

• Extensively worked on troubleshooting, researching product related issues and provided technical solutions.
• Fixed outstanding defects in existing reports and worked on the enhancements of reports.
• Tuned for the performance of the models/reports.
• Developed templates, standard reports, master-detail reports/dashboards and scheduled.

Environment: Windows XP, IBM Cognos Suite 8.4 (Query Studio, Report Studio, Analysis Studio, Framework Manager, Cognos Connection), DB2

Confidential, Detroit, MI

Cognos Consultant

Responsibilities:

• Lead and coordinated with the off shore team for migration activities.
• Migrated models/reports from Cognos Report Net environment to IBM Cognos 8.4 BI.
• Upgraded and modified the existing CRN models in Cognos 8.4 as per new requirements.
• Worked on optimization of upgraded models in IBM Cognos 8.4 BI environment and tuned the performance of the models/reports.
• Worked on analyzing existing framework models/reports and provided remediated solution for maintainability, scalability.

Environment: Windows XP IBM Cognos Suite 8.4 (Query Studio, Report Studio, Analysis Studio, Framework Manager, Cognos Connection, Cognos Configuration), Report Net 1.1, Oracle 9i/10g

Cognos Consultant

Responsibilities:

• Created a plan document to migrate from Cognos 7.3 series to IBM Cognos 8.4 BI and upgrade from Report Net 1.1 to IBM Cognos 8.4 BI.
• Troubleshoot and fix the existing Cognos environmental issues, models and reports.
• Worked on setting up new Cognos environment by creating data sources and deployed the packages/reports from one environment to other.
• Provided the documentation of full lifecycle of migration plan with various options that suits the existing client's architecture.

Environment: Windows XP, IBM Cognos Suite 8.4 (Query Studio, Report Studio, Framework Manager, Cognos Connection, Cognos Configuration), Cognos 7.3,7.4 (Impromptu, Power play, Transformer, Upfront, Access Manager), Report Net 1.1., SQL Server

Confidential, Foster city, CA

Cognos Consultant

Responsibilities:

• Worked on troubleshooting the existing Workforce analytics reports/models and documented technical details.
• Worked on creating standard reports and performed different levels of testing including System, Integration, Performance and User acceptance testing.
• Verified and validated the WFA reports against the database by creating ad hoc reports.
• Provided detail documentation of test results at each level of testing.

Environment: Windows XP/2003, IBM Cognos Suite 8.3 (Query Studio, Report Studio, Framework Manager, Cognos Connection, Cognos Configuration), Workforce Analytics, DB2

Confidential, Bloomington, IL

Cognos Administrator / Developer

Responsibilities:

• Tested and installed new releases, fixes, service packs and administered Cognos applications.
• Installed and configured various components of Cognos BI server on Windows sandbox and maintained the documentation for Cognos products.
• Provided 24/7 on call production support for the reporting applications.
• Handled service calls to provide technical support and root cause analysis to the users.
• Troubleshoot and researched product related issues and documented technical details.
• Migrated Impromptu 7.3 reports to IBM Cognos 8.2 BI.
• Created user accounts for Security purpose on Upfront and Cognos Connection.
• Implemented the full lifecycle of development methodologies, standards and procedures.
• Deployed the Cognos content from one environment to other and published Impromptu reports, power cubes and Power play reports to upfront.
• Developed multi-dimensional models in Powerplay Transformer and generated Power cubes.
• Designed and developed various Cognos multi-object reports that meets the user requirements and scheduled the reports/jobs to run periodically.
• Built Framework models/packages and published packages to the Cognos Connection.
• Developed Templates, standard Reports, Master Detail Reports, Multilingual Reports and Dashboards using Report Studio and Query studio.
• Tuned the performance of Cognos reports and tested for user acceptance.

Environment: Windows XP/2000/2003, IBM Cognos Suite 8.2 (Query Studio, Report Studio, Analysis Studio, Event Studio, Power play Studio, Framework Manager, Cognos Connection, Cognos Configuration), Cognos 7.3,7.4 (Impromptu, Power play, Transformer, Upfront, Access Manager), DB2

Confidential, Kent, OH

Cognos Developer

Responsibilities:

• Gathered report specifications from the end users and developed Cognos 8 BI reports.
• Used Framework Manager to build models/packages and published packages.
• Worked on creating complex multi-object reports using lists, crosstabs, and charts.
• Worked on developing the reports/dashboards using custom SQL to meet requirements.
• Scheduled reports and jobs to run periodically.

Environment: Windows XP, IBM Cognos Suite 8.2 (Query Studio, Report Studio, Analysis Studio, Framework Manager, Cognos Connection), Oracle.