SUMMARY

• Around Six years of IT experience in Data analysis, Data Cleansing, Data Monitoring, Data Profiling, Modeling, Designing, Developing, Dimensional data modeling, Testing, Implementation and maintenance of Data warehouse applications,Client Server applications, Web applications and maintainingdatabase related applications.
• Worked onDatawarehousing business Intelligence area dealing withdataanalysis, solution design Metadatamanagement and MDM, ETL.
• Performeddatacleansing,dataanomaly resolution and developedcleansingrule sets for ongoingcleansinganddata synchronization to improve data quality.
• Experience in managing and leading Joint Application Development (JAD), Rapid Application Development (RAD) sessions, and proposed alternative tasks and transform those into Business Requirement Document (BRD).Worked on ETL exceptions handling, compliance tracking and data reconciliation.
• Experience in Decomposition of text fields into component parts and formatting of values into consistent layouts based on industry standards, local standards (for example, postal authority standards for address data), user - defined business rules, and knowledge bases of values and patterns
• Used DataMapping,DataProfiling, Data Parsing and standardization, Data Monitoring, Gap Analysis, Risk Identification, Risk Assessment, Risks Analyses, and Risk management Standards to improve data quality.
• Extensive experience in using data quality tools & processes like Talend, Decleansing, Validity, Accuracy, Completeness, Consistency and Uniformity.
• Extensively worked on various databases and followed SOA for Integration of various data sources like Oracle, SQL Server, DB2, Teradata, XML and Flat Files.
• Experience in writing PL/SQL stored procedures, triggers and functions. Good experience in Data Cleansing, Data profiling and Data Analysis.
• Extensive experience in Data Warehousing using Informatica PowerCenter 9.1/8.6 with expertise in design, development and implementation of Extraction, Transformation and Loading processes.
• Experience in business intelligence tools (SSIS, SSAS, SSRS, SAP Crystal Reports and SharePoint). Skilled in working with Data Warehousing (DW) and Data Analytic systems.
• Good understanding of Data Warehousing concepts (Kimball/Inmon), DimensionalModeling using Star schema and Snow- Flake schema for faster, effective querying and Business Analysis Requirements.
• Experienced working with Business Intelligence (BI) and Data warehousing tools like Cognos, Hyperion Essbase, and Informatica.
• Extensive experience in analyzing data requirements and creating design of data model and ETL solutions for data warehouse.
• Solid SQL and Business Intelligence development skills to support data mining, analytics and reporting.
• Experience in Functional Requirement Gathering, Gap Analysis, Requirement Traceability Matrix and in Wire Frame & Activity Diagrams.
• Experience in identifying performance bottlenecks and tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions for better performance and efficiency.
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008/2012, Teradata & Netezza.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Excellent experience in writing and executing unit, system, integration and UAT scripts in a data warehouse projects.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Excellent experience in troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models and writing SQL Queries for Data Validation and Data Integration.
• Excellent team player with very good analytical, problem solving, oral and written communications skills.

PROFESSIONAL EXPERIENCE

Confidential - Marietta, GA

Data Analyst

Responsibilities:

• Coordinating with source system owners, day-to-day ETL progressmonitoring,Datawarehouse target schema Design (Star Schema) and maintenance.
• Deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio (BIDS); schedule SSIS and stored procedure in SQL Server Agent.
• Evaluateddataprofiling,cleansing, integration and extraction tools (e.g. Informatica).
• Increased the data quality by 75% to 80% to achieve the pre-defined targets.
• Provide data Integration support to all clients systems. This consist of trouble shooting, analyzing, validating and creating solutions on issued data that is not integrating properly.
• Involved in managing data quality issues and played an active role in providing the suitable solutions.
• Developed a formal business intelligence structure that included internal & external reporting for clients, as well as a reporting environment using SQL Server Management Studio.
• Data warehouse development and maintenance primarily using Netezza database appliance, interfacing also with SQL Server and Oracle system. Experience as a ETL Developer to understand repository objects that support the business requirement and process
• Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects. Involved in development of SQL queries for validating the reconciliation data.
• Performed the data extraction, data transformation, data loading and then compared the transformed outputs of both Source and Target systems.
• Responsible for managing multiple data integration projects on a weekly basis ensuring deadlines were met on time.
• Actively involved in Identification, linking or merging related entries within or across sets of data.
• Tested newly built data warehouse BI reports for sampling of accounts and time periods in the Cognos reports against the DB2 databases.
• Built Hyperion Essbase Business Intelligence solutions to meet Corporate Planning business needs to help analyze actuals and budget.
• Actively worked on large data warehousing and maintenance activities including data modeling, mapping, development, integration, analysis and testing. Designed and implemented the HR Business Intelligence data warehouse and ETL (extract transform load) utilising Oracle Business Intelligence Enterprise Edition (OBIEE) and PL/SQL
• Created and executed detail function Test Scripts and Test cases based on the business requirements. Also supported the User Acceptance Testing during the Implementation phase of the project.
• Consolidated data stored in different databases (SQL, Oracle, DB2) into one single source. It also aimed at creating new interfaces for downstream applications.Installed, Configured OBIEE 11g and Migrated OBIEE 10G to 11G.
• Design Architecture and implementation plans for new Informatica ETL environments to be set up.
• Involved in administration and maintenance for massive Informatica environment involving large number of development projects.
• Worked on the migration of Informatica workflows or folders across environments as per requirements.
• Automated monitoring for workflows by using shell scripts to monitor the workflows. Also worked on the migration of new Informatica/ICM codes and cover post migration support.
• Plan and Supervise Middleware team to coordinate with Strategic Business Units and vendors to implement data integration solutions.
• Involved in Data mapping specifications to create and execute detailed system test plans. Working on the Open Source ETL tool Talend Open Studio for Data Integration is used to Extract, Transform and Load data from the MLS data bases to the client data base
• 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.
• Developed and Performed execution of Test Scripts manually to verify the expected results. Also worked on design and development of ETL processes using Informatica ETL tool for dimension and fact file creation.

Confidential - Pittsburgh, PA

Data Analyst

Responsibilities:

• Prepared data layouts for migration activities from Store Tables in Oracle to multiple tables in data warehouse in Oracle.
• Established methodology specific to Business Intelligence to improve quality, value, and frequency of delivery.
• Set Business Intelligence strategy by working with end-users and managing technical developers.Created ETL job infrastructure using Talend Open Studio.
• Analysed data to capture statistics (metadata) that provide insight into the quality of the data and aid in the identification of data quality issues.
• Acted as a liaison between Data Services team and Data Warehouse team to automate various manual processes using new technologies like ETL tool.
• Efficient in SDLC coherent with Data Cleansing and Conversion.
• Implemented quality stage for data cleansing, standardization and matching process.
• Lead many data specification and Technical walkthroughs.
• Involved in defining the source to targetdatamappings, business rules, business anddatadefinitions.
• Managed vendors, multiple employees, developed business intelligence vision and set strategic direction to understand data relationships and flow of data into the application from the brokerage data warehouse (BDW) and between the applications OLTP database and the data mart.
• Used Stored procedures for cleaning, transformation of data with in Data warehouse. Created centralized and field application for advance data entry and data warehousing. Tailored product for each client providing customisations in data warehouse, ETL mappings, OBIEE Answers, Dashboards & BI Publisher
• Worked with data warehousing group to get all the cleaned up data into OLAP controlled data mining systems. Involved in development of SQL queries for validating the reconciliation data.
• Created new ETL process to extract, transform and load data from different sources to data ware house.
• Experience in documentation of Test Plans, Test Cases, and Test Procedures and Test Scripts for the Web and Client/Server Applications.
• Executed tests and participated actively in system testing and regression testing. Analyzed the user/business requirements and functional specs documents.
• Worked on the ETL process used by the Data Stage System designers used for extracting data from heterogeneous source systems, transforming and loading the data into the data warehouse/ data marts
• Created and executed detail function Test Scripts and Test cases based on the business requirements. Supported the User Acceptance Testing during the implementation phase of the project.
• Extracted data from MS-Access and validated the reports. Also involved in Code walkthroughs and reviews.
• Enterprise Data Warehousing, compatible implementation and upgrade experience of large scale on-premise ERP applications.
• Expertise in User Interface Design (UID) and management of object based application deployment process using waterfall, scrum/agile methodologies RUP and Six Sigma.
• Identified Use Cases from the Functional Requirements and created Use Case Narratives along with the functional specifications for each work streams.
• Involved in various walk-through sessions with developers on and off-shore and prepared presentations to help them understand the requirements and end user needs.Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes.
• Collaborated with the data warehousing team, ensuring that data infrastructure supports the needs of analytics team and validating data quality.
• Performed source data identification and analysis to get a clean master data to report to customers and involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment. Also developed separate test cases for ETL process (Inbound & Outbound) and reporting.

Confidential -Kansas City, MO

Data Analyst

Responsibilities:

• Involved in development of SQL queries for validating the reconciliation data.
• Worked on developing and maintaining Test Scripts, analyzing bugs and interacting with development team members in fixing the defects. .
• Involved incleansingthe datato improve data quality and transforming thedatato the staging area then loading thedatain theDataMarts
• Demonstrated customer focus and Client Management Skills within context of Requirements Definition, Analysis, Documentation, User Acceptance Test and Production Support.
• Executed tests and participated actively in system testing and regression testing.
• Wrote and executed SQL queries to verify that data has been moved from transactional system to Data warehouse, data mart reporting system in accordance with requirements.
• Analyzed the user/business requirements and functional specs documents.
• Created and executed detail function Test Scripts and Test cases based on the business requirements.
• Worked in Support, Maintenance, Data Analysis, Performance Tuning, Query Analysis & Code Optimization roles.
• Involved in entire QA Life Cycle, which includes Designing, Developing and Execution of the entire QA Process and documentation of Test Plans, Test Cases, Test Procedures and Test Scripts. Provided deep dives on Pricing trends, Capture rate, Profitability, and Customer churn which drive Annual Price Review sessions with Sales, Operations, and Finance teams.
• Extracted data from MS-Access and validated the reports and was involved in Code walkthroughs and reviews.
• 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.

Confidential 

Data Analyst

Responsibilities:

• Mapped data elements to the source data files by identifying business requirements. Design documentation and business requirement specifications were used in establishing the relation between the data elements and source data.
• Analyzed exceptions to the data resulting from the trading floor by validating the business logic using business requirement documents.
• Involved in understanding business requirements and creating business activity flow diagrams.
• Performed impact analysis on the data element changes in the source data files.
• Developed generic data extraction and data validation SQL scripts.
• Developed Stored Functions and Procedures for data cleansing, updating & customization purposes.
• Aided Business Users in their testing initiatives by providing extensive Data Support and Data extracts.
• Performed Backend Testing to ensure the authentic retrieval of the data from the database.
• Executed the automated Test Cases and Test Sets in Test Director.
• Created Test data in the form of XML files based on the various Schema versions.
• Developing and Maintaining Test Scripts, analyzing bugs and interacting with development team members in fixing the defects.
• Executed tests and participated actively in system testing and regression testing.
• Supported the User Acceptance Testing during the Implementation phase of the project.
• Analyzed Business Requirement Document and Analysis & Design Document.