Pratik Prataprao Deokar
Pune
Summary
Highly accomplished and results-oriented Solution Architect with 18+ years of experience in designing and implementing scalable, secure, and cost-effective solutions across diverse industries, including banking, Retail & Telecom. Proven ability to translate business requirements into robust technical architectures, lead cross-functional teams, and drive successful project delivery. Expertise in Ab initio, Unix, Teradata. Passionate about leveraging technology to solve complex business challenges and drive innovation.
Overview
1
1
Certification
2027
2027
years of professional experience
Work History
Solution Designer/Developer/Techno Functional manager
VOIS
10.2022 - Current
Solution Designer/Tech lead/ Programmer
Tata Consultancy Services
03.2014 - 10.2022
Technology Lead
Wipro Technologies
08.2013 - 03.2014
Associate
Cognizant Technologies Solutions
03.2012 - 08.2013
Technology Analyst
Infosys Tech. Ltd.
01.2008 - 02.2012
Solution Designer/Techno Functional manager
VOIS
- Client : VOIS Germany
- Work : Requirement gathering, Solution designing, Code delivery. Handling team of 10 people with my own deliveries. Suggested multiple automation solutions and implemented same.
- Role : Solution Designer, Developer, Manager
- Duration : Oct 2022 to till date
- Location : Pune-India
- Software : Ab-initio GDE 4.2.2.0,Unix,Teradata, Control-M,Wherescape, Power Designer.
- Certifications : GCP Professional Data Engineer (Valid till 2026) & GCP Professional Architect (Valid till 2026).
- Requests handled for this client:
- Understand the business requirement, create mapping documents.
- Design solution for the business requirement and add mappings into power designer.
- Develop code using Ab initio, Unix, Teradata.
- Identify performance improvement areas and implement the automations.
- Establish connection between GCP cloud and Ab initio systems, build graphs for data validation and data comparison.
- Handling team of 10 people with my own deliveries also tracking deliveries and status of all my DR's.
Ab Initio Lead (TCS)
Tata Consultancy Services
- Client : Sainsburys-UK
- Work : Migrate Ab initio from legacy world to cloud (AWS) and change the destination database from Teradata to snowflake.
- Role : Solution Designer & Developer.
- Duration : July 2019 to Oct 2022
- Location : Holborn, UK / Pune India
- Software : Ab-initio 3.5.2, Unix, Snowflake, Teradata, Control-M.
- Requests handled for this client:
- Migrate Ab initio code from legacy world to AWS and update code as per the new version of Ab inito
- Modify the existing graphs, Queries, Store Procedures according to new database
- Develop new interfaces to connect with different source systems through S3 buckets.
- Update the table definitions and deploy the same in snowflake database.
- Update all connection details (DBC Files), open the required ports, provide required permissions to the buckets and IP's
- Decommissioning the legacy systems.
- Establish the connection between cloud and legacy systems to run some old legacy systems and control-m job scheduler.
Ab Initio Lead (TCS)
Tata Consultancy Services
- Client : Barclays-UK
- Work : Requirement gathering and analysis, Design, Development, Testing, Implementation/Deployment and support the solution. SIT Execution/OAT Execution.
- Role : Developer / Programmer.
- Duration : March 2018 to July 2019
- Location : Northampton, UK
- Software : Ab-initio 3.2.5.1, Unix, MariaDB, Hadoop.
- Requests handled for this client:
- Developing new and existing Ab Initio code to meet regular business release cycles for an established data warehouse ETL system.
- Call web services / Java API's using existing ab initio components and load data into mariaDB and Hadoop environment.
- Tag management for the team's deliverables.
- Involve in Peer-review process to verify code.
- Housekeep the files and existing tables.
- Write, review, and execute test cases and scenarios for developed code.
- Release management activities
- Process automation (ETL) using shell scripts to avoid manual task.
- Production implementation and support.
Ab Initio Lead (TCS)
Tata Consultancy Services
- Client : Visa Eu.
- Work : Requirement gathering and analysis, Design, Development, Testing, Implementation/Deployment and support the solution.
- Role : Solution Designing and Development.
- Duration : Dec 2015 to March 2018
- Location : Reading, UK
- Software : Ab-initio 3.2.5.1 Enterprise Metadata System, DB2.
- Requests handled for this client:
- Developing new and existing Ab Initio code to meet regular business release cycles for an established data warehouse ETL system.
- Analysing and fix production data issues
- Identify performance improvement areas and implement the same.
- Tag management for the team's deliverables.
- Involve in Peer-review process to verify code.
- Write, review and execute test cases and scenarios for developed code.
- Release management activities
- Process automation (ETL) using shell scripts to avoid manual task.
- Providing 3rd-line support for an established ETL system.
- Decommission existing system without affecting dependent (upstream/downstream) systems.
Ab Initio Lead (TCS)
Tata Consultancy Services
- Client : Citi
- Work : Requirement gathering and analysis, Design, Development, Testing, Implementation/Deployment and support the solution.
- Role : Technology lead and Project manager.
- Duration : March 2014 to Dec 2015
- Location : Pune, India
- Software : Ab-initio 3.0.1 Enterprise Metadata System, Oracle.
- Requests handled for this client:
- Worked on GIW development & breakfix and support request.
- Integrating the data from different source to create integration layer.
- Data merger and migration from different source (as per country).
- Worked on Europe, Asia & LATAM branch.
Ab Initio COE (WIPRO TECH.)
Wipro Technologies
- Client : Citi.
- Work : Design custom reusable component, which will be used in the Projects which are part of A&IM.
- Role : Technology Lead.
- Duration : Aug 2013 March 2014
- Location : Pune, India
- Software : Ab-initio 3.0.1 Enterprise Metadata System.
- Requests handled:
- Created generic CDC/SCD graph to achieve type one and two dimension functionality.
- Created script to get the count from log files and track the status of jobs.
- Created few input and output file components which will help to achieve the files and read the file in ZIP and or normal format.
Project: True Customer View (TCV)
Cognizant Technologies Solution
- Client : Barclays Bank (BTCL-Pune)
- Work : Requirement gathering and analysis, Design, Development, Testing, Implementation/Deployment and support the solution.
- Role : Lead Developer, acting as team lead in this project.
- Duration : March 2012 to Aug 2013
- Location : Pune, India
- Software : Ab-initio 3.0.1 Enterprise Metadata System, Teradata (Database).
- Requests handled for this client:
- Provide true customer view to the existing customers (360 Degree View)
- Integrating the data from different source to create integration layer.
- Data merger and migration from different source (as per country).
- Currently we are working on Barclays-UK, Barclays-WE and Barclays Africa data to provide 360 degree view to customer.
Project: USCARD Level 3
Infosys Technologies
- Client: Capital-One Bank (USA)
- Capital One Financial Corporation is a publicly held bank holding company based in McLean, Virginia. Its principal subsidiaries, Capital One Bank and Capital One F.S.B., offer consumer lending Products and are among the largest providers of MasterCard and Visa credit cards in the world.
- Description: USCARD Level 3 project provides technical support to all production jobs running on USCARD platform of CapitalOne. USCARD L3 supports more than 300 applications which vary from customer acquisition, processing transaction, statement generation, collections etc. Overall L3 team takes care of all credit card business in US and Canada region.
- Level-3 team gets incidents from incident production support team with severity and L3 team is responsible for providing resolution within SLA time. Along with incident resolution ,Level 3 team is also responsible to figure out and fix data issues .Also L3 team provides recommendation to reduce repeated issues . Overall L3 team makes sure of healthy production environment.
- Role: Developer
- Period: April 2008 to Oct 2008
- Environment: Ab Initio, Web EME, Teradata, UNIX, Control M.
- Responsibilities:
- Ensured continuation of Business of client by providing Level 3 Production Support to USCARD Capital One.
- Making sure that incidents and data issues are fixed within SLA
- Project Management related activities
PROJECT: Wachovia Bank
Infosys Technologies
- Client : Wachovia, Bank of US.
- Work : Requirement gathering and analysis, Design, Development, Testing, Implementation/Deployment and support the solution.
- Role : Lead Developer
- Duration : Oct 2008 to Jan 2010
- Location : Pune, India
- Software : Ab-initio 1.14, Enterprise Metadata System, Harvest, Autosys Scheduler
- Requests handled for this client:
- Data merger of Wachovia and Wells Fargo bank and retiring old systems.
- Development in data hub to handle cleansing related requests, for proper handling and cleansing of data.
- Worked in modules like CDW, SIGMA, AML. This consists of all to all flow like Extracts, Transform and Load.
- Work flow of CDW module
- Corporate data warehouse is the complete application in which cleansed data comes from upstream (HUB). CDW accepts this data as multfiles. Applies different mapping transformations provided by business. Looked for the surrogate key in the existing lookups. If any found then assigns it to the out record. If not then new surrogate key is generated in the ETL graphs. After all the transformations data is loaded into the different silo tables and common tables.
- Various extract files also sent to the downstream (data marts). NDM is used for it.
- To load application specific tables CDC( change data capture) have been used
Project: Wells Fargo Bank
Infosys Technologies
- Client : Wells Fargo Bank of US.
- Work : Requirement gathering and analysis, Design, Development, Testing, Implementation/Deployment and support the solution.
- Role : Lead Developer. Acted as team lead in this project.
- Duration : Feb 2010 to Feb 2012
- Location : Pune, India
- Software : Ab-initio 1.14, 1.15, 3.0 Enterprise Metadata System, Harvest, Autosys Scheduler, Abinitio-Data profiler.
- Requests handled for this client:
- Integrating the data from different source to create integration layer.
- Data merger and migration of Wachovia and Wells Fargo bank.
- REQUISITS DESCRIPTION
- 1. Data merger and migration of two U.S banking giants.
- The Client wells Fargo as mentioned overtook Wachovia U.S bank.
- The request was to convert another bank's business data into client's business data format.
- For this the approach was to create a data bridge first and then totally decommissioning another bank's application. Data bridge was the application created entirely for another bank. Request was to merge the data from different types of sources of both banks to move into one common database i.e. Teradata.
- Tasks handled:
- Analysis of existing source details.
- The existing data from some sources were in XML that required the data interpretation knowledge for the same.
- Within database sources, some database sources were different i.e. Sybase and oracle, so needed to take care for compatibility.
- Design of Technical Requirement Document
- The document contained the details of technology required for this request.
- The actual code.
- The different graphs and different code was needed to handle each type of difference sources in such a way that data after transformation would be compatible for new target database.
- The actual code implementation
- In order to implement new code, several software's were used.
- Code check in and tagging: Ab-initio, UNIX
- Code packaging: Harvest
- Code Scheduling on production server: Autosys
- Implemented code validation
- The new code was needed to be validated as part of a precaution measure.
- UNIX scripts were created to compare source tree (deployed code).
- All Autosys jobs were verified with UNIX scripts
- Testing of Code.
- Unit testing, system integration testing.
- Database Involvement
- The database in use was Oracle, and Teradata.
- After daily execution of code through Autosys jobs, the data was being loaded into tables. The impact on database was correctly analyzed. The data from dry run was being loaded into the dummy database tables created.
- Operations performed in database:
- 1. Creation of tables, dropping of tables.
- 2. Generating DDL and DML of tables.
- 3. Loading the data.
- 4. Firing queries on database in order to validate the data.
- Major challenge involved in handling databases.
- As both side (source database and target database) data types should be compatible for moving of proper data, so that was needed to be analyzed.
- Responsibilities:
- Creation of Ab-initio graphs
- Ab-initio graph were developed in order to create cross reference of these two Bank's data
- Worked as Lead developer for this request.
- This responsibility involved grooming new resources coming for this request, managing and allocating work to new resources and handling the main development work.
- 2. Migration of code and server to new version of ab initio 3.0.
- The request was to migrate the code from one server to another server. In this project along with server migration the new code development was involved. Code was needed to migrate to new ab initio version 3.0. So graphs from old server were replicated by adding the new functionality available in 3.0 which can enhance the performance and lower the complexity of expressions.
Education
Bachelor's Degree - Computer Engineering
M.G.M. College, Mumbai University
Skills
- 18 years of intensive experience in designing and implementing scalable, secure, and cost-effective solutions across diverse industries
- Expertise in ETL tool Ab initio, Unix and scheduling tools like Autosys and Control-m
- Sound experience of Database Handling like DB2, Informix, Teradata, snowflake
- Acted as key resource in handling core development project from the scratch
- Experience in Business document analysis, Technical document design, Unit Test Planning & Execution, Integration testing, Data analysis and Defect analysis
- Working with clients to build the new designs/workflows, also helping them to improve the existing legacy processes
- Certified in GCP professional data engineer & GCP professional architect
- Certified in Ab initio graph development
- Tools: Ab Initio : Version- 114, 115, 30, 301, 352, 4219, Autosys Scheduler, Control-M
- Scripting languages: UNIX shell scripting
- Databases: Snowflake, Informix, Teradata, Oracle
Personal Information
- Pratik Prataprao Deokar
- Date of Birth: 1986-06-14
- Gender: Male
- Nationality: Indian
Certification
- Ab initio Graph Developer Certification
- GCP - Professional Architect
- GCP - Professional Data Engineer
- Google - GenAI
Timeline
Solution Designer/Developer/Techno Functional manager
VOIS
10.2022 - Current
Solution Designer/Tech lead/ Programmer
Tata Consultancy Services
03.2014 - 10.2022
Technology Lead
Wipro Technologies
08.2013 - 03.2014
Associate
Cognizant Technologies Solutions
03.2012 - 08.2013
Technology Analyst
Infosys Tech. Ltd.
01.2008 - 02.2012
Solution Designer/Techno Functional manager
VOIS
Ab Initio Lead (TCS)
Tata Consultancy Services
Ab Initio Lead (TCS)
Tata Consultancy Services
Ab Initio Lead (TCS)
Tata Consultancy Services
Ab Initio Lead (TCS)
Tata Consultancy Services
Ab Initio COE (WIPRO TECH.)
Wipro Technologies
Project: True Customer View (TCV)
Cognizant Technologies Solution
Project: USCARD Level 3
Infosys Technologies
PROJECT: Wachovia Bank
Infosys Technologies
Project: Wells Fargo Bank
Infosys Technologies
Bachelor's Degree - Computer Engineering
M.G.M. College, Mumbai University