Summary:

• Over 8 years of IT experience in Business Intelligence BI and Data Warehouse DW projects.
• Extensive experience in effort estimates, requirement analysis, design, development, testing and implementation of various business process.
• Extensive experience in Cognos 10, 8.4 CC, FM, TX, RS, QS, AS, CRN, Cognos Impromptu, PPT, IWR, PPES, PP for Windows/Excel, Cognos 7 Server Administration, Life Cycle Manager.
• Experience in Leading Team on Budgeting, Modeling and Reporting.
• Knowledge of Cognos 10 Administration-Installation, Configuration in a Multi Tier environment.
• Knowledge of full life cycle development of Data Warehousing DWLC Software Development Life Cycle SDLC .
• Extensive data warehouse experience using Informatica PM/PC v 8.6/7.1.3/6.2/5.1 Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Workflow Monitor, Source Analyzer, Transformation Designer, Warehouse Designer as ETL tool on Oracle, SQL Server databases.
• Exposure to SAP BW BEx Analyzer, Query Designer, Solman .
• In-depth understanding of star schema snowflake schema, fact dimension tables, physical logical data modeling.
• Experienced in writing VB scripts, Unix Shell scripts and automating the Informatica process.
• Experienced in query tuning of relational databases Oracle, DB2 and SQL Server T-SQL .
• Has the ability to work as a mentor, team member or as an individual to set priorities, plan/organize, and carry out multiple tasks in an efficient manner and confident in serving the best results.

Professional Experience:

Confidential

Sr. Cognos Consultant

Project: EBSP

EBSP project Caters the needs of users requiring Financial, HR Payroll and planning related Dashboards, Adhoc, Planning, Budgeting and Forecasted Reports for Users across different departments and Accounts at Michigan State.

Responsibilities:

Analyzed the current ongoing process and given inputs/suggestions on moving forward like using Cubes, Implementing DMR, usage of DQM and what the infrastructure supports.

• Solutions to different bottle necks report performance, modeling issues , implementing best practices in the Cognos environment.
• Provided inputs for Health Check of Current environment.
• Shared inputs in Budegting process for new development and managed Reporting Team.
• Lead the Team on Peer Reviewing, Testing the reports, HR Models, preparing Test Scripts and migration from Dev to QA and Prod.
• Worked on Analysis, Model, Design, Testing and documenting of Cognos Framework and Transformer Models and maintaining versions using CVS Tool.
• Build DMR Model prototype to compare it with Finance Cube to check performance and report run time.
• Analyzing the reporting specifications and giving inputs to the Business Team on Report Specification.
• Worked on HR Payroll Models OMPA Actions, Cost Distribution, and Labor Distribution and Finance Models GL, PETS, CAM, CA, and PURAP during design, unit testing, functional testing , moving to QA on integration issues with the team to resolve issues and have smooth reporting.
• Involved in group meetings on current Model issues, DSR's, tickets raised and weekly agenda for Cognos Modeling
• Tested Budget, Finance, and HR Reports for runtime, performance and for specifications.
• Reviewed plan, training agenda, and documentation for 250 Query Studio Users.
• Collected ARM forms and review on who needs what type of access for Query Studio users.

Environment: Cognos 10.1.1, FM, RS, QS, AS, Business Insight, Cognos Planning, Analyst, Contributor, KFS Finance, SAP ECC, SAP HR, Oracle 11g, SQL Developer 1.5.5, Data Stage 8.x, Non-Transport Migration Tool, Win2K, and UNIX.

Confidential

Sr. Cognos Consultant

Project: PentaSAP

PentaSAP project involves migration of various application data into SAP. BW-Cognos Integration involves streamlining data for building reports and Dashboards.

Responsibilities:

Worked on Analysis, Design, Integration, Development, Testing Unit, Integration, UAT and documenting of Cognos Reports and Framework Models.

• Lead the offshore team by reviewing the built reports, functional testing and implementing best practices.
• Analyzing BW technical documents and preparing Cognos Reporting Documents.
• Worked on SAP-Cognos integration issues with the team to resolve issues and have smooth reporting.
• Conducting meetings and preparing presentations, notes on handling how Legacy data can be brought into Cognos along with SAP data and build reports out of it.
• Developed FM Models from BEx Query and Models involving Legacy and SAP data.
• Worked on Building reports, unit testing them by comparing Cognos output with BEx Output and doing Integration testing and verifying business see right data.
• Worked on Cognos reports involving data from AP, AR, and COPA.
• Worked on building Adhoc Reports for Business Users.
• Prepared a plan, training agenda and access limitation for Power users.
• Involved in analyzing Cognos integration to CAPSPIN portal.

Environment: Cognos 10.1.1, FM, RS, QS, AS, SAP Business Explorer 7.X, Analyzer, Report Designer, Query Designer, SAP ECC, DB2 UDB, Data Stage 8.x, Mainframe DB2, DB2 Connect Control Center, Win2K, and UNIX.

Confidential

Sr. Cognos Consultant

Project: GM-Global Purchasing Supply Chain GPSC

GPSC is GM's Global Purchasing and Supply Chain handling GM Supply chain initiatives.

Responsibilities:

Analyzed GPSC documents on Cognos BI Area.

• Prepared presentations on Cognos End-to-End Monitoring.
• Analyzed Mars Incident Analysis Errors on identifying ITIL process and streamlining errors types.
• Worked on VOC Issues in GM VOC Cognos Portal Dashboards.

Environment: Data Stage 8.x, Cognos 8.4/10.x, FM, RS, QS, AS, Oracle 10g, Oracle SQL Developer, DB2 UDB, DB2 Connect Control Center, Win2K, UNIX.

Confidential

Sr. Cognos Consultant

Project: WSS Scorecard

JP Morgan Chase is a global securities, investment banking and retail banking firm. Custody products like Tax Reclaim, Trades, Income, Corporate Actions COAX and Holdings.

Responsibilities:

Studied the current environment from Architecture point of view and suggested changes for long-term implementations on the current ongoing process such as use of ETL, reporting database and Cognos 8.4 Virtual View Manager.

• Provided effort estimates for the new Cognos BI process on tax reclaims, income and design of executive dashboard.
• Worked with business analysts on requirement gathering design on custody products based on the mockups data mapping docs.
• Worked with SME Data Architects on code validations.
• Developed the Executive Dashboard Report in Report Studio as we are having issues building scorecard in Cognos 8.4 Metric Studio.
• Modified the SQL query for referencing it for in various data elements and calculations.
• Developed complex reports involving multiple report, prompt pages and queries.
• Developed reports and bursted the report output to business users in Report Studio.
• Formatted reports using padding, borders and multiple features to fit in the Cross Tabs and referenced Bar Charts, Pie Charts.
• Developed modified the Report Views for business users to add comments in PDF HTML.
• Implemented Pilot project from Cognos 8 to 10.
• Checked validated SQL after referencing data in multiple databases Oracle DB2.
• Worked with on-site/ offshore model of team and delivered.

Environment: DataStage 8.x, Cognos 8.4/10.x, FM, RS, QS, AS, MS, Metric Manager, SDK, Oracle 10g, Oracle SQL Developer, DB2 UDB, DB2 Visualizer 7.5.1, DB2 Connect Control Center, Win2K, UNIX.

Confidential

Cognos DW Consultant

Project: Bank Operations Data Mart Cognos Portal

Confidential Bank provides a full range of commercial and consumer banking products, investment and brokerage services. CFB project loads limits, assessment, utilizations, and credit risk data into Bank Operations EDW.

Responsibilities:

Studied the Current environment by doing gap analysis and suggested changes to the current environment.

• Participated in all phases of project cycle including Requirement Analysis, Client Interaction, Design, Coding, Testing, support and Documentation.
• Extensively worked in table design, creating the ETL functional mapping documents.
• Develop ETL jobs using the Data Stage 8.1, write oracle Pl/Sql scripts, and UNIX shell scripts as per the functional and technical specs provided by the client.
• Designed complex DataStage Jobs, sequences and tuned them for better performance.
• Responsible for preparing ETL Documentation for the developed processes.
• Extract data from different source systems Flat files, Oracle DB move them into the warehouse and mart.
• Responsible for preparing Unit test cases and validating the data as per the business rules.
• Involved in preparing Integration test cases, UAT test cases and involved in UAT testing.
• Involved in tuning many Oracle scripts and other ETL processes used in this project.
• Created reusable metadata in Framework Manager.
• Developed time dimension by determinants to specify the levels of granularity.
• Created Presentation View identifying conformed and non-conformed dimensions.
• Created User Accounts for business users, set security and user access for business users and developers in Framework Manager
• Developed model with multiple OLAP data sources in Framework Manager.
• Developed statement style reports and advanced crosstabs.
• Created MOLAP Cubes achieving faster query performance by multidimensional indexing, optimized storage and caching.
• Created model and thereby Power Cubes and added security in Cognos 8.4 Transformer.
• Published cubes from existing queries for sub-second response times and additional OLAP exploration.
• Created reports based on Query Relationships and distributed reports through Bursting.
• Developed Dashboards in Report Studio for CARM.
• Created reports involving dynamic sorting, dynamic grouping, conditional formatting, blocks, HTML items and hyperlinks.
• Involved in deployment of various report packages between various stages such as Development, Integration, QA and Production.
• Tuning of Report queries for better performance.

Environment: DataStage 8.x/7.x, Cognos 8.x, Oracle 10g, DB2 8.x, UNIX, AutoSys, DB2 Control Center, HP Quality Center 10, Win2K.

Confidential

Senior Certified Data Warehouse /Cognos Consultant

Project: ET Domain

Responsibilities:

Gathered reports requirements with Business Users and converted them in to project documentation.

• Developed Framework Manager Models.
• Used Cognos Connection to create and manage data sources, administer reports as well as ReportNet Server.
• Published the packages to development, test and production servers.
• Developed standard templates, charts, drill through reports, master detail reports in Report Studio
• Created reports involving dynamic sorting, dynamic grouping, conditional formatting, blocks, HTML items and hyperlinks.
• Developed Dashboards Report for BMO projects for identifying the performance of teams over the the current year and quarterly.
• Developed Dashboard reports for ET Domain which included A H, IB, Investments, and International.
• Developed various mappings with multiple sources, targets, transformations and mapplets using Power Center Designer.
• Imported various sources, targets, and transformations using Informatica Power Center - Server, Server Manager, Repository Manager and Designer.
• Created reusable transformations, mapplets, worklets for mappings and workflows.
• Wrote PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Created metadata objects like source definitions, target definitions and built equivalent database objects with proper indexing.

Environment: Cognos Report Net: 1.1 MR3 /Cognos 8.0 FM, RS, QS, Cognos 7.3, Access Manager, Oracle 9i, Informatica 7.X, Mercury ITG, Toad, Win2K, UNIX

Confidential

Data Warehouse/Cognos Consultant

DW-BI IT Project

Detroit Public Schools daily data along with tests like Michigan Educational Assessment Program MEAP , Measured in Progress MIP , and TeraNova.

Responsibilities:

Created DMR Dimensional Meta Data modeling using Relational Database models Drill up, Drill down levels like PowerPlay in FM for Analysis Studio.

• Used PowerPlay cubes as data sources in importing into Frame work Manager and created Models, Packages for Analysis Studio.
• Developed Dashboard report using List, crosstab, gauges, maps for monitoring the School System on Constellations, Attendance, MEAP, MIP, TeraNova based on School year months.
• Worked on complex reports in Cognos ReportNet using Prompts and Tabular Sets.
• Created PowerPlay Cubes using PowerPlay Transformer.
• Published report's to Upfront from Impromptu and Power Play using Impromptu Web Reports IWR and PowerPlay Enterprise Server PPES .
• Involved in data modeling and design of data warehouse in star schema methodology with conformed and granular dimensions and FACT tables.
• Analyzed existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Worked on the student details files which consist of data provided by the 3rd party sources and internal systems like GearUp and Online Phonics.
• Used batch jobs for moving data for Renaissance from Oracle database.
• Implemented Slowly Changing Dimension SCD's, Both Type 1 2 in Informatica.
• Worked on tuning of the databases Oracle and MS SQL Server.

Environment: Cognos 8.1.2/ Cognos Report Net: 1.1 MR3 FM, AS, RS, QS, Cognos 7.3, Oracle 8i, DB2/AS400, MS SQL Server, Informatica 7.X, 5.X, Toad, Win2K, and UNIX

Confidential

Data Warehouse/Cognos Consultant

Sales Management System Project

Departments include Sales, Inventory management, Budgeting, production and Forecasting.

Responsibilities:

Created Catalogs using Impromptu Administration, users and user classes in Access Manager, Assigned privileges to users and User groups on Impromptu Web Reports and Power Cubes

• Implemented security in Catalogs by defining filters on user class to control data access to the tables.
• Worked on Cross tab reports, drill-through reports with filters, Calculations, Predefined Conditions, Prompts, Groups, Association, Sort, Summarizing data, Functions, Styles, linked-sub reports and sub reports Complex reports .
• Created IQD's in Impromptu and used the query definitions as data sources for creating the model and cube in PowerPlay Transformer.
• Created drill-through from Cube to Impromptu and Impromptu-to-Impromptu.
• Created hot files and Snapshots to use in business presentations.
• Published IWR and cubes on upfront using Cognos Server Administration tool.
• Organized accessed data sources into transformer models, dimensional maps and developed Power-Cubes, which can be changed in many ways to slice and dice and drill-through data for further multi dimensional analysis.
• Viewed Power Cubes and developed PP reports in PowerPlay for Windows.

Environment: Cognos 6.x/ 7.x, Impromptu, PPT, PP for Windows/Excel, PPES, IWR Server, Access Mgr, Upfront, Informatica, Oracle7/8i, SQLserver2000, Windows NT/2000 and Unix.