RESUME

Name: BHUVANESWARI SARAVANAN.M VISA Status: Green Card

Email Id: ad1mf3@r.postjobfree.com Contact No: +1-614-***-****

LinkedIn:https://www.linkedin.com/in/bhuvana-bhuvi-577ba259

Professional Summary:

Having 11 yearsof IT experience in application development and Implementation of Data warehousing, Data migration projects Using Data Stageand Informatica.

Around 10+ years of experience inInformaticaPower Center 9.x/10.1/10.2/10.4.1, SQL Server/Oracle DB scripting.

Have good experience in Informatica data Quality (IDQ), Informatica Alanyst, Informatica Administrative Monitor, Informatica DEI and Informatica Cloud.

Sufficient mentorship experience in driving the peers towards better productivity and consistency

Client / Customer facing experience – with active involvement in the technical and organization discussions and contributed with innovative ideas and empathize on the implementation of maintenance of standards

Worked on diverse source systems from conventional to the state of the art Cloud and Bigdata, because of the constant flexibility and adaptiveness was able to accommodate across facilitating technology as well as Leadership roles across multiple domains (Healthcare,Insurance, Retail, Retail Banking, Travel Industry)

Coding and Building java archive files as per the requirement across vendors, facilitated complex batch processing requests in the form of payload (json files).

Have working experience on latest Informatica transformations for calling Mulesoft API’s using HTTP transformation and Rest Call. Also worked on web service jobs to call the Informatica jobs through UI interface.

Adopted into latest cloud technologies like AWS and have fair knowledge on Snowflake and Python 3.6.

Have fair understanding on Snow pipes, Time Travel, Cloning,Clustering, Virtual warehouse, Credit Score,Partitioning and resource monitor.

Created snowflake database, warehouse for learning. Fair knowledge on how to work in snowflake by connection to AWS or Azure system and read data from them.

Aware of most common libraries used in Python and data science concepts like EDA, Data cleansing and few popular algorithms like decision tree, linear regression Knn( nearest neighbor) algorithm etc

Working in Agile projects and with a scrum team. Involved in PI planning.

Have good knowledge in UNIX scripting for Informatica development.

Working knowledge of Software Development Life Cycle (SDLC), having thorough Understanding of various phases like Requirements, Analysis/Design, development and Testing.

With the amount of experience acquired,have always been a bridge for the team to facilitate technology vs business need, performance tuning, code quality Gate keeper by strict adherence to coding standards and checks

Always willing to adapt to challenges and evolves better through challenges

Handling four members team and leading them. Good team player and team lead.

Good experience in multiple ETL tools SSIS,ODI, Data Stage and Informatica PC,IDQ.

Technical Skills:

ETL Tool

Informatica DEI 10.4.1,Informatica Power Center 10.4.1,Informatica analyst, Informatica Administrator Monitor

Scripting Language

Unix, Python 3.6

Cloud Datawarehouse

Snowflake

Databases

ORACLE 9i/10g and SQL Server 2005/2008/2012/2016.

Migration Tool

Git 2.33, Service Now

Operating Systems

Windows XP/NT/2000, UNIX

Projects Experience:

Project #1

Project Name

Tapestry

Start Date

Jun 2022

Organization

Wipro, USA

End Date

Current

Project Location

North Carolina (Remote from NC)

Team Size

10

Project Description:

Its all about supporting the Business by making sure existing process / Jobs are running without any issue 24/7.

Role / Responsibilities

Technical Lead

Contribution:

Inestigate the failure and act accordingly on a timely manner.

Suporting the team and provide guidance on P3,P2 and P1 tickets.

Supporting the client by provide some enhancement ideas and deliveries.

Responding the Emails on time and be a part of root cause analysis.

Helping team to improve knowledge on the existing system.

Implements the new process in the system to follow the Supporting Guidelines.

Manage the team members and Meet with Client directly for any support and questions.

Approves the deployment done by Development team

Environment:Informatica BDM/DEI 10.4.1 On Unix System, XML system, SAP Hana tool, Flat files system, Service Now, Oracle, MFT file tansafer system, Snowflake

Project #2

Project Name

SunTrust

Start Date

Jul 2021

Organization

Infosys, USA

End Date

May 2022

Project Location

North Carolina (Remote from NC)

Team Size

23

Project Description:

Migrate the data from native system to Data lake.

Role / Responsibilities

Technical Lead

Contribution:

Ingest the data to Hive from native source system using the ingestion process.

Agile Methodology – 2 weeks delivery span.

Prepared all required documents.

Created Curator process using Informatica DEI to read the data and move to Hive.

Pre-processed the files before Extraction process.

Adhered to the exiting process of the client development and migration.

Handled the code merge using Git.

Had created Unit Test Cases documents and execution.

Hadnled the Production migraiton.

Environment:Informatica BDM/DEI 10.4.1 On Unix System, XML system, SQL Server 2016,Netezza,ESP Scheduling tool CA workload automation, Gitlab, Erwin Tool for Mapping migrations, Informatica Analyst, Informatica Administrator Monitor

Project #3

Project Name

SunTrust

Start Date

Dec 2020

Organization

Infosys, USA

End Date

Current

Project Location

North Carolina (Remote from Kentucky)

Team Size

8

Project Description:

MOE Core Processing is team of people helps to migrate the data from BBT bank to Suntrust application using Informatica ETL process.

Role / Responsibilities

Technical Analyst

Contribution:

Involving in Extracting, Transforming and Loading data from different sources like CSV, XML, SQL and ORACLE and MDB.

Agile Methodology – 2 weeks delivery span.

Prepared all required documentsdocuments.

Created jobs in Informatica to extract from heterogeneous data sources like SQL Server, MDB, Xml files, Mainframe Fileand Flat files

Adhered to the exiting process of the client development and migration.

Involved in performance tuning and participated in technical discussions.

Had created Unit Test Cases documents and execution.

Environment:Informatica 10.2 On Unix System, XML system, SQL Server 2016,Netezza,ESP Scheduling tool.

Project #4

Project Name

Anthem,

Start Date

July 2019

Organization

VirtusaPolarisSoftware Services, USA

End Date

Sep 2019

Project Location

Virginia Beach, USA

Team Size

4

Project Description:

NextGen project of anthem is to move Anthem medical project into next level. The main goal of the project is to migrate the clinical data for ICD10 codes, Health Care Products, Eligibilities, Providers, Members and Claims since the health care industry is moving to new types of codes and standards.

Role / Responsibilities

ETLDeveloper

Contribution:

Involving in Extracting, Transforming and Loading data from different sources like CSV, XML, SQL and ORACLE and MDB.

Agile Methodology – 2 weeks delivery span.

Prepared all required documentsdocuments.

Involved in Commercial, Medicare and Medicaid Member data migrationfrom Flat file system and Pega System.

Created jobs in Informatica to extract from heterogeneous data sources like SQL Server, MDB, Xml files and Flat files

Used stored procedures and created mapping using it.

Implemented Error handling, Monitoring and Error logging in Informatica.

Involved in performance tuning and participated in technical discussions.

Had created Unit Test Cases documents and execution.

Environment:Informatica 10.2 On Windows OS, XML system, SQL Server 2014 and Flat file system.

Project #5

Project Name

Clinical 2020

Start Date

Oct 2016

Organization

VirtusaPolarisSoftware Services,USA

End Date

May 2019

Project Location

New York, USA

Team Size

4

Project Description:

Clinical 2020 project is a healthcare project. The main goal of the project is to migrate the clinical data for ICD10 codes, Health Care Products, Eligibilities, Providers, Members and Claims, since the health care industry is moving to new types of codes and standards.

Had done the successful migration of commercial product member. Assigned their BHP node to right path when the eligibilities are come to effect/Terminated. Loaded the Institutional, Professional and Pharmacy claims from various system.

The Medicare Members are migrated with dual product eligibilities in the system at a given point of time. Health first supports dual product members in the system for Medicare members currently. All Member and Provider details are received from MDM in Flat Files with pipe delimited format. Task and Programs are created by Mulesoft API’s using Informatica HTTP calls. Batch letters are created for Members and providers.

The Medicaid Members are migrated with complete family management details and history of eligibilities.70% of members in the system are Medicaid members.

Role / Responsibilities

Lead Consultant - ETL

Contribution:

Involving in Extracting, Transforming and Loading data from different sources like CSV, XML, SQL and ORACLE and MDB.

Agile Methodology – 3 weeks delivery span.

Involved in writing technical specifications and analyzing Functional Specifications.

Prepared all required documents and KT documents.

Involved in Commercial,Medicare and Medicaid Member data migration to TruCare system from Flat file system.

Handled the Control-M job scheduling and prepared a document with details.

Created jobs in Informatica to extract from heterogeneous data sources like Oracle, MDB, Xml filesand Flat files

Using Java to fetch files from the client environment via API requests

Handled Change Requests from Business and Business Analysts and performed impact analysis based on the change request.

Used stored procedures and created mapping using it.

Implemented Error handling,Monitoring and Error logging in Informatica.

Involved in performance tuning and participated in technical discussions.

Had created Unit Test Cases documents and execution.

Have working experience in war room.

Environment:Informatica 9.5.1 and 10.1 On Windows OS, XML system, SQL Server 2012 and Flat file system.

Project #6

Project Name

Data Migration

Start Date

Jan 2016

Organization

VirtusaPolarisSoftware Services,USA

End Date

Sep 2016

Project Location

Ohio, USA

Team Size

30

Project Description:

To migrate the data from different source system to XML file, this can be consumed by another application to process the payload.

Role / Responsibilities

Consultant - ETL

Contribution:

Involving in Extracting, Transforming and Loading data from different sources like CSV, XML, SQL and ORACLE and MDB.

Involved in writing technical specifications, and analyzing Functional Specifications.

Prepared all required documents and KT documents.

Created jobs in Informatica to extract from heterogeneous data sources like Oracle, MDB, UNIX files, Xml files and Flat files

Handled Change Requests from Business and Business Analysts and performed impact analysis based on the change request.

Using Java client code to generate the json files form the input files received and the processing the same via .NET using Rabbit MQ messaging server.

Used stored procedures and created mapping using it.

Implemented Error handling and Error logging in Informatica.

Working on performance tuning and participating in technical discussions.

Involved Unit Test Cases.

Slack – User communication application effective and light weightsimilar to OpenText

Trained the junior resources.

Environment:Informatica 9.5.1 and 10.1 with windows, XML system, Oracle 9.0,Flat file and JSON system.

Project #7

Project Name

Network Rail

Start Date

Mar-2012

Organization

Virtusa India Pvt Ltd.,

End Date

May-2015

Project Location

Chennai – India

Team Size

35

Project Description:

Network rail is a UK based government company which maintains the rail system of entire country. It Offering Rail Better Information Services (ORBIS) Asset Data Store (ADS) Invitation to Tender Documents, Network Rail requires a trusted source of asset-related information and insight, from which informed business decisions can be made to balance risk, asset performance and funding. Reliable and accurate asset information provides the foundation for improved safety, improved rail system performance and the implementation of a least-whole-life-cost management policy approach to the management of all railway assets.

Role / Responsibilities

Informatica Developer

Contribution:

Involving in Extracting, Transforming and Loading data from different sources like CSV and ORACLE and MDB.

Involved in writing technical specifications, and analyzing Functional Specifications.

Prepared all required documents and KT documents.

Created jobs in Informatica to extract from heterogeneous data sources like Oracle, MDB,UNIX files and Flat files

Handled Change Requests from Business and Business Analysts and performed impact analysis based on the change request.

Involved Unit Test Cases.

Environment:Informatica 9.5.1,Power Exchange,IDQ,Oracle and UNIX

Project#8

Project Name

Datacert

Start Date

June-2010

Organization

Virtusa India Pvt Ltd.,

End Date

Feb- 2012

Project Location

Chennai – India

Team Size

9

Project Description:

Datacertholds the product based company where client handles a wide range of value-added and complex services for different set of customers based on US for handling Case details, Finance and Accounting services, Software Development and maintenance, and providing IT Service and Helpdesk support and customer service support to the Group globally.

Role / Responsibilities

Software Engineer

Contribution:

Involving in Extracting, Transforming and Loading data from different sources like spread sheet and SQL database.

Involved in writing technical specifications, and analyzing Functional Specifications through SQL scripts.

Prepared all required documents and KT documents.

Created jobs in Data Stage to extract from heterogeneous data sources like Oracle, ODBC, SQL Server, DB2 and Flat files

Handled Change Requests from Business and Business Analysts and performed impact analysis based on the change request.

Involved Unit Test Cases.

Environment:DataStage 8.1, SQL 2008 R2, windows XP and Client product.

Qualification:

Qualification

College / University / Institution

Year of Passing

% of Passing

B.Tech(Information Technology IT)

Vel’s Srinivasa College of Engineering & Technology, Chennai (Anna University),India

2009

73%

Declaration

I hereby declare that all information provided above are true and best to my knowledge.

Date :Yours Faithfully,

Location : Durham,NC

(Bhuvaneswari.M)

Contact this candidate