Summary

• IBM Cognos Certified Professional ( Reports Designer & BI Data warehouses) with more than 8 years of IT consulting experience in designing , developing and deploying BI and data warehousing applications
• Experience in working on full Enterprise Datawarehouse Implementation with good exposure to data modeling , design and build Metadata layer, Analysis and Dashboard using Cognos
• Excellent in ETL/BI tools ( Informatica , Cognos – Data Manager ,SSIS ,Data Stage 7.1r ,Cognos 8.x BI Suite, Cognos TM1 )
• Experience in Data Integration for JDE ERP ,Data Governance , Data Migration , Data Quality and Data Synchronization
• Expert in Dimensional Modeling, complex report development in Report Studio (with cascading prompts, Complex queries, charts, etc.) , Ad-hoc reporting in Query Studio, Scheduling and bursting
• Experience in Oracle 9i & PL/SQL programming, SQL Server 7.0/2000/2008 databases
• Provided extensive End User Training and Support
• Effective communications/presentation skills for technical and non-technical audiences
• Team Player, effective under pressure, creative , strong desire to keep up with latest technologies

Technical Skills

ETL Tools

Informatica Power Center 8.1 , Cognos – Data Manager , SSIS , Data Stage 7.1r

Reporting Tools

Cognos 8/10 Suite ( Report Studio, Analysis Studio, Query Studio, Framework Manager Cognos ReportNet 1.1 (Report Studio, Query Studio, Framework Manager), Cognos Impromptu 7.x, Cognos Power Play 7.x, Cognos PowerPlay Transformer 7.x, Impromptu Web Reports (IWR) 7.x, Cognos Visualizer 7.x, Access Manager 7.x, PowerPlay Enterprise Server 7.x,

Databases

RDBMS/DBMS Oracle 8i, 9i, SQL7.0/2000/2008, MS Access

Programming Languages

C, C++, PL/SQL, SQL, HTML

Microsoft Tools

MS Office (Access, Excel, PowerPoint, Word), MS Visio, MS Project

Other Tools

TOAD, Rational Rose, SAP ABAP-4 ,

Web Development Tools

Macromedia Dreamweaver, Adobe Suite (Pagemaker, Photoshop, Fireworks)

Operating Systems

Windows 9x/NT/2000/XP, UNIX

Education / Certifications

• BE in Computer Science Engineering
• Certified “IBM Certified Developer - Cognos 8 BI Data warehouses”.
• Certified “IBM Certified Designer - Cognos 8 BI Reports Designer”.
• Cognos Certified in Impromptu, PowerPlay
• IBM certified DB2user

Professional Experience :

Confidential

Sr BI/ETL Developer\\Lead

Feb 10 – Jun 12

Confidential is a French industrial company and second-largest cement manufacturer by mass shipped behind Holmic. 
Responsibilities:

• Built complex Cognos reports using Cognos 8 and Cognos 10 suites.
• Responsible for Cognos Administration , estimation , development , defining test cases and deployment of BI Packages/Reports in multiple environment
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Developed Models in Framework Manager both Relational and Dimensional
• Created cubes in Transformer using Framework Manager IQD\'s, packages and reportstudio reports as a source
• Performance tuning the by analyzing and comparing the turn around times of Diff SQLs
• Implementation and design of Datamarts , Framework Manger and Reports/Dashboards with HTML/Java Script & MDX Functions.
• Implementation of an internal application of L&T Infotech “Life Knowbots” on SSIS & SSRS

Environment: 
Oracle Data Integrator
Cognos 8/10 Suite (Analysis Studio, Report Studio, Framework Manager,Transformer ), MS SQL Server, Oracle 9i , JDE- World, JDE-E1 

Confidential is a global diversified healthcare company with expertise in medical devices , pharmaceuticals and biotechnology to create products that advance patient care worldwide. 
Responsibilities:

• Worked with business analyst and users to analyze requirements and business rules
• Performed Cognos user training on Framework Manger and Report Studio.
• Created and maintained Cognos jobs with Framework Manger and Reports/Dashboards.
• Created, supported Cognos Transformer models and cubes to support timely sales operations.
• Performed Cognos administration such as creating user accounts, user classes and roles using
• Abstract the complexity of existing system into manageable BI/DW model
• Creation of Physical and logical data model for Datamarts.
• Implementation and design of Datamarts with DataStage

Environment: 
IBM DataStage Sever Edition 7.1r
Cognos 8 Suite (Analysis Studio, Report Studio, Framework Manager), MS SQL Server, Oracle 9i , JDE- World, JDE-E1

Confidential is Hong Kong’s first mobile operator and leading the market network operator in Hong Kong, arguably the most competitive telecommunications marketing in the world. 
Responsibilities:

• Responsible for handling ETL team from requirement gathering part to design and development of data Marts
• Responsible for logical designing of mart using DB Designer
• Automate manual manipulation of the data done by users using ETL - Data Manager
• Design Data Marts (Data Manager) to deliver data to Cognos planning system for retail team
• Design Data specification templates for documentation
• Create functional specification based on the discussion with multiple functional teams
• Developing cubes using Cognos Transformer
• Performance tuning of various queries and understanding the need of indexes

Environment: 
Cognos 8 – Data Manager
Cognos 8 Suite (Analysis Studio, Report Studio, Framework Manager), MS SQL Server, Oracle 9i , JDE- World, JDE-E1

Confidential (NASDAQ: IVGN) is a global company with revenues of $1.15 billion, providing products and services to pharmaceutical and biotechnology companies, as well as academic and government research institutions. 
Responsibilities:
Enterprise Data Warehousing (EDW):

• Responsible for development and implementation of Data warehouse where in all the necessary marts building ( from scratch as well as maintaining the existing ones) using Informatica Power Center 8.1
• Responsible for developing various mapping ( History Loads as well as ongoing loads for different business units ) , transformations and mapplets for migration of data using Informatica Power Center 8.1
• Created ETL Specification for all the mappings after discussing requirements with the team of business users
• Responsible for logical designing of the mapping
• Involved in performance tuning of various mappings with other team members
• Developed support documentation for user workshops
• Implementation to convert Impromptu reporting to Report Studio / Analysis Studio reports

Global Acquisitions/Integrations:

• Design and Developed an ETL/Business process to incorporate acquisitions in the GIS marts for sales reporting using Cognos ETL Tool ( Cognos 8 - Data Manger )
• Designed templates for the Integrations for acquired sites to submit their data to GIS marts
• Worked on prominent Global Integrations with Invitrogen like BioSource, Cascade, Dynal, etc
• Mapping of Customers and SKUs from sales data of the acquired sites to Invitrogen GIS standards

Special Business Projects:

• Worked on various special projects to improve existing data marts and reporting performance for the Sales/Finance/Marketing teams
• Worked as a BA and also developed various Transformer cubes/reports.

E1-GIS Implementation:

• Analyzed the mappings/Builds of the sales data in the Existing data marts and re-mapped the new tables to create new data marts using (Cognos 8 - Data Manger )
• Worked as a Business Analyst in the ERP update project – from JDE World to E1 – specializing on GIS end-user reporting and ETL modifications (Cognos 8 - Data Manger )
• Worked extensively in developing and accommodating new data marts
• Analyzed and developed various logics to implement the changes in the business process

APAC Cognos 8 Implementation:

• Worked with Cognos 8 team to implement reporting in for the Asia Pacific Region
• Created Framework Manager models for Global and APAC regional marts
• Worked extensively in Dimensional modeling in Cognos 8 to deploy cubes in Analysis Studio

Environment: 
Informatica Power Center 8.1 , Cognos 8 – Data Manager 
Cognos 8 Suite (Analysis Studio, Report Studio, Framework Manager), Cognos Series 7.3/7.4 (Impromptu, PowerPlay, Transformer, Access Manager, Upfront), MS SQL Server, Oracle 9i, JDE- World, JDE-E1, Toad, Cognos Decision Stream / Data Manager, Informatica, MS Visio / Project

Confidential is one of the India’s leading private insurance companies , which offers a range of individual and group insurance solutions.
Responsibilities:

• Identified the relationships and cardinality for the new tables to create impromptu catalogs
• Created Transformer model using IQDs to create a multidimensional cube with manual categories for time dimension, adhering to requirements
• Created an array of PowerPlay, PowerPlay for Excel reports per requirements
• Developed a Framework Manager model in ReportNet for the same, creating a business view with shortcuts, model query subjects, calculations, embedded filters etc.
• Performed troubleshooting for a wide range of issues in the migration process

Environment: Cognos Series 7.3 (Impromptu, PowerPlay, Transformer, Access Manager, Upfront), 
ReportNet 1.1, IBM AS/400, Visual Elk 8.1/9.2, Windows NT

Responsibilities:

• Improved the usability of the reports by creating both report level and catalog level prompts
• Developed Business Mix Reports, Financial Reports using PowerPlay
• Worked in a team to build Multidimensional Cubes from the Data marts
• Using PowerPlay for Excel, generated reportsby connecting to cubes through Excel and performed complex calculations in formatting the reports
• Deployed cubes using PPES and published OLAP reports using Upfront Server

Environment: Cognos Series 7.1, Power Play Enterprise Server, IWR, SQL Server 2000