SUMMARY:

• Over sixteen years of Professional Experience in IT Industry. Hands - on experience in gathering Business Requirements, high level Architectural Design for Information Delivery and Management. Extensive experience in developing Cognos 8 Framework Manager Models, Cognos 8 Report Studio Reports, Cognos 8 Query Studio Reports, Cognos 8 Analysis Studio, Informatica 7.1 and Actuate Tools.
• Extensive experience in developing Cognos 8 Framework Manager Models, Report Studio Reports, Query Studio Reports, Analysis Studio, Event Studio and Cognos Dashboards.
• Experience in publishing packages and reports to Cognos Connection.
• Extensive experience in creating portlets, dashboards, drill-thru reports.
• Experience in developing dimension maps and multidimensional cubes using PowerPlay Transformer.
• Experience in developing ETL mapping, mapplet and workflow using Informatica PowerCenter 7.1.
• Performing reporting requirements, analysis, creating document specifications, providing technical recommendations, and evaluating the performance of current reporting solutions.
• Created List, Sub and Cross-Tab reports using Report Studio.
• Ad-hoc/Parameterized Reports.
• Drill Down and Dashboard Reports.
• Graphical Reports using Cognos Charts.
• Reports with Cascade prompts.
• Excellent experience in C, C++, and C# .NET.
• Excellent experience in SQL Server, Oracle, ADO, Visual Basic, Visual Interdev.
• Extensively worked in Win32 APIs, User Interface Design and Windows Programming using VC++.
• Remarkable capabilities in analytical, logical, programming and interpersonal skills.
• Expertise in solid modeling, analytical geometry and graphics.
• Proven ability to analyze issues logically and provide solutions.
• Proven ability to interact, negotiate, and communicate with clients and staff at all levels.

TECHNICAL SKILLS:

Cognos 8.4 Tools: Report Studio, Query Studio, Framework Manager, Transformer, Power Play

Actuate Tools: eRD Pro 5.0, 6.0, 7.0, Mgmt Console, Active Portal, ADT, EDT, and Report Cast.

Informatica Tools: Informatica PowerCenter 7.1, Informatica Designer, Workflow Manager

Source Control Tools: MS Visual Source Safe, PVCS Version Manager, Clear Case

Languages: C, C++, Java and SQL/PLSQL

RDBMS: DB2, Oracle, MS SQL Server 2000, MS Access

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Cognos 10.2, Report Studio, MS Sql Server 2008

Responsibilities:

• Designing and creating SQL Server tables.
• Design, Development and Architecting new Data Models and Reports
• Created query subjects that are related to reports in Framework Manager.
• Responsible for migrating the upgraded objects from DEV to QA and PROD environment.
• Responsible for supporting issues on MS Sql Server, Cognos objects through out the UAT

Confidential

Environment: MS SQL Server 2008, Python 3.2.4, HTML5, Javascript

Framework Manager

Responsibilities:

• Managed the team to convert BMC, ELIFE, & PUBMED journals to EPUB format.
• Produced regular project status reports for review by IT and the business.

Confidential, Orlando, FL

Environment: Cognos 7.4, Cognos 8.2, MS Sql Server 2008

• Responsible for upgrade, testing and matching data towards the old system
• Responsible for design, development and architecting new Models and Reports
• Responsible for migrating the upgraded objects from DEV to QA and PROD environment.
• Responsible for supporting issues on Cognos objects through out the UAT process.
• Responsible for supporting issues on MS Sql Server, Cognos objects through out the UAT Responsible for migrating cognos objects from Cognos 7.4 to 8.2

Confidential, Carlsbad, CA

Framework Manager

Environment: Cognos 8.4, Cognos 10, Oracle 11, Exa Data

• Managed offshore team to migrate cognos objects from Cognos 8.4 to 10.1
• Design, Development and Architecting new Data Models and Reports
• Managed resources, schedules, risks and issues and set goals and objectives for obtaining customer satisfaction.
• Responsible for migrating the upgraded objects from DEV to QA and PROD environment.
• Responsible for supporting issues on MS Sql Server, Cognos objects through out the UAT

Confidential, Orangeburg, NY

Environment: Cognos 8.3 BI, Sql Server 2008

Responsibilities:

• Managed offshore team to develop the models and reports
• Responsible for gathering new requirements from onsite
• Responsible for the design, development and architecting new Models and Reports
• Managed resources, schedules, risks and issues and set goals and objectives for obtaining customer satisfaction.
• Responsible for migrating the upgraded objects from DEV to QA and PROD environment.
• Responsible for supporting RPS and Sales Commission Cognos objects through out the UAT

Confidential, Boston, MA

Environment: Cognos 8.3 BI, Oracle 10g, Sql Server 2005.

• Responsible for handling crititcal issues onsite
• Responsible for migrating cognos objects from DEV/TEST/PROD
• Responsible for maintaining the Change Control Management System. .
• Created Dimensions and Measures in Framework Manager.
• Published packages for testing and checked in reports in to version manager. Managed offshore team to maintain the models and reports

Confidential

Framework Manager

Responsibilities:

• Analyzed Data Models in Framework Manager for performance flaw in the reports.
• Migrated reports from Reportnet 1.3 to Cognos 8.4.
• Worked on reports to implement new logic to increase the performance for the reports.
• Created Dimensions and Measures in Framework Manager.
• Published packages for testing and checked in reports in to version manager.

Confidential, Duluth, GA

Responsibilities:

• Coordinated with the client for gathering system requirements and constrains and preparing the System Requirements specification.
• Worked with System architect to develop various prototypes, design decisions at different stages of the project.
• Implemented BI solution for Merial wherein managers can utilize dashboards, cubes and reports
• Created dynamic dashboards using Global filters.
• Designed and Developed Data Models in Framework Manager based on reporting requirements.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Developed drill through, Master-Detail Reports.
• Development of filters, calculations, prompts, conditions and created various reports, using Cognos Report Studio.
• Scheduled them to run on a daily basis to help the users do the data analysis.
• Scheduled reports to run based on an event using Event Studio.

Confidential

Framework Manager

Responsibilities:

• Designed and Developed Data Models in Framework Manager based on each client’s reporting requirements.
• Understand the business needs and implement the same in to a functional database design.
• Designed and developed Informatica mappings for data loads.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Implemented BI solution for Merial wherein managers can utilize dashboards, cubes and reports
• Extracted data from recruiting department to flat files and load the data to the target database.
• Created Dimensions and Measures in Framework Manager.
• Published client packages in to Public Folders.
• Designed and Developed List Reports, Crosstab Reports, Charts by using Report Studio.
• Created Interactive Reports by building Report Prompts, cascading Prompts.
• Created dimension maps and multidimensional cubes using PowerPlay Transformer.
• Add value to Reports using calculations.
• Developed reports in Report Studio and implemented grouping, calculations and filters
• Implemented drill through reports to get detail information of the data in another report
• Developed reports that has Master Detail Relationship.
• Designed and Developed AdHoc query packages and trained the end users on how to develop reports in Query Studio.
• Scheduled reports in Cognos Connection based on the reports to run daily, weekly or monthly basis.
• Created and maintained several custom reports for the client using Cognos and Actuate tools.
• Published and troubleshooted reports whenever there is any error in the reports.
• Responsible for maintaining the reports in both Cognos and Actuate environment.
• Written query scripts to update tables that are used by Reports.
• Used WinSQL and Quest frequently for creating database views that are required for the Cognos reports.
• Used Rational ClearCase Version Manager for maintaining report (.xml) versions.