Professional Summary:

• Over 7 years of experience in the Software Industry as a Cognos Developer / ETL Developer / ETL Tester in Health Care , Financial and Insurance Domains.
• Very Good experience in Cognos Framework Manager, Transformer, and Dashboard, Business insight, Business insight Advanced, Report Studio developer and implementations includes designing, development and maintaining of applications using Informatica Power Center and Cognos Technologies.
• Very good experience in developing metadata models using Framework Manager. Solid experience in developing OLAP models using Powerplay Transformer. Strong skills developing DMR models in Framework Manager and dimensional reports in Report Studio. Expertise in training users to use Query Studio and Analysis Studio, Cognos Workspace.
• Familiar with TM1 rules editor to create various calculations, analysis for TM1 planning, budgeting and forecasting.
• Good experience in software development and quality assurance experience in Programming, Designing, testing and including in Data warehousing Informatica Power Center in Unix/Linux, Administration and Support.
• Very good working experience in Gathering Business Requirements, requirements for Mapping for implementations, creating reports, developing interfaces, conversions and enhancement of programs and implementations. Expertise in analyzing requirement specifications and responsible for developing design document and Test Scenarios, Test cases, Test plans etc. I have solid hands-on Extraction, Transformation and Loading ETL development experience using Informatica Power Center 9x/8x product versions. Very good experience in UNIX/LINUX working environment, using the Putty and SSH client editor, writing shell scripts etc. Experience in developing strategies for Extraction using Informatica Power center. Developed mappings, sessions and workflows for relational flat file sources and targets. Expertise in supporting Informatica Production Support. Very good experience in Design and Development of ETL components of Data Warehousing Systems. Solid Experience in SQL, PL/SQL Procedures, Functions, Packages etc. Very good experience in Software Testing, Development and Quality assurance of various applications. Good Team Player and a Self-starter with excellent verbal written, analytical, multi-tasking skills documentation skills. Excellent Communication, organizational, detail oriented, Time Management, strong analytical and problem solving skills Enjoy working in a Collaborative, Fast Paced Environment
• Ability to quickly master new concepts and applications.

Technical Skills:

Professional Experience:

Confidential

Cognos Developer

Responsibilities:

• Analyzed Business Requirements for Reports, worked closely with business analysts to understand the business needs.
• Analysed system documentation like Requirements document, Gap Analysis User Interface Specifications to develop technical document of the business flow and develop and execute the Models and Reports.
• Worked on Star flake Snow flake schemas including tables, views and materialized views for the reporting construction.
• Created DB Layer to handle the relationships between query subjects and then Business Layer on top of it with Model Query Subjects.
• Design and developed the Framework Manager Models Relational/DMR Models and published the packages to the server.
• Implemented Framework manager security at various levels in the model like Package/Row/Object .
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Built advanced reports like List Reports, Cross Tab Reports, Chart reports, reports with multiple prompts and Filters in Report Studio.
• Applied Model filters, Detail filters and Summary filters to generate user requirements.
• Created Bar Charts and Cross Tab reports in Analysis Studio.
• Developed Multi-dimensional Dash Board Reports using Report Studio adding it to the Portal page using Cognos URL.
• 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
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Redesigned the existing reports according to the user requirements.
• Created Jobs to Schedule reports in Cognos Connection based on the reports to run daily, weekly basis using Event Studio.
• Actively involved in the administration part of Cognos Connection for organizing, security, scheduling and distributing reports.
• Extensively worked on developing Metadata Models using Cognos Framework Manager Tools using industry best modelling standards.
• Developed standards for Cognos Framework Manager Model and Reports.
• Design and development of Cognos Power play Cubes using Cognos Power Play Transformer.
• Proficient in implementing DMR Dimensional Modeled Relational data using Cognos Framework Manager Model Tool.
• Built Multi-Dimensional Models DMR with Relational Data using Framework Manager and Deployed Packages to the Report Servers.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Extensively worked on developing complex reports using Cognos Report Studio, and developing reports from Cubes using Analysis Studio.
• Worked with business users on assisting Query Studio reports and graphs.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts, Customized prompts and Report Bursting.
• Upgraded Framework Manager Models, Transformer Cubes from Cognos 8.4 to 10.2.1.
• Implemented features in Reports like Filters, Customized Prompts, Conditional Formatting, and Spark line Charts and Complex Layouts like Cross tabs.
• Expertise in developing Drill-Through, Master-Detailed reports and implemented Report Bursting.
• Experience with Complete Lifecycle implementations of ETL Processes.
• Demonstrating knowledge in OLAP Data Warehouse, Data Mart Concepts and Methodologies.
• Expertise in transforming Star Schema models into building Cognos Metadata Model database layer, dimension layer and business layer using Cognos Framework Manager
• Responsible for monitoring all the Reports that are scheduled, running completed and failed using Cognos connection.
• Created simple and Ad hoc reports using Query studio.
• Provided production support by monitoring the processes running daily.
• Upgraded all Packages, Reports and Data source connections from Cognos 8.4 to Cognos 10.2.1 in different environments.
• Deployed applications from development to QA and then Production servers using Export/Import functionality in Content administration.
• Worked on handling performance issues, Troubleshooting of Cognos Reports, evaluating current logic for tuning possibilities.
• Checking the data flow and extensively using SQL Queries to extract the data from the Database and conducted data quality profiling.
• Involved in Peer Reviews and Internal Reviews.
• Comprehensive involvement in all phases of application lifecycle development be it analysis, development, testing, debugging, performance tuning and User Acceptance Testing UAT with QA team.
• Team Leading and Coordination with Offshore and Supporting teams.
• Trained users on navigation and creating simple reports in Query studio.

Environment: Cognos 10/8 BI, Cognos Connection, Framework Manager, Dashboard, Business insight, Business Advanced insight, Active Reports, Report Studio, Query Studio, Analysis Studio, Power Play Transformer, SQL Server, Oracle, Toad, IBM Data Studio, IBM Lotus Notes, Trac, HP Service Manager, SharePoint Site, Visio.

Confidential

Cognos BI Developer

Cigna Health Care is a company, which provides new and improved biotech drugs for various diseases and their symptoms. The objective of the project is to extract data stored in different databases and load into oracle system, which is the staging area, and the business logic is applied to transform the tables into the required way. The data warehouse is fed by marketing data, sample data, market competitor data, prescription data and others

Responsibilities:

• Analysing Requirement Specification document and developing the Technical specification documents for Framework Manager Model, Transformer and reports as per client requirements.
• Worked on Cognos framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to cognos server.
• Create relationships between query subjects to represent the logical structure of the business and the user requirements.
• Implementing different levels of security in the Framework model like Data level Security, Object level Security and Package level security.
• Developed Reports using Cognos 10.1.2/8.4 Report studio, Query Studio, Analysis Studio. Analyzing the specifications provided by the clients and worked with list, crosstab, chart and Dashboard reports.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases. Used filters for efficient data retrieval.
• Working experience with different Date functions like YTD, QTD, and MTD in Report Studio.
• Developed Dashboards reports using Cube as a data source.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts.
• Writing the Java Scripts in Report Studio Reports to display default values in value prompt.
• Worked in Scheduling and Deploying Staging to production Reports.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Modifying the existing reports based upon the change request by the user.
• Involved in Framework Manager Modeling Issues in CDX Team.
• Created Multi-Dimensional reports using Cognos Power Play.
• Modified Power Cubes by adding new Dimensions, Levels and Measures.
• Created conditional highlighting particular measures for user requirement.
• Customized data by adding calculations, summaries and functions.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Good exposure in Relational Databases Oracle, SQL, SQL Plus, MS SQL server and MS Access for modeling and for supporting analytical and reporting needs of Corporate Business needs.
• Developed effective SQL queries and performed Unit and User Testing to ensure the accuracy of data displayed in the report.
• Used TOAD to run SQL queries and validate the data in Data warehouse and Data Marts.
• Participated in each and every phase of the Software Life Cycle process including analysis, design, implementation, testing and maintenance phase.
• Part of Production support team which involves solving user problems through trouble system tickets.

Environment: Cognos 8.X Cognos Connection, Framework Manager, Query Studio, Report Studio, Analysis Studio, and Event Studio , Cognos Transformer, DB2, SQL Server 2008, Toad, SSH Client, IBM Lotus Notes, Quality center, HP Service Manager, Visio.

Confidential

Cognos Developer

• The client is a leading multi-line healthcare enterprise that provides programs and related services to individuals receiving benefits under Medicaid, including the State Children's Health Insurance Program SCHIP , as well as Aged, Blind, or Disabled ABD , Foster Care, Long-Term Care and Medicare Special Needs Plans .
• I was responsible for handling technical activities that includes managing the ETL processes, analysing and documenting the technical specifications, maintenance of the User acceptance Test UAT manual.

Responsibilities:

• Involved in Requirement gathering from Business Users and analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Handling various technical and process related reviews as per the Client Standards.
• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Converted business requirements into technical documents.
• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Involved in Designing models with Relational Data using Framework Manager and published packages to the Cognos Reporting Servers.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Upgraded Framework Manager Models, Transformer Cubes from Cognos 8.4 to 10.2.1.
• Developed Pharma Dash board reports to display all the information related to environment using Summary reports.
• Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
• Created optional filters/prompts in report studio using Java Script and HTML.
• Implemented Cognos SDK code to retrieve all the report schedules from the content store.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas.
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

Environment: Cognos 8.X,Cognos Connection, Framework Manager, Query Studio, Report Studio, Analysis Studio, and Event Studio, Transformer, DB2, Toad, HP Service Manager, Visio, IBM Lotus Notes, IBM Rational Clear Quest, UNIX, Oracle.

Confidential

ETL Informatica and COGNOS Developer

Banking migration Projects and Aviation Projects Integrated Management and Control System IMCS projects worked as ETL Informatica Tester.

Responsibilities:

• Analyzed and interpreted the business requirements for a data warehouse system.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Used Informatica Designer to create complex mappings using different transformations, mapplets and Reusable Transformations for cleansing and moving data to a Data Warehouse.
• Worked extensively with complex mappings using expressions, aggregators, filters and procedures to develop and feed Data Marts.
• Improved the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases and selecting the table with fewer rows as master table in joiner transformations.
• Created both sequential and parallel loading of the data from workflow manager.
• Developed complex queries using different data providers in the same report
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batch Jobs and the Target Data.
• Participated with the Business Intelligence testing reports Team reviews.
• Developed reports using Report Net according to Business user requirements. Reports are of Sales representatives, including the sales organizations that are assigned to the territories they cover, and the products they promote.
• Developed separate document for each report, which provides design specification for each report with Report Net.
• Developed a Framework Manager model by importing Meta data, preparing business logic, setting up object level security and developing and publishing package.
• Handled object level security in FM level Security is applied to all levels of hierarchy in the model which includes package, Folders, Query Subjects and Query Items.
• Developed Model query subjects in FM manager and materialized views in the database in order to accommodate the report net requirements.
• Developed reports using Customized prompts, advance filters and conditional formatting.
• Implemented Dynamic Filters and Dynamic sorting functionality to give users ability to sort and filter the data in Report Viewer.
• Used TOAD and WinSQL for data analysis and query optimization.
• Used Quality Center for document issues found during the test process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center.
• Prepared Test status reports for each stage and logged any unresolved issues into Quality Center.
• Tested stored procedures views in DB2.
• Coordinated with Different project teams to set up common test environment and common Integration for different applications
• Conducted defect review meetings with the development team members
• Involved in peer review of test cases, and Impact analysis.
• Preparing and supporting the QA and UAT test environments.
• Used Share point for Document Management and Dimensions for version control.

Environment: Informatica Power center 8.x/7.x, Cognos 8.X, WinSQL, SSH Client, UNIX, DB2, Oracle, Share Point, Quality Center.

Confidential

QA Tester

Business Intelligence BI is the group of system capabilities that enables the business to collect, Interrogate, analyze and report on member, employer, transactional and other data for performance measurement, planning and analytical purposes.

Responsibilities:

• Understanding the Business Requirements and developed test cases based on the functional point documents.
• Involved in executing the Test Cases and Analyzing the Results.
• Written test cases for checking the populated data correctly into fact and dimension tables.
• Report layout validation as per mock-ups and data validation as per business requirements.
• Reported defects to development team through Defect Management Tool Quality center.
• Involved in Peer Reviews and Internal Reviews.
• Verification of the fixed bugs and subsequently closing them if they passed the test case.
• Reporting status of testing progress, issues to team lead on a daily basis.
• Periodically obtaining feedback from Team lead and consciously working for Improvement.

Environment: SQL Server, TOAD, Share Point, Quality Center.