PHANI KUMAR BOLLAM

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
See more

Work Experience

Sr. Data Engineer at Vitamin Shoppe Industries
April 1, 2016 - Present
Led and supported tools (SQL Server, Tableau, AWS, Snowflake, Talend); championed cloud migration from on-premises to cloud. Developed ETL workflows using Talend to integrate data from multiple sources (SQL Server, AS400, Oracle, Google Analytics) into Snowflake. Implemented Snowflake Time Travel and Fail-Safe, reducing downtime by 35%. Executed data migration strategies reducing legacy maintenance costs by 25%. Built data ingestion frameworks using Snowpipe, increasing data availability by 20%. Developed Snowflake UDFs to streamline transformations, reducing processing times by 18%. Designed and maintained cloud-native apps on Azure (C#, Python). Accelerated dashboards and Power BI reports; production time down 30%. Implemented advanced DAX queries in Power BI for enhanced performance (~20%). Improved ETL reliability via Python-based migrations and cleansing using AWS EC2/S3 and Snowpipe. Designed Snowflake stored procedures with error handling and performance tuning. Proficient with
Assistant Manager (Information Technology - SQL Engineer) at ICICI Bank
October 1, 2013 - January 1, 2016
Gathers and analyzes core banking data (credit, savings, and current accounts). Strong SQL skills across Oracle, MySQL, DB2, and SQL Server. Experience with data warehousing concepts (star/snowflake schemas), ETL processes, and end-to-end ETL development. Designed and developed Talend ETL jobs for data migration; integrated heterogeneous sources into data warehouses and data marts. Troubleshoots long-running jobs; develops SSIS packages to load data from DB2, Excel, and flat files into SQL Server; creates management reports using SSRS. Developed complex T-SQL stored procedures, views, and functions; optimized queries. Monitored KPIs and data quality to improve processes.
BI Analyst at Onicra Credit Rating Agency of India Ltd
October 1, 2010 - October 1, 2013
Created SSIS packages to consolidate data sources (Oracle, MS Excel, CSV files) into SQL Server. Designed conceptual, logical, and physical data models using Erwin; implemented ETL workflows for data warehousing. Developed interactive SSRS reports (sub-reports, drill-down, parameterized) to deliver insights for SME assessments.

Education

Post-Graduate Diploma in Management at FLAME University
January 1, 2007 - January 1, 2009
Bachelor of Engineering at Sathyabama University
January 1, 2003 - January 1, 2007

Qualifications

Add your qualifications or awards here.

Industry Experience

Financial Services, Retail, Software & Internet, Professional Services, Computers & Electronics