Data Warehouse

Sandy Acharya

Email: ************@*****.***

Phone: 919-***-****

Summary:

• Over 4+ years of IT experience in design, development and implementation of data

i ntegration and O racle development applications.

• More than 3+ years of experience in Extraction, Transformation and Loading (ETL)

p rocess using IBM I nfosphere DataStage 8.1, Ascential DataStage 7.5

(Administrator, Director, Manager, Designer ), P arallel Extender, I nformation

A nalyzer and development of Data Warehouse/Data mart Applications.

• Strong understanding of the principles of Data Warehouse functions including the use of

F act Tables, Dimension Tables on Star Schema modeling, and Snowflake Schema

modeling .

• Excellent knowledge of studying the data dependencies using metadata of DataStage

and preparing job sequences for the existing jobs to facilitate scheduling of multiple

jobs/Production support/Testing of jobs.

• Experience in DataStage Administrator to create/modify/delete projects and cleanup

p rojects.

• St rong k now ledge i n schedu l i ng D a t aS tage j obs using A u tosys, T i vol i, &

C on t rol-M .

• Excellent experience in t roubleshooting of DataStage jobs and addressing production

issues like performance tuning and enhancements.

• H ighly involved on D isaste r Recove r y ( D R ) test for various applications like C S I,

I T A, P H O N I E X, SC M, and I N T E L L I M A T C H M A TC H/ T RAC E.

• Communicate with Business Users, vender & L4 according to the criticality of the

remedy ticket and provide the solution.

• Prepared SOP’s and functional specification documents in various project.

• Prof iciency in da ta wa rehousing techn iques for T r a nsfo r m i ng, Slowly

C hanging D i mension phenomenon and Su r roga te key assignmen t.

• Very good experience in setup parallel and user defined Project specific E nvironmental

Variables a t Project level and using them as job parameters at job level.

• Works closely and effectively with all levels of management to satisfy

p roject/productivity requirements.

• Develop processes for cleansing, t ransforming, extracting, integrating and loading

d ata w ith use of Datastage.

• Installed and configured IBM Infosphere Information server 8.1.

• Self-motivated, customer-focused, teamwork oriented and strategically focused

experienced professional with strong analytical, pattern detection and problem solving

abilities.

TECHN ICAL SKILLS:

ETL Tools IBM Information Server V8.1, Ascential Datastage 7.5

Operating Systems Unix, Windows XP, Windows 95/98/2000, Solaris, BM-AIX,HP-UX

Sandy Acharya

Email: ************@*****.***

Phone: 919-***-****

Scheduling Tools Tivoli, Autosys, Control-M

Languages C, C++, PL/SQL, UN IX Shell Programming

D atabases O racle 11g/10g/9i, DB2 UDB 8/9, DB2, ODBC, SQL Server, Edit

P lus

Packages MS Office 2010/ 2007/ 2003 – Word, Excel, Access, PowerPoint, MS

V isual Studio 2010/ 2008, MS Visual Basic 6.0

Education: Bachelor in Business Science

G raduate Year: 2005 from T r ibhuvan University, Nepal

PROFESSIONAL EXPER IENCE:

STATESTREET CORPORAT ION, BOSTON, MA

05/12 to Present

ETL Developer/ ETL Tester

State Street is one of the largest financial broker companies on North region which handles

a ll the t ransection for European country and some Asia pacific country as well. Their

t ransection data will be store on data ware house form various source. The project was

related to production support as well as the maintenance support based on Remedy based

application.

Responsibilities:

• Responsible for performing data conversion design and for data conversion

development

• Accept the ownership of the remedy t icket and resolve the issue based on the

c riticality of the t icket.

• Debug the issue d uring the failure of Autosys job and fix the issue.

• Developed new parallel as well as used existing job to extract data from dataware

house by using various stages like Join, Merge, T ransformer, lookup, Remove

D uplicate, Row Generator, Column Generator stages etc.

• Used the DataStage Designer to develop processes for extracting, cleansing,

t ransforming, integrating and loading data into data warehouse.

• Created D esign Documents and Unit Test Cases w ith test Results Documents.

• Worked on U nit Testing, developing Test Case as per as the requirements.

• Good experience working with A utosys for Scheduling Daily, Weekely and

M onthly Autosys jobs.

• Worked with DBA team for better production support and performance.

• Based on the Users request developed Reports by running the Query and provide

t hem on the priority.

• Worked with I B M support to fix various bugs by applying the patches in the

DataStage Clients machines.

• Raised the firecall request through UN IX and Update the queries in different DB

based on user’s request.

• Communicate with different groups if the server went down, if job failed during the

schedule time and inform business same and prepared the incident report for

business with the root cause of the issue.

Environment: Info sphere Dtastage 8.1, 7.5, PL/SQL, Toad, Oracle 11g, Window 2000,

Sandy Acharya

Email: ************@*****.***

Phone: 919-***-****

Remedy User 7.1

P ROFESSIONAL EXPER IENCE:

F I F T H T H I R D BANK, CINC I NNAT I, OH

11/11 - 04/12

DATASTAGE DEVELOPER, ETL TESTER

Fifth Third Bancorp is a diversified financial services company with $111 billion in assets,

operates 18 affiliates with 1,232 full-service Banking Centers, including 106 Bank Mar t

locations open seven days a week inside select grocery stores and 2,213 ATMs in different

location. The company engages in five main lending and banking practices: B ranch

Banking, Consumer lending, Commercial Banking, I nvestment Advisors, and Fifth Third

P rocessing Solutions. This project involved testing of the applications involved in retrieving

and updating data for the database.

Responsibilities:

• Developed DataStage server and parallel jobs to extract, t ransform and load data

i nto data Warehouse from various sources like r elational databases (DB2), flat

f iles etc.

• Designed several parallel jobs using Sequential File, Dataset, Join, Merge,

L ookup, Change Apply, Change data Capture(CDC), Remove duplicates,

F unnel, Filter, Copy, Column Generator, Peek, Modify, Surrogate Key,

Aggregator, T ransformer, Row Generator stages.

• Created source table definitions in the DataStage Repository by studying the data

sources.

• Created t est plan documents as per as the business requirements.

• Participated in the meeting with the Business Users and Support Analyst for getting

t he more information and understanding of the Applications

• Optimized job performance by carrying out Performance Tuning Methods.

• Involved in scheduling jobs using T ivoli and DataStage Di rector .

• Involved in U nit Testing, System Testing, I n tegration and Performance

T esting of the jobs.

Environment: DataStage 8.1 PX, Windows XP, TOAD, UNIX-AIX, DB2, IBM DATASTUDIO, AQT, SQL,

PL/SQL, TIVOLI

Q uality Oil Company, Winston - Salem, NC

07/2009-10/2011

D ata stage Developer/ ETL Tester

R esponsibilities:

I t is one of the leading o il companies in northern part of US w ho provides 24/7 service

i n different fields like hotel, convenient stores and heating & cooling for the apartment

complex. The project was related to prepare different data mar t for different services and

build the data warehouse with IB M team.

• Developing test plan, designing the test steps, wri ting test cases and running test

scripts using Quality Center.

• Identified and documented data sources and t ransformation rules required to

populate and maintain data warehouse. Developed Data Stage parallel jobs to load

data from sequential files and f lat files

Sandy Acharya

Email: ************@*****.***

Phone: 919-***-****

• Designed job sequences to automate the process and document all the job

dependencies, predecessor jobs, and frequencies to help the production support

people better understand the job runs.

• Complete Individual participation in documenting Documentation Inspection (DI) in

order to present the result to the Business In telligence department.

• Designed and developed parallel jobs for extracting, cleansing, and t ransforming

data from dataware house.

• Worked with various Parallel stage and Mainframe stages like look-up, Join, Merge,

Sort, Copy, Aggregator, Transformer ect.

• Worked individual on the Import and export repositories across projects using Data

S tage Manager.

• Used the Data Stage Director and its run-t ime engine to schedule and run the jobs,

testing and debugging its components and monitoring the resulting executable

versions on scheduled basis.

• Created job sequences to control the f low of jobs.

• Performed Unit and In tegration testing and validated the test cases by comparing

t he actual results with expected results.

• Resolved data issues during the testing processes and reloaded the data with all the

necessary modifications.

• Performed when performance tuning necessary on the parallel job

Environments: I BM Info Sphere Information Server 8.1(Data Stage), Mercury Quality

Center 9.2,Oracle 10g,ODBC, Flat files, SQL, Toad, Autosys, Unix.

Corbett Accel Healthcare Group, New York, NY

04/2010 – 03/2011

D atastage Developer/ ETL TESTER

The Corbett Accel Healthcare Group provides marketing, advertising, promotions and

p ublic relations services to clients in the health care industry. The data warehouse project

was responsible for providing a broad portfolio of innovative and effective decision support

systems to the business uses.

Responsibili ties:

• Involved in creating ER and dimensional relational data models using data modeling

tool.

• Developed datastage ETL jobs.

• Wrote individual functions for code reuse.

• Responsible for documentation of work f lows of all the datastage jobs.

• Developed secondary indexed hash files.

• Involved in unit, regression, performance and integration testing of datastage jobs.

• Wrote shell scripts to create load ready files from external sources.

• Wrote various Autosys JI L scripts to activate the UN IX scripts.

• Developed shell scripts to automate file manipulation and data loading procedures.

• Participated in weekly status meetings.

• Responsible for t roubleshooting various production systems and document

resolutions.

Environment: Ascential Datastage7.0/Parallel Extender, DB2 UDB, Oracle 9i, UNIX, SQL, PL/SQL

Sandy Acharya

Email: ************@*****.***

Phone: 919-***-****

Om Hospital & Research Center (P.) Ltd, Kathmandu, Nepal

03/2009-02/20010

D atastage developer

I t is one of the leading healthcare companies in Nepal which has around 20 branches

t hroughout the count ry. Om Hospital & Research center is providing customer-friendly

services through its branch networks whose main aim is to help Nepalese citizens live

healthy. The company deals with the products and services that include individual medical,

small business health insurance, short term health insurance products, as well as non-

insurance products and customer choice product such as Health Saving Accounts and

Health Reimbursement Arrangements.

R esponsibilities:

• Involved in status meetings and interacted with the business analyst to get the business

r ules.

• Imported M eta data f rom various t ransactional data sources residing on O racle 10g,

O DBC and Flat files.

• Used Information Analyzer for Column Analysis, P rimary Key Analysis and

Foreign Key Analysis.

• Identified and documented the slowly changing dimensions.

• Designed Parallel jobs using various stages like join, merge, remove duplicates,

f ilter, dataset, lookup file set, modify, aggregator and funnel stages.

• Converted complex job designs to different job segments and executed through job

sequencer for better performance and easy maintenance.

• Enhanced the r eusability of the jobs by making and deploying shared containers

• Imported and exported repositories across D ataStage p rojects.

• Extensively used Autosys for automated scheduling of U N IX shell script jobs on daily,

weekly monthly basis with proper dependencies.

• Used O racle PL/SQL for wri ting stored procedures, packages for extracting the data.

• Involved in creating technical documentation for source to target mapping procedures to

facilitate better understanding of the process and incorporate changes as and when

necessary.

• Worked on t roubleshooting, performance tuning and performance monitoring for

enhancement of D ataStage jobs.

E nvironment:

IBM Information Server D ataStage 7.5, Oracle 10g, TOAD 8.6, Autosys, Windows 2000,

U N IX Shell Scripting, SQL*Loader, Information Analyzer.

Contact this candidate