SUMMARY

• 8 years of IT experience in the Business Requirements analysis, Designing, Coding, Development, Testing and Implementation of business applications with IBM Websphere Data Stage 8.5 and 9.1, IBM DB2 9.1 and 11.2, HP Vertica Database & Mainframes.
• Experience in Shell, Perl, Python, Java Scripting and Programming.
• Extreme working experience with Complex SQL and Data Analysis.
• Knowledge in Hadoop Ecosystem, Hive, Impala, Sqoop, Spark, HBase, HDFS.
• Experienced as Developer/Analyst & Tech Lead in Credit Card Data warehousing and Customer Information System domains.
• Experience in Code deployment to production region via Source Code Control System/Subversion and retrofits to testing region.
• Experience in Batch Execution framework to execute the jobs seamless, monitoring and stats collection.
• Experience in Data Quality Framework for Data Consistency and integrity of application data.
• Strong organizational & presentation skills with excellent analytical& problem solving proficiency.
• Expertise in tools such as Autosys 4.5 and R11, Tectia, WinSCP, Putty, SVN, HP Vertica Database, IBM DB2 Database, SQL Workbench, TOAD, SOAP UI,Easytrive, DFSORT, NDM, FILE AID, FMDB2, ChangeMan, Endevor, PLAT, BMC, QMF, SPUFI, CA7 and HP Quality Center.
• Experience with agile development process in collaborative environment.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance tuning, System Testing, Scheduling and post go live support.
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills.

PROFESSIONAL EXPERIENCE

Confidential, Newark, Delaware

ETL Technical Lead

Responsibilities:

• Design DataStage jobs and UNIX scripts with the Vertica and DB2 interaction for loading and extracts process.
• Carrying out severity analysis of reported bugs.
• Interacted with the third party vendor and cross application team on the interfaces & producing the same to project.
• Coordinate with the client’s testing team for SIT, UAT phases.
• Performed unit testing, point - to-point testing and integration testing to conform ETL code integrity.
• Drive the build and testing activities with offshore team.
• Developed Data movement Utility using DB2 HPU for one time data movement from legacy to DB2 BLU platform.
• Developed Teradata Data Movement process to replicate the analytical data to ODP and ADP platform.
• Developed File comparison process to compare the outbound files between Legacy and BLU platform.
• Driving design discussions, code walkthrough, test results validations, prod-parallel data comparison discussions.
• Identify the technical cause and potential impact of errors and implement coding or configuration changes.
• Used DataStage stages Complex flat file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Funnel, Peek and Row Generator stages in accomplishing the ETL coding.
• Developed job sequencer with proper job dependencies, job control stages and triggers.
• Excessively used DS Director for monitoring Jobs logs to resolve issues.
• Excessively used Autosys for automation of scheduling jobs on daily, monthly basis with proper dependencies.
• Create/Update documentation for the application as code changes are applied.
• Performing code migration as part of weekly/monthly Change request and for break fix.
• Supported the production install activities and the break fix during the warranty period.
• Develop high level and detailed level technical and functional documents consisting of detailed design documentation function test specification with use case and unit test documents.
• Co-ordinate with Defect Management team and WAR Room meeting with the Bacardi Line of Business and cross vendors.

Confidential, Newark, Delaware

Lead Developer

Responsibilities:

• Design DataStage jobs and UNIX scripts with the Vertica and DB2 interaction for loading and extracts process.
• Carrying out severity analysis of reported bugs.
• Interacted with the third party vendor and cross application team on the interfaces & producing the same to project.
• Coordinate with the client’s testing team for SIT, UAT phases.
• Performed unit testing, point to point testing and integration testing to conform ETL code integrity.
• Drive the build and testing activities with offshore team.
• Driving design discussions, code walkthrough, test results validations, prod-parallel data comparison discussions.
• Identify the technical cause and potential impact of errors and implement coding or configuration changes.
• Used DataStage stages Complex flat file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Funnel, Peek and Row Generator stages in accomplishing the ETL coding.
• Developed job sequencer with proper job dependencies, job control stages and triggers.
• Excessively used DS Director for monitoring Jobs logs to resolve issues.
• Excessively used Autosys for automation of scheduling jobs on daily, monthly basis with proper dependencies.
• Create/Update documentation for the application as code changes are applied.
• Performing code migration as part of weekly/monthly Change request and for break fix.
• Supported the production install activities and the break fix during the warranty period.
• Develop high level and detailed level technical and functional documents consisting of detailed design documentation function test specification with use case and unit test documents.
• Co-ordinate with Defect Management team and WAR Room meeting with the Bacardi Line of Business and cross vendors.

Confidential

Lead Developer & Consultant

Responsibilities:

• Data Stage ETL Consultant having mainframe background, lead the design and development of consumer service hub.
• Preparation of requirement document and batch process presentation documents for developers.
• Developed Parallel jobs with DB2 connector stage, lookup stage, sort stage, transformer stage, merge stage, filter stage, duplicate stage, file stages such as Dataset stage and complex flat file stage.
• Designed Autosys scheduling scripts/jil’s to schedule Data Stage jobs and run through the Autosys Scheduler.
• Co-ordinate with cross vendor teams/QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plane.
• Update the project status to clients and with cross vendor team through weekly status calls and to onsite coordinators through daily status calls, preparing Checklists, Project status Reports and test results.
• Supported the production install and validated the data integrity between the legacy mainframe outbound files and Data integrity outbound files with a comparator report.

Confidential

Developer

Responsibilities:

• Preparation of High and Low Level Design documents.
• Worked in major migration projects such as Bank Brokerage Intergraded Statement, Continuum Solution National Migration and Business Continuum Solution 2.1 for enrolling customer in the Combined Statement and Relationship Pricing services.
• Enhanced the existing COBOL Stored Procedure programs to handle the online call from Banking Online Support System.
• Develop new Cobol/DB2 Online Stored Procedure programs to interface with INTERACT application.
• Develop/Enhanced mainframe COBOL, MQS programs for daily/monthly batch processes as part of intergraded project releases and independent agile project releases.
• Worked on migration project to cutover multiple mainframe inbound application for Account and customer profile level information such as FFD/WCC to ETL environment and comparing the data consistency in Agile methodology.
• Update the eligibility rules tables based on the business requirement from line of business.
• Update the project status to clients through bi-weekly status calls and to onsite coordinators through daily status calls, preparing Checklists, Status Reports and test results.
• Collaborated with the Cross Platform Testing team during the SIT/UAT Batch/Online testing for cycle execution and break fix.
• Supported the production installation, post production activities, Batch retrofits in testing region during the warranty period.
• Developed a JAVA application to collect the static table’s volume and a web portal UI to check the Eligibility rules in testing region.