Health Care Data Management

SUNIL KUMAR

Informatica Developer (IICS/IDMC)

Phone: 248-***-**** Austin, TX Email: ************@*****.***

Professional Summary:

As an experienced professional, I have a consistent outstanding performance in ETL methodology for data transformation for various global customers in Health Care, Finance and Insurance domains. With the right mix of exceptional technical and managerial skills, I have guided the teams for successful completion of several Data warehouse projects with compressed timelines. Ability to manage multiple tasks, adaptability and passion to learn new Technologies are my key personal strengths.

I have experience in the end-to-end development life cycle, involving consulting roles for performance-centric architectures driven by an agile process. I bring a process optimization strategy to enhance the operational performance of existing applications and possess extensive experience in implementing business-critical projects with cross-cultural teams across geographical locations.

Being exceptionally well organized, with a track record that demonstrates self-motivation, creativity and initiatives to achieve personal and corporate goals, I am confident that I would add value to your organization.

Summary of Skill:

10+ Years of experience in the IT industry with extensive Domain knowledge of Health Care, Finance, Insurance, Supply Chain and Pharmacy including experience in using Informatica PowerCenter, Informatica Intelligent Cloud Services(IICS), Informatica Intelligent Data Management Cloud(IDMC) and Amazon webservices (AWS).

•Experience on Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS).

•Worked on migration and Decommissioning projects within ETL, among different ETL tools such as Informatica PowerCenter to IICS.

•Demonstrated experience with Power Exchange connectivity to SQL Server and DB2.

•3+ years of experience in IICS Informatica cloud ETL development using CDI, CAI.

•Experience in creating advanced server less deployment of Informatica Intelligent Data Management Cloud (Informatica IDMC) using the Azure portal.

•Experience with dimensional modelling using Star Schema and Snowflake models.

•Facilitate requirement gathering meetings, issue clarifications, review documentation and establish a common understanding between the customer and the software project of the customer’s requirements that will be addressed by the software project.

•Rich experience in Data Warehousing, Data Extraction, Transformation and Loading (ETL) data from various sources like Oracle, SQL Server, DB2, Microsoft Access, Microsoft Excel and Flat files into Data Warehouse using Informatica Power Centre (10.2.0/9.5.1/9.0.1) tools along with that Informatica Big data management (BDM). (10.2.1/10.2.2/10.4.1.1).

•Extensively used Slowly Changing Dimension (SCD) technique in Financial and Health care applications. Expertise in OLTP/OLAP System Study, Analysis, developing Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modelling.

•Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.

•Have very good exposure on Change Data Capture using Power Exchange for DB2 and Oracle.

•Knowledge in Hadoop, Good knowledge of database structures, theories, principles, and practices.

•Have used SQL and database technologies extensively on several projects. Worked extensively on writing efficient SQL to read and write data.

•Worked as a Team Leader, led a team of 4 associates on development and maintenance projects spanning complete SDLC from technical and management prospective.

•Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project.

•Comprehensive experience in providing various technical suggestions, solutions and troubleshooting assistance during development and execution of applications.

•Capable to delve into the new leading Technologies.

•Ability to work well in both a team environment and individual environment.

•As an experience Professional enabled in grooming the Onshore-offshore team, resolving functional and technical impediments and ensuring smooth execution of the deliverables.

ETL Tools

Intelligent Data Management Cloud (IDMC), Informatica Intelligent Cloud Service (IICS), B2B DX/DT Studio, Informatica Data Quality (IDQ), Informatica PowerCenter 10.2.0/9.5.1/9.0.1

/8.6/8.5, Power Exchange, Big Data Management (BDM) 10.2.2/10.2.1/10.4.1, BDS Kafka.

Databases

SQL Server 2008/2012, Oracle 10g/9i, DB2, Teradata, Hue, Teradata SQL Assistant, Toad for Oracle 12.12, Azure.

Programming

C,C++, Java, PL/SQL, XML, JavaScript. Unix Shell Scripting.

Hadoop

Hive, Sqoop, Impala, HDFS, Kafka.

Cloud Platforms

AWS (Amazon Web Services), Lambda, DynamoDB, Azure Databricks, Snowflake, AWS S3.

Job Scheduling Tools

Informatica Scheduler, UC4, Tidal, Control- M, Autosys.

Other Tools

Putty, Super PuTTY, MS Office, MS Visio, Ultra Edit, Remedy Force, Service Now, JIRA, TortoiseSVN, Harvest, SARA, Service Manager, VersionOne, RTC (Rational Team Concert), ESP, RFHutil, MQ Visual Edit V3, Postman, Git, Jenkins, FileZilla, NotePad++.

Technical Skills:

Education:

Master of Computer Science - SILICON VALLEY UNIVERSITY, San Jose, CA - Graduation: Dec 2014

Bachelor of Technology - (Information Technology) - JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY

TKR Engineering College, Telangana, India - Graduation: May 2013

Professional Experience:

Client: Church Mutual Insurance, WI - Jan 2023 to Present

Role: Informatica IICS/IDMC Developer

Employer: Reliable Software Resources Inc - Northville, MI

Description:

The project involved designing and implementing data integration solutions using Informatica IICS and IDMC to consolidate data from various sources. This centralized solution addressed Church Mutual Insurance's evolving business intelligence needs, ensuring secure, scalable, and efficient data management for enhanced decision-making and collaboration across business areas.

Responsibilities:

•Interact with Business to understand and analyse the requirements.

•Worked on installing Informatica Intelligent Cloud Services (IICS) Secure Agent components and subsystems for a multi-server platform capable of scaling with growing number of components and applications.

•Used Informatica IICS Cloud services for building data integration processes by constructing mapping tasks, task flows, schedules, and parameter files.

•Created advanced server less deployment of Informatica Intelligent Data Management Cloud (IDMC) using the Azure portal.

•Enabled Single sign-on (SSO) of Intelligent Data Management Cloud (IDMC) using Azure tenant portal.

•Experience in installing Add-on connectors and drivers for IICS.

•Experience in IICS Application Integration components like Processes, Service Connectors and process object.

•Worked on setting up Jenkins Pipeline to perform Continuous Integration using Git repository.

•Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.

•Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.

•Involved in all phases of SDLC from requirement gathering, design, development, testing, production, user training and support for production environment.

•Developed mappings using needed Transformations in Informatica tool according to technical specifications.

•Captured data error records corrected and loaded into target system.

•Performed Database/ETL migrations from Development environment to Test/Training/UAT/ Staging and PROD environments.

•Optimized data workflows for performance by fine-tuning resource allocation, parallel processing, and job scheduling, resulting in reduced processing time and improved throughput.

•Developed custom transformations using Informatica Cloud Data Integration to meet complex business logic requirements and improve the flexibility of data transformation processes.

Environment: Informatica Intelligent Data Management Cloud(IDMC) Informatica Intelligent Cloud Services (IICS), Secure Agent, AWS S3, Jenkins, Service Now, Jira, Oracle, SQL Server, FileZilla, Tidal, Control M, Git.

Client: Highmark, PA – June 2019 to – Dec 2022

Role: Sr. Application Developer - IICS

Employer: Reliable Software Resources Inc, Northville, MI

Description:

The ODH is a collection of technology, process and data that enables the consolidation of data from various EHS Platform transactional sources for the purpose of providing operational data to the enterprise (out-bounds, applications, users). It collects data from the EHS Platform transactional systems & external systems that enable EHA Platform operations (like Share care & WebMD) and acts as a trusted integrated source for read-only data. The ODH extends the operational data with necessary attributes to partition and enforce security access by business areas and Health Plan Partners.

Responsibilities:

•Coordinating with the business users and business analysts in gathering requirements.

•Prepare the architecture design document and technical design specification as per the business requirement.

•Drive the technical design of ETL reference architecture to ensure high data quality, data integration performance and error recovery/handling.

•Implemented Kafka streaming in one of the Clinical projects.

•Developed integrations using Informatica Cloud Data Integration IICS.

•Created mappings, tasks, task flows for the data migration from files to the Redshift database in IICS.

•Experience working with Informatica IICS tool effectively using it for Data Integration and Data Migration from multiple source systems in Azure Data Lake.

•Expertise in Big-Data Management Tool and successfully executed many projects. Delivered projects under my leadership by handling projects end-to-end.

•The executive team has chosen me to be 1 of the 2 SMEs (Subject Matter Experts) in Titan Project to train the team on BDS (Big Data Streaming). My contributions were key in steaming jobs to read the data from JMS XML messages and write the data into HDFS.

•Lead the development, implementation and take the responsibilities for setting up Informatica BDM environment & Hadoop Hive tables in HDFS from inception to production.

•Develop CDC process using informatica PowerCenter to extract data from DB2 Power Exchange and load into HDFS.

•Involved setting up Hadoop configuration and connection for BDM and PowerCenter tools.

•Develop Informatica BDM mappings, Workflows to extract data from Hive and load it into Oracle integration tables.

•Design & develop reusable components like mapplets.

•Developed automation process using UNIX scripts to run the applications and workflows in BDM and PowerCenter tools respectively.

•Developed UNIX scripts for File Manipulation, FTP to HDFS and archiving log files.

•Develop, test, debug, document and help operationalize various applications leveraging industry best practices.

•Responsible for maintaining the Incremental workflow runtimes to match the business needs.

•Involved in jobs scheduling and production deployment activities creation of the deployment guide migration of the code to production, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 10.2.0, Power Exchange, Big Data Management (BDM) 10.2.2/10.2.1/10.4.1, Hue, HDFS, Hive, Teradata SQL assistant, Toad for Oracle 12.12, Super PuTTY, Ultra Edit, Harvest, SARA, Service Manager, VersionOne,RTC,ESP, RFHutil, MQ Visual Edit V3, Ultra Edit, Postman, Kafka connect,GitLab, Informatica Intelligent Cloud Services (IICS), Azure.

Client: Waddell & Reed, KS - Apr’2015 to June 2019

Role: Sr. ETL Developer

Employer: Reliable Software Resources Inc, Northville, MI

Description:

Invest One is a Core Decommission Program that will focus on the decommission of the Retail Advisor CRM functions on the Siebel/CORE platform and migrate business critical functions into our existing W&R application portfolio.

Responsibilities:

•Coordination with the business users and business analysts in gathering requirements.

•Develop code to extract data from several sources and load to the operational data store.

•Developed Informatica mappings and workflows. Some involved sources as SQL Server views with complex logic.

•Executed performance tuning by optimizing SQL queries and adding indexes on key columns etc.

•Used mapplets, worklets, and transformations to manipulate the data and load data to the data store.

•Worked with sources like flat files, COBOL files. Written various types of SQL queries involving joins, aggregate calculations and performance tuning the queries too.

•Performed unit testing and integration testing with other systems.

•Created Source to target mapping documents which are used by ETL developers to load data into Data warehouse.

•Involved in gathering requirements and designing tables for External vendors which are used for performance attribution and risk analysis for Mutual funds.

•Analysed Incoming Mutual fund data and designed Delta logic (slowly changing dimension 2) for Core Business tables.

•Analyse the requirements and build the BI architecture to support all reporting needs.

•Work with technical (BI & ETL) teams and clients to ensure the closure of problems reported, in a timely fashion.

•Setup scheduling for the execution of jobs through Tidal.

•Worked as a production support resource for the business users.

•Scheduled jobs for movement of files from external sources using IBM SFG. Established job scheduling for end-to-end data movement.

Environment: SQL Server 2012, Oracle 10g, Informatica Power Center 10.2/9.5.1/9.1.0, Flat Files, XML files, COBOL Files, Erwin 9.7, Windows, MS Outlook, Tidal Scheduler, JIRA, ServiceNow, Remedy force, Word, Excel and Power Point, TortoiseSVN.

Client: Reliable Software Resources Inc., MI - Jan’2015 to Mar’ 2015

Role: ETL Developer.

Responsibilities:

•Fundamentals of Business Intelligence and Data Warehousing: Accessing, reporting, analyzing the data.

•Data Warehousing Architecture: Data Integrations, Data Architecture, Technology and Product Architectures.

•Data Modeling Techniques: Star and Snowflakes schemas.

•Advanced SQL to work with Oracle, SQL server databases.

•Responsible for analysing functional specifications and prepared technical specifications accordingly.

•Involve in the Coding and testing of new reports and mocking data as necessary.

•Write SQL test scripts and programs on source and target databases.

•Identify Test Cases to be run for Regression Testing and conducting regression testing as and when new builds were made.

•Develop SQL queries to run Comparison Testing to compare data in database and data displayed on front end.

•Fundamentals of ETL (Extraction Transformation and Loading).

•Create mappings and workflows to extract data from several sources and load to operational data store.

•Setup scheduling for the execution of jobs.

•Perform optimization on the ETL batch processing jobs to meet the service level agreements.

•Wrote windows batch scripts to process the jobs.

Environment: SQL Server 2012, Oracle 10g, Autosys, Informatica 9.5.1, XML files, Flat files.

AWARDS, APPRECIATION & PARTICIPATION:

•Received “Certificate of Appreciation from Church Mutual Insurance, WI 2024”.

•Received “Certificate of Appreciation from Church Mutual Insurance, WI 2023”.

•Received “Certificate of Appreciation” from Highmark for successful implementation of ETL solutions and data migration.

•Received “Outstanding Contributor” award at Highmark for leadership in Big Data and Cloud

•initiatives.

•Received a Certificate of Appreciation from Waddell & Reed, KS for successfully organizing and hosting the Diwali Festival in the office, fostering cultural diversity, and strengthening team spirit across the organization.

•Received a Certificate of Appreciation from Waddell & Reed, KS for going above and beyond by dedicating extra hours to optimize and enhance code quality, resulting in improved system performance and operational efficiency.

•Received “Certificate of Appreciation from Reliable Software Resources” for exceptional performance and contributions to client projects.

•Received “Certificate of Merit” and gold medal for the outstanding academic performance.

•Received “Certificate of Appreciation” for the event management of SHIZNAY -2K13. I was elected as president, and I organized international pop signers AKCENT to perform in the event.

•Received “Certificate of Appreciation” for the events management of Zignaasa-2K9, Zignaasa-2K11 during my 1st year and 2nd year of graduation (Bachelor of technology).

•Received “Participation Certificate” for the paper presentation entitled “IOS7” during my 2nd year of graduation (Bachelor of technology).

•Received two “Certificate of Participation” for the ‘State Inter Engineering Collegiate (T20) cricket tournament’ and ’State level U/14 boy’s cricket tournament’.

Contact this candidate