Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Raga J Mandati

Iselin,NJ

Summary

Technical Lead with a proven track record of rapidly onboarding new personnel and kick-starting new projects. Achieves exceptional completion metrics by utilizing available skills and technical assets. Excels at assembling effective teams through the exploitation of complementary competencies and fostering collaborative employee relationships. Experienced in designing and implementing data integration solutions, bridging the gap between B2B/B2B2C Salesforce platforms and enterprise applications. Expertise in API development, middleware platforms, ETL processes, and data architecture. Strong leadership background guiding cross-functional teams to ensure seamless, scalable, and secure data exchanges across systems.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Technical Lead

TIAA
03.2017 - Current
  • Collaborated with salesforce Architects to set up new B2B2C Salesforce Financial Services cloud for modernization of legacy Siebel CRM Platform.
  • Setup of Mutual certificate TLS between salesforce and Mule Cloudhub as per security review. Also setup Single Sign On on salesforce, Splunk Integrations For Audit logging.
  • Designed execution of CRMA recipe scheduling using Mule via Autosys.
  • Integrated Salesforce CRMA with snowflake to consume data and create datasets Which later used in dashboards
  • Designed solutions in accordance with business partners from B2B, Wealth, CRM groups.
  • Worked along with Mule professional Architects to setup new Mule cloud hub which hosted integrations to exchange data between Salesforce and tiaa internal applications.
  • As an architect, coordinated with an infrastructure team to setup virtual private cloud, ipsec tunnel from Mule Cloud to Enterprise data center
  • Worked with Infrastructure team to create dedicated load balancers on cloudhub 1.0, with MTLS for internal and external hosts.
  • Maintenance of Mule Api Vcores allocation, Env's in cloud hub.
  • Designed solutions to move data from enterprise applications to Salesforce via real time and batch.
  • Lead a team of onshore and offshore developers to build mule api’s/app’s.
  • Solution design for critical business problems and implement them.
  • POC development, providing strategic solutions to progress with project.
  • Designed and Developed integrations using Talend, DataStage to connect to salesforce
  • Reduced footprint of batch processing in Siebel CRM legacy platform which in turn helped to save time and effort to do analysis for new platform
  • Integrating DataStage application with cyberark to retrieve password from safes during runtime

Lead Developer

Novo Nordisk
11.2016 - 03.2017
  • Performed upgrade of DataStage from 8.7 to 11.5
  • Migrated the database connector stages from deprecated version to newer Version using the IBM Infosphere Connector Migration tool 11.5
  • Created the file systems, moved the parameter sets, copied the unix scripts to the new server of the DataStage 11.5
  • Performed unit testing on the projects and made sure BAU is good
  • Designed and developed a new data feed to concur to capture expenses
  • Provided data to Cognos reporting tool
  • Worked on Performance Tuning, troubleshooting and debugging of various ETL Jobs

Senior ETL Developer

IBM
08.2013 - 10.2016
  • Performed requirements gathering and source data analysis and identified business rules for data migration using IBM InfoSphere 9.1
  • Designed various mappings (Source-to-Target) using DataStage tool to link between different source systems and data warehouse for loading data into warehouse
  • Used DataStage Designer for developing various jobs for Extracting, Cleansing, Transforming, Integrating and Loading data into Data Warehouse
  • Extracted data from Excel files, using FTP Stage and loaded into different databases
  • Received the master data and populated the Dimension Tables, Surrogate key generation
  • Designed Parallel jobs using various stages like (Join, Remove Duplicates, FTP stage, Filter, Dataset, and Lookup file set, Modify, Transformer and Funnel stages)
  • Developed incremental and full load data jobs using CDC (Change Data Capture stage), which were scheduled to run on daily, weekly or monthly basis
  • Retrieved and sent data to MDM(Master Data Management) for data fixes in the format of XML’s
  • Created UNIX Shell Scripts that invoked the Datastage jobs passing to execute with parameterized database connection information
  • Along with designing mappings from scratch, re-wrote existing code to enhance performance and trouble-shoot errors in both DB2-UDB and Data Stage
  • ETL development (mainframe DB2 & IMS) to UDB using Datastage server in a shared container in a Datastage PX job
  • The shared container is used for the FTP and translation steps, as well as running a stored procedure
  • Extensively used Db2 visualiser, Aginity(Netezza), TOAD, Squirrel for analyzing data, writing SQL, PL/SQL scripts performing DDL operations
  • Worked on Performance Tuning and Troubleshooting & debugging of various ETL Jobs
  • Created Test plans, Test cases and performed Unit Testing, Integration Testing & System Testing

ETL Developer

Insmed
08.2012 - 04.2013
  • Analyzed the business requirements to detail level for development
  • Build small framework to ingest data across applications
  • Optimized performance of the jobs which were taking longer in production
  • Proposed design solutions within team
  • Worked with business to do data analysis

ETL Developer

Enthone
04.2011 - 07.2012
  • Build basic jobs to read data from Oracle database to target database based on mapping document
  • Build jobs to generate sequential files which were sent to business for reporting
  • Worked with business to do data analysis
  • Worked in waterfall methodology

Developer

Unilever
11.2007 - 11.2008
  • Daily monitor jobs and execute them from data Stage director
  • Check logs for any failures and take corrective action
  • Report our critical failures to senior developers

Education

M.D. - Masters of Science

Sacred Heart University
Fairfield
07.2009

Bachelor of Science -

Kakatiya University
India
06.2005

Skills

  • Salesforce Proficiency
  • SIEBEL Software Proficiency
  • IBM Master Data Management
  • Amazon Web Services Cloud Practitioner
  • Talend Big Data Platform
  • IBM ETL Development
  • MuleSoft Expertise
  • Snowflake Proficiency
  • Oracle Application Proficiency
  • SQL Query Optimization
  • Db2 Database Management
  • Netezza Data Analytics
  • GitLab Proficiency
  • Jenkins Automation
  • Artifactory
  • Electric- Flow
  • Autosys
  • Cron scheduler
  • PL/SQL
  • File zilla
  • Shell scripting
  • Mentorship and coaching
  • Security best practices
  • Cloud computing
  • Solution architecture

Certification

  • Salesforce Certified Data Architect
  • AWS Certified Cloud Practitioner (CLF-C01)
  • Salesforce Certified Platform Developer 1
  • Salesforce Certified Platform App Builder Certification
  • Salesforce Certified Administrator (SCA)
  • Mulesoft Developer 1
  • Certified SAFe 5 Practitioner

Timeline

Technical Lead

TIAA
03.2017 - Current

Lead Developer

Novo Nordisk
11.2016 - 03.2017

Senior ETL Developer

IBM
08.2013 - 10.2016

ETL Developer

Insmed
08.2012 - 04.2013

ETL Developer

Enthone
04.2011 - 07.2012

Developer

Unilever
11.2007 - 11.2008

M.D. - Masters of Science

Sacred Heart University

Bachelor of Science -

Kakatiya University

Similar Profiles

CREATE PROFILE