Pahul Bajaj
ETL Developer
Pune
Summary
Result-oriented IT professional with over 6 years of experience specializing in ETL development, data integration, and database management within the Retail and Banking sectors. Expert in leveraging ETL tools like Talend and Ab-Initio to streamline data processing and migration projects. Skilled in Unix shell scripting and RDBMS with a strong foundation in both Agile and Waterfall methodologies. Recognized for excellent problem-solving abilities, effective communication skills, and a track record of delivering high-quality solutions in fast-paced environments.
Overview
8
8
years of professional experience
6
6
years of post-secondary education
3
3
Certifications
Work History
C11 Officer
Citicorp Services India Private limited
08.2022 - Current
- Innovated invoice automation to eliminate manual processes in reading and enriching invoices, using a Python framework to automatically process invoices received from brokers, supporting the invoice matching process.
- Developed an application for Variable Cost Intelligence, calculating variable costs in broker transactions, including fixed income, equities, derivatives, and more.
- Integrated data from multiple brokers into the application to compute fees and expenses for each transaction, presenting the results on UI dashboards for user analysis.
- Managed the Invoice Matching process by aligning trades recorded on our system with data retrieved from various sources and matching these with invoices for the specific trade date.
- Tasked with enhancing existing processes to accommodate new business requirements and rectifying bugs within the current business workflows.
- Utilized Jira for effective ticket management, ensuring timely resolution of issues and implementation of new features.
- Employed Netezza database for robust data storage and management, supporting extensive data analysis and reporting needs.
- Leveraged the Talend platform and a Python framework for efficient data extraction from source systems, enhancing data integration and processing capabilities.
- Implemented Autosys for job scheduling, automating data workflows to improve reliability and efficiency of data operations.
Technology Lead
Synechron
11.2020 - 08.2022
- Collaborating with MSCI to onboard data from multiple vendors into the MSCI database, serving as a foundation for subsequent analytics and calculations.
- Engaging directly with vendors to set clear standards regarding data integrity and the format of delivery.
- Liaising with MSCI's data owners to ensure accurate representation of vendor data within the MSCI database.
- Maintaining consistent communication with stakeholders and data consumers regarding the status of the data delivery pipeline.
- Evaluating the volume and structure of vendor data to design and implement tailored data pipelines on the Talend Platform.
- Developing resilient data pipelines that include error and log capture mechanisms, with automation facilitated through Autosys jobs.
- Conducting User Acceptance Testing (UAT) and overseeing the transition of projects to production.
- Providing support to the production team during deployment phases and addressing any subsequent issues that arise.
- Leading initiatives to automate repetitive tasks, aiming to enhance efficiency and accelerate processes.
Application Development Senior Analyst
Accenture
01.2020 - 11.2020
- Collaborate with Synchrony to manage, evaluate, and report on credit risk accounts monthly, aligning with business objectives.
- Employ Agile methodologies in project management and development processes.
- Participate in and conduct training sessions on Agile practices and principles.
- Directly engage with clients and business stakeholders to gather insights on new features, requirements, and enhancements.
- Conduct analysis of user stories, assess the impact on existing Ab Initio code, and perform comprehensive evaluations of complex business operations.
- Enhance and develop efficient Ab Initio code, focusing on simplifying existing codebases for improved clarity and performance.
- Extract data from various data warehouses, apply business logic transformations using Ab Initio components such as Parallelism, Plan, PSET, and Graphs, and subsequently store results in designated tables.
- Manage extensive data processing tasks utilizing the Multifile system and optimized SQL queries for efficiency.
- Execute unit testing and coordinate with clients for User Acceptance Testing (UAT) to ensure quality and compliance.
- Independently manage the deployment of user stories to production environments, utilizing tools such as Tags, save files, EME versioning, and Jenkins for smooth transitions.
- Facilitate knowledge sharing sessions to onboard and update new team members on project specifics and methodologies.
Information Technology Analyst
TCS: Customer Analytics/DWBI
01.2019 - 01.2020
- Led the migration of two key applications, Customer Analytics and DWBI, from Ab Initio to Talend, enhancing system efficiency and performance.
- Conducted comprehensive analysis of existing Ab-Initio jobs, from their scheduling specifics to the intricacies of the codebase.
- Executed in-depth impact assessments to ensure a seamless transition.
- Architected a new, optimized system utilizing orchestration tools for improved data handling and processing.
- Crafted and tested Talend code, employing various components such as tMap, tJoin, tFilter, tSortRow, along with database and file components, and leveraging context files/variables for dynamic configuration.
- Undertook migration testing and fine-tuned Talend jobs to meet performance benchmarks.
- Compiled detailed design and mapping documentation to outline the new system architecture and data flow processes.
- Developed solutions for new business requirements using the Talend platform, showcasing flexibility and adaptability in data processing and integration.
- Generated PDF reports for the new CCPA project using Talend components like tJava and tNormalize, demonstrating the platform's capability to fulfill diverse data processing needs.
- Facilitated the transfer of knowledge to newcomers, including conducting comprehensive training sessions on both Ab Initio and Talend, ensuring team proficiency and readiness.
Information Technology Analyst
TCS: Customer Analytics And Data Mart
06.2016 - 12.2018
- Collaborated with a leading American pharmaceutical company as an ETL developer, focusing on the analysis of customer behavior and transactions on a daily, weekly, and monthly basis to generate insightful reports and transform data in alignment with business needs.
- Engaged in the full software development life cycle (SDLC), encompassing stages such as design, build, system integration testing (SIT), user acceptance testing (UAT), and production deployment.
- Operated within an Onshore-Offshore Model to ensure seamless project execution and communication.
- Extracted customer data based on specific requirements using optimized Teradata (SQL) queries and generated files from tables for varied applications.
- Designed generic graphs and crafted efficient UNIX scripts to automate recurring tasks across more than 80 tables, enhancing process efficiency.
- Developed and refined Ab Initio code by utilizing components like ROLLUP, SCAN, REFORMAT, JOIN, NORMALIZE, EXCEL, along with partitioning components; constructed graphs, sub-graphs, and leveraged the conduct>It framework and Multifile System (MFS), followed by thorough unit testing.
- Managed environment configurations, including creating tags, setting up sandbox environments, and working with EME commands and m commands.
- Implemented small enhancements to optimize existing code and devised solutions to automate manual processes, significantly saving time and effort.
- Provided ongoing support for the existing Customer DataMart, ensuring accurate and timely Stage, Dimension, and Fact loading for subsequent analysis and reporting by business stakeholders.
Information Technology Analyst
TCS
01.2016 - 05.2016
- Participated in the Prescription Savings Club project, enabling customers without health insurance to receive up to a 10% discount on medications, with the option to renew annually and include up to 99 family members.
- Utilized Python to develop scripts for tracking and visualizing key metrics like enrollment counts, average processing times, error rates, and enrollment timeouts on Graphite via graphs.
Initial Learning Programme
TCS
09.2015 - 12.2015
- Completed a three-month foundational training course on Big Data and associated technologies.
- Collaborated with a team of five to develop a Book Recommendation Engine Website, enabling users to exchange books and receive personalized book suggestions based on ratings.
Education
B.Tech (C.S.E) -
Guru Nanak Dev University, Regional Campus
Gurdaspur 06.2011 - 06.2015
XIIth (CBSE) -
D.A.V Senior Secondary Public School
Amritsar 04.2010 - 03.2011
Xth (CBSE) -
D.A.V Senior Secondary Public School
Amritsar 04.2008 - 03.2009
Skills
ETL
Certification
Microsoft Certified: Azure Fundamentals
Disclaimer
I hereby declare that the above particulars are true & correct to the best of my knowledge and belief. In the event of any information being found false or incorrect, my candidature will be liable to be cancelled.
Timeline
C11 Officer
Citicorp Services India Private limited
08.2022 - Current
Microsoft Certified: Azure Fundamentals
07-2021
Technology Lead
Synechron
11.2020 - 08.2022
Application Development Senior Analyst
Accenture
01.2020 - 11.2020
Information Technology Analyst
TCS: Customer Analytics/DWBI
01.2019 - 01.2020
Information Technology Analyst
TCS: Customer Analytics And Data Mart
06.2016 - 12.2018
MAPR[MCHD] Certified Hadoop Developer
04-2016
Big Data University Certified
02-2016
Information Technology Analyst
TCS
01.2016 - 05.2016
Initial Learning Programme
TCS
09.2015 - 12.2015
B.Tech (C.S.E) -
Guru Nanak Dev University, Regional Campus
06.2011 - 06.2015
XIIth (CBSE) -
D.A.V Senior Secondary Public School
04.2010 - 03.2011
Xth (CBSE) -
D.A.V Senior Secondary Public School
04.2008 - 03.2009
Similar Profiles
Sandra AminSandra Amin
Deputy Counsel at Citicorp Services India Private Limited (CSIPL)Deputy Counsel at Citicorp Services India Private Limited (CSIPL)
Sathiesh ArunachalamSathiesh Arunachalam
Loan Doc & Product Analyst 2 at Citicorp Services India Private LimitedLoan Doc & Product Analyst 2 at Citicorp Services India Private Limited
K.Vinoth KumarK.Vinoth Kumar
Manager – AML/KYC Governance & Operations – C11 at Citicorp Services India Private LimitedManager – AML/KYC Governance & Operations – C11 at Citicorp Services India Private Limited
Aishwarya PawarAishwarya Pawar
Software Development Engineer in Test at Citicorp Services India Private LimitedSoftware Development Engineer in Test at Citicorp Services India Private Limited
PRASAD JAHAGIRDARPRASAD JAHAGIRDAR
Co-founder and Director at Schego Solutions Private LimitedCo-founder and Director at Schego Solutions Private Limited