SUMMARY:

• A dynamic and highly motivated ETL (Abinitio, Datastage and Informatica) Data warehousing professional with 8+ years of experience and having good exposure in Bigdata platform(Hadoop MapReduce /Pig/Hive/HBase/ Sqoop and Apache Spark.
• Good experience as a technical team leader and currently working with Confidential .
• Expert Skills in all phases of software development, including RDBMS concepts, database( oracle, Teradata, DB2), query analysing, performance tuning and ETL process migration to Big Data platform.
• A strong record of success, working both independently and with multidisciplinary groups. Demonstrated talent for organizing and directing teams in an efficient and effective manner.
• A poised and confident leader with good communications skills. Versatile and well - organized, able to multi-task, with a wealth of knowledge, sound judgement, and an enthusiastic team builder.
• Expertise in ETL tool Ab-Initio, Datastage and Informatica worked as an ETL developer and Developed many graphs/parallel jobs/mappings to extract data from source system and then transform the data as per the target system requirements
• Project experience in ETL integration with Hadoop/Bigdata using Hadoop mapreduce framework, Pig, Hive, HBase, Sqoop and Apache Spark.
• Performed the role of a Team member/Module Lead in development and support of Data warehouse applications.
• Thorough knowledge of UNIX commands.
• Involved in all the phases of SDLC - Analysis, Design, Development, Implementation and Testing ofapplications involving the tool Ab Initio, Datastage, Informatica, Teradata, Oracle, UNIX.
• Certified in Oracle PL/SQL and IBM Datastage v8.5.
• Interaction with client to discuss critical issues and taking the acknowledgement and providing the resolution.
• Energetic self-starter with excellent analytical and organizational skills.
• Developed different utility scripts according to project specifications such as file watcher script, archiving andpurging script, checking for rejection and log analysis, sftp pull and push script for pulling/pushing filesfrom different servers also from different vendors such as mainframe and legacy systems.
• Involved in ETL processes as loading dump, extraction and transformation of data, loading of data in target system, & generation of feed files.
• Created valuable reusable code/graphs for improving the efficiency.
• Has substantial trouble-shooting experience.
• Excellent analyst skills and the ability to collect and define business requirements.
• Excellent analytical & problem solving and business interaction skills.
• Good team worker and has ability to understand and adapt to new technologies and environments faster

TECHNICAL SKILLS:

Programming: C++, Core Java, Hadoop (MapReduce),Scala

Other Utility Tools: Toad, Quality Center, SQL Developer, Aginity, IBM Initiate 8, Inspector, SOAP UI, winscp, putty

Database Systems: Oracle, Teradata, Netezza

Scheduling tools: Autosys, TWS(Tivoli Workload Scheduler), Control-M

ETL tools: Ab Initio, Datastage, Informatica

Scripting: Unix, PL/SQL, Pig/Hive/Sqoop/HBase/Apache Spark

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

ETL Technical Specialist

• Documents all technical and system specifications documents for all ETL processes in Datastage and Ab-initio,perform unit tests on all processes and prepare required programs and scripts.
• Assist in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL-related activities.
• Provide technical knowledge of Extract/Transform/Load (ETL) solutions for Business Intelligence projects
• Work closely with project Business Analyst, Data Modeler and BI Lead to ensure that the end to end designs meet the business and data requirements
• Develop the task plan for ETL developers for a specific project
• Participation and contribution in quality assurance walk through of ETL(Datastage and Ab-initio related processes) components
• Support development teams with performance tuning and troubleshooting issues
• Proficient with a database SQL language for user defined database extract or update statements.
• Work closely with Project Manager to develop and update the task plan for ETL work and to keep the manager aware of any critical task issues and dependencies on other teams
• Ensure the ETL code delivered is running, conforms to specifications and design guidelines
• Unit testing ETL code to ensure it can be delivered and run in a system testing environment.
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.
• Review of ETL design documents and working closely with Business/Architect team
• Help with the analysis of issues raised during QA/UAT/PROD phases and Data Reconciliation
• Onsite communications and co-ordination with clients on business requirements created
• Good understanding of performing file level verification tasks via UNIX Shell scripts and command-line utilities etc.
• Working as an ETL Tech Specialist(technical Lead) for multiple projects.

Confidential, Northbrook, IL

ETL Technical Lead

• Played the role of a Program Technical Lead/ETL Architect and was responsible for designing the ETL Strategy & Architecture of the Project.
• Was responsible in managing tasks and deadlines for the ETL teams both Onsite and Offshore.
• Was the point person on the ETL team for other teams such as Reporting, Testing, QA and Project Management for updates on Project Status and issues.
• To get the Functional Requirement Specifications from customer and understand the same.
• Understand the Insurance domain functionality.
• Break up the work into task list and estimate based on simple, medium and complex methodology
• Interaction with business users and requirement gathering.
• High level & low-level ETL flow design
• Involved in detailed technical design
• Give functional KT to the QA team.
• Was involved in conducting the review of ETL Code, Unit Test Cases & Results with the Developers.
• Organize daily technical discussions with the Onsite team also including the individual offshore workstream leads and set expectations for Offshore delivery.
• Involved in POC and help in making client proposals for new initiatives.

Confidential, Chicago, IL

ETL Analyst

• Analyzed functional requirements and convert them to technical requirements and design.
• To provide user interfacing screens to administer and manage various system parameters and rules.
• Communicating with client and gathering requirement for any new enhancement or improvement in the application.
• Estimating the total efforts that would be required to complete the enhancement or improvement task within Timeline.
• Analyzing the requirement with other team members and then preparing the high level and low level design.
• Maintaining the backend of the application on daily basis.
• Develop the code using data stage and ab-initio as per client requirement.
• Tweaking the system to support the business users needs
• Prepare Knowledge Transition package for inducting trainees in the project.
• Provided schedules, status reports, and issue resolutions to the Project team, Business Users, and Project Managers. Kept peers and upper management well informed with weekly status reports on project status / risks and test issues.

Confidential

ETL Module Lead ( Customer Integration and Analytics)

• Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.
• Giving the inputs & sharing the knowledge with other team members.
• Involve in Designing ETL process for the new interface came as a part of different phase of project
• Process development using ETL tool (Ab Initio, Datastage) and Unix Shell scripts. Development of Interfaces and Loading the EBCDIC data through them into Warehouse after applying critical transformations.
• Developed graphs for batch processing
• Developed shell scripts for automation of environment setup, wrapper scripts for process, batch execution and other process.
• Develop and maintain reports for each status.
• Responsible for the design, development and testing of Ab Initio graphs and datastage parallel jobs.
• Analyzed functional requirements and convert them to technical requirements and design
• Created technical detail design documents and conduct code reviews with different groups
• Responsible for the design of unit testing,system integration test plans
• Testing - unit testing & integration testing
• Supported UAT includes ticket solving, and post production issues
• Responsible for overseeing the Quality procedures related to the project.
• Involve in defining parameters and performance tuning of graphs like unload from Oracle table, utilizing the Ab-initio parallelism in correct phase, avoid using costly components etc
• Worked in construction of reusable components like reading feed files based on project level parameter, reconciliation components etc

Confidential, Baltimore

ETL Developer and Service Operations

• Detailed analysis of the specifications provided by the clients and performed impact analysis
• Design the new ETL process after analysis of AS IS system and define the different areas (interface) and process flow.
• Design the approach for handling Dimension at ETL layer in MFS datasets.
• Design the rejection handling process, audit process based on the analysis from AS IS system and new requirement specification.
• Developed graphs for batch processing.
• Developed shell scripts for automation of environment setup, wrapper scripts for process, batch execution and other process.
• Develop and maintain reports for each status.
• Responsible for the design, development and testing of Ab Initio graphs
• Analyzed functional requirements and convert them to technical requirements and design.
• Created technical detail design documents and conduct code reviews with different groups
• Responsible for the design of system integration test plans

Confidential, Baltimore

Rocket Oversight Data Warehouse

• Create mappings employing various transformations, filters, joiners, lookup, SQL overrides etc to load data from multiple databases into Warehouses
• Creation of Sessions and Workflows to schedule these mappings.
• Creation of Unit Test cases and Integration test cases
• Perform unit testing of these Workflows from source to staging and staging to Warehouse of data warehouse
• Reconciliation and evidence creation.
• Analysis & fix on QA defects made by QA team.
• Involved in Unit testing and UAT defect fixing.
• Was involved in Informatica Power exchange to import Mainframe DB2 sources.
• Was involved in Informatica Power exchange to test the data at mainframe .dat files.
• Involved in sessions partitioning and mappings performance tuning.
• QA & Prodution deployment.
• Creation of stored procedures.