SUMMARY:

Over 7 years of experience as an ETL developer/analyst using ETL tools such as Ab Initio, Datastage. Currently working on project for Netezza to Postgres/Ab Initio migration, was onsite project lead for a fresh development project involving Hadoop and Ab Initio integration, Handled both support and development as part of various projects. Responsible for getting requirements from clients, business analysts, third party systems; coordinating with offshore team for design, development and testing; coordinating with both internal(client) and external(third party) teams for resolving support issues

TECHNOLOGY SKILLS:

• Ab Initio GDE v1.10 through v3, EME, Conduct It, PDL, Technical Repository Management Console(TRMC)
• IBM information Server v8(Datastage)
• Oracle v9 through v11
• Shell scripting
• Solaris Unix v5.9, v5.10
• PL/SQL developer, Oracle SQL Developer, Oracle SQL Developer Data Modeler, Toad, Putty, WinSCP, DbVisualizer, Textpad, CVS
• Ab Initio Continuous Flows, BRE(Business Rules Environment), ACE(Application Configuration Environment)
• Teradata
• Netezza
• Ab Initio GDE v1.10 through v3,
• Join, Rollup, Scan, Normalize
• Partitioning/Departitioning
• Sort, Dedup sort
• Input/Output files datasets
• Read/Write Excel, multiple files, SFTP
• Lookups, multifiles
• EME, TRMC(Technical Repository Management Console)
• Check in / Check out
• Create/Modify projects
• Tagging
• Promotion/ Save file creation
• Locking
• Conduct It
• Plans, Subplans, Looping
• Parameter passing using dynamic parameters
• Control flow using conditional tasks and PDL
• Continuous Flows
• Reading/Writing to queues
• Create Ab Initio Queues
• Continuous Rollup/Join
• Define computepoints and checkpoints for non - continuous sources such as files
• Hadoop integration with Cloudera CDH v5
• IBM Information Server(Datastage) v8
• Datastage Designer
• Various Stages such as datasets, Join, Lookup, Merge, Funnel, Transformer, Aggregator
• Importing/Exporting metadata into/out-of repository
• Datasets, FileSets
• Job Sequences
• Datastage Director
• Monitoring jobs/sequences
• Starting/Stopping/Resetting jobs/sequences
• Solaris Unix v5.9, v5.10, AIX v6, Basic Shell Scripting,
• Basic SQL queries, hints, parallel load, unload using Ab Initio
• Basic SQL parallel load, unload using Ab Initio, external tables.

PROFESSIONAL EXPERIENCE:

Ab Initio Developer

Confidential

Responsibilities:

• Production support for existing Ab Initio applications
• Migrating from Netezza to Postgres

Technology Stack:

• Ab Initio GDE v3.2.2, Ab Initio GDE v3.0.2
• AutoSys Scheduler
• Oracle 11g, SQL developer, Netezza
• Solaris
• Git
• Bamboo for Continuous Integration
• Postgres v.95

Ab Initio Lead Developer/Onsite project lead

Confidential

Responsibilities:

• ETL Design and development responsibilities
• Design the ETL process for on-ramping the data to the data hub and off-ramping it to the data warehouse
• Design review for new facts and Dimensions for the warehouse with data modeler and business analysts
• Discuss and refine design for HDFS setup with Hadoop COE
• Coordinate and discuss with Ab Initio COE for new project setup
• Code review sessions with Ab Initio COE to ensure we adhere to existing enterprise standards
• Discuss and refine design for ETL process with offshore team
• Build ETL process with the offshore team
• Project Management responsibilities
• Setup required accesses for offshore developers(Ab Initio, Hadoop etc.)
• Estimate the time and resources required for this initiative
• Coordinate with the offshore team for build and unit test activities
• Coordinate with QC team for testing, environment setup
• Coordinate with PM to identify whether we are meeting deadlines or any risks to the project
• Coordinate with Enterprise scheduling for setup of new application for the project
• Coordinate with production deployment team

Technology Stack:

• Ab Initio GDE v3.2.2, Enterprise Meta Environment(EME),
• Tivoli Workload Scheduler/Balancer
• Oracle 11g, SQL developer
• Linux
• Cloudera Hadoop CDH v5

Ab Initio Lead Developer

Confidential

Responsibilities:

• Handling support issues
• Coordinating with offshore teams for the same
• Defining support procedures for new issues
• Coordinating with external and internal teams for resolution of issues Enhancement
• Getting requirements from business analysts/end users
• Design, development, testing, deployment and support in conjunction with offshore team
• Test data setup
• Requirements, design, development for undergoing enhancements
• Conversion of existing framework to Ab Initio Conduct> IT

Technology Stack:

• Ab Initio GDE v3.0.2, Ab Initio Technical Repository Management Console, Ab Initio Conduct IT, Enterprise Meta Environment(EME),
• Oracle 11g, PL/SQL developer
• Enterprise Scheduler(ESP)
• Solaris UNIX 5.

Ab Initio Developer

Confidential

Responsibilities:

• Handling support issues
• Coordinating with offshore teams for the same
• Defining support procedures for new issues
• Coordinating with external and internal teams for resolution of issues
• Getting requirements from business analysts/end users
• Design, development, testing, deployment and support in conjunction with offshore team
• Test data setup
• Requirements, design, development for undergoing enhancements
• Conversion of existing framework to Ab Initio Conduct> IT

Technology Stack:

• Ab Initio GDE v3.0.2, Ab Initio Technical Repository Management Console, Ab Initio Conduct IT, Enterprise Meta Environment(EME),
• Oracle 11g, PL/SQL developer
• Enterprise Scheduler(ESP)
• Solaris UNIX 5.10

Ab Initio Developer

Confidential

Responsibilities:

• Handling support issues
• Coordinating with onshore teams for the same
• Defining support procedures for new issues
• Getting requirements from onshore teams
• Design, development, testing, deployment and support in conjunction with onshore team
• Test data setup
• Requirements, design, development for undergoing enhancements
• Ab Initio upgrade from v1.10 to v1.14

Technology Stack:

• Ab Initio GDE 2.14, Ab Initio Technical Repository Management Console(TRMC), Enterprise Meta Environment(EME),
• Oracle 10g, PL/SQL developer
• Enterprise Scheduler(ESP)
• Solaris UNIX 5.9
• CVS

Datastage Developer

Confidential

Technology Stack:

• IBM Information Server (Datastage) v8.0
• Oracle 10g, PL/SQL developer
• AIX UNIX v5

Responsibilities:

• Getting requirements from onshore teams
• Design, development, testing, deployment in conjunction with onshore team
• Test data setup