Informatica/ Talend
KALPESH JAIN
Lead Data Software Engineer
Charlotte,NC
Summary
Career Objective :
Create a better world for everyone with digital innovation and transformation. Enable real time data insights and perform predictive analytics. Use AI/ML to improve the decision making process, reduce cost and achieve highest customer satisfaction
Experience Summary :
Experienced Lead Data Software Engineer , Data/Solution Architect with over 19+ years of experience in Wells Fargo and Tata Consultancy Services (TCS), in the Banking, Insurance and Travel domains. Analytical problem-solver, strategic thinker, great team player, skilled in directing development with creative and performance-oriented approach. Well-organized and customer-focused with proven skills in project management and team leadership.
- Roles Played: Lead Data Software Engineer, Data Architect, Solution Architect, Data Warehouse/BI Architect, Application Manager ,Senior ETL/BI Design Lead and Senior BI/ETL/Mainframe Developer
- Expertise in Leading, Architecting, designing and implementing Data Warehouse, Data Migration and BI projects, technology road map, managing large project teams, support groups, resource, time and schedule management, onshore-offshore methodology, Agile work culture, project sizing and staffing, invoicing, billing, planning and scheduling of deliverables and ensuring compliance of the same to contractual SLAs.
- Managed and delivered multi million dollar ($5M-10M) projects including massive Enterprise Operational Loss Data Warehouse and Consumer Banking Profitability Data Warehouse.
- Architected and implemented metadata driven ETL framework to ease the data movement from DB/File to DB/File including standards, best practices, controls, notification, validation and automated reconciliation. This increased the productivity of development and testing by 85% and reduced the resource needs by 60%.
- Built multiple data warehouses and data lakes with sizes of 50TB and process approx 20 M transactions per day.
- Extensively worked on Informatica, Datastage, Talend, Tableau, SSRS, Power BI ,SQL Server, Netezza, Oracle, UNIX, PowerShell, Java, .net and Autosys.
- Built data pipelines involving MongoDB, Kafka, API, Big Data Hadoop Platforms, XML, MQ, structured and unstructured data and various traditional sources and targets.
- TOGAF, PMP, GCP Digital Leader, GCP Data Engineer trained.
Overview
19
19
years of professional experience
4
4
years of post-secondary education
4
4
Certifications
Work History
Lead Software Engineer / Application Tech Lead
Wells Fargo
Charlotte, NC
06.2019 - Current
- Operational Risk Events Application records operational losses in the bank and support Regulatory and Board reports
- Successful implementation of the consent order deliverable in August 2021 which consisted of policy and procedure change of recording Loss Events.
- Played the Architect and Application Lead role in implementation of DW and Data Integration and creation of regulatory reports like FRY14Q , ORX etc.
- Architected and implemented the metadata driven ETL framework using Talend and Java to ease the data movement from DB/File to DB/File including standards, best practices, controls, notification, validation and reconciliation. Built UI for the ease of metadata entries and Autosys job creation.
- Streamlined data integration with upstream and downstream including Mongo DB/Hadoop via API, Kafka , Teradata and file systems and built multiple data pipelines.
- Participated in the product selection for ETL tool as well as Operation Risk technology platform.
- Created Tableau reports for dashboards , job run summary, data movement, data integrity checks. CI/CD implementation using GitHub and Udeploy, reduced the deploy cycle time by 75%.
- Successfully leading the team of 25+ Onshore and offshore Data Engineers, Business Consultants and Testing professionals.
- Migration of ETL code from Datastage to Talend. (150 jobs). Redesigned the regulatory reports creation and automated around 50 EUCT’s (end user computing tools)
- Worked collaboratively with stakeholders to resolve technical roadblocks.
- Communicated project plans, tracking details, status updates and risk mitigation plans to cross-functional team.
- Directed gathering of performance statistics to assist in determining hardware and communication tools needed to support projected transaction volumes, response time and system availability targets.
Senior Software Engineer /Technical Project Lead Architect
Wells Fargo
Charlotte, NC
01.2015 - 06.2019
- Successful roll out of the SHRP Data warehouse in Data hub in 4 months with more than 500 tables. This project consolidated all the operational risk applications into one Archer platform.
- Played the Architect and Design lead role in implementation of DW and Data Integration. Managed the team of Data Engineers and QA and delivered with highest quality.
- Designed and Implemented ETL framework using Datastage and SQL server to ease the data movement from DB/File to DB/File including notification, validation and reconciliation.
- Developed Extract Archer Data Utility using .net and Java to extract data from Archer and populate in Datahub.
- Responsible for coordinate and finalize the data model and approve design documents based on the requirement. Interaction with Business users for requirements and approvals respectively.
- Participated and provided inputs in Daily Grooming, Sprint planning, Daily Scrum and Scrum of Scrums
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability and performance.
Data Warehouse/ BI Solution Arch/Technical Project Leader
Tata Consultancy Services - Bank Of America
Charlotte, USA
08.2009 - 01.2015
- Successfully implemented Global DataHub and FAST Data mart – Data strategy (Polaris) project in Consumer Banking.
- Profitability reporting monthly cycle time reduced to 1 day from 12 days. This enabled insight into data quicker like top 25 clients and targeted product recommendations were suggested.
- Prepared detailed Project Plan ensuring right Allocation and Tracking work allocation to Onsite and Offshore Teams.
- Managed team of employees, overseeing hiring, training and professional growth of employees.
- Implemented near real time data movements involving XML, MQ, Java and Oracle CDC.
- Designed and Implemented extensive java routines in Java transformation in Informatica and integrate with unstructured data using B2B transformation.
Lead ETL/BI Developer
Tata Consultancy Services
12.2002 - 08.2009
- Performed multiple roles across multiple clients like TIME, Bear Stearns, ING Chile, GE Money, British Airways
- Lead and implemented Data Profiling, Data Migration from Mainframe to Oracle using Informatica Power Center.
- Interpreted data models for conversion into ETL diagrams and code. Data Lineage BCBS 239 requirements was successfully implemented.
- Learned new skills and applied to daily tasks to improve efficiency and productivity.
- Designed and created ETL code installations, aiding in transitions from one data warehouse to another. Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
- Developing and Reviewing Code, Unit Testing and System Testing Support with end to end SDLC support. Trained in coding for numerous Data Warehousing solutions.
Education
Bachelor of Engineering - Electronics & Instrumentation
Sathyabama Engg. College, Madras University
09.1998 - 07.2002
Skills
Data Warehousing/Mining
Software
Datastage
Oracle/ SQL Server/ Netezza
Tableau/ SSRS/ Power BI
Certification
M87 IBM Netezza Technical mastery Test
Timeline
Lead Software Engineer / Application Tech Lead
Wells Fargo
06.2019 - Current
Senior Software Engineer /Technical Project Lead Architect
Wells Fargo
01.2015 - 06.2019
Data Warehouse/ BI Solution Arch/Technical Project Leader
Tata Consultancy Services - Bank Of America
08.2009 - 01.2015
Lead ETL/BI Developer
Tata Consultancy Services
12.2002 - 08.2009
Bachelor of Engineering - Electronics & Instrumentation
Sathyabama Engg. College, Madras University
09.1998 - 07.2002
Similar Profiles
PATRICIA M. SCHERERPATRICIA M. SCHERER
Regional Bank Private Banker II at Wells Fargo Bank / Wells Fargo AdvisorsRegional Bank Private Banker II at Wells Fargo Bank / Wells Fargo Advisors
Andrew S. HollenbachAndrew S. Hollenbach
Collateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NACollateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NA
Laxmikanth ChittampallyLaxmikanth Chittampally
Senior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells FargoSenior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells Fargo
Mayank OberoiMayank Oberoi
Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)
Samantha CottonSamantha Cotton
Manager at Mellow MushroomManager at Mellow Mushroom