Aparna Bhavaraju

Sr. Ab Initio Consultant

Charlotte, NC

Ph: 908-***-****/ e-mail: acsjp9@r.postjobfree.com

Profile

ETL Consultant over ten years of DW/BI experience in financial domain (Banking and Insurance Verticals).

Strong ETL skills (MVS/Ab-Initio/UNIX/DB/Data Modelling) – developing (including upgrading), deploying, migrating/promoting, coordinating development, test and production stages, monitoring, trouble shooting and performance enhancement of Data Warehousing applications.

In-depth experience of participating actively in all phases of the SDLC for an overall solution delivery.

Active interaction with Business Users, Software Development Teams and System Administrators in gathering the requirements and proficient in creating functional and design specifications.

Contributed to IBM’s ICM (Intellectual Capital Management) by submitting re-usable Ab-Initio code that dynamically generates the transforms for normalization.

National Stock Exchange (NSE) Certified in Financial Markets (NCFM).

Ability to perform individually, strong communication skills and high level of motivation. A quick learner with an aptitude for taking responsibilities.

Currently pursuing Coursera’s Big Data Specialization (University of California, San Diego).

Technical Expertise

ETL – Ab-Initio (GDE, EME, Express It (ACE, BRE), Conduct It, Ops-Console, Metadata hub), Informatica Power center (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica Server)

RDBMS - Oracle 11, MS Access 2000

Languages - C, SQL, Perl, Python

O/S - Windows NT/2000/XP, AIX 5.2, HP UNIX, Solaris

Schedulers - Control M, Unicenter, CA7, Autosys

Others – Erwin, hp Quality center, hp ALM, IBM RPM, IBM QMS, Perigrene, Visual Source Safe, PVCS, Vader, SQL Developer, Toad, MS Office Tools

Big Data Ecosystems - Hadoop, MapReduce, HDFS, Hive, Pig, Sqoop

Professional Experience/Projects

DotCom Team, LLC (USA) 05 Feb 2014 – Present

Client – Wells Fargo (Charlotte, NC)

At Wells Fargo, all loan application origination information from MODE (Mortgage operational Data Environment) is extracted, validated and transformed before it is sent to Capital Markets for processing, modeling, analytics and reporting.

– Review requirements with Data Analysts.

– Create POCs for approval.

– Provide estimates for application development/delivery.

– Build generic applications in Ab-Inito ACE (Application Configuration environment) which can be dynamically modified by Business Analysts.

– Build re-usable transformation rules using Ab-Initio BRE (Business Rules Environment) to help business analysts validate and plug the generated transformations in the graphs.

-Analyze data lineage and impact analysis using metadata portal (mhub/metadata hub)

– Promote code across environments using Anthill.

– Collect, integrate, and manage operational metadata from running graphs/plans using Ab-initio Ops-Console to maintain and plan efficient operations.

– Creation of JILs in Autosys to schedule the Ab-Initio jobs.

– Re-use Oracle SQL and packages to retrieve and load data (history and/or incremental) data from operational database.

– Support/Fix bugs when test team conducts system testing/user acceptance that are tracked to closure.

– Track and monitor work progress and assigned tasks using JIRA.

– Directly work with AbInitio Corp Consultants for review, performance tuning and enhancements before code migration.

– Provide KT to Platform support team for code that is newly moved to production

IBM India Pvt Ltd & IBM Corp (USA) 06 Jun 2007 – 23 Aug 2013

Client – SunTrust (Atlanta, GA) Jan 2012 – Aug 2013

Customer Information Systems (CIS) - CIS of Enterprise Client originated as the Operational Data Store (ODS) component of the Information Architecture and has the Total Client View (TCV) requirement of the retail CRM program. The primary purpose for the CIS, as it becomes a mature production system, is to enable a TCV for the business. It will provide this by being the central database hub for Customer Data Integration (CDI) at SunTrust and providing access to this data and information through centrally managed and shared services that are available to any authorized client application.

– Review Business/System Requirements and contribute to development of overall technical design – To read data from various source systems.

– Develop an integral solution in two parts using Ab-Initio, Conduct It, Unix, DB2 SQL.

o INBOUND (which consolidates data from various sources, cleanse, perform quality checks, standardize data using IBM WQS, transform data as per mapping rules and generate XMLs to load DB2 tables using WCC)

o OUTBOUND (which extracts data specific data on daily/ weekly/ yearly basis for updates and is sent to exporter for reporting)

– Conduct dependency analysis in Ab-intio for changes/modifications to the existing code while developing new functionality.

– Fine-tune the code for maximum performance benefits and to reduce the I/O interactions/operations.

– Migrate developed code to test and prod Environments using in-house developed utilities.

– Schedule the designed jobs (Ab-Initio/Unix) using CA7.

– Participate in code reviews with the review board for any code that is being migrated to ensure best practices are carried forward and lessons learnt articulated.

– Break fixes in case production incidents (tracked with ALM), lead analysis & closure of warranty defects.

– Ensure technical environment readiness and support production migrations and knowledge transfer to Production Support Teams.

Client - JP Morgan Chase (Columbus, OH) Jun 2010 – Jan 2012

Regulatory Reporting UK: The objective of the UK Regulatory Reporting Platform Replacement Program is to provide a strategic solution for UK Regulatory Reporting (UK Reg). The Program covers capital adequacy calculations, authority reporting for all FSA Regulated Entities, UK Branches of Overseas Banks, Overseas Branches of UK Banks and all entities captured under FSA Consolidated Groups:

Regulatory Reporting Singapore: As a part of GFT’s (Global Fund Tech) Regulatory Replacement program we are concerned with replacing the existing standalone regulatory reporting architectures with a single strategic solution across regions to handle the data flow from source system to ETL and from ETL to Oracle Reveleus reporting for Singapore.

– Design/Development of common rules framework in Ab-Initio (graphs) with

oReusable rules across multiple feeds.

oReusable rules across multiple regions of Local Regulatory reporting (LRR).

o Reusable rules across programs (LRR and Basel).

– Create centralized Repository of Rules using BRE.

– Design metadata driven approach for invoking the rules.

– Segregate functionality using Ab-Initio Plans in Conduct IT.

– Create Unix wrapper scripts to run the deployed Ab-Initio code (graphs and plans).

– Performance enhancement in both Ab-Initio/Unix and SQL code to leverage maximum benefit of Ab-Initio and to minimize the database interactions.

– Schedule jobs using Control M.

– Responsible for code migration with an in house developed tool – Vader

– Tracking defects and production incidents to closure with hp QC and Perigrene.

– Build centralized repository for loading the various reports like Acceptance / Reject /Filter /Validation Reports.

Client - Bank of Montreal (Bangalore, India) Jun 2007 – May 2010

Enterprise Services – Maintenance and Enhancement/IM Capacity: As a part of this engagement we provide reliable quality data for analysis and decision support purposes to be used by Basel, Insight and Other Data Marts allowing compressed time for Integration by focusing on Core competencies and maintaining Centralized

Data.

– Deliver new and complex high quality ETL solutions using Visio, Ab-Initio, Unix, DB2 SQL to clients in response to various Service/Change requests.

– Developed re-usable Ab-Initio graph that dynamically generates the transforms for normalization.

– Enhance some of the Ab-Initio common utilities and UNIX shell scripts.

– Develop unix wrapper scripts to ensure restartability of deployed scripts.

– Review team member’s work before delivery.

– Responsible for managing scope, planning, tracking, change control, aspects of ETL.

– Involved in effort estimation of all the ETL modules in the project, on the basis of the inputs provided by the customer.

Syntel India Ltd (Syntel Ltd, USA) 18 Nov 2004 – 31 May 2007

Client – AllState (Mumbai, India/ Chicago, IL) Nov 2004 – May 2007

ADW Key Assignment & Maintenance, One Recon:To develop an integrated solution to automate reconciliation of all balance sheet accounts. The solution includes implementation and standardization of reconciliation rules, workflow, electronic document management, and creation of a management dashboard. The integrated solution enables the creation of reconciliation COE and enables global deployment.

– Analyze Functional Requirement, Interactions with End user and Source Programmers for proper business understandings. Member in High & Low Level Design Document creation.

– Development of Ab-Intio graphs to cleanse various source feeds and to bring them into one common format to be fed into rules processor for SAP.

– Creation of wrapper scripts and job schedule for sequential execution through Unicenter during Production

deployment.

– Coordinating off-shore team and helping them resolve issues.

– Responsible for updating Business User with work progress and warn them in case of an impending emergency.

– Production support and Code modifications required to fix the problems during the normal production cycle.

– Root cause analysis and preventive steps for reported defects.

– Come up with feasible risk mitigation plans to resolve or develop work around.

Education

Bachelor of Mechanical Engineering, Osmania University, India Jun 2000 – Apr 2004

Contact this candidate