Swati Bhatt
Business Intelligence Lead
Bengaluru
Summary
- Seasoned Business Intelligence Professional with over 12 years of
experience. Demonstrated exceptional analytical prowess and a keen ability to translate complex data into actionable insights using Power BI, SQL and Cognos Analytics. Excels in data modeling,data analytics and possesses strong problem-solving skills, ensuring precision in data-driven decision-making.
Overview
13
13
years of professional experience
1
1
Certificate
Work History
Business Intelligence Lead
Riskonnect(Formerly Ventiv Technology)
Bengaluru
02.2021 - Current
- Developed and led the BI strategy of the product, acting as a key decision-maker for BI initiatives.
- Responsible for delivering and maintaining over 200 Power BI reports and dashboards tailored to business needs.
- Expertise in creating semantic data models using Power BI Desktop.
- Proficient in utilizing Power Query, DAX functions, and custom measures to attain meaningful insights from the data.
- Maintained the legacy BI system developed in Cognos Analytics.
- Successfully migrated 200+ reports from Cognos 10.2 to Cognos 11 version.
- Expertise in implementing interactive features in Cognos reports, including drill-through, master-detail, report bursting, JavaScript Interactivity, and Event Studio.
- Proficient in using Cognos components like Report Studio, Framework Manager, Event Studio and Dashboards.
- Implemented row-level security in both Power BI and Cognos reports.
- Demonstrated ability to enhance system performance through strategic tuning in both BI reports and SQL queries, thereby improving efficiency by 40% in reports and dashboards.
- Leveraged advanced SQL to solve complex business problems.
- Expertise in implementing dimensional modeling in the organization's data warehouse.
- Involved in development of ETL pipelines using Apache Spark, Scala, Hive, and Unix Shell scripting.
- Conducted team meetings to discuss project progress updates.
- Adept at communicating with clients for requirement analysis and discussing analysis results.
- Guided a team of 4 junior BI developers to help achieve project targets with quality results.
Developer Analyst 2
Wipro
Noida
08.2017 - 01.2021
- End-to-end design, development, and deployment of the data model, reports, and dashboards using Cognos Analytics to meet customer needs.
- Developing Ingestion Framework in Hadoop to bring in the raw data from source.
- Executed ETL flow design and development with Apache Spark/Scala and Hive technologies.
Software Development Engineering, Professional
Fiserv
Noida
08.2015 - 08.2017
- Designed and developed tailored reporting solutions by leveraging Cognos Report Studio and Framework Manager to meet customer needs.
- Migrated Hyperion reports to Cognos using Cognos Report Studio and Framework Manager.
Systems Engineer
Tata Consultancy Services
Bengaluru
12.2011 - 08.2015
- Created client-specific business reporting applications using Cognos.
- Handling fixing of the issues that arise in production.
- Doing the change requests and enhancements in the existing reports.
Education
B.Tech - Computer Science & Engineering
Gautam Buddh Technical University (now AKTU)
Lucknow07.2011
Skills
- Power BI
- Cognos Analytics
- SQL expertise
- Data visualization
- ETL development
- Dimensional Data Modeling
Timeline
Business Intelligence Lead
Riskonnect(Formerly Ventiv Technology)
02.2021 - Current
Developer Analyst 2
Wipro
08.2017 - 01.2021
Software Development Engineering, Professional
Fiserv
08.2015 - 08.2017
Systems Engineer
Tata Consultancy Services
12.2011 - 08.2015
B.Tech - Computer Science & Engineering
Gautam Buddh Technical University (now AKTU)
Certification
- Cognos 10 BI Author
- Cognos 10 BI Metadata Model Developer
Languages Known
Hindi
First Language
English
Proficient (C2)
C2
Personal Information
Nationality: Indian
Similar Profiles
Piyush Sudhir ShobhanePiyush Sudhir Shobhane
Technical Lead Architect at Riskonnect (Formerly Known As Ventiv Technology)Technical Lead Architect at Riskonnect (Formerly Known As Ventiv Technology)
Devin TaylorDevin Taylor
Senior Enterprise Renewals Account Manager at RiskonnectSenior Enterprise Renewals Account Manager at Riskonnect
Suresh Babu SSuresh Babu S
Senior Technical Lead /Architect Project Manager at Ventiv Technology and Harman Connected ServicesSenior Technical Lead /Architect Project Manager at Ventiv Technology and Harman Connected Services