SUMMARY:

• Ab Initio ETL Developer with over nine years (9) of IT experience in analysis, design, development, deployment, testing, support and implementation of Data Warehousing in Property and Casualty Insurance Line of Business
• Experience for nine years (9) of developing ETL applications using Ab Initio, UNIX, Oracle, Teradata and Autosys scheduling tool
• Develop patterns, guidelines and methods using Ab Initio to manage data assets across the data lifecycle, from creation / acquisition through archival and purge
• Strong experience in both Waterfall as well as Agile methodology
• Collaborate with the architects, developers, business analysts and company executives in order to determine the software's technical direction, system design and implementation plan
• Worked on production support team for three (3) years where I provided level 3 production support for complex applications and Extract Jobs having stringent SLA and involving financial and campaign data from various sources for different applications
• Involved in all the four phases namely planning, analysis, design and implementation
• Experienced in testing, documentation and requirements gathering. Excellent understanding of the System Development Life Cycle. Clear and through understanding of business process and workflow
• Responsible for providing application requirements gathering, designing, development, technical documentation, and debugging.
• Assisted team members in defining Cleansing, Aggregating, and other Transformation rules

SKILL:

Development: Abintio 3.2, Teradata 16, Unix scripting, Autosys

Technologies: Abintio Technologies Continuous Flow, XML data

Conduct: IT, Parallelism, Micrograph, PDL & BRE

RDBMS: Technologies, SOAP UI, MQ utilities/Lotus Notes, Hadoop HDFS, Hive

Databases: Teradata 16, Oracle, MySQL and DB2

EXPERIENCE:

Sr. ETL Developer and Programmer/Team Lead

Confidential, Hartford, CT

Responsibilities:

• Scope gathering and project estimation
• Creation of project/work plans/resource plans
• Define E2E project plan/execution strategies
• Defining/documenting/reviewing processes for all teams (Data Model, Testing Strategies, Design Doc, Dev code reviews etc)
• Coach/Guiding/helping all teams to accomplish their tasks
• Review of project artifacts such as work plans, testing strategies and Design Docs
• Reviewed/Assist PMs to prepare project status updates for client's senior leadership team (comprised of CIO, 2VPs). Provided input during senior management connects
• Chairing important technical discussion involving stakeholders across LOBs

Environment: Ab Initio GDE (3.3.3.5 and 3.2.3.14)/ Conduct>It/ Metadata Hub/Technical Repository/Express>It/, Teradata SQL Assistant, Microsoft SQL Server, Putty, Autosys (Job Sceduler), WebSphere MQ Explorer, Hadoop HDFS, Hive, BMC Remedy, Jenkins and UCD

Sr. ETL Developer and Programmer

Confidential

Responsibilities:

• Marketing intelligence platform is an initiative in which in which first client is creating new data warehouse that will be sourced from over thirty sources sending over one hundred and twenty files populating 120 tables.
• Worked with the marketing team to automate marketing reports and measure efficiency early so that marketers can spend more time gaining insight.
• Extensive experience interacting with users and functional analysts for gathering the business requirements and functional specification
• Project planning and lead a team of eight resources from offshore
• Designing and development of E2E ETL Architecture
• Performance tuning of ETL as well as SQL based processes
• Capacity planning/space estimation on LINUX as well as Teradata to processing and populate twenty TB raw data in multiple batches
• Prepared execution schedules to line up with batch execution of other existing applications that were linked as a part of this project
• Performance Tuning of ETL batch Jobs, end to end reviews, defining project standards
• Prepared complex AB Initio plans
• Providing system test support and implementation

Environment: Ab Initio GDE (3.1.2 and 3.2.3)/ Conduct>It/ Metadata Hub/Technical Repository/Express>It/, Teradata SQL Assistant, Putty, Autosys (Job Scheduler), WebSphere MQ Explorer, BMC Remedy, Jenkins and UCD

Sr. ETL Developer and Programmer

Confidential

Responsibilities:

• Translated technical specifications into program codes
• Collaborated with Business Analysts to clarify application requirements
• Defining the technical architecture/coding standards/process flow
• Identified the technical cause and potential impact of errors and implement coding or configuration changes and performance improvements
• Defining data purge/retention/ UNIX/LINUX/TERADATA capacity planning
• Perform structured application code reviews and walkthroughs as needed
• Creating efficient process - to-process 6 TB of historical data, 80 GB daily and 7 TB data on a weekly basis
• Job scheduling for various application and Extracts
• Provided L3 support whenever SME support was required

Environment: Ab Initio GDE (3.1.2), Teradata SQL Assistant, Putty, Autosys (Job Scheduler), BMC Remedy, Jenkins and UCD

ETL Developer and Programmer

Confidential

Responsibilities:

• Understanding processes
• Gather Requirements (Business Specifications Document, BSD) from client and project leads
• Build of code for processes
• Developed unit test plans to test code and Regression Analysis
• Code migration from Development to Test

Environment: Ab Initio GDE (3.1.2), Teradata SQL Assistant, Putty, Autosys (Job Scheduler), Jenkins and UCD