*SHRAVYA J*
*Datastage Developer*
*PROFESSIONAL SUMMARY:*
· *Over 7+ years *of experience in design, development,
implementation and production support of business applications with Data
Warehouse/Data Mart Applications and Client/Server Applications on Windows
and Unix platforms using *ETL tool IBM Info Sphere DataStage(Enterprise
Edition, Parallel Extender) 8.7/9.1, IBM Quality Stage 8.7/9.1, Ascential
DataStage 7.5.x, Profile Stage 7.5.1. *
· Expertise in interaction withusers and functional team for
gathering the business requirements, functional specifications and
estimation of efforts.
· Extensively used ETL methodology for Data Extraction,
Transformation & Loading of ODS & EDW using Data Stage parallel jobs and
sequences.
· Involved in Data Preparation, Data Analysis, Data Cleansing, Data
Profiling and Data Modeling.
· Expertise with IBM Infosphere DataStage (Manager, Designer,
Director, Administrator and Parallel Extender).
· Involved in several phases of SDLC (Software Development Life
Cycle).
· Hands on experience on both *Waterfall model &agile process* of
Software projects.
· Good knowledge in Data Warehousing concepts with emphasis on ETL
and including Requirement, Analysis, Design, Development, Data Analysis,
Data Migration, Data Integration, Testing, Implementation, Deployment and
Support*.*
· Worked on derivations and business rules to be used by ETL for
mapping source data for the population of the warehouse and data marts
· Experienced in Data cleansing and standardizing tools BODS,
Quality Stage.
· Hands on experience in data modeling like Star schema, Snow flake
schema, and dimension table design.
· Experience in Information Analyzer, Fast-track, Metadata Workbench
and Infosphere Information Service Director.
· Hands on experience in Relational Databases Oracle 10g/9i,
Teradata.
· Experience in most of the parallel stages Lookup, Join, Merge,
Aggregator, CDC, Sort, Remove Duplicates, Funnel, Sort, Dataset, CFF and
Databases connectors likeDB2, Oracle Connector, Netezza and Also used
Pivot, XML etc and applying various partitioning techniques.
· Experience in most of the Sequence functionality like Loops,
Execute Sequencer, User Variable Activity, Exception Handler, and Wait for
file Activity etc.
· Experience in *UNIX* shell scripting.
· Experience in working with parallel extender for parallel
processing to improve job performance while working with bulk data sources
· Experience in *Debugging, Troubleshooting, Performance tuning,
Analysis & Optimization of ETL jobs.*
· Hands on experience to design the *Datawarehouse7, created ER
diagrams using Erwin*
· Excellent communication skills with highly motivated individual
and willing to adapt and take up new challenges.
*TECHNICAL SKILLS:*
Operating Systems: Windows NT/XP, Unix/Linux, Sun Solaris,
HP-UX
ETL/Middleware : Unix Shell Scripting, SQL Server, IBM
WebSphere Data stage 8.1, IBM infosphere Datastage 7.5,8.5,8.7/9.1, Profile
stage 7.5.1, IBM Quality Stage 8.7/9.1
Languages : Java, SQL, PL/SQL, UNIX Shell Script
Databases : Oracle 9i/10g/11g, DB2, Teradata,
Netezza, Microsoft SQL Server
DB Tools : TOAD, SQL* Loader
*PROFESSIONAL EXPERIENCE:*
*CLIENT: NORTHERN TRUST BANK, IL
JUL 2014 - PRESENT*
*Senior ETL/IBM Info sphere Data Stage Developer
*
*Responsibilities: *
· Interacted with business users for requirement gathering and
analyzing the scope of the project.
· Design/modify the exiting ETS
· Created the Architecture & Design of the interfaces to the
application.
· Created source-to-target mapping documents by working with
business Analyst.
· Designed and developed DataStage (9.1) jobs and UNIX scripts.
· Performed ETL coding using Datasets, Sequential file, Transformer,
Sort, Merge, Lookup, Remove duplicate stages compiled, debugged and tested.
· Used Infosphere DataStage designer tools for creating parallel
jobs and importing and exporting the jobs.
· Controlled jobs execution using sequencer, used notification
activity to send email alerts
· Played key role in design of scalable, reusable and low
maintenance ETL templates
· Involved in building Audit process , Process Registration
components s
· Created Technical design document , Migration Documents
· Creating Unit Test Plan Scenario
· Performed various performance tuning techniques.
· Coordinating with Team, Planning and scheduling activities
· Production Support and incidents handling s
*Environment**:* IBM Infosphere Data Stage9.1, UNIX, Db2, Teradata
*CLIENT: KAISER PERMANANTE, CA
JAN 2012 – JUN 2014*
*IBM Infosphere DataStage
Specialist *
*Responsibilities : *
· Interacted with business users regarding the agile methodology
requirements and back logs of the previous sprints to analyze and design
integration approach.
· Used Infosphere DataStage designer tools for creating parallel
jobs and importing and exporting the jobs.
· Worked with business owner to understand business requirements in
order to transform business requirements into effective technology
solutions.
· Performed column analysis, primary key analysis, and cross-domain
analysis using Information Analyzer.
· Used Control-M job scheduler for automating the monthly regular
run of DW cycle in both production and non-prod environments.
· Created Technical design document
· Created the data mappings and conversion logic to cleanse the data
· Worked as administrator and provided support on migration for all
non-prod and prod env’s.
· Prepared documentation on provided support.
*Environment*: IBM Infosphere DataStage v8.5, Quality Stage, Information
Analyzer, Oracle, Teradata, Control-M, UNIX, Team foundation
*CLIENT: UNITED NATIONS ICC,
NY JUN
2012 – DEC 2012*
*Sr. DataStage
Developer
*
*Responsibilities:*
· Responsible for all BP2 Interfaces which get feed from SAP to
SPODS and ODS to SVG interfaces which send data out to various downstream
system from SPODS.
· Designed and built ETL jobs to load SP ODS data model in EDW.
· Development of ETL jobs to migrate bulk volume of data
· Worked with business owner to understand business requirements in
order to transform business requirements into effective technology
solutions.
· Involved in Analysis, Development, Testing and Implementation of
complex ETL jobs like SKU, SKU CUST, Price, and Cost.
· Worked on Unix script to implement different requirements s
· Worked on issues and provided fixes based on the priority.
· Extensively worked with Job sequences using Job Activity, Email
Notification, Sequencer, Wait for File activities to control and execute
the Data stage Parallel jobs.
*Environment:* IBM Infosphere DataStage v8.5, Quality Stage, Information
Analyzer, Oracle, Teradata, Control-M, UNIX, Team foundation
*CLIENT: SEARS HOLDINGS,
IL
OCT 2010 – MAY 2012*
*DataStage
Developer
*
*Responsibilities: *
· Created the data mappings and conversion logic to cleanse the data
· Data Analysis to resolve defects with migrated data
· Performed POC in implementing DataStage instead of Pl/Sql in some
of the existing modules.
· Participated in effort estimation.
· Responsible to converting old legacy systems into one integrated
environment. Fetched the data from legacy system and cleansed the old data
and convert according to new business logic and loaded into new systems.
· Worked with Business Analyst to understand business requirements
from business owners in order to transform business requirements into
effective technology solutions.
· Perform DataStage performance tuning, maintain and support.
· Worked closely with Development and QA to clarify the requirement
issues.
*Environment:* IBM Infosphere Datastage V8.5, UNIX, SQL Developer, Oracle
11g
*CLIENT: WELLS FARGO,
CA
AUG 2008 – SEP 2010*
*DataStage Developer
*
*Responsibilities: *
· Responsible to converting old legacy systems into one integrated
environment. Fetched the data from legacy system and cleansed the old data
and convert according to new business logic and loaded into new systems.
· Production support for the applications for all sorts of trouble
shooting.
· Created the data mappings and conversion logic to cleanse the data
· Worked with Business Analyst to understand business requirements
from business owners in order to transform business requirements into
effective technology solutions.
· Implemented slowly changing dimensions on customers table using
SCD stage.
· Involved in data loading as and when required from disparate
sources to the Oracle Data warehouse and data marts using DataStage as the
ETL tool.
· Development of ETL jobs to migrate bulk volume of data.
· Involved in performance tuning of Jobs.
· Regularly did the Data Quality Checks on the source system.
· Coordinating and allocating the team for Development of jobs.
*Environment:* IBM Infosphere Datastage V8.5, UNIX, SQL Developer, Oracle
11g
*EDUCATION: *
· Bachelors of Technology , VIT – INDIA.
*----*
Thanks & Regards
*Siva Prasad ,*
*Clear Thought Solutions LLC.,*
ERP/EAI SERVICES |Consulting – Development – Staffing
*Ph: (919)-655-4576 || Fax 347-296-3797*
*Email: s...@clearthoughtsolutions.com <s...@clearthoughtsolutions.com>*
*Gtalk: shiva.us11*
*URL: *
*www.clearthoughtsolutions.com <http://www.clearthoughtsolutions.com>*
--
You received this message because you are subscribed to the Google Groups "IT
provider" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to it-provider+unsubscr...@googlegroups.com.
To post to this group, send email to it-provider@googlegroups.com.
Visit this group at https://groups.google.com/group/it-provider.
For more options, visit https://groups.google.com/d/optout.
