PROFESSIONAL SUMMARY:

• Having 10+ years of experience in all phases of software development life cycle with Data Warehousing ETL tool Ab Initio.
• Extensive experience in Designing, Developing, Implementing and Testing ETL Applications in the Domain of Banking.
• Well versed with Teradata, Oracle and DB2.
• Good hands on working experience on Express IT and Control Center
• Worked with Ab Initio advanced concepts such as MFS (Multi File System), MQ, Web services (SOAP), CURL and WGET.
• Experience in accessing data with Ab initio from a relational database such as Teradata and DB2.
• Worked with scheduling tools such as Tivoli work load and Ab Initio Operational Console.
• Good working knowledge on parallelism concepts.
• Worked on various components such as Partition, De - Partition, Transform (Rollup, Normalize and De-Normalize), Sort and lookups.
• Exposure to multiple operating systems such as Unix AIX, Solaris and LINUX Red hat.
• Good experience in UNIX and developed multiple scripts using UNIX Shell Scripting.
• Experience in NDM scripting in UNIX.
• Lead a team in onsite-offshore model.
• Working with relative ease with different working strategies like Agile, Scrum and Waterfall methodologies.
• Experience in writing Unit and User acceptance test cases and automating QA reports.
• Lead a team at Citi, Mexico. Successfully implemented various critical projects error-free and got several client appreciations.
• Integrated Ab-initio with Hadoop to drop Ab initio processed files on Hadoop platform.
• Having Knowledge of Big Data technologies like HIVE, Spark, Python and Scala.

SKILL:

ETL Tools: Ab initio, Express IT, ACE/BRE

DBMS/ RDBMS: Teradata, Db2, Oracle

Scheduling tools: TWS 8.4/8.5. Ab inito - Operational Console, Control Center

Operation System: Windows 98/ XP/ NT/ 2003, UNIX (SOLARIS 5.10), LINUX (REDHAT)

Languages: UNIX Shell Scripting (Korn Shell)

PROFESSIONAL WORK EXPERIENCE:

Software Developer

Confidential

Responsibilities:

• Initial requirement analysis and Impact analysis.
• Development of Ab initio Graphs, UNIX wrapper script for source file handling.
• Developing and maintaining database and file system Space utilization scripts.
• Coordination with System Testing team.
• Involved in post implementation production support.

Tools Used: Express IT, UNIX, Oracle, Ab initio and Control Centre

Confidential

Responsibilities:

• Developing Ab initio graphs and plans using different transformations based on business requirements.
• Connecting core systems with SOAP web services.
• Building op console job definitions.
• Initial requirement analysis and Impact analysis.
• Development of UNIX Ksh Scripts.
• Coordination with System Testing team.
• Involved in post implementation production support.
• Developing and maintaining database and file system Space utilization scripts.
• Monitoring and reporting daily weekly and monthly batch jobs.
• Providing l3 level fixes in case of job ABEND by code break.
• Reviewing new implementation DLD, HLD and providing required feedback.
• Reviewing newly developed schedule and find out its concurrency with existing if any.
• Automate the migration process by writing the shell scripts.

Tools Used: Ab Initio, UNIX, DB2, SOAP UI and Ab initio OP console

Confidential

Responsibilities:

• Developing Ab initio graphs using different transformations based on business requirements
• Development of initial setup scripts in Korn shell.
• Initial requirement analysis and Impact analysis.
• Development of UNIX Ksh Scripts
• Creation of graphs using different types of components.
• Coordination with System Testing team.
• Involved in post implementation production support.
• Developing and maintaining database and file system Space utilization scripts
• Monitoring and reporting daily weekly and monthly batch jobs.
• Providing l3 level fixes in case of job ABEND by code break.
• Reviewing new implementation DLD HLD and providing required feedback.
• Reviewing newly developed schedule and find out its concurrency with existing if any.
• Automate the migration process by writing the shell scripts.
• Conducting weekly team meetings and improving team skill by maintain play book and run book documents.

Tools Used: Ab Initio, UNIX, Teradata, TWS 8.4/8.5 and Autosys.

Confidential

Responsibilities:

• Developing Ab initio graphs using different transformations based on business requirements
• Development of initial setup scripts in Korn shell.
• Initial requirement analysis and Impact analysis.
• Development of UNIX Ksh Scripts
• Creation of graphs using different types of components.
• Coordination with System Testing team.
• Involved in post implementation production support.
• Developing Ab Initio graphs using different transformations based on business requirements
• Creation of Automated scripts for setting up the Maestro scheduling.
• Development of pre-process and post-process utilities in Korn shell.
• Development of NDM scripts to push/pull files from different evers/environments.
• Development of UNIX shell scripts for automating some of the manual activities

Tools Used: Ab Initio, UNIX, Teradata and TWS 8.4/8.5.

Confidential

Responsibilities:

• To measure the customers’ willingness to engage them across the entire Confidential relationship.
• To determine optimal offers to modify the product mix or restructure terms so the customer can service all related debt going forward, offer forbearance programs.
• Treatments that stabilize all delinquent relationships.
• To measure the operational efficiency from strategies that target the entire relationship versus a single product strategy.
• Developing Ab Initio graphs using different transformations based on business requirements
• Creation of Automated scripts for setting up the Maestro scheduling.
• Development of pre-process and post-process utilities in Korn shell.
• Development of NDM scripts to push/pull files from different servers/environments.
• Weekly catch-up sessions with the team members
• Development of UNIX shell scripts for automating some of the manual activities

Tools Used: Ab Initio, UNIX, Teradata and TWS 8.4/8.5.