ETL developer
Resume:
********.*****@*****.***
Spandana K
Summary
•Having 4+ Years of professional experience in IT as an ETL Developer and Designer (Ab Initio).
•Having Extensive knowledge on data warehouse concepts.
•Executed various data warehouse projects using various SDLC methodologies like waterfall and Agile.
•Well versed with agile concepts like scrum, sprint etc.
•Extensively worked on Data Extraction with Oracle and Teradata and flat files, XML files by using Ab Initio.
•Good hands on experince in XML and XSDs.
•Hands on experience with SQL and PL/SQL.
•Extensive experience on various Ab Initio components to extract and load huge data, multi files and Change data capture.
•Performance tuning of various Ab Initio graphs and SQL.
•Extensive Experience in UNIX, LINUX.
•Hands on experience in shell scripting.
•Used schedulers like Cron tab, Tivoli Work Scheduler and Control M.
•Having good working experience on EME (For Check in and Check out) SVN (for versioning of SQL files) and TFS.
•Worked with components like Read from Hadoop and Write to Hadoop using Ab Initio.
•Used HDFS to write files to Hadoop server.
•Experience in ACE/BRE and creating/managing templates/frameworks.
•Earned Extra Miler award at work for good problem solving skills.
•Extensive Knowledge in Oracle SOA/OSB 11G, Web logic and Hadoop.
•Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
•Quick adaptability to new technologies.
Technical Summary:
ETL : Ab Initio 3.1.7, 3.1.5.3
RDBMS : Oracle 11.2, Teradata TD13
Languages : UNIX Shell Scripting
O/S : Windows XP/7 Server, HP-UX 11.1, Linux 2.6.32
Education Summary
•Bachelor of Technology from Jawaharlal Nehru Technological University in the year 2013.
Experience Summary
•Working as Ab Initio Developer with SPAR Infotech from January 2019 to Till date.
•Working as Ab Initio Developer with Bitwise Global from October 2018 to January 2019.
•Worked as Programmer with EA Learn Inc., NJ from November 2016 to September 2017.
•Worked as a Software Engineer with Accenture, Hyderabad from Dec 2013 to February 2016
Project Summary:
Project Name : FEP CCTI Jan 2019 – Till Date
Client : BCBSA
Role : Ab Initio developer
Description: The objective of the FEP CCTI project is to close all pending prod issues and enhancements with the fix that is needed. As part of this team, various PROD INC are revisited, analyzed, fixed with detailed documents.
Responsibilities:
•Close outstanding PROD defects and enhancement requests.
•Preparing Technical Design Document based on the Functional Design.
•Developing the graphs (Generic graphs, PSETs and wrapper scripts) required according to the design.
•Validation of PROD issues for data quality and issue resolution.
•Updating the reporting details in JIRA
•Creating PSETS for the generic graphs to deal with INCs various levels of severity.
•Work closely with business to understand the changing requirements and ahead planning.
•Worked on Sev 1 tickets which required update every hour.
Environment : Ab Initio 3.2, DB2, AWS, SQL, UNIX, JIRA, Control M
Project Name : AWS Migration Oct 2018 – Jan 2019
Client : Discover Finanacial
Role : Ab Initio developer
Description: The objective of the AWS migration project is to migrate the data from Teradata to AWS. Application is originally built in ABINITIO to load the data into ORACLE. Various graphs were built to load the data into AWS and Teradata parallely to compare, validate and Reporintg in JIRA.
Responsibilities:
•Loading data into Teradata and AWS.
•Preparing Technical Design Document based on the Functional Design.
•Developing the graphs (Generic graphs, Validation Appconfs, Run Feeds) required according to the design.
•Validation of load jobs in AWS vs TERADATA.
•Updating the reporting details in JIRA
•Creating PSETS for the generic graphs to deal with various tables.
•Work closely with business to understand the changing requirements and ahead planning.
Environment : Ab Initio 3.2, TERADATA, AWS, SQL, UNIX, JIRA, TWS scheduler
Project Name : Express Scripts Nov 2016 – Sep 2017
Client : Express Scripts
Role : Ab Initio developer
Description: The objective of this program is to produce reliable information in a timely manner of a material entity basis related to financial condition; financial and operational inter connectedness and third party commitments and contracts. Acquire data from source systems (Financial, Operational third-party and Reference data) and store it in a standard model with operational functionality to support monitoring, Reconciliation and reporting data quality and data usage.
Responsibilities:
•Extracting the data from various sources (Financial, Reference and Operational).
•Preparing Technical Design Document based on the Functional Design.
•Developing the graphs (Generic graphs, Validation Appconfs, Run Feeds) required according to the design.
•Using BRE to generate transformations and validation rule sets and creating exceptions (assigning error codes) in ACE.
•XML files were used extensively and hence worked with Read XML files.
•Developing Abinitio Generic Graphs using various components like sort, rollup, reformat, join and scan.
•Creating PSETS for the generic graphs to deal with various tables.
•Work closely with business to understand the changing requirements to foresee the changes in the template and ahead planning.
Environment : Ab Initio 3.1.7, TERADATA, SQL, UNIX
Project Name : DELL Financial Services (DFS) Nov 2014 – Feb 2016
Client : DELL Financial
Role : Ab Initio Developer
Description: Dell Preferred Account is a revolving line of credit that gives you the purchasing power to update your technology. Applying for Dell Preferred Account is a snap, and you’ll find out immediately if you qualify. Access a monthly payment that fits within your budget and exclusive offers and insider sales.
Responsibilities:
•Extract Customer data (transactional) from ORACLE.
•Implemented Change data capture to identify the changes in daily data received.
•Transform the data according to the target record layout.
•Load the data into Datamart in ORACLE using Ab Initio.
•Business users query the data from ORACLE tables for reporting.
•Developing Ab Initio Generic Graphs using various components like sort, rollup, reformat, join and scan.
•Creating PSETS for the generic graphs to deal with various tables.
•Check in and check out the code of the latest code from EME.
•Creating Korn shell scripts.
•Creating automation scripts for manual activities in project (like file comparison for audit).
•Scheduling jobs using Operation Console.
•Perform Unit testing and Regression Testing.
Environment: ORACLE, Ab Initio 3.1.5, SQL, PL/SQL., UNIX, OC scheduler
Project Name : Liberty global International Dec 2013 – Oct 2014
Client : Liberty global
Role : Associate Software Engineer (developer)
Description: Liberty Global Inc (“Liberty Global”, “Liberty”) is the largest international cable company with operations in 14 countries. We connect people to the digital world and enable them to discover and experience its endless possibilities. Our market-leading products are provided through next-generation networks and innovative technology platforms that connect 27 million customers subscribing to 56 million television, broadband internet and telephony services at March 31, 2015. In addition, we served five million mobile subscribers and offered WiFi access across over five million access points.
Liberty Global’s consumer brands include Virgin Media, Ziggo, Unity media, Telnet, UPC, VTR, and Liberty Cablevision. Our operations also include Liberty Global Business Services and Liberty Global Ventures.
Responsibilities:
•Developing Ab Initio graphs for customization of user request process.
•Developing Ab Initio graphs as daily and monthly cycle for loading, partitioning, cleaning and populating the data based on legal and business requirements.
•Prepared the Unit Test Case Plan.
•Creating End-to-End Process document for the Graphs and job flow.
•Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects.
•Sandbox features like check in and checkout were used for this purpose.
•Performed Unit Testing of the graphs and System Testing
•Worked on Impact Analysis for the CR’s
•Communicating with the onsite coordinators for the requirements.
Environment: ORACLE, Ab Initio 3.0.2, SQL, UNIX, OC scheduler, Crontab.
Contact this candidate