PROFESSIONAL SUMMARY:

• 7+ years of Industry experience as a Data Analyst & Data modeler with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Expert in writing SQL queries and optimizing the queries in Oracle, Netezza, SQL Server and TeradataV2R6/R12/R13.
• Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata V2R6/R12/R13.
• Experience in Data masking using Informatica data masking transformation.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Excellent knowledge on Perl & UNIX.
• 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.
• Excellent knowledge on creating reports on SAP Business Objects, Tableau & TIBCO Spotfire.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Excellent experience in Data mining with querying and mining large datasets to discover transition patterns examine complex data.
• Solid experience in Database performance tuning, optimization and maintenance
• Excellent experience designing both logical and physical data models in large enterprise organizations
• In depth understanding of data modeling concepts and techniques as applied in OLTP, ODS and Data Warehouse applications including normalization (3NF), de-normalization, dimensional modeling, OLAP
• Experience working within a broader team to fill out details of a conceptual design into a detailed logical data model (ERD) and corresponding a physical data model through developed DDL scripts, and oversee the execution and testing of DDL scripts in collaboration with DBAs

TECHNICAL SKILLS:

Data Warehousing: Oracle, SQL Server, MySQL, SSIS, SSRS, Data Stage 8.x, Informatica 9.5/9.1/8.6/7.1.2 (Repository Manager, Designer, Pentaho (BI), Workflow Manager, and Workflow Monitor)

Reporting Tools: Business Objects, XIR2

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

RDBMS: Oracle 11g/10g/9i/8i/7.x, MS SQL Server, SQL Server Analysis Services, UDB DB2 9.x, Teradata V2R6/R12/R13, MS Access 7.0 SQL Server Analysis Services

Business Intelligence Tools: Info View, Web Intelligence, Desktop Intelligence

Programming: SQL, T-SQL, PL/SQL, UNIX Shell Scripting, VB Script

Environment: Windows (95, 98, 2000, NT, XP), UNIX

Other Tools: TOAD, MS-Office suite (Word, Excel, Project and Outlook), BTEQ, Teradata V2R6/R12/R13 SQL Assistant

WORK EXPERIENCE:

Confidential, Thousand Oaks, CA

Sr Data Analyst

Responsibilities:

• Responsible for complete life cycle implementation that encompassed Business Requirement gathering, analyzing their source systems and then building a new data mart in order to provide functionality for their reporting purposes.
• Understand and articulate business requirements from user interviews and then convert requirements into technical specifications Documents.
• Responsible to investigate data discrepancies between the existing reporting system and a new data warehouse system.
• Navigated table relationships through both a 3NF system and a star schema.
• Implementing source procedures to the existing logic to help identify whether the new data warehouse matches that logic.
• Used profile data to understand potential weak points in the reporting data.
• Documented Database Issues and Send to Information Technology for Correction.
• Communicated with ETL developers in order to figure out where and why a data discrepancy exists.
• Involved in Report writing using Business Objects.
• Created and Maintained Access Databases, using Modules, Reports, Queries and Access SQL, for Call Center.
• Recommended System Changes and Enhancements.
• Involved in troubleshoot data issues using SQL Server Query Analyzer, and Enterprise Manager Tools.
• Created Custom Reports and Queries using Inner and Outer Joins.
• Performed Sales analysis and projections using Access and Excel.
• Created, published, scheduled and maintained Business Objects, Info View reports publisher, Business Objects Console Management.
• Performed routine functions in Informatica like loading data from a flat source file into a target and apply transformations for the data according to the requirements.
• Generated data models using basic concepts of ERWIN.
• Extensively implemented and governed the corporate naming standards according to the company-specified standards.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Interacted with SME accumulate knowledge about business processes and documented those for future purposes.
• Involved all design reviews of mapping according to High level design Mapping Documentation and standards followed for project.
• Collaborate with QA team for Defect tracking and resolved Data Modeling defects.

Environment: SQL Server, Informatica, Business Objects, Info View, ERWIN, MS Access and MS Excel.

Confidential, Rollinsford, NH

Data Analyst/Data Modeler

Responsibilities:

• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Perform data reconciliation between integrated systems.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
• Experience using data cleansing techniques, Excel pivot tables, formulas, and charts.
• Metrics reporting, data mining and trends in helpdesk environment using Access
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Used Data Profile Viewer and wrote database T-SQL scripts to identify and quantify data defects and anomalies.
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Responsible for different Data mapping activities from Source systems to Oracle and SQL Server Databases
• Assisted in the oversight for compliance to the Enterprise Data Standards
• Worked in importing and cleansing of data from various sources like Oracle, flat files, SQL Server 2005 with high volume data
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive Data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• Identify & record defects with required information for issue to be reproduced by development team.
• Flexible to work late hours to coordinate with offshore team.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Informatica 8.6, Oracle 10G, Netezza, Aginity

Confidential, Bridgewater, NJ

SSIS, SSRS Developer

Responsibilities:

• Involved in requirements analysis, design and development of the entire project.
• Created Stored Procedures, triggers, UDF, views, tables and generated TSQL script for application.
• Extensively working in data Extraction, Transformation and Loading from source to target system using SQL Server 2008 Integration Services.
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Execute SQL Task, Send Mail Task, Script Task and Data Flow Task.
• Used different Data Flow Transformations like Sort, Merge Join, Look Up, Union All, Conditional Split, Aggregate and Script Component etc.
• Implemented Package Configurations, Logging information for dynamically pass the values to packages.
• As per requirements developed the reports in the form of Matrix, Table and Chart using SQL Server 2008 Reporting Services.
• Development, Deployment and Mailing of various parameterized reports.
• Created packages in SSIS Designer using Control Flow, Data Flow Transformations to implement Business Rules.
• To develop Audit Process for each ETL package which Stores all the Package Information like On Error, Execution date, Parent Package, Start Date and End Date.
• Scheduling And Monitoring the ETL packages for Daily load in SQL Server Job Agent.

Environment: SQL Server 2008, SSIS 2008, SSRS 2008 & Windows XP

Confidential, Manhattan, NY

Data Analyst

Responsibilities:

• Participated in gathering Business Requirements and designed the project according to the Business requirement specifications.
• Built the Forms for application using various form modules and windows.
• Designed the data flow diagrams using VISIO.
• Involved in preparing Business test cases, test design, test Cases, and Strategies.
• Reviewed the test cases and bug reports.
• Developed user interface screens using VB, ADO to connect to backend and stored procedures to manipulate data.
• Created stored procedures, triggers using PL/SQL.
• Wrote SQL queries to perform database Validations.
• Used SQL*Plus for updating the database and for data retrieval.
• Did unit testing, manual testing of the processes to check the integrity.
• Involved in the implementation, testing and maintenance of the system.
• Design and develop a custom database (Tables, Views, Functions, Procedures and Packages).
• Run batch jobs for loading database tables from flat files using SQL*Loader.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Executed System and data quality testing to ensure all development deliverables are production ready.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Environment: VB, SQL, Test Director, SQL Server 2005, PL/SQL, XML, XSLT, Java and UNIX.

Confidential

Data 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 processes 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, analyze and compare 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