SUMMARY

• Data Warehouse/Business Intelligence specialist with about 9 years of experience in analysis, planning, building and managing successful large - scale Data Warehouse and decision support systems.
• Expertise in designing, developing and implementing ETL techniques on multiple database platforms using Abinitio.
• Good experience delivering project needs in other ETL tools including TALEND,SSIS,SPARK,HIVE and Teradara Strored Procedures.
• Good subject matter hold on functional areas include Supplychain, Geocoding, Insurance, Banking and Sales & Marketing.
• Strong Technical and Functional Ability to lead a team by planning, executing and helping team in achieving project objectives with no probability of failure.
• Strong experience in several aspects of project including requirement gathering by understanding business and technical requirements, effort and resource estimation, translating requirements into mapping documents, proposing application architecture, document test scenarios, development, unit & functional testing.
• Have extensively worked on advanced features of Ab initio like Webservices, continues graphs, PDL and Meta-programming. Have very good experience in performance tuning using several parallelization techniques available in Abinitio. Have Solved complex requirements using Abinitio component set and functionalities with lesser development time.
• Good Experience with other Abinitio ecosystem tools like Abinitio Metadata Management (MDM), Abinitio control center(OC) and AI BRE.
• Strong skills on scanning the system for any optimization scope and provide solution by automating through unix scripting or building utilities using ETL tools.
• Good experience in implementing ETL code in TALEND and SSIS using the component set available and also great experience in implementing user defined functionalities in Java to support Talend ETL.
• Excellent problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction.
• Expertise in developing Data Validation Queries for complex business transformations and developed automated regression test cases.
• Willingness and ability to quickly adapt to new cutting edge technologies and mastering sought-after skills.
• Well acquainted with software development life cycle (SDLC) and followed best AgileScrum practices.

TECHNICAL SKILLS

ETL Tools: Ab initio,Talend,Teradata(IDWB), SSIS

Hadoop & Spark: PYSPARK,Map Reduce, HIVE, Sqoop

RDBMS: Teradata,Oracle, Netezza,SQL Server

Programing & Scripting: Python, SQL,PL SQL,Core Java, Unix shell scripting

Reporting Tools: Java script,HTML5,Angular Js, Microsoft BI,SAP BO

Other Tools: Autosys, Selenium WebDriver,Git Hub,Rally,ServiceNow,TFS, Operation console (Ab scheduling)

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead Developer

Technologies used: Ab initio,SSIS,Teradata,SQL Server, IBM Host,Autosys.

Responsibilities:

• Understand and track business requirements by facilitating calls with product owner, Business Analyst and other stakeholders on behalf of development team.
• Convert Business requirement to Technical Deisgn. Communicate with Host team,external vendors to come up with a design that works for both teams.
• Plan the work for self and team along with scrum master. This involves estimating user stories, capacity planning for each sprint and planning release.
• Co-ordinate and supervised off-shore team, directed developers understand design and requirement.
• Guided team and delivered self assigned stories in a timely fashion by regularly having a sync-up with team.

Confidential

Developer

Technologies used: Talend,Java,Ab initio,Netezza.

Responsibilities:

• Understanding existing solution in Abinitio and design the requirement in Talend.
• Understand capabilities of TALEND that can be leveraged to implement atmost functionalities using Talend DI component set.
• Solve features like hash key generation, lookup functionality using hashmaps, etc., using JAVA programming and re-used across the modules.
• Streamlined complete SK functionality and performance tuned the jobs to run faster using parallelization techniques.
• Implemented Netezza loader functionality to work for multiple process id’s load in parallel.

Confidential

Technical Lead & Off-Shore Co-ordinator

Technologies used: Abinitio, AI BRE, AI MHUB, AI control center, Netezza, Oracle

Responsibilities:

• Co-ordinate with Data modeling team and off-shore ETL team to understand on Functional and Technical requirements.
• Come up with Technical design for implementation by understanding existing code base(if any) and share work with senior developers and developers.
• Peform coding and review codes done by other developers. Ensure unit test cases, functional test cases documented for all the changes.
• Move all the codes to higher testing environments and drive testing teams to ensure all test cases are executed in higher environments.
• Support any production related issues and adhoc enhancement requests provided by users.
• Work on automations including code migration tool, Automatic TRL upgrade tools which are self suggested and initiated efforts.
• Implement Abinitio functionalities in talend using java to create user defined functions required to support AI functionalities.

Big data Developer

Technologies Used: HIVE,PIG, SQOOP,HDFS,HUE, SQL server, Autosys.

Responsibilities:

• Work closely with Data scientist to understand the patterns in Data by sampling.
• Perform data movement from SQL server for various logging tables into HDFS by squooping data at regular intervals, eventually it was automated
• Perform creation of tables in Hadoop and land the source data into these tables, also perform data validations.
• Understand data attributes to be united from Data scientist for a particular analysis operation, write a sql query and HQL query and perform data comparisons, automate that analysis query to pull data for different interval data.
• Prepare PIG operation flows for sequence of analysis tasks and create Autosys job to schedule these flows to run at intervals.

Systems Analyst and Technical Lead

Technologies used: Abinitio, Terdata, SQL server, visio and Oracle.

Responsibilities:

• Understand the Business Requirements and collate, perform fid-gap and system Integration Assessment.
• Come up with Design changes by working with Design Lead and Enterprise Architect.
• Convert Design requirements into Technical requirements and work with developers across technologies to delegate Technical requirements.
• Work closely with Developers for Functional Testing, with up/downstream application teams for Integration Testing, with users for User Acceptance Testing.
• As a Technical Lead Help Developers in case of any technical challenges. Plan all the release activities ahead of release time.
• Involved in reviewing Developers code to make sure the optimized code with all standards maintained.
• Worked on Smart search POC, an effort to make google like search on top of database for Non-SQL users. I have contributed in frontend space to create web pages using HTML5 and Angular JS.
• Created a bash shell based utility to automate multiple tasks including updating configuration files automatically, one click file transfer between different environments etc., to increase productivity of a ETL developer.
• Involved in conversion of reports automatically from micro strategy to bobj by using bobjsdk.
• Mentored and Trained New Developers to learn Ab initio.