Summary
Cognos TM1 Developer/Data Analyst with over 6 years of IT experience, 4 years of Financial Planning Solutions using Cognos TM19.5.2 Applications (Architect, Contributor, Perspectives andTurboIntegrator) from requirements through design and testing, implementation and production support (full SDLC). Expertise inTurboIntegrator processes to load and retrieve data from database tables and other data sources,creating complex Active Forms.Familiar with TM1 rules editor to create various calculations,What if analysis for TM1 planning, budgeting and forecasting.Experienced working with large sets of data, Multi dimensional data sets in a Datawarehouse/Data Store supporting Data Mart.Over 2.5years' experience in Data Warehousingcreating Test Strategies and Validation Plans, testing of multiple backend, ETL and BI Applications.Experiencedworkingon end-to-end data validation of data flow between source, staging, ODS(Operational Data Store), and DM (Data Mart) layer,MercuryQuality Center(now HP Quality Center) to Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, DefectLogging and Reporting.Additional experiencewithautomation tools such as Quick Test Professional (QTP), Win Runner and LoadRunner in Client/Server applications and Web-based applications. Worked extensively with offshore team members and demonstrated teamwork leading to results,effective communication, and sense of urgency.Excellent interpersonal and analytical skills.

Skill Set:

• Environment: Cognos TM19.4, 9.5.2(Architect, Contributor, Perspectives, TurboIntegrator), Oracle 10g, SQL Server 2005
• ETL Tools: Informatica 8.6/9.1, Cognos 8.3/8.4
• Data Modeling: Erwin, Visio, TOAD for Data Analysts
• Testing Tools: HP Quality Center, Mercury QTP, Quality Center, Load Runner
• Operating System: Windows NT, Windows XP, 2000, Vista ,Windows 7, UNIX AIX, Linux and Andriod
• RDBMS: SQL Server, Oracle, MS Access
• Other Tools: TOAD, SQL Plus, SharePoint, Remedy, MS Office

Professional Experiences:

Confidential, Morrisville, NC
Cognos TM1 Developer Oct2011-Aug2012
Responsibilities:

• Responding to a change in the client\'s IT direction, promptly prepared for construction of the planning and forecasting tool, developed a global enterprise-wide application using Cognos TM1.
• Design, develop, and implement Cognos TM1 9.5.2 Applications for Financial Planningand Budgeting models with complex rules.
• Development of TurboIntegrator(TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
• Maintenance of TM1 users, roles, and security.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Created complex Active Forms and enhanced the performance of existing Active forms.
• Scheduled Chores and Monitored Data Loads on timely manner.
• Created TI Processess to transfer currency data to currency cube.
• Created rules to transfer data between cubes.
• Used TM1 rules editor to create and edit rule to create various calculations.
• Used Replication to copy the Cubes from one server to other server.
• Development of ETL processes based upon complex SQL queries retrieving data from various sources for creating dimensions and cubes, and loading data using TurboIntegrator.
• Import the data from ODBC and Text files using TM1 Turbo integrator.
• Provided the What If Analysis facility to users to get desired output by changing parameters.
• Reviewed Business Requirement Document (BRD) for Completeness,Gather and analyze financial planning, budgeting and reporting requirements.
• Performed Unit Testing and User Acceptance Testing
• Used HP Quality Center for Bug Tracking, Reporting and Analysis.

Environment:Cognos TM1 9.5.2, Cognos 8.4, Oracle11g/10g, TOAD,HP Quality Center, MS Excel 2007, Windows XP Professional

Confidential, Reston, VA
TM1 Developer Jan 2010 -Sept 2011
Responsibilities:

• Design, develop, and implement Cognos TM1and Cognos BI solutions for financial planning and budgeting projects using TurboIntegrator(TI) and complex business rules.
• Extensively used TI for loading data into Dimensions and Cubes, added new dimensions and cubes to existing environment.
• Developed TM1 application to gather and consolidate data in support of the footnotes in the annual report.
• Manage TM1 data through TM1 Reports (Active Form & Slice).
• Created and arranged different TM1 rule statements and performed complex calculations for cubes at N&C levels
• Created ad-hoc queries from multidimensional views for analysis.
• Developed Cubes, Reports, and Dashboards using Cognos BI.
• Created Dynamic Reports from Worksheets and Cube views using different functions (DNEXT, DFRST and ELCOMP).
• Worked on replicating the cubes between servers, sharing data between cubes and linking asymmetrical cubes.
• Created ETL (Extraction, Transformation & Loading) processes in TM1 performing business rule mappings of relational data into dimensional model.
• Deployed the TM1 data into production environment.
• Prototyped system interfaces in Excel and facilitated reviews and capture project related documentation and maintain project repository.
• Facilitated discovery and documentation of multi-organizational planning and forecasting processes.
• Validated reports based on Functional Requirements.
• Prepared forUnit Testing, UAT and created Logs, Defect Tracking using Quality Center.

Environment: Cognos TM1 9.5.2, Cognos 8.4, MS Excel, HP Quality Center, Windows XP Professional

Confidential, Minneapolis, MN
Cognos TM1 Developer/Data Analyst Oct2008-Dec2009
Responsibilities:

• Worked with IT Development team to ensure feasibility of design and clarify user requirements.
• Worked with Data Architects to create a solution roadmap based on cross-organizational planning and forecasting tool using Cognos TM1.
• Created ETL(Extraction, Transformation & Loading) processesusing TurboIntegrator in Cognos TM1 performing business rule mappings of relational data into dimensional model.
• Developed ETL processesfor creating dimensions and cubes, and loading data retrieving data from various data sources.
• Designed dimensions, hierarchies, attributes and cubes, creating cubes and cube rules associated.
• Involved in creating TurboIntegrator (TI) programs to process data, writing system documentation.
• Performed Data Analysis and developed Data Mapping documents for ETL projects.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and TestData.
• Performed Data Analysis and developed Data Mapping documents for ETL projects.
• Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Performed Requirement Testing, Unit Testing and User Acceptance Testing
• Executed Test Cases with respect to Source and Target database tables.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Validated reports based on Functional Requirements.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and TestData.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Used Mercury Quality Center for Bug Tracking, Reporting and Analysis.
• Developed test cases for deployment verification, ETL data validation report testing.
• Performed requirements testing, system and integration testing as well as UAT.

Environment:Cognos TM1 9.4, Cognos BI, Oracle, SQL Server, Informatica 8.6, Datastage, Mercury Quality Center, MS Excel, QTP, Windows XP

Confidential, Austin, TX
Data Warehouse Test Analyst Aug 2007 - Oct 2008
Responsibilities:

• Analyzed Business Requirement Document and Design Specification Document to determine the functionality of the ETL Processes.
• Worked with source system personnel on source data delivery issues and assisted DBA for setting up test environment.
• Developed Test Plan using the Business Requirement Document and Functional Specification Document (FSD).
• Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Expertise in writing complex SQL and PL/SQL statements.
• Extensively used SQL for Data Validation, Data Verification, Data Conditioning and Data Integrity.
• Involved in creating the physical Data modeling by using ERWIN.
• Developed the test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables based on Business Requirement Document (BRD).
• Developed Test Cases for Deployment Verification, ETL Data Validation and Reports Testing.
• Performed Requirement Testing, System Testing, Integration Testing and User Acceptance Testing.
• Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD.
• Performed the Data Migration Testing in ETL process.
• Worked with Users to develop Test Cases for User Acceptance Testing (UAT).
• Performed Load, Stress and Performance testing using HP LoadRunner.
• Created and executed various Load Test Scenarios and analyzed the test results for Load Testing using LR Analysis.
• Maintained the Test Logs, Test Reports, Test Issues and Defect Tracking using Quality Center.
• Performed all aspects of Verification, Validation including Functional, Regression and Requirement Testing.

Environment: Informatica 8.6.1, OBIEE, Oracle10g, SQL Server, Flat Files, TOAD 10.0, MS Excel, Mercury Quality Center 10.0, Quick Test Professional 10.0,UNIX, MS Office, Erwin, SDLC

Confidential, Plano, TX
Data Analyst/ETLTester Sept 2006- August 2007
Responsibilities:

• Reviewed documented requirements (mapping documents/report specifications) by business analysts for thorough understanding of this application.
• Validated data through various stages of data movement from staging to Data Store to Datawarehouse tables.
• Created Test Cases using SDLC procedures and reviewed with test leads.
• Executed all Test Cases in the testing environment and maintained them, documenting test queries and results for future reference.
• Validated external data sources by connecting through Oracle heterogeneous services and joining them to existing tables and reporting anomalies in the data.
• Provided flexible and high quality support to wider Testing strategies on key regular deliverables and ad hoc reporting issues.
• Extensively tested Business Objects reports by running SQL queries on the database by reviewing report requirement documentation.
• Validated reporting objects in the reporter against the design specification documents.
• Validated data files from source to ensure correct data has been captured to be loaded to target tables.
• Also validated load process of ETL to ensure that target tables are populated according to data mapping provided, thereby satisfying transformation rules. Validated archive process to purge data that meets defined business rules.
• Performed validation of aggregate tables based on rollup process documented in data mapping.

Environment: Informatica 8, Business Objects XI,TOAD,Oracle, Teradata,Mercury Quick Test Pro 9.0/9.1, Mercury Quality Center 9.0, MS Office

Confidential, Phoenix, AZ
QA Analyst/ ETL Tester Jan2006- Aug 2006
Responsibilities:

• Worked with business analysts to verify that the requirements were testable.
• Develop the QA Project Plan using MPP.
• Coordinated off-shore and on-shore Test resources.
• Developed Test Plan, Test cases for the QA Phase of the Membership Rewards Data Warehouse.
• Performed Unit, Integration, and Regression and UAT Test phases.
• Reported defects and status of the defects in Mercury Quality Center.
• Developed SQL queries to verify the data loaded into the target tables.
• Did performance testing and governance validation.
• Retested the modifications, once bugs are fixed after reinstalling the application.
• Developed automated scripts using Win runner for functional and regression testing.
• Reported defects and tracked the QA progress via Mercury Quality Center 9.0
• Reported the bugs through email notifications to developers using Quality Center.
• Generated Problem Reports for defects found during execution of the Test Cases and reviewed them with developers.
• Worked with Developers to identify and resolve problems.
• Led and scheduled QA project status meetings and published meeting minutes.

Environment: Mercury Quality Center 9.0, Oracle Databases, SQL Server, Informatica 7.1, Cognos BI, UNIX, TOAD, SQL Plus, Windows XP, MS Office

Education:

• M.S., Engineering