Career Objective

Seeking a Data related, challenging and responsible position where my experience, education, ability and potential can be fully and efficiently utilized, which offers opportunities for growth, to acquire more knowledge and to utilize my skills to serve.

Expertise

• Active DOJ secret Clearance
• Active USPS MBI Public trust clearance
• Over 6 years of experience as Data Analyst and ETL Informatica developer with excellent analytical skills for understanding the business requirements, Data migration, business rules, business processes, generating reports and detailed design of the database
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, Normalization, Business Process Analysis, Dimensional Data modeling, FACT dimensions tables, physical logical data modeling.
• Three years of strong experience in Data Warehousing and ETL using Erwin and Informatica PowerCenter
• Exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the development process
• Studied business rules and analyzed data in relation to business rules, evaluate impact to beneficiary, Government and or database system.
• Worked with different source systems like Teradata, Oracle and Microsoft SQL Server.
• Excellent in writing highly complex SQL queries to fulfill ad-hoc requirements and generate reports.
• Experience in data migration from homogenous and heterogeneous sources to a target database
• Performed data cleansing and transformation using Informatica power center

Technical Skills

Work Experience

Confidential

I was to work as a Technical Data Analyst with USPS but contract did not go through due to budgetary constrains

Insight Global Inc

Consultant:

Confidential

Data Quality Analyst

• Data Quality Analyst with the Department of defense Division of Enrolment and Eligibility reporting services DEERS .
• Study DEERS data/ business rules in relation to Military personnel benefits Dental, and other health benefits for analysis purposes
• Look for source of error and do impact analysis using SQL scripts
• Analyze data using excel and extract useful information and create report for decision making
• Consult with subject matter expert to discuss reasons for inconsistent data and cause of error as needed
• Wrote complex SQL to generate report
• Use QA tools to fix data inconsistencies affecting different health plans, policies and eligibilities in line with business rules
• Extracted data from different sources, use EXCEL to analyze and find trend for business intelligence purposes
• Weekly compilation of data errors and analysis of current errors for trend with passed errors, use power point for graphical presentation of results to stake holders
• Impact analysis on cost of bad data to military beneficiaries, Government and the database system
• Conducted cost and impact analyses and give recommendations as needed
• Understand the architecture involve in the flow of data from source through triggers and applications to the central database for analytical purposes
• Understand data issues and or bugs caused by a mal function in the dataflow process and recommend fixes
• Use Excel and Macros to run reports and analyze data for business reporting and error investigation purposes

Confidential

Project 1

Confidential

Data Analyst/ETL developer

SunTrust Mortgage consolidation project was carried out by SunTrust to integrate and standardize data from different sources on Teradata plat form. The purpose of the project was to provide a consistent and integrated view of the mortgage business from the loan origination to the serving system by creating an integrated database system.

Responsibilities

• Source data analysis and profiling
• Wrote complex SQL to generate reports as required
• Created Complex mappings using Connected and Unconnected Lookup, and Aggregate and Router transformations for populating target table in an efficient manner
• Worked on SQL tools like SQL Plus/MS SQL Visual studio/Teradata assistance to run SQL queries and validate the data.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Migrated mappings, sessions, and workflows from Development to Testing and then to Production environments.
• Provided production support by monitoring the processes running daily.
• Performed other data cleansing, analysis and transformation activities as required using Informatica power center and loading to a target database

Confidential

ETL developer /Analyst

Responsibilities:

• Collaborates with subject matter expects to establish data sources, develop requirement specifications according to standard templates.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Used sources analyzer and target analyzers to create sources and target mappings in informatica repository
• Use transformation to specify business rules and requirements to transform incoming data into a target database
• Developed parameters and variables in an external file to capture change data and run workflow in informatia to load the target databases accordingly
• Involve in conceptual, logical and physical designs of database structures using CA ERwin
• Involved in analyzing the source data coming from different Data Sources..
• Performed numerous SQL Statements to Load and Extract Data to and from Databases.
• Performed Data Analysis, created GAP Analysis Document, and performed Data Quality Checking.
• Created and modified views within Teradata for Business Analysts.
• worked in the development and design of ETL processes and interfaces
• Created views to make data available on need to know basis.
• Created queries to fetch data from different tables, using derived tables, Sub queries, as well as Correlated queries on SQL Server platform.
• Acted as point of contact tune inefficient queries so that they can be run during the peak hours as well.
• Created source to target mapping documents from staging area to Data Warehouse.
• Performed numerous SQL queries that were highly tuned using concepts like Explain.
• Performed data analysis as needed on promotional activities and as needed for the purpose of extracting useful information for business decision making.