EXPERIENCE SUMMARY:

• Dynamic, result oriented DW & BI Consultant with 7+ Years of experience in Designing, Developing and Deploying Data Warehousing and BI applications.
• Experience and Exposure to all stages of SDLC from Requirement Analysis to Implementation.
• Proficient in developing BI Reports using Cognos 10.2.1, 10.1, 8.4, Business Objects 4.0, XI R3.1, Oracle discoverer 10g.
• In - depth knowledge of developing reports and applications using various business intelligence tools such as Cognos (Report Studio, Query Studio, Framework Manager), BO(Central Management Server, Designer, Desktop Intelligence, Web Intelligence, Rich Client), Oracle Discoverer (Discoverer Admin, Discoverer Plus, Discoverer Viewer)
• Created Ad-Hoc reports using Query studio and Trained power users to use Query Studio for Ad-Hoc reporting.
• Expertise in Universe designing, developing and generating complex, Adhoc, Reports, List of values along with User Acceptance Test and data accuracy Test.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Expertise in customizing the reports in Windows Excel automated through VBA.
• Proficient in working with various databases that include Oracle and SQL Server databases
• Experience as Team lead by assigning, monitoring and reviewing the development work of development team and other project activities like estimation, allocate & monitor the tasks and technical mentoring.
• Possess sound knowledge in Life sciences domain & Sales Reporting.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2003, Windows XP, Windows Vista, Windows 7 Enterprise

Languages: SQL, PL/SQL, VBA

Database: Oracle 9i, 10g & 11g, SQL Server 2005, Salesforce.com

DW ETL Tool: Informatica Basics

DW Reporting Tools: Cognos 10.2, 10.1,8.4 (Report Studio/Query Studio/FM Model), Business Objects XI4.0, XI 3.1, XIR2

Other Tools: Cognos Life Cycle Manager 10.2, Toad 10.5, PLSQL Developer, PVCS, Peregrine Systems, Salesforce.com

PROFESSIONAL EXPERIENCE:

Confidential -CA

BI Lead

Responsibilities:

• Created a Project plan and managed the project with day to day activities
• Analyzed the customer requirements and get the clarifications resolved
• Prepared the HLD, detailed design and get it approved by technical reviewer
• Developed meta data dictionary in Cognos FM using data mart and transactional DB and provided the model for canned and Adhoc reporting purpose
• Developed report studio reports with drill through and dashboard layout features.
• Unit tested the reports to ensure the reports available for system testing and UAT.
• Coordinated with Quality reviewer report and ETL components
• Coordinated with admin to deploy the code into production and provided the hyper care support
• Provided the weekly status to ensure the customer aware of issues and mitigation plans.

Environment: Cognos 10.2.1, Oracle 11g, Informatica 9.1

Confidential -CA

Cognos Lead

Responsibilities:

• Prepared the Effort estimates for the Cognos report development.
• Analyzed the connectivity between cognos and Cloud Database( salesforce.com)
• Propose the approach to client to develop the Cognos reports using SFDC as backend.
• Created the FM model using the cognos 10.2.1 features for both standard and Adhoc reports.
• Created the Publication reports using cognos 10.2.1 report studio
• Validated the reports using test script execution.

Environment: Cognos 10.2.1, Salesforce.com, Oracle 11g, Informatica 9.1

Confidential -CA

Cognos/BOBJ Upgrade Lead

Responsibilities:

• Analyzed the report complexity using Java SDK
• Upgraded the reports based on Business Criticality and Report Complexity
• Fixed the reports issues in Cognos 10.2 Environment/BO 4.0
• Validated the reports using Life Cycle Manager as well as Manual testing
• Upgraded the reports using BO Upgrade management tool
• Validated the reports using 40 point check list

Environment: New Version: Cognos 10.2, Business Objects 4.0

Confidential -CA

Cognos Developer and Production Support

Responsibilities:

• Developed the Cognos reports using Report Studio for standard semester changes.
• Created the excel template using complex excel functions and VBA to generate dashboard and detail reports.
• Modified and published the metadata model in Framework Manager as per the requirement.
• Involved in troubleshooting report performance and query optimization issues to reduce the execution timelines.
• Prepared the Design document for Weekly and Monthly reports.
• Involved in Prepare and Review the QA script for each sales force.
• Created Excel Macros to automate QC Extract process to eliminate manual Query execution and data copy to Excel Templates for QA
• Performed the archival of previous week/Month reports and Pre-productions tasks using automated process.
• Performed production support activities(KTLO) for Weekly and Monthly reports which includes Bursting, automation, QC, bug fixing and disseminate the reports to the field representatives using Afaria Process.
• Involved in Onsite-Offshore Coordination, Effort estimation.
• Imparted business knowledge about Sales Reporting to team members and guided them to work with complex report requirements.
• Involved in Project management activities like allocate and monitor the tasks till their closure using cognizant 2.0, Shift planning for KTLO production, submitting metrics and participated in Monthly process audits.

Environment: Cognos Report Studio 8.4, Cognos Framework Manager 8.4, Informatica 8.6, VBA, Excel Formatter tool, Oracle 10g and Windows 2003 Server.

Confidential

Oracle Discoverer Admin, Developer.

Responsibilities:

• Worked as Discoverer administrator involved in User Creation & Maintenance, handling multiple queries and solved critical user issues.
• Analyzed the task and requirements very clearly and try to finish within schedule.
• Involved in Discoverer Users creation and assigned privileges to users as per the request.
• Analyzed the requirements, design and implementation of the new features.
• Tracked tickets using Peregrine Service Center and fixed the bugs within SLA period.
• Created custom reports like cross tab and list reports as per user requirements.
• Provided restriction and amendments of the discoverer reports.
• Analyzed and prepared the case study for Migration of Oracle Discoverer to Business Objects.

Environment: Oracle Discoverer Admin, Discoverer Plus, Discoverer Viewer, Oracle 9i, Peregrine Systems and Windows OS.

Confidential

DW&BI Application Developer (BO)

Responsibilities:

• Created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Inserted new Alias tables and made joins with existing ones and added Context.
• Performed the check integrity and exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Maintained the different version of universe using Polytron Version Control System (PVCS).
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report.
• Created the reports using Business Objects functionality like Cross Tab, Master Detail and Formula etc.
• Created User Prompts, Conditions and Filters to improve the report generation.
• Hardcoded the report generated SQL according to the user requirements.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.

Environment: Business Objects XI R2 Designer, Desktop Intelligence, Web Intelligence, PVCS, Oracle 9i, Windows OS