Summary
Overview
Work History
Education
Skills
Professional Overview
Roles
Industry
Solutions
Key Software
Integration Tools
Cloud Platforms
Ide
Db Tools
Office Tool
Browsers
Database
Accomplishments
Certification
Interests
Timeline
Generic

Prabhakar Nallabolu

Manager
Hyderabad,Telangana

Summary

With extensive experience in spearheading enterprise-level technology projects, I have a demonstrated history of success in designing and executing information management initiatives, particularly in the areas of data warehousing and ETL. Proficient in analysis, I excel at team collaboration and possess outstanding leadership attributes. My exceptional written and verbal communication skills further augment my capacity to achieve positive results.

Overview

16
16
years of professional experience
2009
2009
years of post-secondary education
2
2
Certifications
1
1
Language

Work History

Senior Developer

Solenis
01.2024 - Current
  • Company Overview: Solenis is a US based company to sale cleaning products
  • They have acquired another company called Diversey (other clinical products company)
  • Designing/Developing the best architecture to integrate all assets and re-usable assets
  • Along the design and development guided other team members to develop the assets in short time
  • Build Data Integration pipelines (Mapping/MCT/Task Flows/) for batch mode integrations
  • Deployed the deployment process from Dev environment to Prod
  • Automate Data load and Error Handling Receipt
  • Proper testing of code before delivering it to the client (Unit Testing)
  • Used Jira to handle the tickets
  • Provided technical assistance and fixed the defects raised during User Acceptance testing
  • Solenis is a US based company to sale cleaning products
  • They have acquired another company called Diversey (other clinical products company)

Associate Manager

Huron Consulting Group
06.2022 - Current

Senior Associate

Coherent
10.2022 - 11.2023
  • Company Overview: Coherent wants to integrate the products from different locations like US, China and India
  • Designing/Developing Informatica’s Data Integration (CDI) and Application Integration (CAI) in IICS (Informatica Intelligent Cloud Services)
  • Build Data Integration pipelines (Mapping/MCT/Task Flows/) for batch mode integrations
  • Deployed the deployment process from Dev environment to Prod
  • Automate Data load and Error Handling Receipt
  • Proper testing of code before delivering it to the client (Unit Testing)
  • Used Jira to handle the tickets
  • Provided technical assistance and fixed the defects raised during User Acceptance testing
  • Coherent wants to integrate the products from different locations like US, China and India

Senior Associate

Zing Health
04.2022 - 09.2022
  • Company Overview: Zing health care needs to integrate Network hospital information, Doctors information from Salesforce to oracle using IICS
  • Designing/Developing Informatica’s Data Integration (CDI) in IICS (Informatica Intelligent Cloud Services)
  • Build Data Integration pipelines (Mapping/MCT/Task Flows/) for batch mode integrations
  • Deployed the deployment process from Dev environment to Prod
  • Automate Data load and Error Handling Receipt
  • Proper testing of code before delivering it to the client (Unit Testing)
  • Used Smart Sheets to handle the tickets
  • Provided technical assistance and fixed the defects raised during User Acceptance testing
  • Zing health care needs to integrate Network hospital information, Doctors information from Salesforce to oracle using IICS

Senior Associate

WPI
11.2021 - 03.2022
  • Company Overview: WPI will provide solution for construction and Energy
  • Designing/Developing Informatica’s Data Integration (CDI) and Application Integration (CAI) process in IICS (Informatica Intelligent Cloud Services)
  • Build Data Integration pipelines (Mapping/MCT/Task Flows/) for batch mode integrations
  • Deployed the deployment process from Dev environment to Prod
  • Automate Data load and Error Handling Receipt
  • Proper testing of code before delivering it to the client (Unit Testing)
  • Used Smart Sheets to handle the tickets
  • Provided technical assistance and fixed the defects raised during User Acceptance testing
  • WPI will provide solution for construction and Energy

Senior Associate

Huron Consulting Group
02.2021 - 12.2021

Tech Lead

Vemo Education
01.2021 - 09.2021
  • Company Overview: Vemo Education provides a consultancy service in USA
  • Designing/Developing Informatica’s Data Integration (CDI) and Application Integration (CAI) process in IICS (Informatica Intelligent Cloud Services)
  • Wrote the Java code to convert the Un-readable format files into CSV
  • Writes batch scripts for some of the Post process to move Processed files to Archive folder
  • Build Data Integration pipelines (Mapping/MCT/Task Flows/) for batch mode integrations
  • Deployed the deployment process from Dev environment to Prod
  • Automate Data load and Error Handling Receipt
  • Proper testing of code before delivering it to the client (Unit Testing)
  • Used Smart Sheets to handle the tickets
  • Provided technical assistance and fixed the defects raised during User Acceptance testing
  • Vemo Education provides a consultancy service in USA

Team Lead

Punna Software Solutions
01.2018 - 01.2021

Tech Lead

Vemo Education
06.2020 - 12.2020
  • Company Overview: Vemo Education provides a consultancy service in USA
  • Designing/Developing Informatica’s Data Integration (CDI) and Application Integration (CAI) process in IICS (Informatica Intelligent Cloud Services)
  • Implemented a Customized Timestamp for all the taskflow
  • Called CAI process in Salesforce outbound Message
  • Write code in Java for data encryption in CAI
  • Create CAI’s, Service Connectors, Connections, Process Objects and Process to expose the data through a Webservice for the consumers
  • Writes batch scripts for some of the Pre/Post process
  • Build Data Integration pipelines (Mapping/MCT/Task Flows/) for batch mode integrations
  • Deployed the deployment process from Dev environment to Prod
  • Automate Data load and Error Handling Receipt
  • Proper testing of code before delivering it to the client (Unit Testing)
  • Used Zoho to handle the tickets
  • Provided technical assistance and fixed the defects raised during User Acceptance testing
  • Vemo Education provides a consultancy service in USA

Tech Lead

Brady Corporation
01.2020 - 06.2020
  • Company Overview: The Brady Corporation has the 1000s of power center mappings and are migrating from PC to IICS cloud using conversion tool
  • Exported the PC mappings to Informatica’s Data Integration (CDI) in IICS (Informatica Intelligent Cloud Services)
  • Writes batch scripts for some of the Pre/Post process
  • Build Data Integration pipelines (Mapping/Data Synch/Task Flows/Data Replications) for batch mode integrations
  • Deployed the deployment process from one environment to other
  • Did code review along with other team members
  • Automate Data load and Error Handling Receipt
  • Proper testing of code before delivering it to the client (Unit Testing)
  • Provided technical assistance and fixed the defects raised during User Acceptance testing
  • The Brady Corporation has the 1000s of power center mappings and are migrating from PC to IICS cloud using conversion tool

Tech Lead

MPI (Motion Picture Industries)
04.2019 - 01.2020
  • Company Overview: The Motion Picture Industry Pension and Health Plans(MPIPHP) are trust funds established by collective bargaining agreements between many of the unions and employers in the motion picture production industry
  • Designed/Developed Informatica Data Integration (CDI) and Application Integration (CAI) process in IICS (Informatica Intelligent Cloud Services)
  • Write code in Java to parse some of the file level validations and to fetch data
  • Create CAI’s, Service Connectors, Connections, Process Objects and Process to expose the data through a Webservice for the consumers
  • Writes batch scripts for some of the Pre/Post process
  • Build Data Integration pipelines (Mapping/Data Synch/Task Flows/Data Replications) for batch mode integrations
  • Deployed the deployment process from one environment to other
  • Did code review along with other team members
  • Automate Data load and Error Handling Receipt
  • Proper testing of code before delivering it to the client (Unit Testing)
  • Used JIRA to handle the tickets
  • Provided technical assistance and fixed the defects raised during User Acceptance testing
  • Made use of SFTP protocol to transfer files from local to SFTP server
  • The Motion Picture Industry Pension and Health Plans(MPIPHP) are trust funds established by collective bargaining agreements between many of the unions and employers in the motion picture production industry

Technical Lead

Home Point Financial Corporation(HPFC)
07.2018 - 03.2019
  • Company Overview: The Home Point Financial Company (HPFC) is a national mortgage banking business focused on multi-channel residential and wholesale mortgage origination and servicing
  • Creating Functional Design Documents (FDD) for solutioning and share with Solution Architects and other team members to explain the development method or procedures and follow the patters to complete development
  • Write custom Java code and Shell scripts to handle Flat Files, Excel Files, and XMLs calling process
  • Worked with other team members to share the knowledge and helping them to get the development move forward whenever they need
  • Bug fixing and Unit testing
  • The Home Point Financial Company (HPFC) is a national mortgage banking business focused on multi-channel residential and wholesale mortgage origination and servicing

Team Lead

YapStone
03.2018 - 06.2018
  • Company Overview: Yapstone is a provider of online and mobile payment solutions for global marketplaces, software, and large vertical markets
  • Designing and Developing for Data Integration using IICS (CDI & CAI) for to create Mapping Template /MCT
  • Understanding the Business Requirement from Business Analyst and creating the FRD (Functional Requirement Document)
  • Creating Architecture diagram and run through to other Architects and Product Owner and get the sign off before start the actual development or POC
  • Developing CAI (Cloud Application Integration) and CDI (Cloud Data Integration) Assets in IICS and do a Unit test for various requirement and migrate to all the upper environments
  • Worked on POC for the complicated requirement and helping the team if they required for any solutioning
  • Involved in PROD deployment and make sure the deployment happened fine by doing dry run the processes
  • Yapstone is a provider of online and mobile payment solutions for global marketplaces, software, and large vertical markets

Team Lead

Laureate
12.2017 - 02.2018
  • Company Overview: The Laureate International Universities network comprises over 25 higher education institutions which collaborate with industry leaders to provide students with the skills and experience that are relevant to what employers are asking
  • Data Modeling, Data Analyzing and creating Functional Design Document for the integration between AWS flat file and Snowflake
  • Understand the Business requirement by the Business people and co-ordinate with the BI team to finalize the Data Model and handing over to the development people
  • Working with Product team and Architects to come up with the feasibilities for the complicated integrations and doing the POC’s for those integrations
  • Designing the Staging/Temporary/Core Data modeling structure and coming with the standard to design the Mapping/Process to consume and load the data into Data Warehouse
  • Automating repeated processes, generating report based on the load and running time from the Session/Activity logs using Java Programming
  • Developing more complicated Mapping and helping the team to have most feasible solution to finish their Process to load the data in DWH (Data Warehouse)
  • Review the Mapping/Process development with the team/support team and make sure we followed the standards, appropriate solution/logic in order to load the data
  • Testing and Validating the loaded data with BI team to make sure the reporting is appropriate and as per the Business requirement
  • Preparing the UAT/DR/PROD Deployment documentation and communicate with Support team for appropriate deployment once we got the Business approval
  • Validate the data once we deployed in to PROD and bug fix/grooming data if required in POST production
  • The Laureate International Universities network comprises over 25 higher education institutions which collaborate with industry leaders to provide students with the skills and experience that are relevant to what employers are asking

Senior Developer

Punna Software Solutions
09.2016 - 12.2017

Team Lead

Foremost Farms
12.2016 - 11.2017
  • Company Overview: Foremost Farms has 12 external plants that produce a large variety of products from cheese to pharmaceuticals
  • Involves in Requirement gathering and helping to the team so set up the Environment, Project set-up for the development based on the Requirement
  • Designing/Creating the DSS (Data Synchronization Service), Mapping Design for ICS (Informatica Cloud Service) and hand it over to the team to complete the other Objects
  • Creating the Service Connector, Connections and Process in ICRT (Informatica Cloud Real Time) and complete the Unit testing before hand it over to the developers
  • Working with the Client/Business team to complete the User Acceptance Testing(UAT) for end to end testing and make sure the feature built based on the requirement
  • Involves in code review and giving optimize solutions for the Project
  • Deploy the application in DEV and help the team to Migrate into PROD environment with all the Object, Mappings, Connections, etc
  • Giving Technical solution for team members and make sure they are not stuck anywhere in terms of development
  • Foremost Farms has 12 external plants that produce a large variety of products from cheese to pharmaceuticals

Assistant Professor

Vignan Engineering college
05.2009 - 08.2016

Education

Master of Computer Applications -

Bachelor of Science - Computer Science

Skills

  • Informatica IDMC

  • Snowflake

  • Salesforce

  • Oracle

  • MSSQL

  • API Integration

Professional Overview

Experienced Enterprise Tech Lead and Senior Associate with proven ability in developing and implementing Information management projects including Data Warehouse, ETL. Possessing strong analytical skills, an excellent team player with good leadership qualities and strong verbal and written communication skills.

Roles

  • ETL Developer
  • Team Lead
  • Tech Lead

Industry

  • Insurance
  • Financial

Solutions

  • Process Planning - Software
  • Data Integration co.
  • Data Warehouse
  • Data Integration / Application Integration

Key Software

  • Informatica
  • Snaplogic
  • Java
  • Snowflake
  • Dell Boomi
  • SQL Server
  • MySQL
  • Oracle
  • REST API
  • SOAP API

Integration Tools

  • IICS (Informatica Intelligent Cloud Services)
  • ICS (Informatica Cloud Service)
  • ICRT (Informatica Real Time)

Cloud Platforms

Amazon AWS

Ide

  • Eclipse
  • Informatica Developer

Db Tools

  • SQL Server Management Studio
  • TOAD
  • Oracle SQL Developer
  • Sqlyog
  • MySQL WorkBench

Office Tool

  • MS-Office 2010
  • MS-Office 2007

Browsers

  • Internet Explorer
  • Firefox
  • Chrome
  • Safari

Database

  • Oracle 11g
  • Oracle 10g
  • SQL Server 2005
  • SQL Server 2008
  • MySQL 5.5
  • PostgreSQL
  • Snowflake

Accomplishments

This is all about my self

Certification

PC to IDMC

Interests

I am good about IDMC development and admin tasks

Timeline

Senior Developer

Solenis
01.2024 - Current

Senior Associate

Coherent
10.2022 - 11.2023

Associate Manager

Huron Consulting Group
06.2022 - Current

Senior Associate

Zing Health
04.2022 - 09.2022

Senior Associate

WPI
11.2021 - 03.2022

Senior Associate

Huron Consulting Group
02.2021 - 12.2021

Tech Lead

Vemo Education
01.2021 - 09.2021

Tech Lead

Vemo Education
06.2020 - 12.2020

Tech Lead

Brady Corporation
01.2020 - 06.2020

Tech Lead

MPI (Motion Picture Industries)
04.2019 - 01.2020

Technical Lead

Home Point Financial Corporation(HPFC)
07.2018 - 03.2019

Team Lead

YapStone
03.2018 - 06.2018

Team Lead

Punna Software Solutions
01.2018 - 01.2021

Team Lead

Laureate
12.2017 - 02.2018

Team Lead

Foremost Farms
12.2016 - 11.2017

Senior Developer

Punna Software Solutions
09.2016 - 12.2017

Assistant Professor

Vignan Engineering college
05.2009 - 08.2016

Bachelor of Science - Computer Science

PC to IDMC

IDMC cloud developer for R42

Master of Computer Applications -

Prabhakar NallaboluManager