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.