SUMMARY

• IBM Certified Report Developer having 9 years of experience in IT industry. Expertise in Analysis, Design, Development and Implementation of Data Warehousing and Business Intelligence applications using various Reporting tools (Cognos Analytics 11.0.3,Cognos 7/8/10.x, Business Objects) and ETL tools (Cognos - Data Manager, Informatica, Pentaho Data Integration)
• Extensive experience in BI Reports and Dashboard development using Tableau,Cognos BI Suite, Cognos Connection, Report Studio, Query Studio, Event Studio, Business Insight, Active Reports, Dynamic Cubes .
• Deep understanding of the principles of Data warehousing using fact tables, dimension tables, star schema and snowflakes schema modeling, slowly changing dimensions etc.
• Experience in creating Data Models including Star schema, Snowflakes schema and DMR in Framework Manager and applying security and complex business logic to packages.
• Experience in designing and developing Models and Cubes in Cognos Transformer and Cognos Cube Designer for OLAP analysis.
• Proficient in PL/SQL and MDX. Having excellent understanding of different databases (Oracle, SQL Server, DB2 and Teradata).
• Worked extensively on client facing roles, delivered multiple projects running on Agile and Waterfall methodology. Actively worked in all the phases of Software Development Lifecycle.
• Excellent analytical and communication skills, proactive, well organized, efficient, and a great team player.
• A fast learner and always ready to explore new technologies in BI and Analytics domain.
• Good exposure of Insurance, Healthcare Banking and Retail domain.

TECHNICAL SKILLS

Technologies: Data Warehousing, Business Intelligence

BI Analytics and Reporting: Cognos Analytics11.0.3, IBM Cognos 8.x,10.x,Report Studio, Query Studio, Cognos Dynamic Cubes, Event Studio, Transformer, Business Object 7/8, Actuate 8.x

Data Modeling: IBM Cognos Framework Manager, Cognos Cubes Designer, Cognos Powerplay Transformer

ETL Tool: Informatica, IBM Datastage

Databases: Oracle 9i,10g,11g, Sybase 12.5, PL/SQL, Teradata,DB2

Operating Systems: Windows 2000,Windows 98/XP,UNIX (HP-UX)

Programming Methodologies: HTML, JavaScript, Java, Java Servlets

PROFESSIONAL EXPERIENCE

Confidential - Atlanta GA

Technical lead

Responsibilities:

• Communicated with global Stakeholders and business to gather and document requirements.
• Successfully led a team of 5 developers for migrating Cubes and reports from Cognos 7.5 to Cognos 11.03 environment. Worked as a liaison between Business and Confidential team.
• Created Technical design document and worked on development strategy with the team.
• Performed optimization on the reports to decrease the run time to meet the presentation time requirements and made changes to the existing reports for good look and feel in Cognos 11.03 environment.
• Developed framework manager model and worked with ETL team to create facts and dimension tables for reports .
• Implemented security on the reports as per business requirements.
• Worked with UAT team in preparing test cases, data validation and resolved defects.
• Provided training to clients (Report users) to generate report outputs in Report Studio and create ad-hoc reports in Query Studio.
• Deployed Reports in Production and supported for post-production issues.

Confidential - Atlanta GA

Senior BI Consultant

Responsibilities:

• Worked with Dashboard users to understand the KPIs and Metrics to display on the Management Dashboards using Cognos Active report and workspace.
• Designed and implemented Cognos Dynamic Cubes using star schema concepts.
• Created mapping, workflows and ETL packages for validation, data transfer to a data warehouse and DataMart.
• Analyzed multiple existing reports from Production environment and worked on Performance tuning of reports by tuning SQL queries and using Cognos best practices.
• Provided technical support to report users and trained them on Cognos reports.
• Worked with UAT team in preparing test cases, data validation and resolved defects.
• Provided training to clients (Report users) to generate report outputs in Report Studio and create ad-hoc reports in Query Studio.
• Deployed Reports in Production and supported for post-production issues.
• Supported other reporting proprietary project in Randstad.

Environment: Cognos Analytics 11.0.3,Cognos 10.2 (Framework Manager, Report Studio, Analysis Studio, Cognos Dynamic Cube), UNIX, Oracle SQL developer,Datastage

Confidential - Atlanta GA

Senior BI / Cognos Developer

Responsibilities:

• Worked with business users and SMEs to understand the project requirements and prepared Functional Specification Documents and Technical Design Documents.
• Created data models in Cognos Framework Manager connecting various data sources and stored procedure, documented Cognos metadata model specifications and Cognos report specifications with detailed database mapping.
• Designed, developed and implemented Active Reports using complex and advanced features in Active reports.
• Developed Metrics Dashboards and Reports for some of the very complex requirements using Stitched query and Macro prompts, Java script functionalities.
• Created complex SQL Queries using aggregate functions and followed best practices for performance tuning.
• Worked with ETL team to create mapping, workflows and ETL packages for validation, data transfer and data load in data warehouse and datamarts.
• Analyzed multiple existing reports from Production environment and worked on Performance tuning of reports by tuning SQL queries and using Cognos best practices.
• Worked as Cognos Administrator and performed admin tasks including creating user accounts, software installations and deployments.
• Worked with UAT team in preparing test cases, data validation and resolved defects.
• Provided training to clients (Report users) to generate report outputs in Report Studio and create ad-hoc reports in Query Studio.
• Deployed Reports in Production and supported for post-production issues.
• Mentored junior team members and trained them on the advanced product features used in the project.
• Provides assistance to Project Manager in effort estimation, resource planning and task tracking.

Environment: Cognos10.2 (Framework Manager, Report Studio, Analysis Studio, Cognos Dynamic Cube), Oracle 11g, ClearQuest, ClearCase.

Confidential - Atlanta, GA

Senior BI / Cognos Developer

Responsibilities:

• Worked with Reports users and SMEs to analyze the report requirements, helped in creating mockups reports. Translated functional requirements to Technical design document capturing the different components for the solution.
• Metadata Modeling in Cognos Framework Manager, documentation of Cognos metadata model specifications and Cognos report specifications with detailed database mapping.
• Created Data Models with Star and Snowflakes Schema and applied business rules to accomplish the requirements.
• Applied Security on different levels including Object and row level security.
• Designed developed and implemented 5 new Dashboards using some complex and advanced features in graphs.
• Designed and authored complex reports using Active reports and report bursting in Report Studio Using Relational and Dimensional database.
• Created ETL for Aggregate tables for Reports using Data Manager
• Written Complex SQL for reports to meet the requirements.
• Integrated Cognos reports to client's portal and implemented security using Cognos SDK.
• Created customized reports using SDK
• Supported SIT team in preparing test cases and performing testing of reports.
• Worked on Performance tuning of reports by analyzing SQL and using Cognos Best practices.
• Deployed Reports in Production and supported for post-production issues.

Environment: Cognos 10.1 (Framework Manager, Report Studio, Analysis Studio, Transformer, Data Manager, SDK), Oracle 11g, ClearQuest, ClearCase, Control - M

Confidential

Senior BI / Cognos Developer

Responsibilities:

• Worked independently and as a team member with Medco SMEs and Medco stakeholders.
• Performed analysis on the requirements and documented reports requirements in coordination with Medco SMEs.
• Designed various kinds of reports to meet business requirements. Designed other associated artifacts supporting the reports.
• Created Models, Projects and published packages as per report’s requirements
• Built data source query subjects using stored procedures to create query subjects that are used to build reports for specific users.
• Developed complex reports with master detail, report bursting, prompt, cascading prompt, multi object reports using List, Crosstab, and Charts etc.
• Created and modified cubes using Transformer for OLAP analysis of data.
• Used Report Studio and Analysis Studio to build reports based on cubes built in Power play Transformer and deploying the cube in Cognos 8
• Worked on performance tuning of reports by analyzing queries.
• Actively worked on migration of reports from Cognos 8 to Cognos 10.
• Created events in Event Studio as per business requirements.
• Tested reports thoroughly in multiple environments.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Promoted reports in Production environment.
• Trained Team members on Cognos and Teradata. Provided technical guidance and support to junior team members.

Environment: Cognos.8.4, 10.1 (Framework Manager, Report Studio, Analysis Studio, Event Studio, Metric Studio, Transformer) and Teradata

Confidential

Senior Cognos Developer

Responsibilities:

• Interacted with different application teams within IBM to understand the manual processes which was being followed for the collection of the metrics and the reporting. Captured the pain points of the existing process. Understanding of the different data sources and their dependencies on each other. (Understanding of AS Is System)
• Discussion with the applications team and managers to understand the expected process improvements to define and finalize the scope and the requirements. (Define Scope and Requirements)
• Analyzed the requirements comprehensively and defined the overall solutions approach. Captured the data requirements for the solution and defined the different components to be built for the solution. (Design the Solution )
• Captured the requirements in Requirements document and coordinated discussion with stake holders for a formal sign-off.
• Designed the database schema, table structures for the reports. Used the concepts of data modeling, normalization, data validation.
• Designed Reports & related artifacts.
• Created SQL scripts for data loading, data validation in Informatica
• Installed Cognos8.4 with DB2.
• Created models, Projects and published packages in Framework.
• Developed various type of reports crosstab, list, charts using prompts cascading prompts, drill through etc.
• Tested the overall solution and the reports.
• Demonstrated the entire application to users(data collection, loading, generating reports)

Environment: Cognos v.8.4, 10.1 (Framework Manager, Report Studio, Analysis Studio), Informatica and DB2

Confidential

Senior Cognos Developer

Responsibilities:

• Analysed specifications given by the clients.
• Migrated reports from Business Object to Cognos environment.
• Analysed technical functionalities of reports in Business Object and prepared Low level design document
• Developed package in the framework manager.
• Prepared low level and high level design document for the Cognos reports
• Developed dashboard in report studio
• Developed list, crosstab and chart reports
• Applied some complex functionality like drill through, cascading prompts.
• Executed unit test on reports and participated in code review meetings with clients.

Environment: Report Studio, Cognos Frame Work Manager, SQL Server, Business Object

Confidential

Cognos Developer

Responsibilities:

• Co-ordination with clients and onsite team to understand the requirements.
• Distribution of task to team members.
• Created technical specification document of Business Object reports.
• Development of Package in Framework Manger used for report development
• Created design documents for Cognos reports.
• Created Test case documents and executed unit test.
• Developed complex reports using prompts, summery and detail filter, cascading prompts based on the requirements.

Environment: Cognos 8.3, Cognos Frame Work Manager, Oracle9i

Cognos Developer

Confidential

Responsibilities:

• Co-ordination with clients and onsite team to understand the requirements.
• Distribution of task to team members.
• Created technical specification document of Business Object reports.
• Development of Package in Framework Manger used for report development
• Created design documents for Cognos reports.
• Created Test case documents and executed unit test.
• Developed complex reports using prompts, summery and detail filter, cascading prompts based on the requirements.

Environment: Cognos 8.3, Cognos Frame Work Manager, Oracle 9i

Actuate Report Developer

Confidential

Responsibilities:

• Analysis of the existing reports and understanding the business requirements documents.
• Preparation and review of technical specification.
• Creation and review of test cases.
• Modification of existing reports as per the new reporting needs of business.
• Customization of reports for filtering, grouping and sorting the report data of custom reports.
• Design and developments of reports of new reports.
• Coding global function to be used in various reports.
• Developed new libraries and enhanced existing libraries.
• Deploying Reports to iServer through Management Console.
• Testing Reports Functionalities in various environments.

Environment: Actuate 8, ErdPro, iServer, Management Console, UNIX, Oracle

Confidential

Database Developer

Responsibilities:

• Participating in client meetings to clarify the requirements.
• Preparation of Technical design documents as per the Business Requirements Documents
• Writing and reviewing test cases.
• Modifying tables in database and reflecting the changes in all servers.
• Writing and modifying stored procedures.
• Loading bulk data in tables through UNIX.
• Writing shells script as needed.
• Working as QA analyst for the team.

Environment: Power Builder, Oracle, UNIX, Sybase