Data Engineer Health Care

Shivlochan Yadav

Data Engineer (Oracle/Talend/Python) Email: ***********@*****.***

Contact: +1-508-***-****

• Having 18+ years of rich professional experience in Oracle, MongoDB, SQL Server, Redshift database, Talend, Informatica, SnapLogic and IBM DataStage in Linux and Windows environment.

• Worked in Retail, Pharma & Health Care and Energy & Utilities domains, having comprehensive process and compliance knowledge in these domains.

• Experience in writing PL/SQL, T-SQL, Unix shell script and database performance tuning.

• Worked in Database Design, Development, Migration, Administration, Application Development, Enhancement/Maintenance and Support Projects.

• Experienced in writing python script for data load into MongoDB from file or database.

• Data migration using AWS Snaplogic, Informatica, Attunity, Redshift and Oracle DB.

• Experience in leading database and ETL related project in Integration and Data warehouse environment.

• Consistently achieved good customer satisfaction, excellent delivery track record with process compliance.

• Joined Wipro Technologies as campus recruit on 1st August 2005.

• RxAdvance/Nirvana Health is my employer from 4th January 2022 till date.

• To work in an organization where one can achieve career goals along with the growth of the organization.

• Oracle database design and development

• Oracle database administration and performance tuning

• ETL design and development

• AWS Migration using Snaplogic, Attunity and Redshift DB

• Agile Framework

• Python coding for data load from file or database.

• Retail domain process

• Pharma & Health Care

• Energy & Utilities

• Pharmacy Benefit Management

• Medicare/Medicaid claim system

Organization Designation Duration

RxAdvance/Nirvana

Health - US

Data Engineer

(Oracle/Talend/Python)

Jan ’22 – Till date

Wipro Technologies - US Senior Database Developer/Lead Jan ’17 – Dec ‘21 Wipro Technologies - IN Senior Database Developer/Lead Jan ’15 – Dec ‘16 Wipro Technologies - CH Database Administrator Jan ‘09 – Dec ‘14 Wipro Technologies - IN Database Developer Aug ‘05 - Dec ‘08

• B.E.

Bachelor of Engineering in Information Technology

– NIT Durgapur, India. Batch 2005.

OS: Windows 95, 98, XP, Vista,

NT/2000/2003/2008/Windows 7/10,Linux

6.2

Language:

PL/SQL, Unix Shell Scripting, SQL, T-SQL,

Python, XML, Java Scripting

DevTools:

ERWin R9.7, Toad, Oracle SQL Developer,

Oracle PL/SQL Developer, MS SQL Server

Management Studio, Informatica, Talend,

SnapLogic, Aginity workbench, Attunity, IBM

Datastage 11.3, Visual Studio Code, Studio

3T, Dell Boomi, Bitbucket, Jenkins,

SourceTree, Jira, Confluence

Database:

Oracle 9.x to Oracle 11.x, Oracle 12c, Oracle

19c, SQL server 2008/2012, Redshift,

MongoDB

• Customer appreciation – By Magellan Health Client For migration of Claims and Account Receivable (AR) historical conversion data for California Medical and process improvement.

• Excellent Customer feedback – By TJX Companies INC. Client For development and support of IDS Oracle database in Integration Project.

• Certificate and Token – By Novartis GIS program

management, Switzerland Client

For excellent contribution and teamwork in DIAMOND project.

• Feather in Cap – By Delivery team of Energy and Utilities National Grid, UK Account, Wipro

For my contributions to bug fixing and testing in development project.

Areas of Expertise

Profile Summary

Professional Qualifications

Career Progression

Technical Skills

Awards & Recognitions

Domain Experience

Professional Aim

Employer: RxAdvance/NirvanaHealth (US) Address: 136 Turnpike Road, Southborough, MA 01772, USA Duration: Jan 2022 – till date Role: Data Engineer (Oracle/Talend/Python)

Domain: Pharmacy Benefit Management/

Medicare/Medicaid claim system

Work Location: Client office

Responsibilities:

• Design and implement Database Objects to maintain the organizational data and maintain the integrity of the relational data.

• Design and Implement Database procedures and complex queries to retrieve data for different needs of the organization.

• Guide Application development teams walk through the data models and help them create data retrieval queries.

• Modify existing databases and database management systems or direct programmers and analysts to make changes.

• Data Transformations, ETL (Extract, Transform and Load) programming from Source to Target Data Mapping capabilities.

• Design and develop ETL jobs using Talend and Python script.

• Scheduling job using JAM scheduler.

• Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.

• Work as part of a project team to coordinate database development and determine project scope and limitations.

• Review procedures in database management system manuals for making changes to database.

• Revise company definition of data as defined in data dictionary.

• Review project requests describing database user needs to estimate time and cost required to accomplish project.

• Establish and calculate optimum values for database parameters, using manuals and calculator.

• Have a general understanding of, and perform in compliance with, the current PBM (Pharmacy Benefit Management) v2.2 URAC (Utilization Review Accreditation Commission) standards applicable to the position. Employer: Wipro Limited (US)

Address: 2 Tower Center Boulevard Suite 2200, East Brunswick NJ 08816, USA

Duration: Jan 2017 – Dec 2021

Role: Senior Database Developer/Lead Domain: Retail, Health Work Location: Client office/Remote Responsibilities:

• Identifying the source and target data requirements.

• Analyzing the data and mapping the data from source to target system.

• Database schema designing and creating tables, indexes, constraints, triggers, views and materialized views for Online Transaction Processing (OLTP) and Datawarehouse (DW) environment.

• Creating and maintaining the logical and physical database model using ERWin tool.

• Creating package, stored procedure and function using PL/SQL language for data migration.

• Writing DB scripts for onetime data load, data validation, comparison and automation tasks.

• XML data retrieval and parsing XML data and storing into Oracle database.

• Tuning of SQL queries and PL/SQL code for performance improvement.

• Designing Informatica Job for migrating data from source to target database.

• Writing Unix shell script to perform operations at Unix server and scheduling Job.

• Migrating data into AWS cloud environment using Informatica, AWS Snaplogic and Attunity tools.

• Development and delivery following Agile methodology using Jira tool.

• Deployment of code using Continuous Integration (CI) and Continuous Deployment (CD) tool e.g. Bitbucket, Jenkins and SourceTree tools.

• Providing production support during the critical deployment phase.

• Creating technical design document, standard operating procedure documents for the projects.

• Co-ordination with business analyst, architects, subject matter experts and transitioning the project to production support team.

• Attending review meeting, status meeting and providing regular status update to business and higher management. Employer: Wipro Limited (IN)

Address: Block DM, Salt Lake City, Sector 5, Kolkata 700091, India

Duration: Jan 2015 – Dec 2016

Role: Senior Database Developer/Lead Domain: Retail Work Location: Wipro office Responsibilities:

• Gather/analyze Data Interface Requirements for Enterprise Data Warehouse.

• Perform analysis to validate Legacy Data Sources.

• Prepare Data Mappings between Source and Target Systems.

• Creating data model using ERWin tool.

Employer Experience

• Report the aberrant data and work with subject matter experts to come up with rules for Data Cleansing.

• Validate Data Finding with the Data Architect Team.

• Profile the legacy data elements.

• Writing SQL queries for data analysis, data validation and data comparison in Oracle and Netezza database.

• Work with all onsite technical leads and architects and offshore team for functional enhancements

• Weekly status reporting to the Client and Wipro manager. Employer: Wipro Limited (CH)

Address: Clarahuus Center, Teichgässlein 9, 5 Floor, 4058 Basel, Switzerland

Duration: Jan 2009 – Dec 2014

Role: Database Administrator Domain: Pharma & Health Work Location: Client office Responsibilities:

• Maintenance and support of multiple Client databases

• Incident management, Change management and problem resolution of Oracle and SQL Server Databases

• Co-ordination and meeting with business and end users for database related change.

• Identifying the best practices like automation of jobs, process documentation and also focuses on Continuous process improvement.

• Perform database migration and upgrade from older database version to latest Oracle database version.

• Create database sizing based on the business requirement.

• Troubleshooting database issues and performance improvement.

• Co-ordination and support application team.

• Identifying and applying suitable database patches to resolve any security issue and bug fixes. Employer: Wipro Limited (IN)

Address: Survey No. 203/1, Manikonda, Gachibowli,

Hyderabad 500 032, India

Duration: Aug 2005 – Dec 2008

Role: Database Developer Domain: Energy & Utilities, Pharma & Health Work Location: Wipro office Responsibilities:

• Writing SQL queries, PL/SQL procedure, functions, triggers.

• Writing test cases to test the various business requirements.

• Analyzing the existing PL/SQL code and understanding the functionality of the application interfaces.

• Analysis of the new business requirement and modifying the PL/SQL code to implement the change in the application interface.

• Unit testing and execution of test cases to regression test the application interface.

• Review and documentation of the application interface change in the user manual.

Contact this candidate