Harish Babu Pamarthi
Senior Software Technologist
Bangalore
Summary
Experienced IT professional with over 17 years of experience in Data Engineering, Data Warehousing, Data modeling, Data Architecture, Database design, ETL (Informatica), Unix Shell scripting, AWS Cloud and Python. Skilled in various database technologies such as Oracle, SQL Server, Postgre SQL, and MySQL. Strong background in team management and project management. Hands-on knowledge in Bigdata Ecosystem. Seeking a Lead Database Engineer role to leverage my skills and experience to drive innovation and improve the performance and reliability of the company's systems.
Overview
17
17
years of professional experience
6
6
years of post-secondary education
2
2
Certifications
Work History
Sr. Software Technologist / Manager
London Stock Exchange Group (LSEG)
06.2014 - Current
- Designed and developed Cloud based data ingest tool for Wealth order management platform using AWS Transfer Family, EC2, Lambda, Python, AWS Aurora PostgreSQL and S3.
- Saved close to 40% of annual infrastructure costs by migrating on-premise web application to AWS Cloud platform using DynamoDB, Postgres SQL, Python, S3, S3 Glacier, Redis, ELB, Route53 and AWS Fargate.
- Implemented a new disaster recovery and business continuity plan that significantly reduced recovery time and improved the organization's ability to handle unexpected outages.
- Manage and mentor a team of Database Engineers and Administrators, providing guidance and technical expertise to ensure the team's success.
- Improved database performance by 30% through the implementation of indexing and query optimization techniques, resulting in a noticeable improvement in application response time for end-users.
- Successfully managed several large-scale data migration projects, ensuring data integrity and minimal business disruption.
- Introduced and implemented DevOps practices resulting in more efficient, automated and streamlined release processes, faster problem resolution and increased reliability of systems.
- Collaborate with other teams and stakeholders to understand their database requirements and design solutions that meet their needs.
- Participating in incident and problem management and ensuring resolution of database-related incidents and problems.
- Implemented Next Generation framework to all ETL applications which helped improving productivity for operations, data quality to WM ODS, improved process consistency and reduce development learning curve.
- Automated entire suite of ETL applications using Control-M which helped gaining 90% of monitoring effort in production, stage and QA environments.
- Automated complex file movement process using Control-M. It improved file movement performance by 80% and also improved operations visibility across various environments.
- Identified bottlenecks and worked on performance tuning of ETL jobs/complex SQL queries which in turn improved run times of daily ingestion process in turn helped meeting SLA's for all clients.
Module Lead / IT Project Coordinator
CenturyLink
12.2008 - 06.2014
- Had taken complete responsibility for all end to end ETL deliverable's from offshore with respect to application which has around 3000+ jobs which are extracting data from 90+ source systems.
- Delegated team size of five to eight members and have been helping and guiding team as and when need help during work.
- Worked as IT Project Coordinator for 20 months at Denver, United States and coordinated several critical projects in order to get them executed with offshore teams within specified timelines.
- Worked closely onshore management, business users and also development DBA for migrating Combined company data warehouse application from Oracle RAC to Exadata which is having around 300 + Informatica jobs.
Sr. Software Engineer
JBA Infotech Pvt Ltd
09.2007 - 11.2008
- Involved in developing ETL tasks which includes extraction of data that comes from different operational systems of different lines of business like Auto (APPS), Fire (FPPS), Life (eCMS) & Home (eCMS) and loading it into data mart to generate agent, customer and quotes analysis reports.
- Involved in Development of several Informatica mappings, mapplets, reusable components, sessions and workflows also involved in tuning mappings for Optimum performance and Dependencies.
- Performed unit testing on Informatica mappings and fixed bugs.
Education
Master of Computer Applications - Computer Science And Programming
Vellore Institute Of Technology
Vellore 07.2001 - 04.2004
Bachelor of Science in Electronics - Electronics And Electronic Equipment Maintenance
P. B. Siddhartha College Of Arts & Science
Vijayawada 07.1997 - 04.2000
Skills
Informatica Power Center / Power Exchange - ETL
Oracle SQL and PL/SQL - Database
Unix Shell Scripting - Scripting
Control-M - Scheduling & Monitoring
Amazon Web Services - Cloud
Microsoft Azure - Cloud
Microsoft SQL Server - Database
Python - Scripting
DynamoDB - NoSQL
Wealth Management Technology
JIRA
Project management
Team management
Stakeholder management
Agile Methodology
GitHub
RDS - Postgres
CI/CD Pipeline Process
Big Data
RDS - MySQL
Accomplishments
- Platinum Award Received during Oct 2024 from London Stock Exchange Group (LSEG) for eliminating critical blocker in Cyprus Project saving millions of dollars for the company.
- Platinum Award Received during Oct 2024 from London Stock Exchange Group (LSEG) for the work done on Advisor Dashboard Project.
- Hall of Fame Q4 2017 Received during Feb 2018 from Thomson Reuters for successful implementation of Enterprise Scheduling Tool (Control-M) into the Wealth Management Operational Practice.
- DWBI All Star Award Received during Dec 2013 form CenturyLink for successfully migrating Combined company data warehouse application from Oracle RAC to Exadata.
Certification
AWS Certified Solutions Architect - Associate
Timeline
Microsoft Certified - Azure Fundamentals
06-2023
AWS Certified Solutions Architect - Associate
06-2019
Sr. Software Technologist / Manager
London Stock Exchange Group (LSEG)
06.2014 - Current
Module Lead / IT Project Coordinator
CenturyLink
12.2008 - 06.2014
Sr. Software Engineer
JBA Infotech Pvt Ltd
09.2007 - 11.2008
Master of Computer Applications - Computer Science And Programming
Vellore Institute Of Technology
07.2001 - 04.2004
Bachelor of Science in Electronics - Electronics And Electronic Equipment Maintenance
P. B. Siddhartha College Of Arts & Science
07.1997 - 04.2000
Similar Profiles
Matus LaiwanitMatus Laiwanit
Lead Software Engineer at London Stock Exchange Group (LSEG)Lead Software Engineer at London Stock Exchange Group (LSEG)
M VARSHAM VARSHA
Content Analyst at London Stock Exchange Group (LSEG)Content Analyst at London Stock Exchange Group (LSEG)
Arghya Kusum DharArghya Kusum Dhar
Director - Transformation & Operational Excellence at London Stock Exchange Group (LSEG)/RefinitivDirector - Transformation & Operational Excellence at London Stock Exchange Group (LSEG)/Refinitiv
Anil Kumar SawAnil Kumar Saw
Staff Engineer at Altimetrik India Pvt. LtdStaff Engineer at Altimetrik India Pvt. Ltd
Hisham ParveezHisham Parveez
AI Engineer at Optimum SolutionsAI Engineer at Optimum Solutions