PROFESSIONAL SUMMARY:

• A dynamic professional with 8 years of experience in IT Industry with experience in analysis, design, testing, development, documentation, Quality Assurance and implementation of Cognos applications.
• Major areas of expertise is in designing and developing, creating and modifying different reports like Master/detailed, List, Chart, Cross Tab, Drill Through using Query Studio, Report Studio, Analysis Studio.
• Excellent working knowledge of Cognos Series 10.1.1/8.4/8.2/7.x/6.x.
• Experience in Framework manager for creating metadata models (Relational and DMR), folders, filters and publishing packages.
• Having good understanding of Dimensional Data modeling (Star Schema modeling, Snow-Flake modeling, Fact and Dimension tables, and Physical & Logical data modeling.)
• Excellent working knowledge on ETL Tools Informatica and Data Stage.
• Good Knowledge on programming using Oracle9i-SQL, SQL*Plus, PL/SQL Procedures/Functions, Triggers and Packages.
• Trained on Cognos TM1 in Turbo Integrator, Executive viewer, TM1 Architect and TM1 Perspectives for MS Excel.
• Having Good knowledge on Metric Designer, Metric Studio and Score Cards Design.
• Trained on Cognos Planning7.5/8.4 with including Analyst, Manager and contributor.
• Having good knowledge on UNIX and Shell scripting.

Certifications:

• IBM Cognos BI Developer certification.
• IBM Cognos Meta Data Developer certification.
• IBM Cognos BI OLAP Developer certification.
• IBM Cognos TM1 certification.

Candidate\\Testing ID for the above certifications: SR6989600

Education:

Bachelor of Computer Applications

SKILLS:

PRIMARY SKILLS:

Cognos10.1/8 Business Intelligence Suite. Versions: 10.1/8.4/8.3/8.2/8.1.2, Metric Studio.8.3/8.2,CognosReportNet,CognosPowerPlayTransformer 8.4/8.3/7.3, CognosImpromptuV7.x/6.x,Impromptu WebReports (IWR), Upfront, Access Manager, Cognos Planning7.5/8.4 with Analyst, Manager, and Contributor, Cognos TM1 9.4 TI and TM1Architect, TM1 perspectives for excel, Informatica6.1 and Data Stage .

LANGUAGES:

Java/J2EE, C,C++, SQL, PL/SQL

RDBMS:

SQL Server 2000/05/08, IBM DB 2, Oracle 8/9i/10g, Teradata.

OS:

Windows 95/98/2000/NT/XP, Linux.

OTHER SKILLS:

XML, HTML, JavaScript, SQL, UNIX Shell scripting.

ETL:

Informatica Power Center Suite 6/7, Data Stage8.0.

PROFESSIONAL EXPERIENCE:

Client: Confidential, New York, NY (Dec 2010 to Till Date)
Cognos Developer

Description: Confidential, financial management and advisory company with a presence in 38 countries across six continents. It serves the needs of both individual and institutional clients with a diverse range of financial services.

TPW - Touchpoint Warehouse:
TPW CRM is a warehouse that stores touch point information. Touch points consists of Conferences, Deals, Non-Deals, Investor-Corporate and Analyst data for Research Hierarchy people. We get data from our upstream applications ROADSHOW, GEMS, COMPASS and ISALES. TPW CRM stores future data and historical data for trailing 3 years. COGNOS Cubes and reports have been build/enhanced to support decision making for Traders of Bank of America.
Client Profitability:
Within the Equity Business Management world, to build a system that would allow business managers to run periodic global and regional reports and perform on-going analysis to highlight the most profitable and least profitable clients. This required, bringing together data from several disparate sources into a single repository and need to analysis and reporting could be performed.

Responsibilities:

• Installation and configuration of Framework Manager and Power Play Transformer.
• Involved in gathering requirements for Transformer cubes and Reports.
• Developed and tested Package in Framework Manager and built cubes based on these cognos packages by using Power Play Transformer.
• Involved in the design of the report format and in the preparation of the

Specification documents for the reports.

• Developed and tested Reports in Report Studio and Query Studio.
• Created pre calculated columns in fact tables using PL/SQL Stored Procedures.
• Created complex reports (multiple queries joined together to create one output, manual sql with custom joins) using Report Studio.
• Authored multi page, high level visual reports with multiple data sets which included the development of dashboards and Summary reports.
• Created various prompts for the Report Studio Reports.
• Worked on Java Script to customize the prompts and enhance to report design structure.
• Create and manage scheduled jobs.
• Enhancements to Cognos 7 cubes and reports in Cognos 7 upfront.

Environment:
Cognos 8.4/10.1,Transformer 8.4/10.1,Analysis Studio, Event Studio, Framework Manager, Report Studio, Cognos Connection, LDAP, Java Script, Windows 2003 server, Oracle 10g/11g, PL/SQL, PL/SQL Developer, Toad.

Client: Confidential, (Apr 2008 to Dec 2010)

Project 1: Confidential, NAO
Client : Confidential,
Cognos Developer (Dec 2009 to Dec 2010)

Description: Confidential, is one of the leading Auto finance corporation Bank, Confidential, is actually a standalone banking operation that provides lending and banking services. MAC offers loans and lending to GM and Chrysler dealers to finance their operations. This project deals with NAO region (North America Operations) business of Confidential,.

The goal of the Project is to provide a data warehouse and business intelligence design, development and implementation expertise to deliver the NAO Retail Financing Profitability Business Intelligence solution. Major task for the project is to implement physical data warehouse model and reporting data mart based on the underlying logical data models that were derived from the IBM Banking Data Warehouse Model. Furthermore, design/build with the intention of establishing the standard for retail finance profitability data warehouse and reporting data mart solution for Confidential, North America Operations.

Responsibilities:

• Worked on preparing data dictionary and functional and technical specifications for the reports.
• Created Projects, Namespaces, Data Source, Models and dimensionally Modeled Relational Data (DMR Models) in Framework Manager.
• Generated IQDs for cubes using Framework Manager and built cubes using Power Play Transformer and published them on toCognosconnection.
• Created Packages with various security settings and published them ontoCognosConnection.
• Developed List, crosstab, drill through, master-detail, chart, dashboards and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports.
• Authored multi page, high level visual reports with multiple data sets which included the development of dashboards and Summary reports.
• Involved in Building portals and designing them according to user requirements.
• Enhanced reports by using a series of features like; Highlighting report values using conditional styles, focus the scope of a report using filters, format report objects, applying a report template.
• Tested reports and performed unit testing, Trained end users on how to useCognosConnection, Query Studio and Analysis Studio.
• Developed HTML and Java script code in Reports to achieve requirements.

Environment:
Cognos 8.3/8.4 ,Analysis Studio, Event Studio, Metrics Studio, Framework Manager, Report Studio, Cognos Connection, LDAP, Cognos Configuration , Java Script, Windows 2003 server, Oracle 10g/11g, PL/SQL, PL/SQL Developer, Toad.

Project 2: Confidential, OLAP CUBES.
Client : Confidential,

Cognos Developer (Feb 2009 to Dec 2009)

Description: This is OLAP project, this deal with creation of New Penetration, Volume, Volume CM, Losses, Applications, Repos and Delinquencies cubes.

Responsibilities:

• Created Multi-Dimensional Cubes and Reports as per the User Requirements. Generated Trend Over Time, Variance Reports. Deployed Power Cubes on Power Play Enterprise Server.
• Developed Power play cubes and published them to Cognos connection through automation.
• Used Ranking functionality for top ten Customers and Billing Customer Service locations.
• Customized data by adding calculations, summaries and functions.
• Developed List, crosstab, drill through, master-detail, chart, dashboards and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports.
• Authored multi page, high level visual reports with multiple data sets which included the development of dashboards and Summary reports.
• Created reports in HTML format for easy navigation of data from web browser.
• Giving support for the daily base build cubes by running jobs in autosys tool.
• Monitoring the Service Center from time to time (daily) to check for tickets assigned to our group and work on them to get the resolution ASAP.

Environment: Power Play Transformer7.3, Cognos 8.3/8.4 ,Analysis Studio, Event Studio, Metrics Studio, Framework Manager, Report Studio, Cognos Connection, LDAP, Cognos Configuration , Java Script, Windows 2003 server, Oracle 10g/11g, PL/SQL, PL/SQL Developer,ToadSQL Server and Windows NT,

Project 3: Confidential, IO (International Operations).
Client : Confidential,

Cognos Developer (Apr 2008 to Feb 2009)

Description: The goal of the International Operations project is to provide a standard set of reporting tools and data on a common and scalable platform. The project will identify and integrate non-IW data sources required into the IW database and will provide a common set of reports for Confidential, International Operations report users.
The IO application will leverage the existing Confidential, Exchange Portal Infrastructure by adding a new link to provide IO users online access to new cross functional and cross branch reports in a new Cognos 8 reporting environment.

Responsibilities:

• Involved in gathering Business Requirements for new models.
• Involved in the design and development of CRN reports inReport Studio.
• Created database connections for different data sources.
• Built models usingFramework Managerand published the package.
• Implemented security for data access, object level access and package access.
• Accessed published package usingCognosConnection.
• Prepared Unit Test Cases and performed testing in the developmentenvironment.
• Reports were triggered by DB Stored Procedures.
• Created Query Subjects in Framework Manager.
• Maintained and publishedFramework Model. Initially theFramework ManagerQuery Subject was pointed to SQL Server2000 as database and all the reports have been developed. In final, the sameFramework Manageris deployed to Oracle 9 and all ReportNetreports made to run successfully on both the platform.
• Created drill-thru reports and cross-tab reports inReport Studio.
• Create and manage scheduled jobs.
• Created complex reports with sub-queries and sub-sub-queries.

Environment:
Report net MR1, Framework Manager, Report Studio, Cognos Connection, LDAP, Cognos Configuration, Java Script, Windows 2003 server, Oracle 10g/11g, PL/SQL, PL/SQL Developer, Toad.

Client: Confidential, Canada
Cognos Developer (Oct 2006 Apr 2008)

Description: Confidential, has a need for an analytical data warehouse to improve the decision-making. Like every (international) fast growing banks this bank is also searching for new business avenues, wants to increase the customer base and attract more investments. The major deal of the project is to develop operational and analytical reports for each module out of the Delaware Housing using Power Play Transformer. Oracle was Data base.

Responsibilities:

• Installed Power Play Transformer for Client, Power Play Server.
• Created Multi-Dimensional Cubes and Reports as per the User Requirements. Generated Trend Over Time, Variance Reports. Deployed Power Cubes on Power Play Enterprise Server.
• Developed Power play cubes and published them using upfront.
• Used Ranking functionality for top ten Customers and Billing Customer Service locations.
• Installed Cognos ReportNet 1.1 and Power Play Enterprise Server6.6.
• Customized data by adding calculations, summaries and functions.
• Created List Reports, Cross Tab Reports and Drill Through reports.
• Created reports in HTML format for easy navigation of data from web browser.
• Schedule a group of reports in Cognos connection to be run regularly in a specific order.
• Trained the End users how to navigate in Power play cubes (mdc) to build the simple reports.

Environment: Cognos Report Net 1.1, Power Play Transformer, Power Play Enterprise Server 7.0, Oracle and Windows NT.

Client: Confidential,Dallas Retail Sales Decision Support System.
Data warehouse Developer (Nov 2004 to Oct 2006)

Description: This is Warehouse being developed for SABRE Inc., a leading research-driven pharmaceutical products and services. The Objective of this project is to provide the single integrated database to the client that extensively helps in the keeping low cost maintenance.

ETL Responsibilities:

• Extensively participated in Data Analysis, Data Extraction, Data Transformation and Data Loading.
• Integration of various data sources like Oracle and Flat Files into the Staging Area.
• Used Lookup, Update Strategy, Aggregator, Expression, Router Transformations.
• Developed Joiner Transformation for Extracting from multiple Sources.
• Created Informatica mappings with Stored Procedure to build business rules to load data.
• Optimized Query Performance, Session performance.
• Developed mappings to load the data in Slowly Changing Dimensions
• Involved in Scheduling.

OLAP Responsibilities:

• Designed and Maintained FrameWork Models.
• Creation of Calculations, Prompts, Conditions and Filters in a Report Studio Reports.
• Created different Joins according to User requirements in reports.
• Created Power Play Cubes using Power Play Transformer.
• Created IQD’s using Framework Manager and published them.

Environment: Informatica Power Center 6.1, Oracle 9i, Cognos ReportNet 1.1, Cognos Power Play Transformer 7.3, Windows NT.

Client:Confidential,Cincinnati, OH
ETL Developer (Mar 2004 to Nov 2004)

Description:
Confidential, is a mutual life insurance company offering a broad portfolio of innovative products through field representatives. The project involved extracting data from their legacy system sources and loading into a Data Mart. The major job involved in cleansing the data and transforming the data to the staging area then loading the data in the Data Mart for analyzing business performance at various stages.

Responsibilities:

• Participated in the review and approval of the technical transformation requirements document used to design and build the ETL modules in Data Stage Designer.
• Extensively worked with Facts and Dimension tables to produce source - target mappings based upon business specs.
• Used Data Stage Manager to implement the Import and Export Interfaces.
• Developed many Data Stage application jobs for data processing, loading and jobs are scheduled using Data Stage Director.
• Designed several Data Stage jobs using Sequential File, Join, Merge, Lookup, Change Apply, Change Capture, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Dataset, Pivot stages, Aggregator,Transformer,Modify,and Compare.
• Automated Job Control using Batch logic to execute and Schedule various Data Stage jobs.
• Migrated data from Oracle 8i, SQL Server, DB2 and other flat files data sources using Data Stage.
• Analyzed and tuned the database application for performance improvement.
• Extensively used Data Stage Designer components to design various jobs in accordance with business specs.
• Developed the ETL Jobs for handling the SCD Type-II Surrogate Key generation.
• Used Before and After Stage subroutines to further enhance performance of the system.
• Developed the Data Quality jobs, performed the Unit testing of all the jobs through the Job Sequences and documented the test case results as per the standards.

Environment: Ascential Data Stage 6.0, DB2, Teradata, Oracle 8i, SQL, PL/SQL, Shell Scripts, Erwin, UNIX, Windows NT 4.0