SUMMARY:

• 8+ years of experience in Business Intelligence/Data Analyst with solid understanding of business requirements gathering, business process flow, business process modeling, and business analysis.
• Excellent analytical, communication, problem - solving, decision-making, presentation and organization skills.
• Solid experience in data warehousing best practices, working with metadata repositories, and experience within a disciplined lifecycle methodology.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Developed ETL Mapping Document based on Data profiling and source system analysis.
• Experience in Data Modeling using Erwin in Client/Server and distribute applications development.
• Expert in writing SQL queries and Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica.
• Experienced working with Excel Pivot and VBA macros for various business scenarios.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Ab Initio and Informatica Power Center Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers, and packages.
• Expertise in Testing complex Business rules by creating mapping and various transformations.
• Strong working experience on DSS (Decision Support Systems) applications and Extraction, Transformation and Load (ETL) of data from Legacy systems.
• Designed, developed, and deployed highly complex BI solutions via Cognos 8 Report Studio, Analysis Studio and Transformer.
• Ability to handle and interact with Business users, collect and analyze business / functional requirements.
• Experience in Business Process Optimization using tools like IBM Business Modeler. IBM Business Monitor, and IBM Business Compass.
• Experience providing organizational training especially in BI tools.

TECHNICAL SKILLS:

ETL Tools: Informatica, SSIS, Data Stage

Software development methodologies: RUP, Waterfall, UML, Agile

Data Modeling Tools: Erwin, power designer

Programming Languages: SQL,PL/SQL,C

Project Management Tools: MS Office, MS Project, MS SQL ServerOracle, DB2, Microsoft Access

Database Administration Tools: WinSQL, TOAD

Reporting Tools: Cognos 8, Crystal Reports, Business Objects

Operating Systems: Windows 2000/XP/NT, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Brea, CA

Sr. Business Data Analyst/ ETL Developer

Responsibilities:

• Involved in business requirements gathering to enable Data Integration across all business groups.
• Co-ordinate with different application team to develop and standardize enterprise-wide data model, created the dimensional data model using Ralph Kimball Methodology, Designed and developed fact tables, dimension tables, conformed fact and dimension tables.
• Extensively interacted with the user for requirement gathering, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Integration test plan, Unit test plan, Release notes etc.
• Extensively worked on Analyzing data, Applying business rules, designing the data warehouse, creating data mart/ schemas, partitioning the data, creating easy/quickest ETL process to load the data and automating the ETL process.
• Participated in Complete formal Design process from initial specifications and requirement. Involved in creating technical design documentation.
• As a team lead worked closely with the entire team member to assign the work and get the updated status of work as well as helped them to complete their job wherever required.
• Extensively used ERWIN to design Logical/Physical Data Models, forward/reverse engineering, publishing data model to acrobat files.
• Designed and developed Data warehouse, Data marts, star schemas, fact table, Dimension tables, Slowly Changing Dimension, Staging areas, Operational Data Store.
• Involved in designing, development and testing of Interfaces to communicate with third party data.
• Managing Oracle 11g databases for daily data loads.
• Worked with ETL team responsible for Designing, modeling, and creating ETL procedures to load bulk data into the highly denormalized database.
• Designed ETL specification documents to load the data in the target using various transformations according to the business requirements.
• Worked with reporting team in generating various reports using BO XI and helped them in providing the data according to their requirement.
• Involved in designing Universes incorporating all the business requirements and creating hierarchies to support drill down functionalities in reports.
• Created Unix Shell Scripts for Data Centric applications.
• Developed shell scripts for scheduling the jobs.
• Extensively used Shell Scripts for loading the data. And monitoring all BULK data loads.

Environment: Oracle 11g, Erwin, SQL server, Informatica power center Designer 9.x/8.x, Repository Manager 8.x, Workflow Manager 8.x,Informatica Power exchange, BO XI, Hyperion, Flat files, Tivoli, Perl, UNIX and Shell Scripting

Confidential, TN

Sr. Data Analyst

Responsibilities:

• Requirements review, ETL process flow designs and walkthroughs, and data profiling/analysis of required source systems.
• Work with various business SME's to properly document (business & functional) the overall process - source(s), business logic, and target.
• Proposed solutions for gaps identified between business requirements and tool capabilities.
• Analyze and develop data requirements and source to target mapping documentation, aligned with approved architectural direction.
• Facilitate requirements gathering sessions with various strategic business units and developed use cases with inputs from business users.
• Develop and execute test scripts to validate the results for accuracy and to ensure the requirements have been met.
• Written SQL queries to validate data and business logic between different hops in EDW.
• Serve as a subject matter expert and participate in data model design reviews and ETL design reviews.
• Data mining, ad-hoc analysis, and researching data issues with business partners in user acceptance test (UAT).
• Established consistent data definitions, ensuring integrity of underlying data models and monitoring/auditing the overall data quality as per the requirements of key stakeholders.
• Used Cognos reporting tool for ad-hoc analysis of data, provided training, user manuals, and validation spread sheets to business users.
• Catalyst for change in BI methods and tools to streamline data introduction process into highly abstract and complex enterprise data warehouse.
• As part of process, optimization used IBM Business Monitor to present dashboards to higher management which gives them insight into end-to-end business process and activity monitoring.
• Responsible for Subversion administration, migrations, and deployments of scripts in different environments on AIX platform.

Environment: Windows XP, UML, RUP, MS Project, MS Visio, Microsoft Office (Word, Excel, Outlook), UNIX, DB2, SQL Server, Cognos, Subversion, Informatica, WinSQL, Erwin, Putty

Confidential, Cleveland, OH

Data Analyst

Responsibilities:

• Creating & delivering data structures via logical & physical designs for IT Project teams based on an understanding of application requirements, business requirements and database constraints.
• Creation of the logical & physical database design for small & complex application across multiple projects and applications.
• Worked on the Consolidation data of the Call center specific for all the call center applications.
• Developed the Customer Global data stores to share among the different applications across the company that focuses on the customer specific data.
• Responsible for identifying, and negotiating of the corporate-wide technologies to purchase, deploy, and Implementation.
• Used SQL for Clarify data manipulation in the custom application.
• Review test cases for accuracy. Validate User Acceptance results confirm to requirements.
• Manage project plans and the deliverables including all artifacts for SDLC.
• Working directly with System Analysts, Application Analysts, and Database administrators to ensure data efficiency and integrity.
• Capture and document detailed data requirements for the strategic Initiatives and Projects.
• Facilitating the model walk-thru sessions for the business and application users.

Environment: Oracle 8.1.7, Erwin 4.1, Power Designer 9.5, Business Objects, Siebel. UNIX

Confidential

Data Warehouse Analyst

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used SQL for Querying the database in UNIX environment.
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting.
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Design and development of ETL process using Informatica ETL tool for dimension and fact file creation.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Conducted Black Box - Functional, Regression, and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Defects tracking, review, analyzes, and compares results using Quality Center.
• Participating in the MR/CR review meetings to resolve the issues.
• Defined the Scope for System and Integration Testing.
• Prepares and submit the summarized audit reports and taking corrective actions.
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub-System Testing.
• Document and publish test results, troubleshoot and escalate issues.
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones with the dependencies.
• Functionality testing of email notification in ETL job failures, abort or data issue problems.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule.
• Created and executed test cases for ETL jobs to upload master data to repository.
• Responsible to understand and train others on the enhancements or new features developed.
• Conduct load testing and provide input into capacity planning efforts.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing, specifically load testing using Load Runner.
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Windows XP, Informatica Power Center 6.1/7.1, QTP 9.2, Test Director 7.x, Load Runner 7.0, Oracle 10g, UNIX AIX 5.2, PERL, Shell Scripting