SUMMARY

• Over 7+ years of extensive experience in Data analysis, Data Quality Management, gathering requirement, modeling, design and development of Databases in OLTP and Data warehouse environments in the finance, insurance and banking domains.
• Proficient in Data Analysis, System Analysis, Business Requirement Gathering &Data Modeling. Experienced and comfortable working on databases like SQL Server, Oracle & Teradata.
• Expertise in business modeling documentation for the AS - IS process and proposing the TO-BE business process.
• Proficient in gathering the requirements using JADs, Interviews and existing documents and surveys etc.
• Proficient in documenting the Business requirements (BRDs), System requirement Specification, writing higher level Use cases.
• Experienced with Full Life Cycle and Methodology for implementing Data warehouse and Business Intelligence Reporting System.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata and Flat files into a staging area.
• Technical expertise in BI, DW, Data profiling, Data Cleansing, Data Integrity, Deference Data, Data Security and Data Quality Management.
• Well conversant with test case design, test case execution, test data preparation, SDLC concepts, Defect Life cycle
• Expert in using design and management tools like Erwin and Toad, SQL Developer
• Good exposure to Object Oriented Programming, Agile Methodologies
• Proficient in Data Governance, Data Lifecycle, Data Quality Improvement, Master Data Management, and Metadata Management
• Analyzed performance improvement pathways by parallelizing the scheduled of Informatica jobs using UNIX Shell Scripting thereby improving time to deliver.
• Proficient in Oracle 11g, Teradata, SQL Server, PL/SQL on UNIX and Windows platforms. Extensive experience in Database activities like Data Modeling, Design, development, maintenance, performance monitoring and tuning, troubleshooting, data migration etc.
• Well capable in preparing Financial Reports, On-Demand Reports using Oracle SQL, Teradata. Developed Adhoc queries and Reports using Oracle, SQL, PL/SQL, and UNIX to fulfill business analysts, Operations Analysts and Financial analysts’ data requests.
• Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint
• Experienced in analyzing Business Requirements Documents (BRD), Functional Requirement Documents (FRD), Test Strategy and Test data preparation, Coordinating User Acceptance Testing (UAT), Preparing Manuals and Training Business Users

TECHNICAL SKILLS

Data Warehousing: Informatica 9.5/9.1/8.6/7.1.2 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SSIS, IDE, IDQ, Data Cleansing, data profiling, Data Stage, Ab-Initio, Talend, SAP Business ObjectsXIR3.1/XIR2, Web Intelligence

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

Databases: DB2 V9.1, Oracle 10g, SQL PL, SQL Server 2008,Teradata

Reporting Tools: Business Objects6.5, XIR2/XIR3, Tableau, Tibco Spotfire

Languages: UNIX Scripting, Perl, SQL, XML

OS: Windows 95/98/2000/XP/7/8, DOS, UNIX, UBUNTU 12.04, CENTOS

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Senior Data Analyst/Modeler

Responsibilities:

• Analysis of data elements for data profiling and mapping from source to target data environment.
• Developed working documents to support findings and assign specific tasks
• Created data masking mappings to mask the sensitive data between production and test environment.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle 10g/11g and Teradata.
• Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• 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.
• Performed data mining on data using very complex SQL queries and discovered patterns and projections.
• Used CATT for transaction results and system messages and making comparisons between target and actual values or determining values.
• Created DML code and statements for underlying & impacting databases.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Perform data reconciliation between integrated systems.
• 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
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Created and maintained the logical data model using ERWIN and based on determining logical requirements from analysis of a physical object model.
• Responsible for different Data mapping activities from Source systems to Netezza
• Assisted in the oversight for compliance to the Enterprise Data Standards
• Worked in importing and cleansing of data from various sources like Netezza, Oracle, flat files, SQL Server with high volume data
• Worked with Excel Pivot tables.
• 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.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Business Objects XIR2, ETL Tools Informatica, Oracle 10G, Netezza, XML, Aginity

Confidential, Stamford, CT

Senior Data Analyst

Responsibilities:

• Analysis of functional and non-functional categorized data elements for Data Migration, 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.
• Experience developing data transformation and cleansing rules for migration using ETL tools
• Analyzed multiple source system to identify the data for migration
• Coordinated data migration from old to new system during Teradata system capacity expansion.
• Performed data mining on data using very complex SQL queries and discovered pattern.
• Created DML code and statements for underlying & impacting databases.
• Solid Back End Testing experience by writing and executing SQL and PL/SQL Queries.
• Worked with ETL team who ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Used CATT test case & recording the data input of of the source file template.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin
• Perform data reconciliation between integrated systems.
• Good experience in Data Extraction, Modification, Validation, Analysis, Management and Reporting using SAS Software.
• Metrics reporting, data mining and trends in helpdesk environment using Access with SharePoint.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Performed data analysis, Data Migration and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Responsible for different Data mapping activities from Source systems to Teradata

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, My SQL, Erwin, Business Objects XIR2, ETL Tools Informatica 8.6, Oracle 10G, Teradata R12, TOAD 7, Teradata SQL Assistant 12.0, Informatica power center, IDQ

Confidential, Colorado Springs, CO

Senior Analyst

Responsibilities:

• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files, XML and RDBMS tables to target tables.
• Responsible for different Data mapping activities from Source systems to EDW, ODS & data marts.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Used CATT to maintain data as variants for data uploading, and aloso used for Integration,error handling.
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, and Relational Data from various heterogeneous data sources.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
• Tested several stored procedures and wrote complex SQL syntax using case, having, connect by etc
• Involved in Teradata SQL Development, Unit testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
• 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: Informatica 8.1, Data Flux, Oracle 9i, Quality Center 8.2, SQL, Ab Initio, TOAD, PL/SQL, Flat Files, XML, Teradata V2R11,Netezza, MySQL, Oracle Databases, Actian, NoSQL - Hbase, MongoDB, CouchDB

Confidential, New York, NY

Data Analyst

Responsibilities:

• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Worked hands-on with the Enterprise Data Warehouse (EDW).
• Involved with Design and Development team to implement the requirements.
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• 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.
• Worked with data source systems and Client systems to identify data issues, data gaps, identified and recommended solutions.
• Performed data modeling and data analysis as required.
• Worked on database features and objects such as partitioning, change data capture, indexes, views, indexed views to develop optimal physical data model
• 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.
• Designed and developed Business Intelligence dashboards/workbooks in Tableau
• Created of SQL/HQL queries that are efficient, precise and easily modifiable
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
• Worked on Teradata and Oracle 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