Bhavya P
Senior Solution Engineering Specialist
Bengaluru
Summary
8+ years experienced BI Developer with an extensive journey in maximizing data visualization tools for informed decision-making. Proficient in Power BI, SQL, and ETL processes, adept at simplifying complex datasets into actionable dashboards and reports. Recognized for collaborative aptitude, delivering tailored solutions that align with business objectives, driving organizational efficiency, and facilitating strategic planning.
Overview
9
9
years of professional experience
4
4
years of post-secondary education
Work History
Senior Solution Engineering Specialist
ABB Global Industries & Services Ltd
4 2022 - Current
- Worked on CEMS, QAL3 and Anomaly detection - To measure and analyze different emissions in industry along with quality assurance level 3 and detecting analyzer anomaly
- Designed and implemented data models, back-end tables, and stored procedures using SQL
- Created dashboards with Power BI, implemented paginated reports and customized reports for stakeholders
- Developed and scheduled Linux scripts for data migration to archival tables using crontab-e
- Created gateways and scheduled refreshes with Row-Level Security (RLS) in Power BI service
- Participated in Azure Scrum activities like sprint planning and daily stand-ups
- Led R&D initiatives to enhance system capabilities
- Managed on-premises deployments to address diverse project needs.
Senior Software Engineer
Bank of America
06.2020 - 04.2022
- Conducted daily processing of payment transactions for diverse clients, ensuring seamless flow and accuracy
- Utilized SQL for comprehensive data extraction, transformation, and loading to support payment processing activities
- Built advanced data models to streamline payment data analysis and reporting
- Leveraged Power BI to design and deploy interactive dashboards that highlight payment flows, trends, and performance metrics
- Conducted performance tuning of SQL queries and Power BI reports to achieve rapid data retrieval and efficient report generation
- Implemented best practices for data integrity and accuracy, ensuring consistent and reliable reporting outputs
- Troubleshot and resolved data processing and reporting issues to maintain high efficiency and reliability
- Maintained thorough documentation of data models, SQL scripts, and reporting configurations.
Software Engineer
TechMahindra Ltd
12.2015 - 05.2020
- Led design and development of enterprise data lake for Scotiabank
- Utilized Diyotta ETL tool to extract, transform, and load data from various sources
- Managed data ingestion process, ensuring data movement to live nodes
- Actively participated in production releases and complex bug fixing
- Leveraged Power BI for report and dashboard generation, designed complex queries for data visualization
- Supported Indonesian Telecom project by collaborating with client to gather daily requirements
- Developed and maintained reports focusing on customer base analysis, IMEI analysis, and site utilization.
Education
JNTU-Ananthapuram
08.2011 - 05.2015
Skills
- PowerBI
- SQL
- DAX
- Paginated Reports
- Tableau
- Diyotta (ETL)
- Hive
Accomplishments
- Extra Miler, Synergy Accolade, Harmony Champion, Skill Balance Awards from ABB
- Bronze,Hi-Fi, Pat on the Back, Bravo Awards from BOFA and TechM
Timeline
Senior Software Engineer
Bank of America
06.2020 - 04.2022
Software Engineer
TechMahindra Ltd
12.2015 - 05.2020
JNTU-Ananthapuram
08.2011 - 05.2015
Senior Solution Engineering Specialist
ABB Global Industries & Services Ltd
4 2022 - Current