SUMMARY:

• Data warehousing consultant with nine years of experience in business analysis, data modeling, database design development, implementation, testing and production support of Data warehouse and data marts.
• Certified Cognos Professional in Impromptu and Powerplay.
• Have expertise in Dimensional modeling of Data Marts, design of Multidimensional cubes and reports for OLAP applications.
• Have functional knowledge in diversified fields such as Supply chain management, demand forecasting, Telecom, Insurance and Utilities.
• Proficient in Cognos suite of products (7.1.3) - Impromptu Administrator, Transformer, Power Play, IWR, Decision stream, Upfront and Enterprise manager, Report net 1.x and Framework manager.
• Have vast experience in various modules of Business Objects Xi, 6.5, Informatica, Erwin and Oracle designer.
• Have Excellent Analytical and Interpersonal skills. Capable of working as a team member and technical lead analyst.

PROFESSIONAL EXPERIENCE:

Confidential

Data warehouse Engineer

Tools: Business Objects 6.5, Xi MS SQL server

• Do an impact analysis document by interacting with the Project management team to understand the changes in the business functionality and architecture of the application.
• Designing for the enhancement of the existing product with various modules for handling interview, extension of engagement, etc.
• Completely new functionality - Multicurrency conversion, UTC to local user time conversion are the major release that has been designed and implemented in the application.
• Come up with the test plan, test cases for testing of the modules for new releases (QA).
• Supporting the production system.
• Updating/re-designing the Views and the procedures for performance tuning as a part of the support.
• Got trained in Business Objects Xi - CMC and advanced reporting.
• Currently doing the update of the universe in Xi and supporting the clients in Xi.
• Fixing the problem reports in Xi as a part of Production support.

Confidential,Cadbury Adams

Technical Lead

Tools: Cognos 7.1.3, Informatica 6.1, Erwin 4.1, Oracle

• Was involved in requirement gathering and business analysis. Prepared the Requirement and functional specification document at the end of the system study phase.
• Prepared the detailed design document and developed the dimensional model using Erwin at the end of design phase.
• Developed and tested the Cognos catalog, Cubes and Impromptu reports.
• Was responsible for the timely delivery of the Catalogs, Cubes, Powerplay & Impromptu reports and batch files for scheduling.
• Came up with the idea of having a materialized view to base the daily reports presenting the order, shipment and forecast details at various levels of time dimension.
• Was able to come up with multiple solutions whenever there were changes in the source system configuration.
• Generated the error reports, which were published daily for reconciling with the SAP source system for transactions as well as master data.
• Was doing the support for the application for a period of 6months by monitoring the nightly jobs. Was also responsible for answering the pagers messages during the nightly batch runs.
• Was supporting the business users in getting the adhoc reports.
• Prepared a comprehensive helpdesk document for the complete application including the source system, history data, database structures, functionality of the cubes and reports.
• Did a complete impact analysis and the strategy for transforming the data from Fiscal calendar to Julian calendar.
• Created sample reports in Report net using the existing model and presented to the business users. Have work experience in Framework manager and Report net.

Confidential

Technical Lead

Tools: Business Objects 5.x, Oracle Warehouse Builder, Oracle Designer, Oracle database

• Played a major role during requirement gathering phase of the project.
• Was a key player in dimensional data modeling of the system that was developed in parallel with the source system.
• Prepared the technical architecture & Specification documents, test plans and strategies for ETL programs and Business object reports.
• Was a part of the design team and facilitated in the maintenance of Source to Target mapping document for each of the data marts. Ensured that the design adhered to the predefined quality norms.
• Contributed towards the efficient design of the database to balance the load between ETL & OLAP thereby enhancing performance.
• Was involved in the design of the metadata repository.
• Came up with ideas to create reusable components for handling the slowly changing dimensions (SCD type 2) that reduced the development and testing effort to a greater extent.
• Was part of the team in preparing the database estimate for the data marts and performance tuning of the queries for the reports and ETL programs.

Confidential

On-site coordinator

Tools: Business Objects, Informatica, DB2, Oracle, Oracle Designer 2000,Utilities

• Derived the logic for developing the Informatica mappings to populate the required tables.
• Developed the universe and standard reports that were stated in the requirement specification document.
• Prepared the test plan and the executed the test cases for mapping, universe and reports.
• Created and Scheduled Sessions and Batches for time based run using Informatica Server Manager.
• Created all possible pre-calculated measures for ease of use and adhoc querying.
• Was actively involved in the design and coordination with other vendors while moving into the acceptance and production environment.
• Prepared the impact analysis document for getting the approval from the other vendors while migrating the code into production environment.

Confidential

Team Member

Tools: Cognos 6.x, DB2, Oracle, Oracle Designer 2000,Utilities

• Prepared the source to target mapping, test cases for the decision stream jobs.
• Developed the decision stream jobs for populating the staging, dimension facts tables.
• Developed the Catalog for the application.
• Develop reports using Impromptu. Generated the test data for all possible scenarios during the initial phase of testing.
• Developed and tested the transformer model and PowerPlay reports. Prepared the technical specification for all the cubes and reports.
• Developed multiple layer report providing a comprehensive and detail report with drill through facility to the Impromptu.
• Dynamically generated the random number in Impromptu for a specific requirement using a combination of functions available to overcome the tool limitation of not having a random number generator.
• Prepared the test cases and documented the test results.
• Automated the creation of the users using the Cognos macro there by reducing the maintenance effort for the application.
• Was in Production support at site for a period of 3 months.

Confidential

Team member

Tools: Cognos, PL/SQL procedures, DB2, MS SQL Server

• Created source to target definitions. Developed and executed the test plan for the ETL programs.
• Developed PL/SQL procedures to extract the incremental data and load data into the Data Mart (DM).
• Security implementation was done using the supervisor module of Business Objects so that only the authorized users can query on the data mart.