Datastage Developer

Srinivas Cell#512-***-****

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

Professional Profile:

Over 13 years of IT and 9+ years of DataStage Experience in analysis, design, development, implementation and troubleshooting.

Proficient in all phases of Software Development Life Cycle (SDLC) including requirements Gathering, data conversion, system implementation, acceptance testing and maintenance.

Extensively used DataStage tools like Designer, Director and Administrator

Experience in developing jobs, sequences by using Join, Merge, Funnel, Filter…Etc.

Worked with different source systems like Flat Files, XML and Databases.

Developed Test Scripts, Test Cases to perform Unit testing.

Knowledge of reporting tools like Cognos, Power BI.

Experienced on Informatica Tools.

Experienced on ETL Administration, performance tuning and troubleshooting.

Experienced with Marketing or Campaign technology (e.g., Unica, Adobe Campaign)

Experienced executing using agile frameworks.

Excellent communication skills, good organizational skills, outgoing personality, self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly and learn fast.

Worked directly with non-IT business analysts throughout the development cycle and provided production support.

Worked on Service Now tool for service request management.

Technical Skills

Operating Systems : Windows 95/98/NT/2000/Xp, Dos, UNIX, Linux

ETL Tools : DataStage V9x&11x, Informatica V8x.

RDBMS : Oracle 7.3/8i/9i/10g/11g, Ms Access 7.0/2000, SQL Server 2003/2000, DB2, Netezza

Languages : UNIX Shell, SQL, PL/SQL, XML, Python, Java

Software : SQL Loader, Service Now, Q-Test, Toad 7.6/8.0, Service Now, WinSCP, SQL Developer, Kafka.

Scheduling Tools : Tivoli, Crontab, Control-M

Reporting Tools : Cognos, Power BI

Education:

Bachelor’s in Computer Science & Engineering.

Professional Experience:

USAA, San Antonio, TX Aug’20 – Present

Sr. DataStage Consultant

USAA, a diversified financial services group of companies, is among the leading providers of insurance, investing and banking solutions to members of the U.S. military and veterans who have honorably served and their families.

As a Senior DataStage consultant, working on Marketing Operational sector. Involved in development, maintenance, production support and playing key role on the day-to-day operational activities. Working under Data Movement team for a Unica Campaign migration to Adobe project.

Responsibilities:

Involved in PI planning and analysis of feature as part Agile methodology.

Worked on sprints and creation of user stories.

Worked with Business Analyst on source to target map analysis between Unica and Adobe campaign database systems.

Created ETL design and data mapping documents for different data elements like Household, Product, Customer...Etc...

Developed Datastage jobs and sequences between Unica legacy systems to Adobe database XDC.

Updated param, config and sql files by adding entries for data elements on Linux.

Migrated code to test and prod environments through GIT LAB and UCD (Urban Code Development) tool.

Created and executed test cases in Q-Test under Test environment and documented test results.

Developed Control -M cycle for job schedule.

Worked on Service now tool for all service requests.

Provided production support based on on-call schedule.

Environment:

DataStage 11x, Oracle, DB2, UNIX, Control-M, Java, Service Now, GIT LAB, UCD, Q-Test, Kafka, Jira

Epsilon, Irving, TX Sep’12 – Jul’20

Sr. DataStage Developer

Epsilon is a leading marketing technology services business with the largest independent multichannel agency with the deepest supply of marketing data. This cohesive connection creates a new kind of company, where a unique blend of strategy, analytics, marketing creativity, data and robust technology platforms provide brands the most comprehensive and effective direct access to customers at virtually every brand touch point in the virtual and physical worlds. As a senior DataStage developer, working on DELL, P&G and RJRT accounts. Involved in development, maintenance, production support and playing key role on the day-to-day operational activities.

Responsibilities:

Working with Business System Analysts on requirements.

Using Datastage tools like designer, monitor and administrator for development.

Processing campaign files through Datastage by developing various jobs and sequences.

Extracting, transforming and loading data on ORACLE with Datastage.

Created shell scripts to load data into Netezza and automate datastage processes.

Scheduling shell scripts through CRONTAB

Supporting day-to-day operational requests from P&G, RJRT and DELL teams.

Involved in HARMONY migration project for Dell.

Created Power BI reports for different projects.

Environment:

DataStage 9x, Oracle, Netezza, UNIX, Crontab, Win SQL, Toad, Flat files, XML, Power BI

HMS, Irving, TX Mar’12 – Aug’12

DataStage Developer

HMS is the nation’s leader in cost containment solutions for government-funded, commercial, and private entities. Focused exclusively on the healthcare industry since founding, HMS helps clients ensure that healthcare claims are paid correctly and by the responsible party, and that those enrolled to receive program benefits meet qualifying criteria. As part of REFORMAT team, involved in multiple projects for different clients.

Responsibilities:

Understanding the client Requirements, Analysis of mapping document

Followed standard coding techniques and assisted in moving towards a framework model and abstraction of data access to reduce development time and cost.

Used transformations like Aggregator, Joiner, Lookup, Router, Merge, and Filter...Etc. to develop complex jobs.

Involved in code review and created test cases for different business scenarios.

Created harvest packages to migrate code to production.

Created and executed the script to run jobs based on crontab schedule.

Provided production support.

Worked as part of a development team to meet development and implementation deadlines.

Environment:

DataStage 8x, PL/SQL, Linux, Windows XP, Harvest, Toad

Super Media, Dallas, TX Nov’11 – Feb’12

DataStage Developer

SuperMedia are a leading provider of internet advertising, yellow page directories in 34 states, and direct mail products in select markets. Its core business processes revolve around the sale of advertising and the processes designed to identify new customers and fulfill orders. These processes include sales, yellow pages production, printing and distribution of yellow page advertising via telephone directories, internet advertising via superpages.com, and solutions magazines. The project is looking forward for the complete implementation of its two products VAST and VISION.

Responsibilities:

Involved in Understanding client Requirements, Analysis of Functional specification and Technical specification preparation.

Prepared Source to Target mapping documents.

Developed jobs to extract data from multiple sources, transform data, and then loaded to the Salesforce databases.

Used transformations like Aggregator, Join, Lookup, Filter, etc. to develop jobs.

Closely worked with the SalesForce Consultant to understand the requirements at the SalesForce end.

Loading data into lookup tables from heterogeneous sources.

Involved in identifying bugs in existing jobs by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing jobs for improving the performance.

Involved in Performance tuning of jobs.

Worked directly with non-IT business analysts throughout the development cycle and provide production support for ETL.

Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.

Environment:

DataStage 8x, PL/SQL, Oracle 10g, MS-Office, UNIX, Windows XP, SalesForce

Great West HealthCare, Denver, CO Sep’07 - Oct’11

Informatica Developer

Great West is a national employee benefits provider with expertise in creative health care management solutions. They are also a leading provider of retirement savings plans. Great West offers traditional group health plans and other benefits as well as consumer-driven health plans that are supported by nationally recognized disease management program. Great West provides a variety of employer-sponsored retirement savings plans and private-label record keeping and administrative services for other providers of defined contribution plans. Great West also provides individual annuities and life insurance policies through our Individual Markets group.

Responsibilities:

Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

Used transformations like Connected and Unconnected Lookups, Aggregator, Joiner, Update, Router and Sequence generator.

Worked with various Informatica Power Center tools –Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, Transformations.

Created reusable transformations and Mapplets and used them in complex mappings.

Fine-tuned Transformations and mappings for better performance.

Developed and scheduled Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored the results in Workflow monitor.

Created workflows and worklets for designed mappings.

Used workflow Manager for Creating, Validating, Testing and Running the sequential

And concurrent Batches and Sessions and scheduled them to run at a specified time.

Did performance tuning at source, transformation, target, and workflow levels?

Used typed II Slowly Changing Dimension for Version Control.

Used reverse engineering in Erwin 3.5 to understand the existing data model of the data warehouse.

Used the Mapping Debugger to debug mappings in the Mapping Designer.

Environment:

Informatica Power Center 8.6, Workflow Manager, Workflow Monitor, PL/SQL, Oracle 9i.

Contact this candidate