Project Developer

_Top of Form

Houston, Texas

Contact

Number: 832-***-****

Aruna Tharangan

*****.*********@*****.***

SUMMARY

. Abinitio Professional with 6 years of work experience in Abinitio

Design, Development and Testing of complex graphs processing very high

volume of data.

. Certified by SAS Institute as "SAS Certified Advanced Programmer " -

2nd Level of Certification in SAS Analytics and Reporting Tool..

. Certified by Oracle as "Oracle Database 11g: SQL Developer".

. Expert in using Ab Initio ETL tool for implementing extensive

transformations and mappings.

. Worked on almost all phases of Data Warehouse development including

gathering business requirement, logical and physical data modeling,

designing Ab-Initio - ETL architecture, development of Ab Initio

graphs, job scheduling in Autosys, unit testing, peer review, bug

fixing and production support.

. Have extensively used Ab-Initio components such as REFORMAT,

NORMALIZE, ROLLUP, SCAN, JOIN, WRITE MULTIFILES, REFORMAT, LOOKUPS,

DENORMALIZE, FTP, GATHER, MERGE, SORT, Join with DB, Assign Keys

etc

. Hands on Experience in Developing, Testing Rules using Abinitio's

Advanced Utility - BRE. Trained the team on Using BRE.

. Worked extensively on various problems related to complex JOINs,

delimited vectors, fixed length vectors, data length vectors,

READ/WRITE Excel component to handle the incoming data.

. Extensive knowledge in EME, checkins, checkouts, command line

interface, air commands and Dependency analysis.

. Have Designed graphs to load Datawarehouses and Datamarts. Have loaded

tables to provide Daily, Monthly, Yearly snapshot of data.

. Have written Basic queries in Teradata to Extract, load and update

data.

. Hands on experience in loading of Data Warehouses/Data Marts using Ab

Initio Co>OP, GDE, Component Library, Oracle and UNIX for mainly

Banking/Financial industries.

. Experience in Data Warehousing concepts like Dimensional Modeling/

Kimball Methodology, Star Schema, Snowflake Schema and ETL.

. Experience in migrating applications in EME Datastore from one

environment to another.

. Experienced in interacting with EME Data store with several air

commands.

. Have worked on SSH Keys setup (private/public key setup) between

servers for SFTP/SCP.

. Experienced in creating tags and doing checkout from the UNIX

environment for code migration from DEV to UAT and UAT to PROD.

Familiar with creating d - tag and r-tag for code migration.

. Extensive knowledge and work experience in creating and scheduling

AUTOSYS JILs and creating BOX wherever required with various

conditions and dependencies. Also familiar with the AUTOSYS commands

like SENDEVENT, AUTOREP etc. to work in AUTOSYS environment.

. Experienced in development of CONTINUOUS graphs.

. Experienced in using m_eval and m_db effectively in wrappers to

Insert and Update Job status into Job status tables. Generate

exhaustive Run statistic reports by extracting data from those

tables.

. Experienced in Developing an Abinitio Application that can handle any

Input file layout, do the user mentioned processing and create output

files .Before every run the user can change these specifications.

Based on an excel filled by the client, this application will include

mentioned fields in specified formats with specified file names

including dates in specified format.

. Well versed with various Ab Initio parallelism techniques and

implemented number of Ab Initio Graphs using Data parallelism and

Multi File System (MFS) techniques

. Experienced in integration of various data sources such as Flat files,

Excel files, CSV files, Unstructured Adhoc files, ASCII, EBCDIC files,

XML files, DB tables etc.

. Also experienced in working with Mainframe Data Files, COBOL Copybook

. Well versed in UNIX shell commands and wrapper scripts. Have written

Wrappers that enable parallel processing of generic jobs and also

enable automatic queueing of jobs.

. Excellent analytical, interpersonal and communication skills with

aptitude to assimilate new technologies.

. Excellent ability to work in groups as well as independently with

minimum supervision. Have taken an initiative to learn new

technologies and tools quickly.

Technical Skills:

Operating Systems UNIX, LINUX, and Windows NT/2000/XP/Vista

Languages SQL, Unix Shell Scripting, C, Java, J2EE, PHP.

Databases Oracle, MS SQL Server, Teradata

ETL Tool Ab-Initio, SAS, Talend, Informatica.

Utilities AutoSys, Erwin, Visio.

CERTIFICATION

[pic]

Sas certified Base programmer Sas certified Advanced

Programmer

[pic]

Oracle Certified SQL Developer

Professional Achievements

. Received Performance Excellence Award from client Capital one in 2007

for Charger project.

. Received E- award from HP for Successful execution of Calendar

Project.

. Received E-award from HP for Successful execution of Positions

Project.

. Received E-award from HP for Successful execution of Recon Project.

Professional Experience

Walgreens

Abinitio Consultant

Dec 2011- Present

Merchandise Portal

Responsibilities

. Understood the Datamodel developed for maintaining data at different

granularities across various dimensions within a short time.

Understood how efficient storage and retrieval of data was getting

done.

. Understood how Sales data can be analysed with respect to various

dimensions like User, vendor and Products.

. Designed and developed graphs to load the tables in Merchandise portal

Data model.

. Documented and shared the understanding with team mates.

. Gained understanding of Logically complex Oracle queries used in the

application.

Environment: Abinitio GDE 1.15, Co Operating System 2.157, Unix, Windows,

Oracle 10g, Autosys

Citigroup Corp, NJ

Abinitio Developer

Feb 2010 - Sep 2010

Risk Portal

Responsibilities

. Analyzed Existing systems

. Understood the perl scripts, Unix wrapper scripts.

. Documented and shared the understanding with team mates.

. Gained understanding of Oracle queries used in the application.

. Consolidated the functionality of every module given, and tried to

trace back the requirements.

. Prepared the Requirements document.

. Designed Abinitio graphs to implement the ETL Part.

Environment: Abinitio GDE 1.15, Co Operating System 2.157, Unix, Windows,

Oracle 10g, Autosys

Citigroup Financial Services, NJ

Abnitio Developer

Aug 2009 - Jan 2010

Star UI

Responsibilities

. Created the Mapping document by translating all Business requirements

into metadata names.

. Learnt BRE Usage and environment

. Developed "Fin Risk Link ID assignment" Module in BRE

. Created Input, Output and Lookup variables in BRE environment for all

the 54 Rules in BRE.

. Created 54 BRE rules to assign values to Fin Link id and Risk Link id

based on its respective rule number.

. Tested 54 rules that implemented "Fin Risk Link ID assignment" inside

a generic graph, by creating sample data that covered all scenarios

mentioned in every rule.

. Performed SIT to validate the rules and find gaps if any.

. Implemented the change requests to fill in the gaps that were present

in the requirements, and performed testing.

Environment: Abinitio GDE 1.15, Abinitio BRE, Co Operating System

2.157,Unix, Windows, Oracle 10g, Cognos, Autosys

Citigroup Financial Services

Abinitio Developer

Jan 2008 - Aug 2009

Recon

Responsibilities

. Designed and developed Abinitio graphs for highly complex and hard to

handle scenarios.

. Coordinated and Worked in parallel on multiple modules of the project.

. Worked hand in hand with the Users and other partners to get

requirements/changes, fix it quickly and do testing.

. Handled Very high volume of data efficiently and in a robust way.

. Received more than 50 files daily, successfully handled the risk of

any file being received twice on the same day.

. Performed checks to ensure that no file was missed without processing

well in time, so that files can be asked to be resent from source

system.

. Tracked every run of Job and had checks to ensure that no job was

rerun.

. Designed and Created datamodel to maintain Job run statistics which

included the jobs run for a day, number of times a job ran, job start

and end time, job status etc. and Record count statistics which

included the number of records in input, output, the records that

satisfied the necessary match conditions etc.

. Populated Job status and RecordCount statistics table for every run on

failure or success of the run.

. Implemented parallelism in graphs to handle heavy volume of data.

. Created Wrappers to do everyday cleanup including Index rebuild,

Database bouncing etc.

. Created 100s of JILs to successfully receive and process the files

that were received throughout the day.

. Created BOX JOBs and appropriate dependencies to make them run in

parallel and meet the SLA everyday.

. Had appropriate Alerting mechanisms to mail the concerned group of

users on receiving a corrupt file, not receiving the file, any delay

in processing the file or on having successfully sent the file to

target.

. Generated various kinds of reports that had many complex calculations

involved and sent to the required users by mail, excel.

. Tested the graphs in Modular Testing, System Testing phases and

debugged the graphs to solve the issues raised.

. Monitored the Autosys jobs in production during the warranty period.

Environment: Abinitio GDE 1.14, Co Operating System 2.14,Unix,

Windows, Oracle 10g, Autosys

Citigroup Financial Services

Lead Developer

Aug 2007 - Jan 2008

As a Lead developer, trained my team mate on Unix, Abinitio and developed

this Project. This Project was aimed at generating Customer Files for more

than 200 Customers dynamically. Customers wil provide their requirements

filled in excel sheet in a predefined format, and this project will

generate dmls, xfrs required to generate Customer Files and generate them.

The generated files will be ftped/sftped to their respective Customer

Servers.

Responsibilities

. Explained and coordinated the team in understanding TDD

. Trained teammate on Unix and designed, developed Unix wrapper in a

highly efficient and robust way.

. Validated and Created Config file that had all the Customer's server

name, authentication method and authentication credentials.

. Developed generic graphs that will do the customer required

functionality based on the parameters passed.

. Developed wrappers that will enable multiple instances of same generic

graph using AB_JOB_PROXY parameters.

. Tracked the job status of jobs that ran in parallel by recreating the

Abinitio generated Error and Log file name(Used $AI_LOG_FILE,

$AI_ERROR_FILE, $AI_DATETIME etc parameters) and by checking for a non

zero byte error file name.

. Used air sandbox run commands to run some graphs by invoking their

psets.

. Developed the graphs and incorporated changes in design, code with

respect to requirement changes.

. Tested the graphs in Modular Testing, System Testing phases and

debugged the graphs to solve the issues raised.

. Created AUtosys JILS to schedule all the jobs.

. Monitored the Autosys jobs in production during the warranty period.

Environment: Abinitio GDE 1.14, Co Operating System 2.14,Unix,

Windows,Oracle 10g, Autosys

Citigroup Financial Services

Offshore Lead

Apr 2007 - Aug 2007

Calendar

As a Lead, initiated and coordinated the First Abinitio Project for Hp

India with a team of 9 freshers and one Solution Architect. This project

was developed to provide Calendar information to downstream consumers.

Calendar Information was maintained across several Exchanges, Countries,

Currencies, Process Centres etc. Any change in Holiday dates/information

across all these dimensions has to be captured and updated in DB. It

extends the distribution capabilities by creating a messaging framework in

XML to allow for near real-time updates of financial holiday.

Responsibilities

. Worked with the data modeler in understanding and coming up with ideas

to implement the Data model for Calendar Project.

. Designed graphs to load Datawarehouse and datamart tables based on

requirements.

. Analysed Source data extensively so that the challenges related to

data coud be faced easily.

. Explained and coordinated the team in understanding Technical Design

Document.

. Conducted training and brainstorming sessions on Abinitio to a team of

9 freshers all new to Abinitio.

. Distributed and coordinated the development work that was sent to

offshore.

. Worked on Continuous graphs, Used XSD to create XML data and published

it to a JMS QUEUE.

. Developed the graphs and incorporated changes in design and code with

respect to requirement changes.

. Designed and developed Wrappers to run the graphs designed.

. Tested the graphs in Modular Testing, System Testing phases and

debugged the graphs to solve the issues raised.

. Created Autosys JILS to schedule all the jobs.

. Monitored the Autosys jobs in production during the warranty period.

Environment: Abinitio GDE 1.14, Co Operating System 2.14,Unix,

Windows, Oracle 10g, Autosys

Capital One, VA

Abinitio Developer

July 2006 - Jan 2007

Bradshaw (Armstrong Re- engineering)

As a developer of this project developed and assisted in re engineering the

existing Armstrong which was developed by Capital One IT and failed to meet

its functional requirements due to some design flaws .Since Armstrong was

not able to serve its purpose, it came to Wipro for Reengineering. It is an

end to end data warehousing project with a very high level of complexity

involved in design and development.

Responsibilities

. Understood the Datamodel of Datawarehouse and Datamarts.

. Designed graphs to load Datawarehouse and datamart tables based on

requirements.

. Analysed the source data, available fields and helped Team Lead in

coming up with the Mapping Document.

. Helped Designers in designing performance efficient Abinitio graphs.

. Developed graphs as per Technical design Document.

. Lead the LO module in development.

. Performance tuned the graphs wherever possible to make it meet the

stipulated SLA.

. Developed Unit Test cases and performed Unit Testing.

. Implemented changes in design and code as per Change Request received.

. Worked strenuously with the SIT and UAT team in resolving their

queries and finding gaps.

. Tested the graphs in Modular Testing, System Testing phases and

debugged the graphs to solve the issues raised.

Environment: Abinitio GDE 1.14, Co Operating System 2.14, Unix, Windows,

Oracle 10g, Autosys

Capital One, VA/ India

Abinitio Developer

Apr 2006 - July 2006

Armstrong Debugging

As a tester, bug fixer was involved in doing test runs and debugging the

issues/bugs faced in the Client's Project which had gone live but failed to

meet its functional requirements. The Aim of this project was to solve the

complex issues which were faced when Armstrong went live. This was a Non

Compliance project (done by Client, Capital One IT Team) and the Production

issues faced were of very high severity and had to be fixed within the

given short stipulated time.

Responsibilities

. Analysed and understood the functionality of graph given.

. Edited sample data provided by client to test all the branches in the

graph.

. Got sample lookup files from client and tweaked them to match the

various scenarios.

. Executed sample runs and documented the observations.

. Used Filewatchers and Intermediate files as required to analyse data

after every component.

. Successfully solved all the issues that were of varying complexities

and criticalities in functionally complex graphs.

. Wrote queries in Teradata to extract and test Load target tables.

. Trained two Informatica professionals in Abinitio and lead the team to

resolve the issues assigned within the stipulated time.

Environment: Abinitio GDE 1.14, Co Operating System 2.14, Unix,

Windows, Teradata, Autosys

Capital One, India

Abinitio Developer

Dec 2004 - April 2006

GFS -Charger

As a developer of the Project Charger, assisted in implementing an

infrastructure solution for the Installment Loan Business by outsourcing

significant components of the loan origination and servicing value

chain(systems and business processes to one or more vendors),thus enabling

the Installment Loan business to reposition itself strategically. The

streams in this project are: Originations, Servicing, and Finance.

Responsibilities

. Used REFORMAT/JOIN/ROLLUP etc components.

. Used various string Validation and Standardization functions.

. Developed simple graphs that performed Data Cleaning, Validation and

Standardization following the clients Design standards.

. Got exposure to understand the AI_SERIAL and AI_MFS parameter and

layout in Ab-initio.

. Learnt how to use m_eval and m_db utilities available in Abinitio.

. Worked on improving the performance of Ab Initio graphs by using

various Ab Initio performance techniques such as using Lookups or

Joins, In Memory Sort or a Sort required option etc.

. Involved in creating Fixed length, delimited Flat files using dataset

components like input file, output file, and intermediate file in Ab

Initio graphs.

. Involved in documenting Client specific AB Initio Coding and Naming

standards.

. Learnt How Version Control is implemented using Abinitio.

. Understood the parallelism concepts and its usage in Abinitio.

. Developed wrapper script for the respective graphs

. Learnt to understand and write simple queries in Teradata while

interacting with target tables in Load graphs.

. Framed the Detail design document for the graphs

. Framed the Test case Documents and tested the graphs.

Environment: Abinitio GDE 1.14, Co Operating System 2.14, Unix,

Windows, Autosys,Teradata

Educational

. B.Tech in Information Technology - Anna University, Sri Venkateswara

College of Engineering, Sriperumbudur, India.

ACADEMIC ACHIEVEMENTS

. A Gold Medal, cash prize and a memento from IIPE for scoring centum

in Higher Secondary MATHS and excellent performance in TNPCEE.

. Cash Prize from RTC and Adarch Vidyalaya for Academic performance in

Higher Secondary.

. Won First and Second prizes in Creative Writing-College Culturals.

Contact this candidate