Professional Summary:

• Over 7 years of IT experience in Data Warehousing environment with Cognos Report Net suite and Cognos 10.1,8.x/7.x BI series with sound knowledge in different phases of Software Development Life cycle SDLC including requirement, analysis, design, development, testing and production.
• Good experience on Cognos Enterprise EP series Tools such as Cognos Report Net/Cognos 8.x, Cognos Impromptu 7.x/6.x, Cognos Impromptu Web Reports IWR 7.x/6.x, Cognos Transformer Power Play 7.x/6.x, Power Play Enterprise Server PPES 7.x/6.x, Access Manager 7.0, Upfront 7.3.
• Expert in Cognos Report Net/Cognos 8-Framework Manager, Cognos connection, Report Studio, Query Studio and Analysis Studio.
• Thorough knowledge in developing frameworks and dashboards using Cognos,
• Strong understanding of Business Intelligence BI, OLAP, ROLAP tools.
• Excellent one to one interaction with end users/Business analysts to identify their needs and wants, then translate the functional requirement into reporting requirements, design and business data flow.
• Thorough knowledge of Star-Schema design methodology, dimensional modeling Kimball and Multi-Dimensional Database Architecture. Strong understanding of Business Intelligence BI, OLAP, ROLAP tools
• Involved in migration of Impromptu Reports including designing the catalog, identifying the table structure as well as migration of Report Net 1.x reports to Cognos8.
• Excellent skills with expertise in Data design, analysis using Oracle 7x/8i/9i, 10g, SQL Server, SQL, PL/SQL.
• Used TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.
• Expert in developing and testing of reports and cubes using Cognos 7.x, 6.x tools in Windows.
• Knowledge in Pharmaceutical, Finance, Banking, Telecom .
• Excellent skills in advanced Report Authoring which includes Conditional Formatting, using Filters.
• Original and forward thinking, ability to lead, organize and work in a team.
• Strong experience in client interaction, understanding business applications, business data.
• Highly motivated, self-starter able to work independently and collaboratively within a diverse technical team.
• Original forward thinking, ability to lead, organize and work in a team.
• Excellent communication, presentation documentationvery good team player.

Technical Skills:

BI Tools: Cognos10.1, 8.x Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio , Cognos Report Net Report studio, Query Studio and Framework Manager , Cognos EP BI series Cognos Impromptu, Power Play, Transformer and Access Manager.

Data Modeling Tools: Transformer Framework Manager.

ETL Tools: Abinitio V1.13 GDE, Informatica 7.1/6.1.

RDBMS: Oracle Database

10g/9i/8i, MS Access, Sql Server2000/2005.

Languages: PL/SQL, SQL, C, C .

Web Technologies: Microsoft IIS, HTML.

Operating Systems: Windows.

Professional Experience:

Confidential

Sr Cognos Developer.

• For more than 80 years, Caterpillar has been building the world's infrastructure and, in partnership with its independent dealers, driving positive and sustainable change on every continent. Caterpillar is a technology leader and the world's largest maker of construction and mining equipment, diesel and natural gas engines, and industrial gas turbines.
• For 30 years, the Financial Products Division has offered a wide range of financing and insurance alternatives for Caterpillar machinery and engines and Solar gas turbines, as well as other equipment and marine vessels. FPD includes Cat Financial, Cat Insurance, Cat Redistribution and Cat Power. Our offices and subsidiaries are located throughout the Americas, Asia, Australia, and Europe, with headquarters in Nashville, Tennessee.
• Our business was formed in Peoria, Illinois, in 1981 to provide lease financing for Caterpillar lift trucks. By 1985, we had expanded our services to support the entire Cat product line. We relocated to Nashville in 1991.
• The project which I was involved was to build Frame work manager models and build reports out of it and upgrade the Cognos version from cognos10 to Cognos 8.4.
• Designed a Standardized Business models in Framework manager and published it for building reports in cognos8 Report studio.
• Involved in writing the technical specifications for the Reports and assisting the developers understand the technical requirement and help them build the reports.
• Used oracle to run SQL queries and validate the data against the micro strategy reports.
• Created cubes using Framework package as data source and implemented security into the cube model.
• Involved in writing the technical specifications for the Reports and assisting the developers understand the technical requirement and help them build the reports.
• Providing Production Support and resolved maintenance issues.
• Involved in current projects for requirement gathering and converting them into technical specifications and to build the data model to buld the reports based put of it.

Confidential

Sr Cognos Developer

• Designed a Standardized Business models in Framework manager and published it for building reports in cognos 10.1 Report studio.
• Involved in writing the technical specifications for the Reports and assisting the developers understand the technical requirement and help them build the reports.
• mentoring the junior developers in developing professional reports in Report Studio and ad hoc reports in Query Studio. Created list reports, cross tab reports, chart reports and reports with features like conditional formatting, drill through and have extensively used the new features in Cognos 10.1.
• Used oracle 10 g to run SQL queries and validate the data against the micro strategy reports.
• Used java scripts in the reports against the prompts.
• Provided Production Support and resolved maintenance issues.

Environment: Cognos 10.1 BI series - Framework Manager10.1, Cognos Connection, Report Studio, Query Studio, Oracle 10 g, Windows .

Confidential

Cognos Developer

• I was responsible for leading the Cognos offshore team.
• Developed professional reports in Report Studio and ad hoc reports in Query Studio. Created list reports, cross tab reports, chart reports and reports with features like conditional formatting, multiple drill through and have extensively used the new features in Cognos o8.4.
• Used SQL Server to run SQL queries and validate the data in Data warehouse and Data Marts.
• Created cubes using Power play Transformer and implemented security into the cube model.
• Created complex custom queries to optimize the Report Studio report Performance in the model.
• Provided Production Support and resolved maintenance issues.
• Designed a Standardized Business model in Framework manager and published it for building reports in cognos8 Report studio.
• Created IQDs' in the framework manager packages and used them as data sources for Power Play Transformer models.
• Developed effective SQL queries and performed Unit Testing to ensure the accuracy of data displayed in the report.
• Also created documentation for all the processes involved like applying security for reports.

Environment: Cognos 8.4,cognos 10.1 BI series - Framework Manager, Cognos