Post Job Free
Sign in

Data Manager

Location:
Alpharetta, GA, 30004
Posted:
April 24, 2013

Contact this candidate

Resume:

Charan

Phone : 859-***-****

E-mail: ******.*****@*****.***

PROFESSIONAL SUMMARY

• Over 2 plus years of experience in design, modeling, analysis, development, testing and

implementation of data warehouse/data mart applications, web applications and client/server

applications on windows and Unix platforms.

• Extensive experience in using the data warehousing tool, Data stage 8.5/8.0.1/7.5.x (manager,

designer, director and administrator) extensive experience with Data stage parallel extender.

• Knowledge of all phases in software development life cycle(sdlc).

• Extensively worked on parallel and server jobs using various stages like join, lookup, lookup file

set, change capture, filter, funnel, copy, column generator, peek, dataset, sequential file, oracle

enterprise, DB2/UDB, merge, transformer, aggregator, remove duplicates stages.

• Excellent knowledge in extraction, cleansing and modification of data from/to various data

sources, flat files and comma delimited files (.csv).

• Strong knowledge in OLTP/OLAP systems, normalized (OLTP), de-normalized (DW and ODS)

models, dimensional strategies, surrogate key, star schema, snowflake schema.

• Good knowledge of dimensional modeling (star and snowflake schema) for data warehouses and

data marts.

• Experience in integration of various data sources like DB2, Oracle into staging area.

• Used stage variables, constraints in Data stage jobs.

• Efficient in all phases of the development life cycle, coherent with data cleansing, data

conversion, performance tuning and system testing.

• Good working knowledge in Unix environment, java, java script, html, agile methodology.

• Having good knowledge on Cognos reporting tool.

• Knowledge transfer, mentor & training to existing/new team members 24 / 7 rotational on call

production support of ETL projects.

• Strong analytical and technical exposure. Working effectively as a team member.

• Excellent written and communication skills and ability to work independently in a time sensitive

environment.

TECHNICAL SKILLS

ETL Tools IBM Web Sphere Data Stage 8.1.x/80.x / 7.x/6(Manager,

Designer, Director, Administrator),Kettle

Data Modeling Erwin 4.1/3.5, Designer2000 and MS Visio

Languages C, C++, SQL, PL/SQL and Visual Basic

Web Development Java Script, XML, HTML and DHTML

Application Servers IBM Web sphere Application Server 5.0/4.0/3.5

Operating Systems UNIX, AIX, Windows 2000/xp/2003 and Linux

Database Tools SQL Plus, and TOAD, PL/SQL

Databases DB2 9.x/8.x/7.1, Oracle 10g/9i/8i/11g,2005/08

EDUCATION & PROFESSIONAL DEVELOPMENT

MASTERS OF COMPUTER ENGINEERING AUG 2010 – DEC 2011

International Technological University, San Jose, California, USA

MASTERS OF COMPUTER APPLICATION SEP 2006- MAY 2009

NIET, JNT University, Andhra Pradesh, INDIA

BACHELOR OF SCIENCE (Maths, Electronics and Computer Science) JUN2003- APR2006

Nizam College, Basheerbagh, Osmania University, Andhra Pradesh, INDIA

INTERMEDIATE APR 2001- MAR 2003

Ideal Junior College, Dilsuk Nagar, Hyderabad, Andhra Pradesh, INDIA

SSC MAR 2001

Siddhartha High School, Vanasthalipuram, Hyderabad, Andhra Pradesh, INDIA

WORK EXPERIENCE

Client : McKesson Corporation, Atlanta Aug 2011 to Till Date

Title : BPR Data Conversation Project

Role : Programmer/Analyst

Environment : Datastage8.0.1, SAP, Oracle11g, Toad11, File Zila, WinSCP5.0, Unix, SharePoint

Project Description:

McKesson is a pharmaceutical and healthcare company which maintains the data warehouse for the

hospitals that includes the data related to sales orders, Contracts, billing, customer, cost center related

information. This project is involved in the migration of the date from the legacy systems HP, PeopleSoft,

SAP to SAP. Converting the Data from Legacy systems and providing hands-off to the SAP team to load

properly into SAP.

Responsibilities:

• Understanding the Technical specifications and Mapping techs provided by the Client

• Participated in all phases including Requirement Analysis, Design, Testing Support and

Documentation.

• Developed more than 50 XREF tables and updated them according to the changes requested by

the business in the data to Oracle Database.

• Closely working with the business analyst and functional team to understand the specifications

and helping them in SAP load program (LSMW).

• Involved in dividing the assignments to the offshore team and giving 24/7 support to meet the

deadlines of the tasks and taking the status updates daily from the team to report onshore manager.

• Experience in interacting with business users to understand the requirements, problems and

ability to resolve issues as early as possible.

• Played a key role and Involved in solving the issues within the team.

• Actively involved in developing the parallel jobs and server jobs depending upon the

requirement.

• Extensively worked on various stages like Transformer, Filter, Sequential file, Join, Lookup, Sort,

Aggregator, Copy, Dataset, Merge, Oracle, Remove duplicates stages

• Extensively used the various Partitioning Methods like Hash, Entire, Auto, Same, Round Robin to

increase the job performance.

• Worked on server jobs for moving the data from the legacy system Tax ware to Vertex.

• Exported and imported the project from development to QA.

• Interacting with the DSADMIN to resolve the issues with Data stage Client.

• Performing the administrative work to unlock the job, kill the PID, installing the patches on DS

client.

• Analyzing the jobs developed by the team and guiding them to improve the performance of the

jobs.

Client : Bank of America, Atlanta Jan 2011 to July 2011

Title : Health Logic Systems Data warehouse

Role : Data stage Developer

Environment : Data stage 8.0.1, Oracle 9i, and windows 2000, IBM AIX, Autosys

Project Description:

This project is involved in the development of data warehouse for Health Logic Systems. The data

coming from the different Insurance companies is maintained by the Health Logic Systems and create the

XML file format which is later pulled into the Oracle Database. They needed a data warehouse so that

they could maintain historical data and central location for integration and analyze business in different

locations, according profit areas, which could serve a purpose of a decision support system for decision

makers.

Responsibilities:

• Understanding the Technical specifications and Mapping techs provided by the Client

• Participated in all phases including Requirement Analysis, Design, Testing Support and

Documentation.

• Work closely with users, business analysts, systems analysts, and application developers to define

and resolve information requirements, data flow and data content/quality issues

• Transform business requirements into environment specific rule-set and data validation designs

• Design and develop ETL jobs, scheduling and monitoring consistently across the project.

• Performed Import and Export of Data Stage components and table definitions

• Provided technical solutions for the Process requests raised by Data team to fix the issues in the

existing system.

• Designed the mappings between sources (external files and databases) to operational staging

targets.

• Used the Data Stage Designer to develop jobs for extracting, cleansing, transforming, integrating,

and loading data into data warehouse database.

• Worked on extensively on migration from 7.5.2 to 8.1.0 version of IBM Info server(enterprise

data stage).

• Extensively worked on various stages like ODBC, Transformer, Filter, Sequential file, Join,

Lookup, Lookup file set, Sort, Aggregator, Copy, Dataset, Merge, Oracle, Remove duplicates stages.

• Extensively used the various Partitioning Methods like Hash, Entire, Auto, Same, Round Robin to

increase the job performance. .

• Provide staging solutions for Data Validation techniques and Cleansing applications for different

source systems.

• Designed, developed and Unit tested using Data Stage for Extraction, Transformation and

Loading of data from source to target.

• Expert in unit testing, integration testing, implementation, maintenance and performance tuning.



Contact this candidate