SUMMARY

• Over all 7+ years of experience in IT industry with experience on Business Intelligence and Data Warehouse Applications.
• Extensive experience in 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.
• Experienced 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, Mater and Details Reports, Dashboard portals, Cognos Workspace and Workspace Advanced.
• Good Experience in Created 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.
• Experienced with Data Warehouse Concepts, Methodologies, on ODS, Data Warehouse, 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 Experience on ETL, BI Tools (Cognos, Tableau, Informatica).
• 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, WINSQL, IBM DATA STUDIO and SQL Server Management Studio for Back-end testing.
• 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.
• I am Hardworking, Enthusiastic, Amicable person with positive attitude towards my personal and professional life.
• High Initiative, Self-motivated with an Excellent Communication, Analytical & Presentation Skills, Willingness and ability to quickly adapt to New Environments and learn New Technologies.
• Strong Analytical, Administration and Problem Solving skills dedicated to maintain the High Quality Standards in Work Delivery, ability to Work Independently and able to work in a Collaborative Team Environment.

TECHNICAL SKILLS

BI Tools: Cognos BI10.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: SQL, PL/SQL.

Web Technologies: HTML 4.0, XML, Java Script.

Databases: Oracle 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, Bloomington IL

BI Cognos Analyst

Responsibilities:

• Understood the business by investigating and studying the company’s existing resources.
• Interacted with the business users and gathered report requirements.
• Analyzed the existing data warehouse database to create models base on 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.
• Developed report prototypes using Excel Spread Sheet and MS Word.
• Prepared report specifications as part of company’s documentation policy.
• Developed models in Framework Manager and deployed packages to the Cognos Connection
• Customized data by adding filters at both the Framework Level and Report Level
• Published different packages from Framework Manager to Cognos Connection
• Analyzed Relationships between tables in the schema and applied cardinality in the database layer.
• Created highly Complex Reports using OLAP CUBES as Data Source for Multi-Dimensional Analysis.
• Implemented all business logic in Framework Manager by creating prompts, folders, calculated columns, joins and naming convention
• Created Dashboards using list reports, cross-tab reports and chart reports and applied filters, calculations, complex expressions, conditional formatting, conditional blocks.
• Developed Drill Down/Up and Drill through and Master Detail reports.
• Bursting the reports in various formats, such as html, PDF, excel and sending via e-mail based on the sales area and different levels of administration.
• Developed many Ad hoc reports using Query Studio and Analysis Studio.
• Created schedule jobs to run Report and Report View.
• Developed and supported multiple applications and Optimize new and existing complex reports.
• Created and maintained LDAP and AD Security groups based on user profiles
• Developed UTC (unit test cases) and helped Business Partners in UAT (user acceptance test cases) documentation as part of testing.
• Created a implementation plan and component documents for Change Management Approvals.
• Involved in providing estimates and deliverable plan to Project by analyzing the business requirements.
• Assured quality of report data output by manually verifying and executing SQL statements in TOAD.
• Trained and guided business users about Query Studio, Analysis Studio and Application usage.
• Monitored daily report Schedule Management required for the business.

Environment: Cognos BI 10.2/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 MS Office, and Windows server and Unix.

Confidential, Boulder CO

Cognos Developer

Responsibilities:

• Extensively worked with Business Team and Functional Team to review business requirements, and Functional clarifications.
• Coordinated and conducted various meetings between Offshore and Functional Team to review business requirements, and Functional clarifications.
• Estimated the time required for the development and planned for the team activities.
• Provided key project inputs by working with users and developers in defining several functional and technical issues of project and system requirements.
• Played a key role in the planning, testing, and implementing system enhancements and conversions.
• Responsible for creating and maintaining all testing documentation including test cases, test scripts, and test task lists.
• Created customized, Complex reports in Cognos Report Studio and Ad-hoc reports in Query Studio.
• Responsible for the daily, weekly, monthly, Quarterly and Year End Reports for business needs.
• Worked in Framework Manager to create Models using different data sources, and publishing packages to Cognos connections as per reporting requirements.
• Created DR and Relational Model in Framework Manager.
• Created plans and models to fit as per business needs using Cognos Planning.
• Designed and implemented Data Cubes using Microsoft OLAP services, Cognos Impromptu, and Power Play to facilitate executive, management and end user reporting.
• Created multidimensional cubes using Impromptu’s Query Definition in Power Play Transformer
• Developed Power Play cubes which involved model definition in Transformer, used multiple queries, Calculated Measures, Customized cube and Optimized Cube creation time.
• Created Dashboards in Report Studio involving a mixture of data coming from both the database and Power play cubes.
• Developed many Complex Reports as List, cross tab, drill through, master-detail, chart using Report Studio.
• Implemented Security filters at Package level, Object level, Data level.
• Worked on Power Play dimensional cubes.
• Administrated Cognos portal and specified user roles, permissions using LDAP
• Involved and worked in Data Mapping from legacy system to PeopleSoft system.

Environment: Cognos 8.4/8.3, Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Cognos Planning, Cognos Power Play Transformer, LDAP, XML, Informatica, MS SQL Server 2005, Oracle, DB2, JAVA/J2EE, Cognos SDK, PeopleSoft HRMS 7.6 (HR, Benefits, Payroll, Fully Custom Time & Labor) People Tools 7.6, SQR 6.0, Windows 2003 server and Unix.

Confidential, Abilene TX

BI 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 Test Matrices to report the progress and status of the testing effort.
• Created Traceability Matrix and responsible for documentation.
• Analyzed and Report data base on business functionality and performing data analysis by writing SQLs against Data warehouse tables.
• Validated BI Cognos Dashboards and report functionality.
• Monitored data quality, resolving problem data issues, and ensuring timely updates.
• Involved in testing the application manually before automating the desired test cases.
• Closely worked with Developers and System Engineers to nail down the technical problems.
• 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, Bug Zilla.
• 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, Cognos 8.4 Suite, Oracle 9i, SQL, MS SQL Server, Toad, Benthic Golden, MS Office, VB Script, HTML, Windows XP, and UNIX.

Confidential

Systems Engineer

Responsibilities:

• Involved in creating entity relational and dimensional relational data models using Data modeling tool Erwin.
• Creating databases from the physical model and creating indexes on the tables in the data ware house.
• Designed and generated database objects and Oracle Forms, Reports. Including Forms based on stored procedures.
• Generated SQL and PL/SQL scripts to install, create and drop Trading Exchange Connection database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Extensively used SQL Loader and PL/SQL for extracting source data, transforming and loading into Data marts and Operational Data Stores.
• Created PL/SQL procedure, functions and packages to fulfill the transformation part of the ETL.
• Responsible for capturing data changes.
• Created Export/Import scripts to Export Files using Oracle’s Export utility and importing the data into a different oracle database.
• Used Transportable table spaces for moving large volumes of data between two Oracle databases.

Environment: PL/SQL, Oracle, Erwin, MS Office (Word, Excel, PowerPoint), Visio, Windows 2000 / NT