Sql Server Data

Isaac K. Quarshie *****.********@*******.***

***** ****** ***** **. 704-***-****

Charlotte, NC 28277

Summary

• 10 years overall IT experience, with 7 years as MS SQL Server

****/****/****/*****matica ETL Developer in Windows environment in Telecom, Utility,

Mortgage, Health insurance, Finance and Retail companies

• Experience in designing and implementing BI solutions with Microsoft SQL SSIS, T-

SQL, Stored Procedure, SSAS, SSRS, Informatica, SQL Server, Oracle, Teradata and

DB2

• Experience in SQL Server DTS/SSIS/Informaticaworkflow to import,transform and

load(ETL) data between databases and external data sources.

• Design data mart and data warehouse.

• Responsible for Logical and the Physical design of the database according to

requirements.

• In-depth knowledge of Transact-SQL DDL and DML.

• Extensive knowledge in Tuning SQL queries and improving the query performance.

• Installation, Configuration and Maintenance Using Performance Point planning to Expertise in

creating reports using SSRS with MDX codes, PowerPivot (Excel Spreadsheet)

• Experience in designing Database Models using Microsoft Visio, Erwin and Toad

• Certified Informatica developer with over 4years experience

• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and

communication skills.

• Results oriented employee with successful record of accomplishment of providing and

delivering unique solutions to clients.

• Strengths include exceptional communication and interpersonal skills, strong work ethic,

multi-tasking, detailed oriented and capable of working in a fast pace environment.

Technical Skills:

Databases: MS SQL Server 2012/2008/2005, Oracle, Teradata, DB2, MySQL

ETL/OLAP Tools: SSIS, SSAS, SSRS, T-SQL, MDX, Power Pivot, Informatica 8.x/9.x

Data Modeling Tool: Visual Visio, TOAD, Erwin

Analytics: SAS, Minitab, Excel, Data mining (SAS)

Others: C#.NET, AGILE, SLDC, Team Foundation Server 2010,

Education & Certifications

• Masters of Science(Distributed Computing Systems), University of Greenwich,

London, UK, Dec/05

• Bachelors of Science (Statistics & Computer Science), University of Ghana, Legon-

Accra, Ghana, Jun/99

• Certified SAS Base Programmer – Feb/11

• Informatica Certified Developer – Mar/09

• Microsoft Business Intelligence (Master’s Program), Set Focus, Parsippany, NJ,

Aug/07

• Java Certified Programmer – Jan/05

1

*****.********@*******.***

• Microsoft Certified System Administrator – Aug/03

• Certificate, Specialist IT Programmer/Designer, Forssa, Finland, Aug/01

Professional Experience

Wells Fargo & Co., Charlotte, NC BI Consultant Jan/13 – June/13

• Analyzing, designing, developing and maintaining enterprise ETL systems and applications.

• Working with Business analyst, DBA's, SAS analysts and BI teams

• Provides enterprise data warehousing solutions, including design and development of ETL processes

• Extracts and moves data to databases, data marts and data warehouses, organizing and grouping

information for ease of use.

• Adapts T-SQL, Stored Procedures, SSIS processes to accommodate changes in source systems and

new business user requirements. Extracts data from outside sources, transforms data to fit

operational needs and loads data to end target, including databases, data marts and data

warehouses.

• Works on multiple hands-on ETL (SSIS) development projects. Offers sound guidance to team

discussions about data migration and ETL solutions.

• Supervise daily and monthly credit card, mortgage and retailer mart ETL reporting processes

Environments:-SQL Server 2010\2008, Visual Studio, TFS 2012, Hyperion Workspace, BPA Automate

American Tire Distributors, Charlotte, NC BI Consultant Jan/12–Dec/12

Responsibilities:

• Design, administer, enhance, and develop applications within our Sales & Marketing

department using SSIS, SQL SSRS, Server 2005/2008, SSAS and TFS 2010

• Extract data from the various source, Transform and load data into Corporate Data warehouse

• Develop the technical analysis documentation indicating Input, Process and output, proof of

concept (POC) and Mockups

• Design the technical specification document including the Dataflow, ETL Architecture, ER

diagram design, tables (base, lookup), Views, etc

• Design multiple complex and interactive report using SSRS with MDX and T-SQL

• Provide status updates to internal and external stakeholders as needed

• From a programming perspective, provide detailed review and analysis that includes;

reviewing code; warehouse loads; incoming data from point of sales systems, mappings, etc.

• Collaborate with members of other teams to accomplish tasks in timely manner including

problem resolution

Environments: - SQL Server 2012\2008, Visual Studio, Oracle, MDX, PL\SQL, Windows 7, Window 2003

Server, Visio, Toad, Team Foundation Server 2010

Accenture, Charlotte, NC Consultant Sept/07 – July/11

Client - Duke Energy - Finance Office (BI Lead Developer)

Responsibilities:

• Developed and execute activities related to end-to-end project management, including project

plans and estimates, scoping and requirements through implementation and deployment.

• Proactively monitored, managed and reported on execution of deliverables.

*****.********@*******.***

• Designed an Enterprise-wide ETL from an old legacy system using SSIS, Informatica 8.6, SQL

Server, Oracle and Teradata.

• Configured and monitored database application.

• Designed and implemented several complex reports and administration modules.

• Involved in performance tuning of the database and T-SQL queries using Explain Plan.

• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using in-house

report tool.

Environments: - SQL Server 2005\2008, Visual Studio, Oracle, PL\SQL, Windows XP, Informatica 8.6,

Unix

Client – PG&E - (Senior ETL Developer)

Pacific Gas and Electric Company, incorporated in California in 1905, is one of the largest combination

natural gas and electric utilities in the United States. The company provides natural gas and electric

service to approximately 15 million people throughout a 70,000-square-mile service area in northern and

central California. The project under my scope was to migratean old legacy system written in Mercator

to Oracle using Informatica 9.x

Responsibilities:

• Designed an Enterprise-wide tool from an old legacy system using Informatica 9.x, Oracle

and SQL

• Gathered requirements, analyzed, designed, tested and deployed new system.

• Created the Informatica source to target mapping, edited the rules and validation,

transformations, and business rules

• Creation of Transformations like Lookup, Joiner and Rank Transformations in the Informatica

Designer

• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed

dynamic Lookup and Router transformations for populating target table in efficient manner.

Environments: - SQL Server 2005\2008, Teradata, Windows XP, Informatica 8.6, UNIX

Client – Highmark, Pittsburg - Marketing Campaign(R&D Analytics)

Highmark history of helping families and companies with their health insurance needs dates to the

1930s, when Highmark predecessor companies were established to help Pennsylvania's residents pay

for health care. Highmark was created in 1996 by the consolidation of two Pennsylvania licensees of the

Blue Cross and Blue Shield Association Pennsylvania Blue Shield (now Highmark Blue Shield) and

Blue Cross of Western Pennsylvania (now Highmark Blue Cross Blue Shield). Highmark is now one of

the largest health insurers in the United States

Responsibilities:

• Assisted in report generation using Teradata SQL Assistant, SSIS, SSRS and in-house tools

• Aligned report structures with inbound and outbound systems.

• Collaborated with other strategy consultants and implementation team to work on analytical systems

and report enhancement for fraud detection capabilities

• Designed systems that enable clients to take appropriate corrective action through the database

• Created SSIS Packages to move the data from marketing campaign system into SQL

database. Before loading the data into the server, using various tasks, transformations and variables,

made dynamic SSIS packages which did data scrubbing, including data validation checks.

• Created various data objects like tables, views and indexes, and Data Dictionary

Environment: Teradata, UNIX, SSIS, MS SQL Server 2005, Windows 2003, Windows XP

Client– Freddie Mac (Senior SSIS Developer)

Freddie Mae is the leading Solution Provider for economic housing & mortgage market to ensure that

mortgage bankers & others lenders have enough funds to lend to home buyers at low rates & work to

increase the supply of affordable for sale & rental housing by creating customize financing solution.

*****.********@*******.***

Making Home Affordable Compliance is the new program started by the US department of Treasury for

the low home mortgages. The program helps generating the reports using the SSRSwhich helps the

treasury to look the reports on the daily basis. My Scope of work includedPopulating the dimension table,

fact tables and Transfer the Data from source to staging and applying transformation to the Data

warehouse.

Responsibilities:

• Design the SSIS packages to strip the PPI information.

• Load the staging (CDS) environment from flat file (LPS data) with the help of SSIS.

• Populating the staging environment first and then the fact and dimension table with the help of

ETL\SSIS and some of the transformations services.

• Involve in data cleansing and massaging with the help of SSIS.

• Design the SSIS package for the delta process and incremental load using the Fuzzy logic and

slowly changing dimension.

• Handling the duplicate data with the help of T-SQL.

• Created and developed research summaries, expert reports and presentation materials

• Analyzed and mined multiple data sources to select statistically valid data samples; built,

tested and implemented models by investigating appropriate methods and algorithms

• Created analytical datasets from data sources as necessary to develop variables for modeling

• Created the audit tables and developed an impact analysis solution using SSIS and SQL

Server.

• Reviewed and analyzed the most current trend and recommended strategy changes and gave

recommendations when needed.

Environment: SSIS/SSRS, MS SQL Server 2005, Windows XP.

Client - Best Buy (On/Offshore Coordinator)

With operations in the United States, Canada, Europe, China and Mexico, Best Buy is a multinational

retailer of technology and entertainment products and services with a commitment to growth and

innovation.The purpose of the package was the creation and maintenance of Schedule information

which passes between the Retail Merchandising System (RMS) and Advanced Inventory Planning’s

(AIP) Data Management Online (DM Online). This project import and translate the necessary information

for Order Groups and Delivery Groups from RMS to DM Online.

Responsibilities:

• Participated in data requirement gathering, analysis, design, development, unit testing and

implementation of warehousing projects using Informatica

• Created business requirement specifications, detailed designs, unit test cases, and change

controls

• Collaborated with client to and developed defect tracking and closing systems

• Trained new associates on the projects implications for Best Buy

Environment: SSIS, MS SQL Server, Oracle, Teradata, Informatica, Windows XP, TOAD, ERWin,

Client – BCBSM (ETL/SQL Developer)

Blue Cross Blue Shield of Michigan is a leading provider of quality health insurance for residents of

Michigan. Our main goal is to make health care cost-effective by offering health insurance solutions for

individuals, families, and large and small businesses at affordable rates.

Responsibilities:

*****.********@*******.***

• Assisted in design, development and implementation of complex data management and

storage applications using SSIS/Informatica

• Developed a tool for setting strategy and developing data warehouses for optimal decision

support

• Providedcontinuedtechnical assistance in identifying andevaluatingand procedures as they

related to the decision support databases.

• Ensured creative and analytical approach to minimize and possibly eliminate any compromise of

customer or company information

• Developed same project for Centene and HealthNet

NESS Technologies, RTP, NC Consultant Nov/06 – June/07

Responsibilities:

• Designed, implemented and supported data warehousing

• Implemented business requirements

• Developed reports to ensure accuracy of data

• Provided a framework, which easily aggregated, filtered, joined and transformed data as needed

Environment: DB2, WebSphere, InfoShare, DTS/SSIS, Unix

TekMark Global Solutions Consultant Jan/06 – Oct/06

Client – Lucent Technologies

Responsibilities:

• Participated in Design and high level modeling of data warehouse and data mart objects,

related to the Business Intelligence

• Translated client user requirements into data flows and designed ETL processes and

architecture

• Business Intelligence Report design, development with SSIS, SSAS and SSRS and supported

development.

Nokia Mobile Phones Tampere, Finland System Engineer Feb/02 – Dec/05

Responsibilities:

• Developed requirements for data

mapping and data loading processes

• Executed data mapping/loading requirements and reconcilement of such activities using

DTS/SSIS

• Analyzed, documented, developed, tested and implemented changes as necessary

• Assisted with the development of the data model(s) for the data repository guided by the data

warehouse architect

• Gathered system and platform requirement specifications for S60 product

• Maintained active contact with internal/external suppliers and participated in application

requirement specification work

Professional Affiliations:

• British Computer Society – Member – Dec 2005

Contact this candidate