SUMMARY

• IT Professional with 8+ years of comprehensive experience in Business Intelligence, Design, Development, Testing, Security and Support for Data Warehousing, and Client/Server projects.
• Extensive experience in Retail, Finance & Banking, Insurance, Healthcare Domains.
• Worked on full Software Development Life Cycle in Agile and Waterfall Methodologies projects.
• IBM Certified Cognos Developer and developed multiple projects using Cognos Suite.
• Expert in analyzing the requirements, designing and developing the applications based on business requirements, testing and documenting the details of the application.
• Good experience in Performance Tuning, Application Development and in resolving all BI Production support issues on various platforms, using Data Warehouse tools including IBM Cognos 10.2/10.1/8.4 and Informatica 9.6.
• Expert in IBM Cognos suite with Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Dashboards and Cognos Connection.
• Expert in developing reporting using List, Chart and Cross - Tab, Prompts, Conditional Formatting, Conditional Blocks, Master-Detail Reports, Dashboard Portals and Cognos Workspace.
• Good Experience in Creating DR and Relational Model using Framework Manager and Transformer.
• Well-versed in understanding OLTP data and in developing OLAP multi-dimensional cubes and analyzing power play transformer.
• Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
• Good knowledge on Cognos Admin Activities as enabling security, publishing the Model packages and providing object access to users through LDAP and AD Security user groups.
• Worked with Business Users to analyze the business requirements and process as part of new and Ad-hoc development.
• Experience with Data Warehouse Concepts, Methodologies, E-R modeling, Data marts, Star and Snow Flake Schemas.
• Expert in developing Technical Documents and Design Documents based on Business requirements.
• Developed Unit Test Case for Report validations and supported business in developing UAT and application validation.
• Developed business case to change management process for changes implementation.
• Good knowledge on Informatica ETL process, Auto flow process and Control-M process.
• Expert in writing SQL and PL/SQL queries against Oracle 10g/9.x, DB2, MS SQL Server, MS Access databases using TOAD and SQL Server Management Studio for Back-end testing.
• Provide best practices for day to day operations, performance analysis, Tuning and Capacity planning.
• Collaborated with Business Analysts, Project Team and End Users to ensure quality of the application and played a key role in timely delivery of the application.
• Ability to adapt and learn new technologies.

TECHNICAL SKILLS

BI Tools: Cognos BI 10.2.1/10.1/8.4 (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Power Play Transformer).

ETL Tools: Informatica 9.x, Data Transformation Services (DTS), SQL Server 2008/2005 Integration Services (SSIS)

DataModeling Tools: Framework Manager, Transformer.

Testing Tools: HP Quality Center 9.2, Clear Quest, Trac

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

Web Technologies: HTML 4.0, XML, Java Script.

Databases: Oracle 11g/10g/9.x, DB2, Sybase, MS Access, MS SQL Server, TOAD, WINSQL, IBM DATA STUDIO.

Other Tools: Share Point, Lotus Notes, HP Service Manager, Ms word, MS Excel, MS Visio.

Operating Systems: MS DOS, Windows 2000/XP/Vista/7, and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Salem, NH

Sr. BI Cognos Developer

Responsibilities:

• Participated in requirement sessions with project managers and assisted the business user community with capturing and articulating their reporting needs.
• Decomposing data elements from the source elements.
• Validating the decomposed data elements.
• Explored the existing database and data warehouse for report requirements.
• Involved in ETL Mapping team discussions to solve the issues in mapping documents and design.
• Worked as part of sprint team in Agile Methodology.
• Utilized various agile methodology tools such as MKS and JIRA.
• Designed model based on the requirements for Risk Functional and Loss Dashboard Reports by analyzing the underlying data.
• Developed Complex Framework Manager Models and created virtual Star Schemas and applied Object level, Data level, Package level Securities using AD Securities and Macros.
• Designed and developed reports using the Capmat specifications.
• Developed various Crosstab, List and Chart reports using Report studio 10.2.1 for Commerce solutions line of business.
• Manually modified the SQL in Report studio to tune and/or to write complicated reports using join/union objects in Report studio.
• Created sophisticated Dashboard reports for various reporting requirements like using legacy Charts for the Dashboard reports and also created multi page reports by using Cascading Prompts, Conditional Formatting and page rendering.
• Conducted page quality reviews and validation of the quantitative and qualitative content on the report pages prior to them distributed.
• Worked within ALM for all testing activities and produced the status updates.
• Tested and validated the report outputs against the database to measure the performance of the reports.
• Demonstration of prototypes to the user community.
• Developed complex SQL queries using TOAD and Teradata to validate Models and Reports.
• Deployed packages, folders and content store from a development environment to test and then to production environments.
• Worked on improving the performance of reports with data team.
• Involved in writing test cases for the user acceptance testing.
• Worked on the BI anatomy tool for generating the flow diagrams and logic implemented in each report for documentation purposes.
• Assisted QA team in documenting and analyzing their current process and then make recommendations for the improvement in their functional areas.
• Scheduled reports to run on monthly basis using Cognos connection scheduler.

Environment: Cognos BI 10.2.1(Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Workspace, Workspace Advance), HP Service Manager, Informatica, Oracle 11g, Teradata, TOAD, PL/SQL, MS Excel 2007 and Windows server.

Confidential, Boulder, CO

Sr. BI Cognos Developer

Responsibilities:

• Understood the business by investigating and studying the company’s existing resources.
• Interacted with business and technical users to gather requirements and created design document
• Analyzed the existing database and data warehouse data for report requirements.
• Worked along with the ETL team to understand the flow of data from OLTP system to the OLAP system.
• Involved in Defining the Source Definitions and Target Definitions in the Designer tool.
• Have knowledge on the Workflow Manager and Workflow Monitor to load the data and monitor the status.
• Responsible for creation of metadata models in Framework Manager and cubes in Transformer
• Created Projects, Models, and Packages using Cognos Framework Manager as required for the report development.
• Applied 3 Layer (Database, Business and Presentation Layers) approach and defined appropriate relationship and cardinalities while developing models as per best practice.
• Framework Manager Models and apply proper securitiesand publishing packages on to Cognos Connection.
• Developed and Used Stored Procedures in developing Framework Manager Models.
• Upgraded Models and Reports from Cognos 8.4 to Cognos 10.1.1
• Developed various dimensional and relational reports by deploying lists, crosstabs, charts, union, joins, burst, master-detail, drill through and drill down, reporting techniques.
• Creation of analytical reports, modifications to existing reports in Base Product.
• Developed complex prompt report and dimensional reports using different features like slice &dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.
• Created different Dashboards in report studio using combination of List, Crosstab, and Chat andMap reports.
• Developed dimensions, measures and calculation using Transformer for OLAP Analysis of data.
• Developed dashboards reports using Business Insight, Business Insight Advanced and Cognos Workspace.
• Developed UTC (unit test cases) and helped Business Partners in UAT (user acceptance test cases) documentation as part of testing.
• Created an implementation plan and component documents for Change Management Approvals.
• Involved in providing estimates and deliverable plan to Project by analyzing the business requirements.
• Developed most of the reports along with the team, made them understand the requirements and deliverables.
• Handled pre and post implementation issues as part of implementation process.
• Handled Production Support issues.

Environment: Cognos BI 10.1/8.4 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Business Insight, Business Insight Advance and Event Studio), Informatica, SQL Server 2008, Oracle 10g and Windows server and Unix.

Confidential, Houston, TX

BI Cognos Developer

Responsibilities:

• Worked with Business users to analyze the business process and user requirements.
• Managed the on-site and offshore team and developed client relationship through all phase of the implementation cycle.
• Planned, and successfully implemented the cross functional projects within defined budgets and timelines.
• Identified and assembled the project resources and directed project team tasks to assure effective project completion.
• Created the changes and tasks for implementation process.
• Designed Relational and DMR models using Framework Manager and deployed packages to the Cognos Connection.
• Created database layer and business layer, defining start schema by creating appropriate relationship between query subjects in Framework Manager.
• Applied Security at the package level, query subject level and the query item level.
• Used Governing techniques for improving performance of the Model and Reports
• Designed and implemented the migration and upgrading planning as part of migration from 8.3 to 8.4.
• Created various complex List Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Developed Dashboard Portlets and integrated multiple Cognos reports onto a single Dashboard Page.
• Customized Reports by writing complex custom SQL.
• Customized Reports using HTML, JAVA Scripting.
• Deliver advanced/ complex reporting solutions such as Dashboards, Scorecards and Standardized Reporting (including the bursting of reports globally).
• Involved in building the complex cubes and optimizing the cube creation.
• Built Multidimensional Cubes, Cube views for user groups using PowerPlay Transformer.
• Created and managed jobs and schedules using Control-M process

Confidential, Atlanta, GA

BI Analyst / Test Analyst

Responsibilities:

• Installed and Configured Cognos BI 8.1 and worked in different environments.
• Extensively used Analysis Studio, Query Studio and Report Studio for Report design in Cognos BI version 8.1
• Designed multidimensional models in Framework Manager in Cognos BI 8.1.
• Understood data and business logic underlying the business requirements.
• Created Projects, Models, and Packages using Cognos Framework Manager and published Packages to Cognos Connection.
• Created and established Joins / cardinality between the tables in the application layer.
• Designed and applied conditions and based on business functionality as per requirements.
• Used Report Studio to create multi query, multi-page reports
• Implemented Security in Models / Package / Report/ Folder level.
• Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.
• Created charts, lists and crosstab reports using Report Studio and ad hoc reports using Query Studio.
• Provided security to the Report in Access Manager through LDAP Server and configured settings in Cognos configuration.
• Administration involved implementing security, managing users, User groups and roles in the organization. Worked on bursting reports for the web users.
• Implementation of Impromptu reports and PowerPlay cubes using multiple queries.
• Imported power cubes from the PowerPlay enterprise server to Report Net Cognos connection server.
• Worked with business partners in understanding business requirements to create design and technical documents.
• Designed and developed Relational and Dimensional models for analysis.
• Worked with DBA in developing MQTs for to modeling and reporting purpose.
• Designed and developed multiple models for different modules and published packages.
• Drafted and finalized documents such as Unit Test Plans, Design and Requirements Specification,
• Customizing the data by adding functions, calculation and summarizing
• Manually tested the application based on software requirements specifications.
• Involved in creating Test Strategy for Testing.
• Good experience in preparing the Test Plans, developed Test Cases and Test Procedures based on SRS.
• Created Test Matrices to report the progress and status of the testing effort.
• Analyzed and validated the report and performing data analysis by writing SQLs.
• Designed, configured and monitored scenarios for load, stress and performance testing.
• Performed Positive and Negative testing of the application.
• Performed White Box, Black Box, Functional Testing, Regression Testing, System Testing, Web Testing, Database Testing and User Acceptance Testing on various builds of the application supported on various Operating Systems.
• Performed GUI Testing on various screens.
• Performed Backend Testing by executing SQL Queries statements.
• Performed the Data validation to meet all test condition requirements
• Developed SQL queries to test the Database values for data Integrity.
• Documented the Test Results and prepared Test Reports.
• Defects were logged, tracked and reported using Test Director, BugZilla.
• Preparing the defect reports and interacted with developers for debugging.
• Involved in the Defect reporting analysis and reported to the management.
• Developed and shared daily and Weekly Defect Status reports with test lead upon request.
• Followed the Standards in the application for the Testing life cycle.

Environment: Cognos 8.3 /8.4 Report Studio, Analysis Studio, Query Studio, Cognos Connection and Framework Manager, Transformer, Test Director 7.2, Bugzilla, MS Office, VB Script, HTML, Informatica v9.1, Oracle 10g,, SQLServer2005, Control-M, Windows 2003 Server and UNIX.

Confidential, Warren, AR

Test Analyst

Responsibilities:

• Manually tested the application based on software requirements specifications.
• Involved in creating Test Strategy for Testing.
• Good experience in preparing the Test Plans, developed Test Cases and Test Procedures based on SRS.
• Peer review of the documents like Test Plan and Test Cases using Test Director.
• Created Traceability Matrix and responsible for documentation.
• Monitored data quality, resolving problem data issues, and ensuring timely updates.
• Designed, configured and monitored scenarios for load, stress and performance testing.
• Performed Positive and Negative testing of the application.
• Performed White Box, Black Box, Functional Testing, Regression Testing, System Testing, Web Testing, Database Testing and User Acceptance Testing on various builds of the application supported on various Operating Systems.
• Performed GUI Testing on various screens.
• Performed Backend Testing by executing SQL Queries statements.
• Performed the Data validation to meet all test condition requirements
• Developed SQL queries to test the Database values for data Integrity.
• Documented the Test Results and prepared Test Reports.
• Defects were logged, tracked and reported using Test Director, BugZilla.
• Preparing the defect reports and interacted with developers for debugging.
• Involved in the Defect reporting analysis and reported to the management.
• Developed and shared daily and Weekly Defect Status reports with test lead upon request.
• Followed the Standards in the application for the Testing life cycle.

Environment: Test Director 7.2, Bugzilla, Oracle 9i, SQL, MS SQL Server, Toad, Benthic Golden, MS Office, VB Script, HTML, Windows XP, and UNIX.

Confidential

Systems Engineer

Responsibilities:

• Business Analyst consultant on 100% travel for projects.
• Reengineering processes and workflows to ensure operational efficiencies.
• Participated in JAD sessions for a team of 3 business analysts to define expectations, success criteria and potential risks and sources for unpredictability in the project.
• Provided business knowledge and technical support for business requirements development.
• Worked closely with developers, requestors (end users) and Subject Matter Experts identifying and documenting data.
• Review technical documentation for analysis, definition and direction.
• Assisted in developing applications using Java, VB, SQL, Oracle, and Access.
• Implemented systems design in order to build a bridge between the information systems.

Environment: SQL, Visual Basic, Oracle, Crystal Reports, Access, MS Office (Word, Excel, PowerPoint), Visio, Windows 2000 / NT.