Surendra Puligeeti

Senior ETL Designer/Developer

E-mail: ac48ox@r.postjobfree.com. Ph. +1-650-***-****

Overall of 10+ years of IT experience and 2+ years of onsite experience in implementation of ETL applications using Ab-Initio/Talend/Informatica on Unix, Oracle, Teradata, Hive databases and Hadoop Environments.

Have Expertise in Business Analysis; Design/Optimizing existing data model, ETL Development, Deployment, Maintenance, Enhancements and Implementation of Various DWH projects.

Worked on Financial, Cards and Banking data-models. Able to understand and can work in all domains.

Worked as an ETL Tech Lead/Designer, Senior ETL Developer in providing BI solutions and for reporting/data visualization on OBIEE and Tableau.

Extensively used ETL methodologies for supporting data Extraction, Transformations and Loading processes using Ab Initio/Informatica/Talend.

8+ years of hands-on experience on Ab-Initio PDL, Meta Programming, UDFs, conduct>It, Resource pool manager, plans, psets, conditional, continuous components, for/while loops, blocks, recursive lookups, transform, DB, Join with DB, XML, Miscellaneous components, Debugger and watches for data validation, EME Project creation, Sandbox Setup, graph check-in & Project check-outs, air commands and Project Deployment activities. Created complex graphs for aggregated Facts, SCD-1, SCD-2 Dimension table load. Exposure on Ab-initio BRE and Ab-initio Data Profiler tools.

2+ years of hands-on experience on Talend Integration Suite 6.x/5.x with Creation of complex Jobs/Joblets, Talend Big data components, tMap, tJoin, tReplicate, tJava, tParallelize, tConvertType, treplace, tJavaFlex, tAggregateRow, tDie, tWarn, tLogCatcher, toracleinput,tputdelimited, tunique, tFlowToIterate, tsort, tFilterRow.

Well versed with Talend Spark jobs, code version control and deployment with GIT and TAC, data profiling for key business rules, Global and context variables, Talend outlets and Parallelized, creating data model using Talend MDM, Job conductors for scheduling, Execution plan and Triggers.

2+ years of hands-on experience on Informatica Power Center 9.5/9.1/8.x, workflow Manager, Repository Manager, Administrator Console, Job scheduling using DAC & Control – M, Push Down Optimization and IDQ.

Well versed with Informatica transformations as – Expression, Joiner, Lookup, Sorter, Filter, Aggregator, Update strategy, match, merge, comparison and standardizer to perform various data enriching and data loading activities. Designed and Implemented type -1 and type -2 dimensional loads and Fact aggregate table loads.

1 year of experience on Hadoop technologies as HDFS, Hive, Python, Sqoop.

Worked on converting existing Ab-Initio ETL code using HQLs, Python and migrated critical jobs to Hadoop System for Tableau reporting.

Implemented new enhancements on Hadoop system for the current project.

Extensively worked on Complex SQLs, Procedures and Triggers and used SQLs for debugging data and ETL code related issues, created DB objects, Partitions, Indexes.

Expertise in BI reporting Tools like OBIEE and Tableau. Worked on debug/Analyze report functionality for new enhancements to be implemented.

Have experience on debugging code, in validating transformed data and in deploying code to non-production environments.

Worked as ETL tester in SIT and UAT. Experience on ETL code and job script’s migration and preparing deployment notes.

Excellent knowledge on UNIX commands and experience in creating shell scripts for automation of job alerts.

Have Knowledge on ESP scheduler and in creating job doc sets to schedule ETL jobs.

Worked on Functional specification doc, Detail design, High-level design, Test plan, install plan, Change request placeholder documents.

Worked on production issues and enhancements over more than 1000 bugs/improvements.

Created Production support reference and process related documents.

Provided transition to team and conducted training sessions on tool related stuff and in understanding functionality of system.

Performed code reviews and POC for the given business requirements. Proposed design steps, built and implemented requirements successfully.

Thorough knowledge of Dimension modelling, Star schema, Snowflake schema.

Bachelors of Technology in Electronics and Communications Engineering.

Big Data

Hadoop, HIVE, Python, SQOOP

DBMS

Oracle 9i, 10g, Teradata

Data Integration Tools

Ab Initio, Talend, Informatica

Reporting Tools

OBIEE, Tableau

Scripting

UNIX, Python

Operating Systems

Windows NT, Win 2000, XP, Windows 8, Windows 10, UNIX

Concepts

Data warehouse, Business Intelligence and ETL concepts

Scheduling Tools

ESP, Tivoli, DAC, Control-M

Process/Issue Tracker/log

JIRA, Quality Center, Viper, Asknow

SDLC

Waterfall, Agile, Hybrid Agile, Scrum

VELT Ab-Initio to Hadoop Migration, Visa Inc. SFO (CA) Mar 2017 – Till Date

Role: ETL Designer

Key Deliverables:

»Continued with existing system enhancements to build on Ab-initio and load into Oracle into Oracle tables.

»Analyzed existing system, databases, and prepared design documents to migrate data into Hive tables.

»Migrated existing ETL components and SQLs into Hadoop system.

»Loaded and staged data into Hadoop using Sqoop incremental and full import of tables.

»Performed Aggregation of data processing for the source/staging files using Hive queries.

»Created UNIX job scripts and scheduled to run data import, store and aggregate processes using ESP scheduler.

»Followed complete agile process with monthly sprints for the critical modules to migrate.

»Involved in ETL build, review and performance tuning.

»Prepared Test Data and Test plan for Component Integration and QA Testing.

»Code deployment to QA, UAT and Production.

»System Integration, User Acceptance testing support for defects fixes that were logged in JIRA.

»Production Implementation activities & processes (Change Request Management), conducting code walkthrough to Production support for Code Handover and related documentation.

»Setting up daily calls to go over on issues/concerns during build/QA/UAT.

Tools, Database:

Hadoop : HDFS, HQLs, UNIX, SQOOP

Reporting : Tableau

Database : HIVE

VELT Phase III, Visa Inc. SFO (CA) Feb 2016 – Mar 2017

Role: ETL Tech Lead

Key Deliverables:

»Ab-Initio Technical Lead/senior developer starting Business Requirements analysis till end to end project delivery to Live

»Interacted with CSR business and Design team to clarify requirements.

»Analyzed Master Data Mapping and scope of data requirements, changes to existing modules and new source and target mappings.

»Created High-level and Technical design documents based on the business requirements with all the system details required for ETL and DB components.

»Involved in ETL build, review and performance tuning.

»Created UNIX job scripts for running new Ab-initio graphs/psets/plans and for file pre-process and job flow automation. Changes to the existing job scripts to accommodate Phase III requirements.

»Prepared Test Data and Test plan for Component Integration and QA Testing.

»Code deployment to QA, UAT and Production.

»System Integration, User Acceptance testing support for defect fixes, which were logged in JIRA.

»Production Implementation activities & processes (Change Request Management), conducting code walkthrough to Production support for Code Handover and related documentation.

»Created job-docs to run UNIX jobs in ESP Scheduler.

»Involved in monthly sprints and delivered tasks on Hybrid Agile model.

Tools, Database:

ETL : Ab-Initio

Reporting : OBIEE

Ab-Initio File System: Serial & Multi partitioned files on UNIX server

Database : Oracle 11g

VELT DR, Business Continuity Plan, SFO (CA) Feb 2016 – Sep 2016

Role: ETL Tech Lead

Key Deliverables:

»Ab-Initio Technical Lead starting Business Requirements analysis till end to end delivery to Live

»Deployed Ab-initio, job scripts, ESP Job-docs from existing OCE server to OCC server.

»Prepared and Delivered Detail Design document with all details of ETL scope.

»Created Ab-Initio graphs for pre-requisites on implementing business continuity plan.

»Involved in ETL build, review and on creating UNIX job scripts for the data copy of pre-requisite files from OCE to OCC servers.

»Deployed Ab-Initio code, job scripts and ESP job-docs with Change Requests.

»Prepared and implemented Technical Recovery Plan document successfully as part of Business continuity plan.

»Co-ordinated with Infra, DB, Reporting Admins on the pre-activation, execution and post-activation of plan.

Tools, Database:

Ab-Initio File System: Serial & Multi partitioned files in UNIX server

Database : Oracle 11g

NSPK Interim& Full solution, Visa Inc. CHN Oct 2015 – Feb 2016

Role: ETL Senior Developer

Key Deliverables:

»Ab-Initio Technical Lead starting Business Requirements analysis till end to end delivery to Live

»Interacted with Business Analyst and Design team to clarify requirements / HLD

»Created Detail Design document with ETL component and DB details.

»Involved in ETL build, review and performance tuning.

»Created UNIX job scripts for running Ab-initio graphs/psets/plans.

»Prepared Test Data and Test plan for Component Integration Testing.

»Code deployment to QA, UAT and Production.

»System Integration, User Acceptance testing support for defects fixes logged in JIRA.

»Production Implementation activities & processes (Change Request Management), conducting code walkthrough to Production support for Code Handover and related documentation.

»Analyzed the job dependencies, pre-requisites, and Created UNIX jobs on ESP Scheduler.

»Shared Weekly status report and to go over on issues/concerns during build/QA/UAT.

Tools, Database and OS:

ETL : Ab-Initio

Reporting : OBIEE

Ab-Initio File System: Serial & Multi partitioned files in UNIX server

Database : Oracle 11g

Corporate Analytics Support, Visa Inc. CHN Jul 2013 to Sep 2015

Role: ETL Senior Developer & System Analyst

Key Deliverables:

»Supported and maintained three applications that were run On Talend and Informatica Power Center.

»Was able to acknowledge data/code/reporting/design issues and work on resolution and implementing fixes in production system.

»Used Talend debugger and breakpoints to view transformations output and debug mappings in pre-prod environment.

»Created new Talend jobs and implemented as part of enhancements for the existing functionality.

»Worked Global and context variables and extensively used most of the Talend components required for the development.

»Worked Extensively on TAC (Admin Console) for Scheduling and monitoring Jobs.

»Performed administrator role in migrating the objects from one environment to the other DEV/QA/PROD.

»Designed, developed, implemented and maintained Informatica Power center and IDQ 9.0.

»Created/modified various Informatica mappings and workflows for the successful migration of data from various source systems to oracle.

» Developed mappings using various transformations such as Source Qualifier, Router, Filter, Sequence Generator, Aggregator, Lookup, Stored Procedure and expression as per the business requirements.

»Responsible for Trouble shooting, Production support, Performance tuning and Batch monitoring activity

»Production Implementation activities & processes (Change Request & Incident Management).

Tools, Database and OS:

ETL : Talend, Informatica Power Center

Reporting : OBIEE

Database : Oracle 11g

Visa Exposure and Liquidity Monitor Tool, Visa Inc. CHN Dev -Apr 2012 to Jun 2013.

Role: ETL Senior Developer

Key Deliverables:

»Ab-Initio senior developer starting Business Requirements analysis till end to end delivery to Live

»Interacted with Business Analyst and Design technical aspects of requirements.

»Created Functional specifications, Detail Design and High Level Design documents.

»Involved in ETL development for Dimension and Fact table load and for data validation. Performed data validation and debugging to verify business requirements.

»Created UNIX job scripts for running Ab-initio graphs/psets/plans.

»Prepared Test Data and Test plan for Component Integration Testing.

»Code deployment to QA, UAT and Production.

»System Integration, User Acceptance testing support for defects fixes logged in Quality Center.

»Production Implementation activities & processes (Change Request Management).

»Created UNIX job scripts and scheduled them on ESP Scheduler.

Tools, Database:

ETL : Ab-Initio

Reporting : OBIEE

Ab-Initio File System: Serial & Multi partitioned files in UNIX server

Database : Oracle 11g

Office of Fair Trading, Barclays Bank PLC, PNE May 2010 - Mar 2012

Role: Associate Consultant

Key Deliverables:

»Ab-Initio developer starting Business Requirements analysis until end-to-end delivery to UAT.

»Created Detail Design and Functional specification documents as per the High level design.

»Built, Tested and validated Ab-Initio graphs for the design to enrich and aggregate data.

»Involved in developing Account, Fee & Charges, Refund modules and in creating account summary data for the final file.

»Prepared Test Data and Test plan for Component Integration Testing.

»Acknowledged and worked on the issues logged on Quality Center.

Tools, Database:

ETL : Ab-Initio

Ab-Initio File System: Serial & Multi partitioned files in UNIX server

Database : Oracle 10g

Accurate Bank Customer Data dashboard, Barclays Bank PLC, PNE Jan 2009- May 2010

Role: ETL Developer

Key Deliverables:

»Ab-Initio developer starting Business Requirements analysis until end-to-end delivery to LIVE.

»Involved in Detail Technical Design and coding part.

»Created summary file from the Acquiring published UKRB files. Derived and populated all the business flags in the summary file using BRE XFRs and loaded this file in Teradata DB.

»Created Ab-initio BRE XFRs, check-in into repository and calling them from Ab-Initio GDE.

»Involved in ETL build, validate, debug and test the requirements.

»Prepared Test Data and Test plan for Component Integration Testing.

»Have worked on SIT, QA and UAT issues and provided fixed and released again to re-test the code.

Tools/Languages:

ETL/Tools : ETL Ab-Initio Tool (GDE 2.15 / EME 2.5)

: ETL Ab-Initio BRE – Business Rule Engine

: Putty, Tivoli Scheduler, Quality Center, Service Center & Manager

Database : Teradata

Reporting : COGNOS

ISTHMUS (CLP CD – BAU 152), Barclays Bank PLC, PNE Nov 2007- Dec 2009

Role: ETL Developer

Key Deliverables:

»Analyzed existing Ab-Initio code and Business Requirements and design documents and started build on the file processes to load into Teradata DB.

»Involved in populating load ready files and verified data against the requirements provided.

»Ran the Ab-Initio jobs in Debug mode and performed Unit Testing on the key transformations.

»Involved in creating Ab-Initio objects i.e. xfrs and psets to process multiple source files.

»Resolved Dependency Analysis issues for existing and new graphs and improved the performance of execution.

»Resolved issues in SIT and UAT phases and maintained track of issues using Quality Center.

»Co-ordinated with Tech-Office officials and worked with multiple teams on DB, Tivoli scheduling and Infrastructure teams.

Tools/Languages:

ETL/Tools : ETL Ab-Initio Tool (GDE 2.15 / EME 2.5)

: Putty, Tivoli Scheduler, Quality Center, Service Center & Manager

Database : Teradata

Contact this candidate