Data Sql Server

WALTER NDI

Cell: 202-***-****, Email: ********@*****.***

Career Objective

Seeking a Data related, challenging and responsible position where my experience, education, abilities 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

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

process and detailed design of the database in Banking, Healthcare and transportation sectors

Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling

•

experience using Normalization, Business Process Analysis, Dimensional Data modeling, FACT&

dimensions tables, physical & logical data modeling.

• 2 two 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

• Active DOD Confidential level NACL Clearance

• 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 11g and Microsoft SQL Server.

•

Excellent in writing highly complex SQL queries to fulfill ad-hoc and strategic data segmentation

•

requests using SQL server management studio.

Experience in data migration from homogenous and heterogeneous sources to a target database

•

Performed data cleansing and transformation using Informatica power center

•

Technical Skills

RDBMS Teradata (12,13), Microsoft Server (2005,2008,2012), Oracle (10g, 11g)

Teradata SQL Assistant, SQL Server Management Studio, SQL Plus/ SQL

Querying Tools

Developer

Requirement

QA tool, Excel, Power point, Outlook, Beyond Compare, CA Erwin,

Management Tool/Data

Informatica

software/ETL

Languages Advanced SQL, Pl/SQL, T-SQL, VB scripting

Windows, Unix/Linux

Operating Systems

1

WALTER NDI

Cell: 202-***-****, Email: ********@*****.***

Experience

US Department of Defense, Seaside, CA

Data Quality Analyst

Jan 2014- present

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)

• Look for source of error and do impact analysis using SQL scripts

• Analyze data using excel and extract useful information for decision making

• Consult with subject matter expert to discuss reasons for inconsistent data and cause of error

• Use SQL to update tables and extract data for data profiling and analysis

• 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

• 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

1. 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

• Use PL/SQL scripts to run checks within the data base

• Proficient in Microsoft office, Outlook, power point and excel

2

WALTER NDI

Cell: 202-***-****, Email: ********@*****.***

SunTrust bank, Bowie, MD Feb 2012- Dec

2013

Data/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

I imported Source tables from the respective flat files and relational database systems and created reusable

transformations (Joiner, Routers, Lookups, Rank, Filter, Expression and Aggregator) inside a mapplet and

created new mappings using Designer module of Informatica Power Center to implement the business logic and

to load the customer financial data incrementally and in full into the target database.

• Created Complex mappings using Unconnected Lookup, and Aggregate and Router transformations for

populating target table in an efficient manner.

• Used Shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit

changes made to the source automatically.

• Worked on SQL tools like SQL Plus/MS SQL Visual studio/Teradata assistance to run SQL queries and

validate the data.

• Extensively work on the performance tuning of Informatica PowerCenter Mappings as well as the tuning of

the sessions by creating multiple sessions on primary key values by using partition query.

• 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.

• Performed unit, integration and system level performance testing. Associated with production support team in

various performance related issues.

• Provided production support by monitoring the processes running daily.

• Scheduled the Jobs by using Informatica scheduler.

Performed other data cleansing and transformation activities as required using Informatica power center and

loading to a target database

3

WALTER NDI

Cell: 202-***-****, Email: ********@*****.***

Client: Citi bank NJ July 2009 - Jan 2012

Role: ETL developer / Support Data modeler

Citi Bank provides many bank related products to their qualified customers including checking and saving

accounts, money market accounts, certificates of deposit and many more. I was one of the ETL developer/ Data

analyst supporting the Data modeling efforts. By analyzing data involve in the modeling process and using

complex SQL and Informatica powercenter to extract transform and load data into target databases, dimensions

and fact tables.

Responsibilities:

• 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.

• Performed other data migration, transformation and loading task as required using Informatica powercenter

4

WALTER NDI

Cell: 202-***-****, Email: ********@*****.***

Professional Education

Graduate Certificate - Information Technology (informatics)

University of Maryland University College – Adelphi, MD Dec. 2013

Diploma – Oracle database administration (UNIX and Linux operating systems)

Brontech computer institute- Greenbelt, MD. 2007

Master of Science (Msc.–Business) Acquisition and Supply Chain Management/Minor – Logistics University of

Maryland University College – Adelphi, MD

Final GPA 3.5/4

Bachelor of Science (Evaluated to US Standard by WES) – Economics, Honors/Minor – Management University of

Buea –Buea, SW Province, Cameroon 2000

5

Contact this candidate