PROFESSIONAL SUMMARY:

• 6 years of experience in Information Technology as System/Business Analyst, Data Analyst and Data Quality Analyst.
• Performed analysis on Supply chain, Healthcare and Insurance domain to help clients gain insights into their business and customer behavior through analysis of campaign data, transactional data, customer profile data, and campaign conversion data.
• Experienced System Analyst and Data Quality Analyst with excellent understanding on Data modeling, Data Mapping, Data Profiling, Data Validation, Data Cleansing, and Data Verification also in - depth knowledge in OLAP Systems, Data Warehousing, Star and Snowflake Schema, Slowly Changing Dimensions.
• Expertise in working with various relational databases like Oracle, DB2/UDB, SQL Server, Teradata and integrate data from multiple sources for business requirements.
• Extensive experience in Source to Target Mapping and Source to Target Testing to confirm data loaded into data warehouse accurately.
• Responsible for running complex SQL queries and performing data validation,
• Experience in data analysis and data profiling using complex SQL on various sources systems including Teradata, ORACLE and SQL Server.
• Specialize in data models, database design, technical design document and development.
• Expertise in all phases of data warehouse projects including requirement analysis, data analysis, mapping document preparation, validation of data and test process management.
• Experience in Big data analysis and implementation of Big data project using Hadoop, HBase and Hive, HQL, Scoop.
• Experienced in creating and maintain rich interactive visualization through data interpretation and analysis integrating various reporting components from multiple sources.
• Expertise in JIRA (Epic, Story, Bug, Task), ALM, XML Spy
• Expertise in SDLCs including Agile/Scrum Methodology and creating data visualization, ad-hoc reports using Tableau.
• Expertise in preparing Test Strategy, Test Plan, Test Summary Reports, Test Cases and Test Scripts for Automated and manual testing based on the User Requirement Document
• Experience assessing testing processes, creating and implementing testing strategies in testing environment

TECHNICAL SKILLS:

Databases: Oracle 11g/10g, MS SQL Server, Data Lake, Teradata 16.20

ETL Tools: Informatica PowerCenter 9.5/8., Teradata Fast load/Multiload, FastExport, BTEQ

Big data: Hadoop, HDFS, Hive, Sqoop

Test Management: HP Quality Center, ClearQuest, JIRA

Operating Systems: Microsoft Windows, UNIX, LINUX, IBM MVS

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, XML, HTML

Other Tools: SQL*Plus, SQL Developer, SQL Loader, TOAD, SQL Assistant

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Business System Analyst

Responsibilities:

• Created and presented relevant documentation such as business required documents, User stories, Use cases, Process flow documents to business stakeholders
• Extensively worked with the consumption team to create business/transformation logic for source to target mapping to ensure that data is moving properly from Data Lake to Teradata according to business requirements
• Worked and created complex SQL or BTEQ queries/scripts for root cause analysis and ad-hoc reports
• Worked closely with business stakeholders to show any changes made in current project will/will not make any effect on existing data and how it will advance company’s goals by creating business scenarios
• Coordinated with Project managers, Development and Testing team as appropriate to review the proposed solution and design to ensure that the requirements are met.
• Reviewed test plans, test cases, test scenarios to ensure that the requirements are covered
• For the project need worked closely with developers to find source and create traceability matrix
• Performed different roles BA or Scrum Master apart from SA for the project needs
• Worked closely with Agile methodology by attending daily standup, sprint grooming, sprint planning, backlog refinement

Environment: Agile, Hadoop, Data-lake, Teradata 16.20, MS Excel, MS word

Confidential, Kalamazoo, MI

Data Quality Analyst

Responsibilities:

• Developed source to target mapping for Migration Project also performed data profiling.
• Developed complex SQL queries for querying data against different databases for data verification process.
• Extensively worked with flat files, XML, Jason and excel sheet data sources. Wrote scripts to validate the flat files data in the databases.
• Wrote complex queries in Teradata, SQL Assistant to check the data from source and target
• Loaded data from operational data store (ODS) to data warehouse tables by writing and executing foreign key validation programs to validate where exactly star schema appears, with fact tables and dimensions/lookup tables.
• Involved in preparing Source to Target Mappings and coordinating UAT with business teams and reporting status periodically.
• Extensively involved in Reconciliation and Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Developed Complex SQL queries to fetch the data from the Database as per the business requirement to analysis the gap or root cause and use the SQL queries for further processing.
• Involved in the Data Validation, Data Conditioning, and Interacting with Acxiom for standardizing Name and Address Information and entire Delta Processing for different Line of Businesses.
• Identified various Data Sources and Development Environment.
• Tested complex Talend mappings that loaded the data from various sources using different transformations like tMap, join files, expression, aggregator, filter, normalizer, tuniqrow and sorting.
• Worked closely with project managers to understand and maintain focus on their analytical needs including actionable insights to relevant decision-makers.

Environment: MS.Visio, Oracle 11g, Teradata 15, SQL Server, MS Excel

Confidential, Ann Arbor, MI

Data Analyst

Responsibilities:

• Performed complex source to target mapping, data analysis in support of ad-hoc, standard, and project related requests.
• Developed test scripts based on technical specifications/Data design documents and Source to Target mappings. Ensured Quality standards to meet the Data Quality SLAs.
• Analyzed and tested data from Hadoop using Hive/HDFS.
• Prepared the expected results based on business rules.
• Wrote complex SQL to source to target loading.
• Created expected results and checked and validate the Data Integrity.
• Prepare the Test Data for the Initial, Incremental (Daily Inserts and Updates) and historical Load testing and validate.
• Test the various informatica mappings with Tuning Techniques to improve the mapping/session performance.
• Use Informatica debugger and session log to debug the defects. Test reusable Mappings and Transformations.
• Test and maintained process tables to check the status of control loads.
• Work closely with Developers in resolving the issues and understanding the functionality for future reference.
• Validate Informatica mappings, update processes, Control Loads, and Scheduling mechanism.
• Involved in Unit Testing of Datastage Jobs, integration testing and system testing in pre-production environment
• Used SQL (Set Operators- MINU, INTERSECT, UNION), and OLAP functions for validating the ETL processes functionalities.

Environment: Talend Open Studio 5.4, Oracle 11g, Teradata 14, Informatica, SQL Developer, PL/SQL, UNIX

Confidential, Windsor Locks, CT

Data Quality Analyst

Responsibilities:

• Updated and remediated existing Business Intelligence scripts and Teradata applications to reflect changing business data requirements.
• Facilitated and attended numerous detailed chartering sessions with the Marketing Business team in order to enhance the reports being used by them.
• Acted as the sole resource for satisfying ad hoc requests from the Direct Marketing analysts. Activities involved running segmentations, gathering responses to the marketing campaigns, and integrating campaigns and the conversions thereof.
• Used Excel Functions and Pivot tables to provide data to the business users for greater analysis.
• Did analysis on the existing gaps in the logic of fraud tracking and enhanced those scripts to the great appreciation of the top executives.
• Satisfied adhoc SQL requests from the Credit card Risk Analysis team.
• Developed numerous BTEQ scripts for Transformation of data as well as for reporting of data.
• Automated jobs and did extensive file processing using UNIX Shell scripts.
• Scheduling of jobs through Control-M on UNIX platform.
• Provided end users with data in different formats including Excel sheets, ad hoc enabled Business Objects and Microstrategy reports, SAS data sets, and word documents.
• Extensive work in creating BI applications involving MS Excel Pivot Tables, Vlookups, Hlookups and statistical formulae.
• Automated daily, weekly and monthly reports on Windows and UNIX platforms.

Environment: Teradata 14, BTEQ, Fastload, Multiload, SQL Assistant, MS.Visio, ERWIN, CA7