SUMMARY

• 6+ years of experience in analysis, design, development, customization and implementation of Software applications and products. Strong understanding and knowledge in areas of Data Management/ Reporting and Project Management.
• Strong experience in gathering business requirements, data cleansing and extraction, report design, implementation and testing.
• Expert at data analysis and research, completing data requests and creating reports using Cognos8.x/10.1, SQL Server Integration and reporting services 2008,MS Excel, MS Access.
• Detail oriented professional with excellent report writing skills and presentation skills to upper management and third party vendors.
• Expert at developing and optimizing complex/standard reports using different Cognos reporting tools based on detail analysis of systems and stakeholder requests.
• Proficient at creating Dashboard, scorecard and other performance reports by using Cognos Business Insight and BI advanced.
• Strong migration skills and the ability to extract data from legacy systems to new systems and to process and validate the accuracy of the data.
• Excellent team player and proficient at working on multiple projects concurrently and delivering artifacts in time, resources and budget.
• Detail oriented and commitment towards learning and development.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like SQL Server 2000, Excel and Flat file to Microsoft SQL Server and Oracle Database by using SSIS and SQL server 2008
• Extensive experience on IBM Cognos 10x/8x (Framework Manager, Report Studio, Query Studio, and Cognos Connection).
• Extensive hands on experience in installing and developing OLTP/OLAP/Data Warehousing and Cognos tools, Cognos Impromptu, Cognos Powerplay, Cognos Transformer, Access Manager, Cognos Metrics Manager, Visualizer,Cognos10x (Framework Manager, Cognos Connection, Report Studio, Query Studio) and Cognos 8 Suite.
• Created Multi - dimensional models using Powerplay Transformer, Cube Designer based on business gathering.
• Extensive experience on Informatica providing Business Intelligence solutions using Informatica-Power Center and 1year of experience in data modeling with ERWIN tool.
• Technical and analytical skills with clear understanding of the difference in design goals of ER Modeling for OLTP and Dimension Modeling for OLAP.
• Experienced in Data Warehousing, ETL, Star Schema, Fact & Dimension tables and Hands on with Data Marts.
• Strong experience in Data Mapping and Data Loading techniques.
• Worked with Erwin, Designer to develop logical model, physical model diagrams and in forward, reverse engineering tasks.
• Worked in Data porting using open interfaces/ETL Tools from legacy systems to Data Warehouse database.

TECHNICAL SKILLS

BI/ OLAP Tools: IBM Cognos10.1/10.2/8X(Report Studio, Query Studio, Analysis Studio, Powerplay Studio, Event Studio, Workspace Advance, Workspace, Powerplay Transformer, Framework Manager), ReportNet 1.1, Cognos Planning, Cognos EP Series 7, Impromptu Administrator, Power Play, Cognos Query, Powerplay Web reports, Upfront, Visualizer, SQL Reporting Services, Oracle Discoverer 6i, Crystal reports 9.

Data Modeling/ Data Warehousing Tools: Informatica 9x/8x Power Mart/ Power Center, SQL Server DTS, SQL Server Integration Services, Decision Stream, Data Stage, Erwin4.0/3.5.2.

Databases: Oracle11x/10.x/9i, SQLServer2008/2005, IBM DB2 10x, MS Access.

Operating Systems: Windows 7/XP, UNIX (Linux, AIX, HP-UX, Solaris) and MS DOS.

Others: Expert in MS Excel, MS Access, MS Project, Outlook, FrontPage and MS PowerPoint, Toad, HP Service Manager, IBM Data Studio, Erwin 7.

PROFESSIONAL EXPERIENCE

Confidential, IL

Cognos BI Developer

Responsibilities:

• Effectively communicated with Business to resolve design action items. Involved in providing both business and technical expertise in the requirements gathering, report design, report development by performing analysis of an underlying data source/schema.
• Created and worked with complex database schemas and large volumes of data (up to hundreds of millions of rows), leveraged the data to create solutions that present data through Cognos BI Dashboards and KPI's.
• Migrated reports from Cognos 8.4 to Cognos 10.1 environments. Validated the migrated metadata models and reports in Cognos 10.1 environment.
• Developed Cognos reports using MDX and OLAP Cubes as a data source, Passing Parameters (MDX and regular) to drill down reports, etc.
• Supplemented regular prompts, cascading prompts, filters, Conditional style, static headers, Drill Through, sub queries to add interactivity for users in Report Studio.
• Created HTML Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.
• Trained end users to develop interactive dashboards using Business Insight for ad-hoc query analysis.
• Assisted the business users in analyzing the data by utilizing various Business Insight functionality - slider filters, chart type changes, drill up/down techniques, pre-defined/custom calculations, on the fly prompt modifications etc. on the dashboard.
• Developed dashboard reports using Business Insight Advanced (BIA) from the base and on the existing reports using multiple query objects and by integrating external data on the fly.
• Created dashboards using BIA by allowing consistent filtering across multiple objects and editing sets to modify calculations on existing reports.
• Performed post-development peer review & coordinated migration/deployment of packages, reports and cube between environments.
• Designer Dynamic Cubes - in memory tool using Cube Designer tool and deployed in the Cognos 10 environment to increase the performance.
• Developed SQL Server Stored Procedures for data migration and transformation from Teradata extracts to SQL Server objects.
• Articulated and implemented OLAP solutions that drive strong return on investment and provide robust high availability and performance.
• Presented demos to the business users to expose the proficiency of upgraded versions of Cognos tools.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.

Environment: Cognos 10.1/8.4 (Cognos Connection, Framework Manager, Report Studio, Analysis Studio, Event Studio, Business Insight, Query Studio, Powerplay Studio, Powerplay Transformer, cube Designer - Dynamic Cubes),Oracle 11G/10G, SQL Server 2005/2008, MS Visio, Toad 10.5, HP Service Manager.

Confidential, Orlando, FL

Cognos BI Developer

Responsibilities:

• Migration of the reports from Cognos 8.4 to Cognos 10.1 environments.
• Validating & troubleshooting migrated metadata models and reports in Cognos 10.1/8.4 environment.
• Designing and planning for application migration from Cognos 8.4 to Cognos 10.1
• Providing strategic solutions after performing RCA and troubleshooting the BI issues.
• Actively worked with Business Partners and Designers to get the Requirements and create High level Application Design.
• Successful Executing the Projects within the Budget and stipulated timeframe.
• Working on Incidents and Service calls using HP Service Desk/Service Manager to resolve the Production Issues.
• Responsible for managing the Framework Manager Projects, Models and Packages.
• Coordinated in moving the Packages, Reports, Cubes from Development environment to SimProd and Production Environment.
• Coordinated in different Levels of Testing to achieve the common goal of High availability of Web Application.
• Troubleshot Framework Manager Model which is migrated from Impromptu Catalog.
• Created IQD from Framework Manager and used it to create a model/cube for meeting some requirements where users wanted drill through/slicing and dicing, which can be done with a cube.
• Used features in Cognos administration like monitoring activities, system and schedule
• Setup security using Access Manager Administration.
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.
• Effectively communicated with Business Analysts to resolve design action items. Involved in providing both business and technical expertise in the requirements gathering, report design, report development, and support of all client/server layers and components of the data warehouse.
• Supplemented regular prompts, cascading prompts, filters, Conditional style, static headers, Drill Through, sub queries to add interactivity for users in Report Studio.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.
• Created List, Sub and Cross-Tab reports using Impromptu and distributed Catalog to users for Ad-Hoc reporting and analysis.

Environment: IBM Cognos 10.1/8.4 (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Powerplay Transformer, Powerplay Studio, Metric Designer, Metric Studio), Content Store, Oracle 10g/9i, IIS, Framework Manager on Windows XP Professional 2002, SQL Server 2005/2008, Toad 9.1, Control-m, Hp Service Manager, IBM DB2, ERStudio 7.1.

Confidential, Madison, WI

Cognos BI Consultant

Responsibilities:

• Implemented business process re-engineering for several business units using modern business technologies. Duties included gathering business requirements, making recommendations, preparing technical specifications and overseeing the implementation of the new processes.
• Organized cube dimensions hierarchically in a pattern which can easily be used for reporting by Cognos BI suite (Report Studio, Query Studio and Analysis Studio).
• Designed and developed Framework manager models and Packages for various projects with the source as DB2, SAP BIcubes.
• Designed and created dashboards reports and scorecards in Report Studio and Analysis Studio. Developed complex reports and implemented Bursting for the reports.
• Individually developed complex reports consisting of multiple queries, and multiple joins, Unions, ranking, and drill through to other reports. Extensively used MDX OLAP functions in Creating report Studio Reports.
• Migrated Cognos objects from DEV - > QA - > PROD and Optimized Cube performance to improve the report run time.
• Involved in developing complex Informatica mappings to implement the business logic for the project. Alsoscheduled the ETLjobsin peek monthly forecasting cycles.
• Involved in production support of reports and debugging issues raised by worldwide users there by fixing them in Dev and deploying them back to Production.
• Designed and developed Framework manager models and Packages for various projects with the source as DB2, SAP BIcubes.
• Migrated Cubes to Cognos 8 BI, Created externalized Query Subject to create Impromptu Query Definition (IQD) files to use as source in building Powerplay Transformer cubes and used as a cube data source to create a package.
• Published IWRs and Power Play cubes, Power Play reports, on the portal using Cognos IWR administration, Power Play enterprise server.
• Validated the reports against the planning data in the Cognos contributor along with unit testing by writing manual SQL queries against the database. Also, validated the Planning application and the ETL to ensure data integrity between them.
• Trained end users in accessing the reports, interacting with prompts and in creating ad-hoc reports using Analysis Studio.

Environment: Cognos 8.3/8.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection, Powerplay Transformer, Powerplay Studio), Transformer 7.4, DB2,Toad, HP Service Center, Informatica 8.6.1, MS SQL Server 2005, IBM DB2.

Confidential

BI Developer

Responsibilities:

• Interacted with the user to understand the user reporting requirements for various financial planning applications like PNL (Profit & Loss) Forecasting and Budgeting Model. Facilitated Joint Applications Development (JAD) Sessions for detailed definition of business requirements.
• Created ‘Requirement Specification document’ to define the requirement specification which addresses Functional and Non-Functional structure of the PNL BI reporting model.
• Expertise working on the Planning models built for the various applications to plan, budget & forecast activities in real time.
• Used access manager and Cognos Contributor to set user permissions and work flow access. Monitor and Maintain Job servers & Job Clusters.
• Published analyst cubes on the web using Cognos Contributor and set access using Access manager.
• Executed admin link macros upon the request for the real time reports, and performed GoTo Production on daily basis. Scheduled the batch files to publish the data from the planning to the ETL (AAF) and from ETL to the reporting.
• Created PNL Forecast reports for four decks (Monthly/Total Year Quarterly/Quarterly/Budget) for each individual company and created PNL Consolidated reports which capture the summarized data of the companies at different levels with drill through functionality.
• Expertise in developing Standard Reports, dash board, List Reports, Cross-tab Reports, Charts, and Multiple-levels of Drill through reports Using Report Studio.
• Deployed reports from development environment to the production ensuring the user group access and security.
• Validated the reports against the planning data in the Cognos contributor along with writing manual SQL queries against the database. Also, validated the Planning application and the ETL to ensure data integrity between them.
• Implemented database partitioning to improve the performance tuning of all the reports that access the huge table.
• Analyzed and created indexes on certain fields to boost the performance of the reports.
• Responsible for the installation, configuration and day-to-day tasks associated with ensuring the smooth and efficient operation of Cognos environment with good Knowledge of Cognos 8 BI and Cognos Connection portal.
• Trained the users in accessing the models and assisted them in building the adhoc reports from Query studio and also assisted the users to create dashboard reports using Analysis Studio.
• Participated in review meetings to propose enhancements to the existing application from business perspectives and coordinated with the users during the User acceptance phase.

Environment: IBM Cognos Planning 8.3 - Analyst / Contributor, Cognos 8.3 (Report Studio, Query Studio, Analysis Studio, Event Studio), IBM’s Adaptive Analytics Framework (AAF), SQL Server 2000 and Toad.

Confidential

BI Developer

Responsibilities:

• Generated catalogs by connecting to different databases.
• Developed reports from multiple queries using Impromptu and Power Play, and published them for end-users in Upfront.
• Created various types of reports such as List, Grouped List, Crosstab, Nested Crosstab, Drill through, and Standard List
• Created cascading prompts and worked with various prompt controls such as Value prompt, Pick list prompt, and Date and Time prompt.
• Customized Power Play Reports by using Slice and Dice, Drill through, Ranking, Conditional formatting, and Sorting options.
• Worked with the join functionality to create various reports.
• Experienced Cognos 8.4 BI Studio, Cognos 8.4 Framework Manager, Cognos 8 Administration, and Cognos SDK
• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management.
• Generated reports for comparative analysis based on the Projected v/s Actual.
• Used Cognos Scheduler to update a report for specific or recurring times and dates
• Designed Multi Dimensional Cubes using Transformer and Optimized Cube performance to improve report run time.
• Installed Cognos v8.x on Windows environment with Oracle 10g as a backend database.
• Deployed cube security to give only specific users the access to specific hierarchies.
• Designed and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Worked on Informatica for master data management, data migration.
• Successful implementations of the Analyst, Manager, and Contributor applications within Cognos 8 Planning
• Extract Transform Load (ETL) development using Informatica power center 8.5.

Environment: Cognos 8.4/8.2, Planning, Impromptu, Impromptu Web Reports (IWR) 6.6, Power Play 6.6, Power Play Transformer 6.6, Upfront, Access Manager, and Informatica power center 8.5.