SUMMARY

• A proficient professional with 11+ years of experience with System Analysis, Development & Testing in the field of Data warehousing, Data Modeling, Business Intelligence (BI), Decision Support Systems (DSS), Customer OLAP and Reports Generation.
• Adept at designing and development of data warehousing reports using COGNOS 10.2, Cognos 10.1, COGNOS 8 (Report Studio, Query Studio, Analysis studio, Event studio, Transformer & Framework Manager), PL/SQL, COGNOS Report Net 1.1 & Impromptu & BUSINESS OBJECTS XI R2.
• Possess strong oral, written and organization skills, excellent time and project management skills and a strong ability to prioritize tasks. Self - motivated and industrious professional with good technical, communication and leadership skills.
• Carries a positive attitude, enthusiastic and a firm believer of team work
• Good knowledge in COGNOS Impromptu, Impromptu Web Reports, Upfront, PowerPlay and PowerPlay Enterprise Server.
• Involved in the full Project Life Cycle of the Data Warehouse Project and exposure to client interaction and user-requirement analysis.
• Mentored and trained users for the successful execution of the project
• Carried out Requirement Gathering, Requirement Analysis, Estimations, Planning, Coding, Testing and Post Production Support.
• Managed project teams of 5-20 members in an onshore-offshore model to successfully meet project deadlines and commitments
• Experience spans all the phases of life cycle of software development such as Requirement Gathering, Requirement Analysis, Estimations, Planning, Coding, Testing and Post Production Support.
• Experience in BI Tool Cognos v.10.x (Cognos Workspace, Cognos Workspace Advanced, Business Insight, Business Insight Advanced, and Report Studio).
• Experience in working with Cognos 8.x. (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio and Cognos Connection).
• Expertise in Framework Manager Modeling (Database Layer, Intermediate Layer, Presentation Layer, Packages, Dimensional Data Modeling) and Complex Report building with Report Studio.
• Strong Complex Reporting skills -- complex Drill-Through, Dashboards, Summary Reports, Burst Reports, ad-hoc reporting and advanced report authoring.
• Experienced in preparing technical specification documents such as Global requirement Gathering Documents (GRG), New Product Development (NPD).
• Experience in developing new reports and customizing existing reports and change request processing.
• Hands on experience in migration /upgrade of Cognos older versions to newer version.
• Expertise in OLTP/OLAP System Study, Analysis, developing Database Schemas like Star Schema & Snowflake Schema used in Relational, Dimensional and Multidimensional modeling.
• Proficient in coding using SQL, Scripting, Stored Procedures.

TECHNICAL SKILLS

Languages: SQL, PL/SQL

Databases: Oracle 11g, MS SQL Server 200x, TeraData, and MS Access 2000

Operating Systems: SUN-SOLARIS, HP-UNIX, Windows NT/2000/03/XP

OLAP/BI: COGNOS 10.x, Qlik View, COGNOS 8i (Report Studio, Query Studio, Analysis studio, Event studio, Transformer & Framework Manager), COGNOS Report Net 1.1, Impromptu 7.0, BUSINESS OBJECTS XI R2 (Designer, Business Objects Supervisor, Auditor, Web Intelligence and Info view)

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Project Lead/Architect

Responsibilities:

• Single point of contact for client for all reporting & database questions/concerns.
• Created and published packages for different subject areas, using Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Created list, crosstab and Chart reports and implemented drill-though conditions and Master-Detail relationships.
• Created Burst Reports and scheduled reports.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports. Customized prompts using HTML Items.
• Used Union, Intersection, joins between queries in report studio.
• Developed several Dashboard reports and hands on with QlikView.
• Implemented Drill-up and Drill-down with advanced options.
• Deployed reports, models and cubes from Dev to Test and Prod environments.
• Developed Stored procedures and user defined functions using PL/SQL.
• Part of Unit testing and data validation of various reports that were developed in Cognos.
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.
• Carried out performance tuning of reports, both on data base side and Cognos report and modeling side.
• Upgraded the Cognos environment by Installing and Configuring Cognos 10 on multi-server.
• Upgrade a set of reports and FM Models to Cognos 10.
• Used Business Workspace / Insights and Business Workspace / Insights Advanced to arrange individual reports into dashboards.
• Worked in multiple phases of Software Life Cycle starting from the scratch to production delivery.

Environment: COGNOS 10.1, Cognos 10.2, Oracle 11g, and SQL Server 2005.

Confidential

Project Lead & Lead COGNOS Analyst

Responsibilities:

• Worked extensively onCognos10.1 with Framework Manager, Report Studio, Transformer, and Analysis Studio.
• Actively involved in Requirement Gathering from Business Users and Developed Technical Documentations for the Business and IT Team.
• Created Prototypes for the business showcasing them the Models and future report samples and Dashboards.
• Translated reporting requirements and the business data model and convert into a Framework Manager Model and Transformer model to meet reporting requirements.
• Involved in CustomizedCognosConnection with appropriate reports and security measures.
• Created Model Query subjects, Data Source Query subjects, Stored Procedure Query subjects as per the business requirements in the Framework Manager.
• Designing the Logical model that conforms to star schema concepts, different views (Import, Business, and External) as per Business requirement.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created Database layer, Physical layer and Presentation layer, defining appropriate relationships between query subjects.
• Used Report Studio, Analysis Studio and Business Insights to create simple to Complex reports.
• Created Active Reports and used Business Insights Advanced to create reports.
• Involved in modifying the existing Reports based upon the change requested by the user.
• Developed List Reports, Cross Tab Reports, Charts, Drill through Reports and Master Detail Reports using Report Studio.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, Page Breaks, Master-detail, Drill Through, Drill Down, Drill Up, Expand-Collapse
• Deployed the reports and package from Development to Testing and then Testing to Production environments.
• Worked on TOAD with ORACLE as a database.
• Involved in writing test cases for SIT (System Integration testing) and UAT (User Acceptance testing, Unit testing, Integration testing and System testing of the reports in Development, Testing and Production environments.
• Involved in resolving Performance issues with various reports.
• Worked on-shore off-shore model. Experience guiding a team of 3 off-shore developers.
• Prepared User Documentation to train users and to explain functionality of each report.
• Enhancement and development of existing/new reports.
• Bug-fixes on the report.
• Developed customized reports with Drill down and Charts.
• Worked with Packages using Framework Manager.
• Design & Enhance Dashboards.
• Performance tuning of the reports.
• Prepare SQL Test scripts for COGNOS Reports.

Environment: COGNOS 10.1, Oracle 10g, Abi Initio and Humming Bird Genio.

Confidential

Team Lead / Senior Cognos Developer

Responsibilities:

• Involved in the entire project life cycle from analysis, development, testing, production and end user support
• Worked closely with business users while gathering requirements
• Designing of Impromptu Catalog, Cognos Transformer model to build the cubes.
• Hands on experience in Cognos Impromptu Web Reports (IWR), Upfront, PowerPlay, and PowerPlay Enterprise Server (PPES).
• Hands on with Cognos 7 Transformer, design/development of model and cube building.
• Efficient in writing SQL Queries
• Worked on Data Analysis, Validate reports and find data quality issues
• Prepared User documentation to train users and functionality of each report

Environment: COGNOS 7, TeraData, and Informatica.

Confidential

Senior Cognos Developer

Responsibilities:

• Involved in the entire project life cycle from analysis, development, testing, production and end user support
• Worked closely with business users while gathering requirements
• Designing of Framework Manager Model, development of reports using Report Studio.
• Designing and building of model and cube with Cognos 7 Transformer.
• Efficient in writing SQL Queries
• Worked on Data Analysis, Validate reports and find data quality issues
• Prepared User documentation to train users and functionality of each report

Environment: COGNOS Report Net 1.1, Cognos 7 Transformer, TeraData, and Informatica.

Confidential

Developer (VB and Cognos)

Responsibilities:

• Involved in PowerPlay Transformer Model design using data sources.
• Design the Dimension map, measure using exclude, include and Generate Categories.
• Build the cubes using model from one or more Data Sources.
• Created Dimensions, Fact table and Multi-dimensional cubes.
• Involved in taking reports, requirements from business users and project planning.
• Developed Catalog using impromptu.
• Design and development of Impromptu Environment.
• Established user groups and users and assigned privileges.
• Created different types of Reports (Reporter & Explorer) in Power Play.
• Involved in Analysis, Development and Maintenance.

Environment: COGNOS 7, Transformer, Oracle 8, and Visual Basic 6.