Ramya Gnanaprakasam

336-***-****/336-***-****

aderif@r.postjobfree.com

****,****-*,*** ****** Road

Greensboro,

North Carolina,

27410

Summary

12+ years of experience in IT industry with experience in the total life cycle of Software Development Applications involving Requirements, Design, Analysis, Development and Testing

8+ years of experience in Data Warehouse projects, Development and Testing using Ascential DataStage and IBM Infosphere Datastage 7.5/8.1/8.5/9.1/11.3 Server & parallel jobs

2+ of years of experience in DQ(Data Quality) data rule development using IBM Information Analyzer 11.3 and 11.5. Hands on experience in effectively handling the Team & guiding the team to deliver the tasks on time.

Experience in Talend Data Integration and Knowledge on Talend Big data Integration(Talen Open Studio 6.3)

Experience in using tFileDelimitedinput,TFileDelimitedOutput,tMap,tLogRow,tFixedFlowInput,tJoin,Perspectives,Context Variables,tDie,tWarn,tRowGenerator,tCreateTable,tMySQLInput,tMySQLOutput,tSortRow,tUniqRow,tAggregateRow,tWaitForFile Components.

Thorough understanding of the SDLC with proficiency in mapping business requirements, technical documentation, design and development.

Expertise in working with relational databases such as SQL Server 2012/2008 Oracle 11g/9i.

Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server.

Experience in using CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.

Experience in using SSIS tools like Import and Export Wizard, Package Installation and SSIS Package Designer.

Experience in importing/exporting data between different sources like SQL/text/Excel/Oracle etc. using Datastage and SSIS utility.

Worked on DataStage clients tools DataStage Designer, DataStage Director, DataStage Administrator and Multi client Manager.

Used both Pipeline Parallelism and Partition Parallelism for improving performance.

Worked on IBM Infosphere Information server console for creating data rules.

Experience in Designing, Compiling, Testing, Scheduling and Running DataStage jobs

Excellent experience in using complicated Stages like change capture stage,XML input and XML output.

Have performed POC on Hierarchical stage to handle XML and JSON files.

Certified IBM Infosphere Datastage and Talend Data Integration developer

Expertise in writing UNIX scripts and experience with scheduling of shell scripts using Tivoli/Control-m/AUTOSYS/CA7.

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

Experience in all Testing Phases: Unit testing, Integration Testing, Regression testing, Performance testing.

Implemented Slowly Changing Dimensions in the datawarehouse projects.

Extensively Implemented Exception Handling Concepts, Testing, debugging skills and Performance tuning of targets, sources, transformation logics, extensively used clearcase and MKS Integrity version control to promote the jobs.

Good communication, interpersonal and presentation skills.

Excellent work ethics and quick learner.

Willing to learn, adapt new technologies and third party products.

Seeking a challenging position in an environment that will allow me to utilize my professional and interpersonal skills.

Excellent understanding of the SCRUM framework and implement the complex Agile requirements using Agile methodologies.

Technical Skills:

Data Warehouse

Ascential DataStage 7.0/7.5.X, IBM WebSphere DataStage 7.5/8.0/8.1/8.5/9.1,IBM Infosphere Datastage 11.3

Information Analyzer 11.5(Thin and Thick Client)

Talend Open studio

Languages

SQL, PL/SQL, SQL*PLUS, XML,Python

Database

Oracle 10g/9i/8i/

PL/SQL, UDB DB2 9.1/9.7, SQL Server 2012/2008,SSIS

Dimensional Modeling

Star Schema and Snow- Flake, Fact and Dimensions

Operating Systems

Windows 2000/ NT/ XP/ Vista/98/ 95, Windows server 2008/2003, UNIX.

Others

Lotus Notes, MS office Tools, Scheduling tools(Autosys,Contol-m,CA-7),Jira, Sharepoint, HP ALM,Rational Clearcase,MKS Integrity,Excel VBA

CERTIFICATIONS

IBM Certified Solution Developer - InfoSphere Datastage 8.5

Certified Scrum Master

Talend Data Integration v6 Certified Developer

Sterling certification from Sterling Commerce- Distributed Order management

Mongo DB certification-M101P: MongoDB for Developers

ACCOMPLISHMENTS

Experience in Datastage and information Analyzer from Design to Code deployment.

Successfully handled Datastage MDM project single handedly from offshore working directly with clients.

Make Your Own Award by Harvinder Singh Raina for Excellent team effort (Lloyds Bank) from Wipro Technologies

Feather In My Cap award for Excellent Project Delivery in AOC Project(Lloyds Bank) from Wipro Technologies

TD & IBM 2016-Special achievement certificate for my commitment and exhibiting strong technology skills in the ETL space of ICDS portfolio which led to successful delivery of MDM UCID project.

Received TD client appreciation certificate for the dedicated work in CRS project.

Academic Qualifications

Bachelor of Engineering in Mechanical Engineering.

Professional Experience:

IBM India Private Ltd,India(Bangalore)

Data Management specialist June’18-Dec’19

Description:

Worked as a Data Management specialist for Toronto Dominion Bank client from IBM. The bank receives customer data from various sources like TDW and Customer Link. Datastage used to be the interface between the datasource and the MDM server. OCDO project in TD performs the Data Quality check using IBM Information Analyzer.

Develop and Deploy Data Rules and Data Rules Definition as a part of Data Profiling using IBM Infosphere Information Server.

Handled all the Agile requirements of the OCDO projects at TD Bank.

Lead the MDM Datastage project for TD Bank from offshore. Handled the design requirement, development and Code Review of the project.

Work on creating mapping documents from business requirements and designed the ETL specification documents

Deploy Datastage jobs and fine-tune them by implementing best practices, Environment variables, parameters and following naming standards

Perform performance tuning of the jobs by interpreting performance statistics of the jobs developed.

Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs.

Ensures timely delivery of the projects.

Performed CM audit,Product reviews and Process audit for the ETL projects.

Company sponsored the Talend training and had completed the certification of Talend Data Integration v6 Certified Developer

Worked on a Talend project proposal to migrate the Datastage projects to Talend. I had worked on job flow that reads the feed from source,perform the ETL mapping and transformation and then loads it into the oracle DB.

Have used the best practices, context variables for the Talend development.

Have gained Big Data Integration knowledge and have hands on experience on the concepts.

Environment : IBM Infosphere DataStage 11.3,IBM Infosphere Information Analyzer 11.5, SQL, Unix, Oracle 10g,DB2,CA-7,ALM,JIRA,Talend Open Studio

IBM India Private Ltd,India(Bangalore)

Data specialist Sep’14-Jun’18

Description:

Worked as a Data specialist for Toronto Dominion Bank client and Prudential Insurance from IBM. The bank receives customer data from various sources like TDW and Customer Link. Datastage used to be the interface between the datasource and the MDM server. OCDO project in TD performs the Data Quality check using IBM Information Analyzer. Prudential Insurance client had the datawarehouse (EDW) receiving data from various data sources. Slowly changing dimensions Type 2 was implemented in the EDW datawarehouse.

Worked on creating mapping documents from business requirements and designed the ETL specification documents

DataStage will put MDM compliant XML’s in Landing Zone and MDM will take these files as input for MDM Batch Processing. Quality Stage is used for Name and Address Standardizations.

Participated in all phases including Requirement Analysis, Design, and Coding, Testing, Production support and Documentation

Analyze the existing informational sources and methods to identify problem areas and make recommendations for improvement. This requires a detailed understanding of the data sources and researching possible solutions.

Got in touch on a regular basis with Business to understand the requirements clearly.

Developed Excel based Utilities to perform redundant functionalities in the project that had saved a lot of time and resource. These were the value adds provided to the organization.

CSM Scrum Master trained and certified.

Trained in Podium tool by Podium corporation.

Been a part of CM Audit, Product reviews and Process audit for the ETL projects.

Performance tuning techniques for Datastage projects.

Created value add reconciliation report to summarize the source, error and target count and send out an email to the business

Worked in the smoke, shakedown and regression testing for the CRS project single handedly from offshore with no onsite counterpart. Have received appreciation from the Customer for my performance and dedication.

Creating SSIS Packages to read data from third party vendor feed which comes in csv format and import the data to staging area for further process.

The packages created included a variety of transformations, for example lookup, Aggregate, Data Conversion etc.

Created SSIS Packages to perform filtering operations and to import the data on daily basis from the feed file to staging DB to data base tables and process them.

Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and to implement business rules.

Package deployment using SSIS Tool

Environment : IBM Infosphere DataStage 11.3, SQL, Unix, Oracle 10g,DB2,Autosys,ALM,SQL Server 2008/2012,SSIS

Wipro Technologies,India(Bangalore)

Senior Software Engineer Nov’11-Sep’14

Worked in Central portfolio of LBG(Llyod’s Bank group). Also worked in APRA project at ANZ bank(Australia and New Zealand Bank)

SME(Subject matter Expert) and Designer in Llyods Bank project.

Received a PCSAT of 7/7 for the AOC project from client during client visit(Lloyds Bank) from Wipro Technologies

Worked in projects from Requirement gathering phase to support handover phase.

Done Quality check by performing code review of the projects and documented the reviews for audit.

Designed and developed shared containers for the Datastage jobs to perform redundant functionality.

Designer and Developer in APRA project at ANZ Bank

Designed and developed ETL processes using Datastage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.

Used Datastage stages namely, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.

Developed job sequences with proper job dependencies, job control stages and triggers.

Developed logging and Exception Handling mechanisms for the Datastage jobs.

Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Developed UNIX shell scripts to automate the Data Load processes to the target

Performance Tuning of Jobs, Stages, Sources and Targets.

Created PL/SQL Procedures/Functions to build business rules to load data

Environment : IBM WebSphere DataStage 7.5/8.0/8.1, SQL, Unix, Tivoli Scheduling tool, Clearcase, Oracle 10g,SQL Server 2008

Tata Consultancy Services,Uruguay(Montevideo)

Onsite Co-Ordinator Feb’10-Jan’11

Worked for Target Corporation handling the AS400 applications like Mozart and Pacman.Also EDW datawarehouse applications.

Direct client appreciations for effectively handling critical problems.

Provide technology and business related trainings for Uruguay associates. As it had been a new location opened by TCS, we were selectively sent to Uruguay to handle clients and train local associates.

Onsite primary oncall for AS400 Applications(Mozart and WMS) and Target.com EDI.

Involved in developing ETL Process to Load the Data from the Production Databases to the Data Warehouse using Data Stage.

Created Data Stage jobs, batches and job sequences and tuned them for better performance.

Extensively used Transformer, Join, Sort, Merge, Filter, Oracle enterprise, Aggregator, DB2 and remove Duplicate Stages.

Provide suggestions for fixing the issues permanently through problem management and thereby work towards stabilization of the applications.

Have acquired expertise on the usage of QPASA and Message broker toolkit.

Environment : Ascential Data Stage 7.x, Oracle 9i/8i, UNIX, AS400

Secure CRT,Putty,SQL Developer, Control-M,Informix,CL,RPG

Tata Consultancy Services,India(Chennai)

System Engineer Jun’07-May’11

Application ownership for Integrated system applications.

Target.com EDI (TCE)-This is an EDI interface between the vendors and Lawson (Check payment application).This involves the datastage tool for performing the validations and reporting, with Oracle DB at the backend.

eDW- The main business objective of Sales and Accounting is to provide the daily transactions like sales, returns etc. across all the target stores and target.com. The data is being used by business users for reporting using Cognos Reporting tool. Datastage is used as an ETL tool.

Sterling OMS is used for Order Management part of Target.com which handles key functionalities like Order capture, Order allocation, Order release to FC’s, Inventory management between FC’s and Site, Payment authorization, Tax calculation, Fraud validations. Sterling Purchase Order module is used for replenishing Target’s own FC’s by cutting the Purchase Orders to Vendors.

Have gained sterling knowledge by attending 10 days sterling training from Sterling Commerce(Bangalore).Have been TCS representative for attending the training along with Target INDIA trainees.

Have acquired hands on training on Distributed Order Management.

Designing of service component within the Yantra Service Framework.

Validating the component design documents HLD’s and DLD’s.

Performing Functional testing and providing technical solutions.

Created datastage jobs to send the purchase orders to downstream systems.

Extensively used Transformer, Join, Sort, Merge, Filter, Oracle enterprise, Aggregator, DB2 and remove Duplicate Stages.

Prepared UTC’s for all possible scenarios and has done testing for them

Used Control-M Scheduler to schedule the Datastage jobs

Excessively used DS Director for monitoring Job logs to resolve issues.

Environment : Sterling platform, Oracle, Unix, Ascential datastage 7.5

Secure CRT, Putty, SQL Developer, IBM message broker toolkit, QPASA, WMQTOOL, Sterling console

Contact this candidate