Summary:

• Over 6 + years of extensive experience in IT industry which includes extensive Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI), Decision Support Systems (DSS) and OLAP, ETL tools, product development and Reports Generation.
• Extensive exposure to various business sectors such as Finance, Insurance and HR.
• Extensive experience in database design, data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.
• Experience in Cognos 8 BI(Framework Manager, Report Studio, Query Studio, Event Studio, Metric Studio, Analysis Studio and Cognos Connection).
• Experience in setting up and configuring the entire OBIEE suite (BI Server, BI interactive Dashboards, BI Answers, and BI Publisher etc) to meet business reporting needs.
• Experience in Conceptual, Logical and Physical data modeling with strong knowledge of Data warehousing concepts and Dimensional modeling Star schema and Snowflake schema.
• Experience in developing various reports like List reports, Crosstab reports, Charts, Dash Boards and Score cards, Drill reports, Report Bursting.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Involved in entire lifecycle development process of data warehousing.
• Expert at creating Multi-dimensionalCubes for corporate data using PowerPlayTransformer.
• Strong programming and debugging skills in Oracle Data Warehouse, SQL
• Hands on experience in administering, deploying and maintaining models, reports and cubes
• Installed and configured various components, such as the Framework Manager and Content Manager.
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and object levels as part of setting up reporting infrastructure.
• Experience in developing ETL processes using Microsoft SSIS, SSAS, Informatica to extract, transform and load data from various source and archive systems into Data Warehouses and Data Marts.
• Knowledge of database administration like, data backup, restore and other tasks those are required for ETLactivities.
• Strong Experience in User acceptance test, product support, version control and change management.
• Team Player and have been successful in mentoring and guiding teammates, as well able to workindependently with minimum supervision.
• Possess strong Interpersonal, Communication and Presentation skills, Enthusiastic, quick learner & and strong desire to keep pace with latest technologies.

Technical Skills:

Business Intelligence: Cognos 10, 8BI 8.4/8.3/8.2/8.1 (Report Studio, Query Studio, Cognos connection, Analysis Studio, Event Studio and Framework Manager, Cognos Go Office
OBIEE 10.1.3.2
SSRS
Powerplay Transformer
TM1
Data Modeling: Erwin 4.x/3.5.2/3.x, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer
RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/7.0, MS Access 5.0, My SQL, DB2 9.0
ETL: MS SSIS (2005\2008), SSAS, Informatica
Operating Systems: Windows 2000/03/08, UNIX, and DOS
Languages: C, C++, Java, SQL, PL/SQL, HTML, Java Script
Other Tools: Oracle Portal, WebDb, SQL*Loader, TOAD, SQL Navigator, Sync sort

Education

Bachelor of Engineering

CERTIFICATIONS

• MCP-Microsoft Certified Professional (Paper-designing and implementing databases with Microsoft SQL server2000 enterprise edition).
• Oracle 9i-SQL - Exam no: 007

Professionalexperience:

Confidential, Lenexa, Kansas January 2011 - till date
Client: Confidential, USA
Role: Cognos Developer/BI Consultant

Responsibilities:

• Worked with business users, functional lead to understand and document the Business requirements.
• Worked on installation and configuration of Cognos 8.
• Used Framework Manager to create models, packages and publish packages.
• Built models containing namespaces, query subjects and query items from scratch as well as from imported metadata.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Planned and Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Assist in the development of programming tools, macros and techniques to improve efficiencies in reporting Developed Standard Reports, Dash boards, YTD reports, Tabbed reports Charts, Drill through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Define Global Drill through Definitions and established drill-through from Cognos 8 Analysis Studio to Cognos 8 Report Studio.
• Migration of reports and catalogs from Cognos series 8.4 to Cognos series 10.1.1
• Upgraded reports from 8.4 to 10.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Testing the report and the validity of the data it retrieves from the database.
• Integrated Cognos 8 with third-party security providers like LDAP and distributed Reports through Bursting, E-mail and uploading to folders.
• Customizing Cognos Connection Portal based on the User Requirements.
• Scheduled Reports to run on a monthly, weekly and daily basis using Cognos Scheduler.
• Tuned the performance of the Cognos BI 8 for quick runtime of reports.
• Trained business users to develop/use reports using Report Studio/Query Studio.
• Knowledge of development and designing of ETL methodology for supporting data transformations using Informatica Power Center
• working experience in Data Mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehousing Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.

Environment: Cognos10.1.1,Cognos 8 BI, Cognos Connection, Report Studio, Query Studio, Frame Work Manager, Metric Studio, Analysis Studio, Informatica , Oracle 10g, XML , PL/SQL, SSIS, MS SQL Server 2005 \ 2008, Oracle 11g.

Confidential, Bangalore- India January 2008 - January 2011
Client: Confidential, USA
Role: Cognos Developer

Project 1Description:

Scorecards are basically used to evaluate the performance of employees in an insurance company. It involves lot of performance criteria, objectives. The objectives are calculated based on predefined formulas. This scorecard is used to analyze and verify the performance of employees of a particular department called ‘Property' . There are several levels. CR, Supervisor, Manager.
Manager can see the performance score card of Sup and CR in a particular period. These performancescorecards show monthly and yearly wise scores.

Responsibilities:

• Involved in data gathering and developing models in Framework Manager and publishing packages onto Cognos Connection.
• Created model query subjects, parameter maps and established relationships required between different model query subjects and between model query subjects and data source query subjects according to the business needs.
• Deployed packages, folders and content store from a development environment to test and production environments.
• Extensively used prompts, summaries, and conditional formats, grouping and sorting features to generate efficient and user-friendly reports.
• Carried out Bursting of reports.
• Scheduled reports using Cognos Connection.
• Created Power Play multidimensional cubes using Power Play Transformer and created drill-through.
• Formatted data to analyze in drill mode and slice & dice mode.
• Responsible in the weekly refresh of multiple multi-dimensional cubes.
• Worked on Cognos Security Administration to restrict the Users.
• Maintain the Cube Security by Category level and Dimension level.
• Coordinated in training sessions and demonstration of Cognos tools to End-users.
• Assisted users in troubleshooting their reports.

Environment: Cognos 8 BI, Cognos Connection, Report Studio, Query Studio, Frame Work Manager, Metric Studio, Analysis Studio, Access Manager, Oracle 9i, XML , and Windows 2003/XP.

Project 2: Auto Scorecards
Role: Cognos Developer

Responsibilities:

• Involved in creating sophisticated reports using Cognos 8.4 Report Studio.
• Responsible for metadata modeling, data security, object security and package security in Cognos 8.4 Framework Manager.
• Used Query Studio to create Ad-hoc reports.
• Involved in creating various prompts and cascading of prompt pages, filters, calculation and used conditional formatting accordingly.
• Published packages on Cognos portal.
• Used Cognos Go! Office to import reports from report studio to Ms office
• Created Dashboards which include drill through reports and scheduled reports.
• Working with packages in report studio to create professional reports (List, Cross tabs, Bubble chart, Bar graph etc).
• In charge for Cognos admin activities by creating user classes, managing user accounts, security rights for access to Cognos Portal, etc., in Cognos Access Manager Administration & Active Directory.
• Involved in preparing Test Scripts and validating the data based on the Scenarios.
• Creation and deployment of SSIS packages.
• Creation and scheduling of SQL Jobs.
• Db migration and implementation.

Environment: Cognos 8 BI, Cognos connection, Report Studio, Query Studio, Frame Work Manager, Metric Studio, Analysis Studio, Access Manager, Oracle 9i, XML , and Windows 2003/XP.

Confidential, Bangalore- India August 2006- December 2007
Role: IT Consultant
Project title: Local Management Reporting for Logica Pvt. Ltd.

Responsibilities:

• Creating reports (Report/query studio) which cater to different employees at different levels.
• Report includes all types such as charts (bar, bubble, line, lists etc.)
• Creating new packages from model and publish to Cognos server.
• Analyzing the requirement and building complex SQLQueries.
• Creating complex models using Framework manager.
• Dashboards and Drill-through reports for the complete management hierarchy.
• Interacting with the user to get the detailed information about the issues.
• Preparing and testing the code to fix the issues in Development and QA environment.
• Involved in preparing Test scripts and validating the data based on the Scenarios.
• Involved in Preparing the ETL Spec.
• Developed the mapping based on the ETL Spec.
• Created ETL packages for scheduling and refreshing the CUBE in periodic basis.

Environment: Cognos 8 BI, Cognos Connection, Report Studio, Query Studio, Frame Work Manager, Metric Studio, Analysis Studio, Access Manager, MS SSIS 2005, MS SQL Server 2005, Oracle 9i, Windows NT/2000.