Diverse and comprehensive experience in IT performing multiple roles as Technical Manager, Senior Consultant, Data Engineer, Team Leader, Scrum Master with rich experience in ETL processes and data migration projects. Have led and managed a numerous data-centric projects to go live, responsible for end-to-end delivery, including design, planning, coding, project execution, project automation, resourcing, mentoring, quality assurance and delivery.
Successfully led and mentored a team of freshers in the high-stakes data migration project valued at multi million dollars.
An extensive ETL data migration engagement involving huge volumes of data extraction, data staging, cleaning, enrichment, formatting, application of complex business rules and final loading of 10 years of data into FLEXCUBE tables leveraging several automation tools created by me and my team.
Collaborated and Co-ordinated with multiple stakeholders involving FLEXCUBE teams, SCB Bank, FBC Holdings ensuring seamless integration of systems.
Implementing the project through writing pl/SQL migration scripts, running multiple Mock runs, DR runs on static and dynamic data having daily deliverables adhering to strict, non-negotiable deadlines.
Focused on Automating the processes and creating reusable generic utilities, conducting POCs and working on performance tuning to accommodate 10 years data migration.
Designed and got developed the migration of one the very complex Signatures module, extracting data from XML files, converting to CSV, and reconciling with JPEG images for over 10 years of customer records.
Conducted Agile ceremonies, daily scrums, Story creations and assignment in Jira, Holding Retrospective calls and all the related activities for Agile implementation of the Project having a team exceeding 11 members.
Infosys Technologies
Technology Lead | Software Engineer | Lead Tester
2006 - 2012 (6 years)
Remote
Implemented and Configured data product PMM to facilitate real time data integration in the application transitioning it from batch to real time processing. The impact was real time data was available in Netezza reporting database for Campaigning team to read real time purchasing behavior of customers and create more meaningful campaigns and coupons for them.
Enhanced the features and supported a web application that processes and reconciles travel data from multiple agencies, generating financial reports.
Developed PL/SQL procedures, debugged applications, created i-Reports, and automated testing using Rational Functional Tester (RFT).
I was a full-stack developer on the 'Rule Execution Platform for Amazon', contributing to the development of an Ion-based rule-execution platform for efficient micro-service creation.
Key implementations include an Ion data storage/retrieval solution with DynamoDB and Elasticsearch, a UI portal via REST APIs for seamless CRUD operations, an on-box caching solution, and a permission control system for secure data sharing.
All these developments have improved system resources and client interactions.
Implemented a client-facing REST API using AWS technologies including Lambda, CloudAuth, and API Gateway to enable direct claiming of Amazon e-Gift cards
Established a cloud formation stack to connect API Gateway with Amazon's internal microservices and developed a Java client library for seamless API integration
Resolved the Lambda cold start issue using AWS CloudWatch events, reducing average latency by nearly 50%
Collaborated with senior developers to design the HDFS export feature, ensuring seamless implementation of data pruning functionality for Sybase IQ-based virtual warehouses.
This feature validates the presence of data within the underlying HDFS prior to executing the pruning workflow.
Ensured the functionality maintains compatibility with previous versions and long-term maintainability.
Redesigned a data warehousing pipeline, achieving a 70% reduction in operational burden for the team.
Implemented a new serverless solution using Fast Data Pipelines and ensured backward compatibility for all six related microservices.
Executed daily SQL queries to reconcile data between the old and new solutions, and seamlessly transitioned to the new solution after verifying its accuracy.
Education
B. Tech in Electronics and Communication Engineering
Guru Jambheshwar University of Science & Technology, Haryana