Aditya Jamalpur
Data Engineering, BI, And Quality Assurance
The Rocks,NSW
Summary
Result-driven Business Intelligence (BI) and Data Analytics Professional with 9+ years of experience in delivering end-to-end BI solutions, data visualization, and analytics for telecom and banking industries. Proficient in the full BI stack including Tableau, Power BI, Qlik Sense, Teradata, SAS DI, Python and Splunk , with hands-on expertise in Kenan telecom billing systems , shell/Unix scripting , and cloud platforms like AWS . Skilled in data modeling , ETL processes , and database management using Postgres, Oracle, and SQL . Adept at managing complex data pipelines, optimizing SQL queries, and delivering actionable insights to drive business decisions.
Overview
10
10
years of professional experience
5
5
years of post-secondary education
4
4
Certifications
3
3
Languages
Work History
Data Engineer
Tata Consultancy Services Ltd.
Sydney, New South Wales
06.2019 - Current
- Worked as a Tableau Desktop developer focusing on developing high-end visualization driven by data coming from various data sources SQL Server, MS Excel
- Migrated on-premise BI applications to AWS, ensuring scalability and cost-efficiency.
- Conducted data modeling using star and snowflake schemas for telecom project.
- Managed Unix servers and applications, ensuring high availability and performance.
- Developed multiple ETL jobs and stream line to load data in DWH, thereafter creating reports and dashboards
- Creating project requirement documents for ETL projects to load in DWH and closely working with client architecture for end users
- Managed and upgraded custom applications built on diverse technologies including Perl, Shell, Java, and APIs (BRE, OBS, BPEL) , ensuring compatibility with the upgraded Kenan system and meeting client-specific requirements.
- Worked on AWS cloud services (EC2, S3, RDS) to host and manage BI applications and databases.
- Provided technical leadership in troubleshooting and resolving production issues related to the Kenan application, ensuring minimal downtime and business continuity.
- Upgraded Kenan Telecom Billing Application from version 2.0 to 6.0 , ensuring seamless migration, enhanced functionality, and improved system performance.
- Migrated the Kenan application infrastructure from on-premise Oracle databases to AWS cloud , leveraging Postgres as the primary database, resulting in improved scalability, cost-efficiency, and reduced maintenance overhead.
- Optimized SQL queries for Kenan core databases to align with the new cloud infrastructure, improving query performance by 30% and reducing data processing time.
- Managed and upgraded custom applications built on diverse technologies including Perl, Shell, Java, and APIs (BRE, OBS, BPEL) , ensuring compatibility with the upgraded Kenan system and meeting client-specific requirements.
Business Analyst
IBM India Ltd.
03.2015 - 06.2019
- Analyzed business requirements and build logical data models that describe all the data and relationships between the data
- Developed calculated fields and measures using DAX expressions, and have hands-on experience creating Power BI reports with diverse visualizations, including custom visualizations.
- Performed data analysis and EDA using Python (Pandas, NumPy) to derive insights from financial and telecom data.
- Developed ETL workflows using SAS DI and IBM LSF Scheduler to streamline data integration processes.
- Collaborated with marketing teams to analyze campaign performance and generate actionable insights.
- Having experience on installing and configuring Data Gateway to deploy scheduled refresh for Power BI service reports
- Having good experience in Power Query in Power BI to transform the data, also created Bookmarks and sync slicers to move from one page to other page based on requirement like moving forward and backward navigations.
- Analyzing efficiency of various campaigns by performing essential analysis using SQL queries, to enhance insights & expand upcoming campaigns; generating campaign lead list accurately & on time
- Ensuring timely resolution of Marketing team queries & ad-hoc requests by collaborating with marketing stakeholders
- Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.
Education
B. Tech -
JNTUH
Hyderabad, Telangana 01.2010 - 01.2014
Intermediate - State Board of AP
State Board of Intermediate Education
Hyderabad 01.2009 - 01.2010
Skills
Microsoft Power BI
Tableau
Teradata
Splunk
DB2
SQL
MS Excel
Power query Editor
MySQL
ADF
T-SQL
Azure Services
SAS-DI
undefinedCertification
Agile Practitioner from Bluemix IBM
Awards
- Manager Recognition award, 2016
- Star performer award, 2017
- Best Performer award, 2019
Timeline
Data Engineer
Tata Consultancy Services Ltd.
06.2019 - Current
Business Analyst
IBM India Ltd.
03.2015 - 06.2019
B. Tech -
JNTUH
01.2010 - 01.2014
Intermediate - State Board of AP
State Board of Intermediate Education
01.2009 - 01.2010
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Poornima BalakrishnanPoornima Balakrishnan
API Development Lead at WestpacAPI Development Lead at Westpac