Summary


Over 9+ years of experience in requirement analysis, design, development, writing test plan/test cases, testing, capturing test results in 3 tier business applications and web-based applications
Over 7+ years of experience in development and implementation of Data Warehousing applications using Cognos Business Intelligence, ReportNet, Cognos8, Impromptu, Impromptu Web Reports IWR, Cognos Power Play Enterprise Server, Cognos Transformer, Cognos Upfront, Access Manager, Informatica power Center 8. x/7. x/6 .x and SQL Server.
Well-versed in developing reporting applications using Cognos Business Intelligence components like Framework Manager, Query Studio, Report Studio, Analysis Studio, Metrics Studio and Cognos Connection.
Excellent understanding and hands-on experience of Extraction, Transformation and Loading ETL of data into Data warehouse/Data Marts/ Online Data Stores using tools like Informatica and Data stage
Good working and practical knowledge in all aspects of SDLC like requirement analysis, design, development, testing, implementation and maintenance of Projects
Designed and implemented database and reporting solutions using SQL, MDX and XML.
Strong understanding of Dimensional Modeling concepts and have Experience in dimensional modeling using Star Schema and Snow-Flake Schema
Proficient in using best practices to support the reporting activities. Adept in using performance tuning and optimization techniques like load balancing, table weighing and partitioning.
Involved in upgrades of Cognos series 6 to series 7 suite
Developed graphics reports extensively in Report Studio
experience in installation and configuration of ReportNet suite
Involved in upgrades of Actuate version 7.x to 8.x
Extensive exposure to various business processes spanning over spectrum of industries Health Care, Insurance, Finance and Retail
Major area of experience in designing and developing Decision Support Systems DSS and Business Intelligence tools from Cognos
Experienced with multiple relational databases, Sql Server, Oracle 10g/9i/8i, UDB and DB2
Hands on experience in analysis and report design documents, report layout, development, testing using Actuate Reporting
Experience in Client/Server application development using Visual Basic, ASP and Sql Server
Strong design and programming technical skills, ability to learn new emerging technologies and adapt quickly


Acadamic -
Graduated in Bachelors of Engineering
Post Graduate Diploma in Computer Applications
Certificate Course in Oracle Financials
Certificate Course in Oracle 7.3 and Visual Basic 5.0


Employment

November, 2008 -  Present
Role : Lead Developer

Working on Manufacturing Reports for producing the Manufacturing Reports. This project involved creating model and generating Work Order number, Stocking Type, Standard hours, Overhead Cost and Inventory Transactions of different Branch locations.

Responsibilities : Interact with business users or stake holders or IT team members from departments like SAP, Siebel and E1 team to gather and understand the requirements
Gathered requirements from source system staff and identified the data and reporting requirements
Planned an approach for documenting, categorizing and packaging the requirements
Involved in Designing and Creating various models and Publishing packages in Framework Manager
Developed the model/packages in Framework Manager creating star schema presentation business layer or EDW view
Developed advanced reports using Report Studio
Developed various adhoc report types ranging from simple lists, crosstabs, chart, through complex dashboards, drill-through, master-detail and conditional formatting reports.
Created Complex, multipage reports involving prompts, cascading prompts, conditional rendering and conditional highlighting
Created Scorecards and Metrics using Metric studio
Worked as a Lead Developer for Manufacturing Project which helped me understand the business well since the project needed my involvement right from the business requirements stage through the completion of project
Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision-making
Involved in improving the performance of the report

Developed mappings using corresponding Source, Targets and Transformations like Lookup, etc.
Created Mfg Cube as the data source in Powerplay Transformers
Built multi-dimensional models and cubes in Transformer using IQDs as a data source
Identified various dimensions and measures required for the generation of a cube
Troubleshoot various existing reports that had issues and Fixed Remedy tickets from production system
Created reports, complex and Cross Tab reports using Cognos Report Studio
Deployed packages, folders and content store from a development environment to test and then to QC and Production environments.

Optimized the Powerplay Transformer Cube build times using various techniques like SQL Tuning, Time-based partitioning and created Powerplay Reports using the Powerplay for Windows application Mentor and trained in house employees. Created ETL Source to Target maping document.
Mentored the team members to understand the project ETL Design Architecture and Over view.
Extensively worked on Informatica Designer, Workflow Manager, Workflow Monitor Working on Source Analyzer, Warehouse designer, Mapping Designer and Mapplet Designer.
Extracted data from different Sources like Oracle and Sap R/3, Flat Files.
Identified and tracked the slowly changing dimension tables.
Scheduled the Sessions/Workflows by using Informatica Tool.
Performed Unit Testing for ETL Mappings and documented the results.
Worked closely with QA team to close the bugs if any.

Environment : JDEdwards, SAP, Cognos 8 Business Intelligence 8.1.2 Report Studio, Metric studio, Analysis Studio, Framework Manager, Oracle Sql Developer, Toad 8.5, Informatica 8.x, Mercury Quality Center 9.0, Putty Client, Windows XP and Linux

April, 2008 -  October, 2008
Senior Cognos Consultant

Automate the Current Business Process for producing the Manufacturing Inventory Status Report. This project involved creating model and generating Stock Status Reports of different Plants.
Developed RMA Return Material Authorization reporting application to provide information on Return Material Authorization.

Responsibilities : Analyzed the requirements and specifications to create the Reports, Quarterly Package and Dashboards
Involved in Designing and Creating various models RMA Application, Sales and Product Dashboards, Chemical Pricing and Publishing packages in Framework Manager
Designed and developed mapping, transformation logic and processes in SQL Server for implementing business rules and standardization of source data from multiple systems into the data warehouse.
This application retrieved information from OLAP cubes, using MDX and displayed the reports to end users
Developed advanced reports using Report Studio
Developed and maintain of DTS and SSIS packages

Developed mappings, applets using corresponding Source, Targets and Transformations like Lookup, update, aggregate, etc.
Developed the model/packages in Framework Manager creating star schema presentation layer/ business layer
Transact SQL and stored procedure development
Written Stored Procedures to import the data from different data sources
Created reports with Analysis Services Cube as the data source using SQL Server 2005 Reporting Services
Scheduled and executed SSIS Packages, using SQL Server Agent
Created, updated and maintained DTS technical documentation.
Fine tuned SQL queries using hints for maximum efficiency and performance
Migrated Web Catalog applications to Cognos PowerPlay Cubes
Created different types of ad-hoc Reports and Charts in Query Studio
Created reports, Drill through Reports and Cross Tab reports using Cognos Report Studio

Environment : JDEdwards, Cognos 8 Business Intelligence 8.1.4 Report Studio, Framework Manager, SQL Server 2000/2005, Access, Windows 2000/XP

July, 2007 -  March, 2008
Cognos Developer

This Pilot project involved creating model and generating reports of different Agencies in Virginia State. This Prototype project is designed to give summarized information, performing based on State/Region/Agency view. This includes Food Stamps, Medicated, Child Protective Services and census data.

Training

Microsoft Certified Professional in VB
Brain bench Certified in Software Quality Assurance , SQL 2000 , HTML and WEB Programmer



Skills

Business Intelligence Tools : Cognos 8 Business Intelligence 8.1/8.4 MR2 Report Studio, Query Studio, Analysis Studio, Metrics Studio, Framework Manager, ReportNet 1.1 MR3/1.1 Framework Manager, Report Studio, Query Studio, Cognos Impromptu 7. x/6 .x, Impromptu Web Reports IWR, PowerPlay Transformer 7. x/6.0, PowerPlay Enterprise Server, Actuate Reporting 7. x/8.0 ETL Tools : Decision Stream, Data Manager, Informatica PS 8. x/7. x/6 .x, DTS, SSIS RDBMS : Oracle 10g/9i/8 .x, SQL Server7/2000/2005, DB2 and Access. Operating Systems : Windows 95/98/2000/XP/NT, UNIX and Solaris Design Tools : Erwin, VSD Visio soft diagram Languages : C++, C, SQL, MDX, PL/SQL Web Servers : IIS 4. x/5 .x Web Technologies : Java Script, XML, HTML 4.0, ASP, VBScript ERP : JD Edwards, Oracle Financials, SAP R/3, SIEBEL



Miscellaneous

Responsibilities : Analyzed the requirements and specifications to create the Reports, Quarterly Package and Dashboards
Involved in Designing and Creating various models and Publishing packages in Framework Manager
Developed advanced reports using Report Studio and Ad-hoc reports using Query Studio
Developed a prototype for Customs Department to demonstrate the benefits of Performance Indicator Reports
Written Stored Procedures to import the data from different data sources
Imported data from Text file through SQL Loader
Modified existing Reports
Fixed tickets from production system
Created calculations, filters used by report authors
Created different types of ad-hoc Reports and Charts in Query Studio
Created different types of Professional Reports Cascading, Drill Through, Web Page Style, etc and with complex formatting in Report Studio
Created reports, Drill through Reports and Cross Tab reports using Cognos Report Studio
Cross training the end user for Query Studio and Report Studio and Framework Modeling
Environment : Cognos 8 Business Intelligence 8.1.2 MR2, Cognos Report Studio, Cognos, Toad, Internet Information Server, Oracle 10g/9i Windows 2000/XP