Radha Krishna

425-***-****

adcmad@r.postjobfree.com

Summary:

Total 18 years of IT experience in Requirement Analysis, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Testing of Database and Data warehousing and Data Marts for Financial, Insurance industry.

13 years of strong Data Warehousing/ETL experience using Ab Initio GDE and EME Continues flows, Plans,

4 years of experience in providing Architecture solution

2 years of Data warehousing ETL with Informatica.

Extensive experience in reverse engineering the existing applications in Java, Sql and Cobol.

One year of experience in UAT Test Support, and code build

Extensive experience loading data and compare target systems like Teradata, DB2, Oracle, Sql server and Netezza

Excellent knowledge of complete data warehouse life cycle, testing methodologies and reporting.

Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema and ODS architecture for modeling a Data Warehouse by using tools like

Extensive knowledge in Data warehouse concepts and methodologies

Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels

Education/Training:

M.S Computers and Systems Engineering, Andhra University 1988.

B.Sc (Engineering), Civil engineering, Regional Institute of Technology, Jamshedpur 1985

Work Experience (In Reverse Chronological Order)

Client: Wells Fargo

Capacity: Application Developer (6)

Location Charlotte NC

Roles and Responsibilities Aug’17 -- Aug’19

Worked many Jira requests to implement changes in current ab initio graphs of existing process

Incorporated changes to CMPL extracts for using the files intraday files changed source system files

Worked on Sybase to oracle conversion for CMPL, GMI, RDI, VMDR ab initio Projects

Converted VMDR Sybase procedures to oracle stored procedures and associated Abinitio Graphs

Developed generic dynamic diff Graph to identify diff in oracle extracts and Sybase extracts to validate conversion process

Created many new auto sys jobs for oracle based extracts and delete old Sybase autusys jobs

Worked on sourcing GPTM Files into oracle tables

Developed common graphs,plans and pset to implement common frame for extract distribution to different clients

Developed Generic Plan extract to generate extract based on table driven

Environment: Ab initio 3.2 Oracle Sybase, Windows, Linux,

Client: Bank of America

Capacity: Application Developer

Location Jacksonville Florida

Roles and Responsibilities July’16 -- Mar 2017

Worked on average 2/3 work requests/ per day t for TQMS team

Enhanced the existing feed copy shell script to accommodate new feed on fly

Worked on deployment of Jira tagging script for month end release and hand over to SSPM team

Worked on Jira to deploy components containing unix scripts. Informatica, DB2 Sql,,Sqlserver Auto sys objects

Mentored for new team member to work on WR and build team of 10 members

Environment: Informatica, Phyton scripts, UNIX Script, DB2, Sql Server, XP .

Client: Florida Blue

Capacity: Application Developer

Location Jacksonville Florida

Sep’15 -- July2016

Roles and Responsibilities

Developed abinitio Graph to recycle unprocessed messages in regular flow of message processing

Implemented R4 changes for Blue square xml messages in continues flows

Developed abinitio graph to generate data quality report for avility messages

Prepared xml test data for Blue square messages for unit test and system test

Crafted ETL Detail Design document form preliminary design documents for data masking Project for offshore team

Analyzed existing code issues for Blue square messages processing

Identified opportunities to improve some of processing in CF, and initiated those improvements in code

Environment: Ab Initio (GDE, Co-Op 3.0), EME, continues flows, xml, Unix, UNIX Script (KShell), DB2,main frame, XP .

Employer: JPMC

Capacity: Application Developer Lead

Location Jersey City

May’13 -- May’15

Roles and Responsibilities

Managed June !4 release with Team of 10 Dev team and 4 designers

Standardized build tracker and trained other on this

Managed to reduce noises in daily team status calls

Analyzed impacts APTP,EMEATP/IFTP, MIS, BASEL, LRI Project Bo servers Upgrade and implemented required changes around 190 interfaces independently

Learned and implemented CTM Jobs Related to Bo servers Upgrade

Implemented strutting mapping documents so that generation of xfr ( code)can be automated for 70%

Implemented new interface form source OMINI with 2 data feeds data into common frame work

Modeled after OMINI interface to get 36 Monthly Olympic feeds in CF

Independently worked on 12 CR for Nov 2013 with minimal issues

Identified opportunities to improve some of processing in CF, and initiated those improvement them

Environment: Abinitio 3.0,EME, Oracle10g,Windows, Linux, Business objects

Client: Citi

Loaction Jersey City Dec’11 – Jan’13

Abinitio Expert

Roles and Responsibilities

Reveres engineered the existing Saturn Project code to elicit the current business logic and mapping rules

Provided Architecture solution web services Graph for POC and helped other teams for implementing web services

Designed and implemented extract and Transform common Graphs .for SMC Product

Developed common graphs,plans and pset to translate SMC data to Secore farmat

Developed Graph to identify the differences in field level from GSM and SMC Data sources

Involved with tem to construct XML Payload to publish messages from DDI Cache for Downstream systems

Worked the Java teams on nailing down the flow for creation of new securities on fly

Worked with other team member to design custom API for temporal implementation

Designed canonical model XML for Data distribution

Analyzed data product coverage and attribute coverage IN SMC and GSM

Created plan and shell scripts loading SOI and lookup related date

Environment: Abinitio 3.0,EME, Oracle10g,Windows, Java, flex

Client: Capital One, Richmond, VA Dec’09 – Nov 11

ETL Specialist

Roles and Responsibilities

Crated shell script to parse existing sql scripts and generated Preliminary data requirements

Worked with EDW abinitio Teams to establish common Projects for all EDW Projects

Developed shared Graphs in common project to Load table like mailing_addr, phone Etc

Crated 90 sets of pset,sql and xfrs to load consumer date into where hose

Created plan and shell scripts to schedule loading all consumer application related date

Leaded research involved data mapping issues and data Steward in UAT region.

Created an extract specification documents, High level design documents and implementation Plans related to consume data

Developed Referential integrity check script in Sql

Created plan to and shell scripts loading all consumer history for application and Applicant related date

Evaluated solutions for XML and flat file based solution for Moody”s ratings file for history

Developed Graphs for parsing loading XML data into reference database for Basel 2 initiative

Environment: Ab Initio (GDE 1.15, Co-Op 2.15), EME, Teradata Sql server, Oracle10g,Windows 2003 professional.

Client: AT&T Bothel WA July 09 – Nov 09

Application Designer/Solution archictect

Roles and Responsibilities

Worked with three different solutions abinitio, informatica and shell scripts and went with shell script solution

Client: VISA FOSTER CITY CA Oct 08 – Jan 09

Sr Abinito developer/designer

Roles and Responsibilities

On site coordinator for 4 abinitio developers in India

Crafted ETL Detail Design document form preliminary design documents for Mars Authorization

Updated the existing plans and Graphs as per requirement

Implemented required changes parent search shell script for MARS project

Implemented required changes for existing insert main shell script

Implemented the required changes for B1-B2 match graphs

Analyzes the change impact of MARS project on ODS, DWAUTH, CMLS, GLOBALS abinitio projects

Implemented the Sftp part for MRCH automation project

Crafted Detail Design document for ETL form functional Specks document for Authorization Result code reporting

Implemented the required change for B1-B2 match

Analyzed the change impact of Au Result Code project on ODS, DWAUTH, CMLS, GLOBALS abinitio projects

Created graph to generated test data for parent search used by QA Team

Analyzed the sizing requirements on FERA related RTNS

Environment: Ab Initio (GDE 1.14, Co-Op 2.14), EME, Plan >It and Conduct >It, Unix, UNIX Script (KShell), DB2,main frame, MVS,Windows XP .

Client: CITI GROUP WARREN NJ May 06 – Jul 08

Sr Abinito developer

Roles and Responsibilities:

Designed, implemented and maintained warehouse load graphs

Developed type 2 change graphs for dimensions such as account, product, and desk

Developed and rolled out ETJ –EQDW reconciliation project

Developed and rolled out graphs for loading landing, staging and fact tables

Developed Perl programs to parse Fix4.2 data,log files from smart server

Developed many shell scripts for system health check of systems

Worked on many projects to enhance spectrum of data

Mentored production support, Autosys Jil, DDL, Ab Initio, and UNIX package promotions to India, Brazil Teams

Developed stored procedures for partitioning tables on all schemas in GEDW

Developed many shell scripts to send statues reports, compliance mails and pull data from various sources

Initiated and stabilized UAT environment for production parallel run to have integrated QA data .

Responsible for the automation and production deployment of Ab Initio Graphs using Korn shell scripts

Developed many ad hock graphs for data quality, data spectrum enhancements, query retrieval analysis

Created and maintained autosys Calenders,Cycle boxes

.Environment: Ab Initio GDE 2.14, EME, autosys Unix solaris, linux Toad, UNIX Script (KShell), Oracle 9i/10g,Windows XP .

Client: BankOne Wilmington DE Ab Initio Developer Apr 05 –Mar 06

Roles and Responsibilities:

Designed and developed on enterprise privacy module for upgradations by adding Ab Initio graphs and analysis of logs

Maintained circuit city privacy module

Developed log analysis methodologies for Quality assurance purpose.

Developed and maintained Texas conversion project in merger project of bank one and Chase

Written and analyzed several Custom Components and called in Ab Initio.

Developed and Responsible for maestro Job scheduling implementation

Involved in writing Stored procedures to access data from Oracle 9i.

Environment: Ab Initio (GDE 1.12, Co-Op 2.12.2), EME, Tivoli, Unix AIX, Sql Developer Sql Navigator, UNIX Script (KShell), Oracle 9i,,Windows 2000 professional.

Harte Hanks Inc. Boston MA Nov04– Apr 05

Ab Initio Developer

Performing transformations of source data with Transform components like Join, Sorted, Dedup Sorted, Denormalize, Reformat, Filter-by-Expression, Rollup etc.

Designed and implemented sub graph for Record count for load balancing

Developed initial and incremental load graphs for 11 dimensions.

Developed data validation Graph for validating 200 info_usa source data files

Developed wrapper scripts for loading fact tables and load status tables

Develop and modify several application scripts in UNIX in order to pass the environment variables and to implement run controls for various graphs

Involved in writing Stored procedures to access data from Oracle 9I.

Developed QA scripts to generate report from table logs.

Responsible for cleansing the data from source systems reporting the data quality levels on file-by-file basis using Ab Initio.

Environment: Ab Initio (GDE 1.12, Co-Op 2.12.2), EME, Data profiler, Linux, Unix, Pl-Sql Developer Toad, UNIX Script (KShell), Oracle 9i,E-Piphany, Windows 2000 professional.

Client:Allstate, Chicago, IL Aug 04 – Sep’ 04

Ab Initio Developer

Developed 90 Xfr for various components like scan, rollup, join, reformat Components of Ab Initio.

Developed 8 parameterized graphs witch will cater for transformation of 55 tables

Generated Dml s from Cobol copybooks for various graphs

Implemented the Parallel application by replicating the components- datasets and processing modules into number of partitions.

Analyzed many Cobol programs and JCL.

Developed wrapper scripts for loading fact tables and load status tables

Strong experience loading data into target systems like main frame DB2, Oracle

Replicate operational tables into staging tables, Transform and load data into warehouse tables using Ab Initio GDE and responsible for automating the ETL process through scheduling and exception-handling routines

Environment: Ab Initio (GDE 1.12, Co-Op 2.12.2), EME, Ab Initio Web, HP-UX, Toad, COBOL, MVS,, UNIX Script (KShell), Oracle 9i, Test Director, Windows 2000 professional.

Contact this candidate