Name

Archana Anandakrishnan

Contact Info

E-mail: ac3cy7@r.postjobfree.com mobile:+917*********

Executive Summary

●Overall 7+ Years of ETL Experience.

●Good understanding Data Warehousing, project life cycle Phases.

●Experience in design and implementation of ETL solution in DWH development projects using ETL Tools like Informatica and Ab initio.

●Have worked in LLD, HLD, and Technical Design, Designing the Mappings, Developed and Implementation experience in DWH development projects.

●Worked as an independent resource in 3 projects and delivered the modules on time and to the appreciation of the Client.

●Good knowledge of all the phases like Development, System integration Testing, User acceptance testing.

●Achieved 3 “Feather in Cap” awards from Wipro and Client appreciation for Project deliverables.

●Achieved 1 “Brite Award” and “Highly Performed Achiever” Award in Cognizant.

●Possess strong communication and client management skills.

●Been part of the Induction Team, and have inducted many Rookies and guided them in project activities.

●Have zeal to learn new tools and technologies in ETL and Business Intelligence

●Worked on Datastage and Hadoop system as part of project.

●Handled 10 member project team as Team lead.

●Attended Sessions on DWH, OBIEE Reporting Tool, Cognos and Teradata, BigData Hadoop and R programming.

Professional Highlights

Cotiviti Healthcare Insurance - ITI Data Wilton, Connecticut,USA

Ab Initio Developer

Responsibilities:

●Interacting with the clients directly in client location (Wilton CT, USA) for requirement gathering.

●Attended meetings and trainings to understand the functional aspects of the business.

●Developed Ab Initio graphs to build business rules to extract data from Flat File to validate, transform and load data to Hadoop File System.

Hyderabad,Telangana, HYD

Responsibilities:

●Claim data are ingested for 100 PCA clients from source to Data Lake in an EDM Format. Data is pulled to Bronze layer. From the Bronze data lake path, the claims undergo dups processing, the claim opportunities are ranked, mapped to the EDM model to the Silver /Gold layer in the Hadoop file system.

●Created Parameterized plans and graphs of Ab initio generic graphs to process data according to the business modifications..

●Developed Ab Initio graphs to build business rules to extract data from Flat File to validate, transform and load data to Hadoop File System.

●Involved in code review for the code developed by peers.

●Involved in migrating the code from Development Environment to Stage Environment.

●Involved in scheduling production jobs.

●Monitored operational jobs on a daily basis and managing incidents

●Involved in production issue fixes.

●Automated Data verification and validation processes by Ab Initio Graphs for Historical Load of data in the application.

May 2015 – May 2016

FedEx - Syntel Ltd Chennai, TN, IND

Ab Initio Technical Lead

Responsibilities:

●Involved in analyzing the existing Datastage jobs and preparing Software Requirement Specification (SRS)

●Involved in L0 Estimation of 200 modules

●Assigning tasks to team members

●Built graphs, created Unix shell scripts and Involved in interacting with SME/Client for business clarifications

●Guiding peers technically and provide better coding approach

●Handing Project meetings with onshore and SME

●Involved in code review

●Involved in all phases starting from analysis, estimates, design, development, QA and production support.

●Prepared status tracker and project tracker

January 2015 – May 2015

AllState Insurance – Syntel Ltd Chennai, TN, IND

Ab Initio Technical Lead

Responsibilities:

●Code changes on scripts and Ab initio based on the Migration job Aid

●Involved in Shell to PDL code changes in Ab Initio

●Prepared Unit test case document and Involved in Unit testing for Phase 1 and Phase 2 of 28 Interfaces in X86 Migration

●Fixing Issues and bugs on Unit Testing

●Assigning tasks to team members

●Guiding peers technically and provide better coding approach

●Handing Project meetings with onshore and SME

●Involved in code review

●Involved in phases like analysis, estimates, design, development, QA and production support

●Prepared status tracker and project tracker

May 2014 – January 2015

Citi Bank EMEA - Oracle Financial Services Software Chennai, TN, IND

Ab Initio Senior Developer/Lead

Responsibilities:

●Involved in analysis and requirement gathering of AGS End to End Reconciliation and Delinquency Management

●Prepared L0 Estimation for the projects

●Prepared the Functional and Design document for the project

●Prepared the Implementation change Document

●Allocating recourses with the project task and guided them in the project activities

●Reviewing the entire Ab initio related code activities with deliverable artifacts

●Developed Ab initio code, testing and Support in UAT and Prod

August 2012 – May 2014

Key Bank – Cognizant Technology Solutions Chennai, TN, IND

Ab Initio Developer

Responsibilities:

●Involved in Estimation for the Projects

●Prepared HLD s, Delivery List Document and RTM Document

●Build Graphs in Ab Initio and Involved in Unit testing

●Created Generic Graphs and Components

●Created Mainframe PARAM Jobs for QV scheduling

●Involved in Analyzing the Business in MDM Project

●Exposure in PDL and MetaProgramming Concepts

●Regression testing for existing Projects

●Involved in QV Support and Project Team testing

●Handled 3 projects independently and simultaneously

●Guiding peers technically

April 2011 – August 2012

Zurich North America – Wipro Technologies Chennai, TN, IND

Informatica Developer

Responsibilities:

●Prepared LLD'S, HLD and test cases according to the Requirement

●Build mappings in Informatica

●Involved in Estimation for the Projects

●Unit testing and prepared test evidences

●Worked in UNIX for Configuring Session Properties

●Prepared Autosys scripts

●Involved in QV Support and Integration Testing

June 2010 – April 2011

Capital One Auto Finance – Wipro Technologies Chennai, TN, IND

Trainee Developer

Responsibilities:

●Prepared LLD'S, HLD and test cases according to the Requirement

●Build mappings in Informatica

●Created Stored Procedures

●Unit testing and prepared test evidences

●Worked in UNIX for Configuring Session Properties

●Prepared Autosys scripts

●Involved in QV Support and Integration Testing

Technical Skills

Ab Initio 3.1.6, 3.1.5, 3.0.4, 2.1.3, 1.1.4 – GDE, EME Metadata Hub, Conduct IT & Data Quality, Informatica 8.6.2 & 9.0, Netezza, UNIX Shell Scripting, SQL server 2005, Teradata BDW model, Basics of Mainframe, Datastage, and Autosys.

Education

University of Madras

Bachelor of Computer Application

Pondicherry University

Master of Business Application (Finance)

NIIT Limited

GNIIT Software Engineering

Microsoft Technology Specialist certified

Contact this candidate