Mayanka Thani
Tampa,FL
Summary
Hardworking and passionate Business Intelligence expert with over 12 years of experience, excelling in transforming raw data into actionable insights using tools like QlikView, Tableau, and Power BI. Proven leadership, analytical thinking, and strategic planning skills empower dynamic environments to drive business growth and achieve organizational goals.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Business Intelligence Manager
Charles Schwab
11.2020 - 01.2024
- Led data governance and data quality management initiatives, establishing robust data models and frameworks to enhance data integrity and accessibility by 30%.
- Designed and implemented 50 SSRS reports, optimizing calculations and version control with GIT (Bitbucket) for improved performance and scalability by 55%.
- Directed team of 5 BI analysts, providing mentorship and fostering continuous improvement in developing impactful BI solutions.
- Developed comprehensive BI showcase designs using PowerPoint to produce user manuals and training materials that conveyed technical insights effectively.
- Collaborated with senior stakeholders to define business needs, gathering and translating requirements into technical specifications for BI solutions.
- Managed Tableau and GCP cloud migrations, improving data visualization and analysis by creating interactive dashboards and automating reporting.
- Created Tableau scorecards and dashboards, leveraging advanced visualization tools and data blending techniques for efficient reporting solutions.
- Automated manual reports using Alteryx and Answer Rocket, streamlining report generation for enhanced decision-making.
- Developed 15 SSIS packages for data loading from multiple sources, optimizing ETL workflows and queries for efficient data processing time by 45%.
Sr Technical Analyst & BI Solutions Architect
PricewaterhouseCoopers (PWC)
05.2018 - 11.2020
- Designed and implemented comprehensive reporting solutions utilizing PeopleSoft and Workday HCM ERPs to optimize HR analytics.
- Developed T-SQL scripts, SSIS packages, and database objects to improve application development and reporting efficiency.
- Created and optimized ETL packages in Informatica, resulting in a 40% increase in data migration speed to Google Cloud Platform (GCP).
- Led data warehouse design and implementation, focusing on metadata management and database architecture.
- Managed HCM reporting and turnover projects, leveraging Crystal Reports, Tableau, and Thought Spot for actionable insights.
- Utilized Informatica Power center for comprehensive data warehousing, enhancing ETL workflows and data modeling, reducing data transformation time by 25%.
- Significantly optimized data packages across Oracle, SQL Server, and Teradata, increasing data processing efficiency.
- Developed SharePoint solutions, including custom web parts, content management, and sites to improve collaboration.
- Elevated software quality by implementing robust maintenance protocols using Alteryx and rigorous QA and integration testing across diverse application environments.
Sr ETL Consultant/BI Analyst
JP Morgan Chase
07.2014 - 05.2018
- Designed and implemented robust ETL processes to extract, transform, and load data from multiple banking systems, improving data warehouse efficiency by 30%.
- Developed scalable data models and architecture to support complex banking analytics and ensure smooth data flow.
- Formulated comprehensive testing strategies to identify and resolve more than 200 application defects, ensuring robust software quality across environments.
- Automated and developed 50+ reports using SSRS and BI tools to support banking compliance, performance analysis, and data-driven decision-making.
- Optimized data workflows with Alteryx data blending and functionalities, ensuring data accuracy and efficiency.
- Created and maintained BI solutions using Power BI, Tableau, and QlikView to visualize banking metrics and drive strategic insights.
- Implemented data quality checks and governance practices to ensure accuracy and consistency of data, enhancing ETL processes using Alteryx.
- Developed dynamic dashboards with Tableau, Power BI, and QlikView, enabling efficient visualization of complex datasets for actionable insights.
- Led Base Support team as a Team Lead, coordinating between onsite and offshore teams to maintain operational efficiency.
Software Consultant/Business Analyst
Quest Diagnostics
04.2013 - 07.2014
- Collaborated with healthcare stakeholders to identify business requirements and translated them into technical specifications for Exam View and Exam One development.
- Leveraged BI tools to extract actionable insights from healthcare data, improving patient outcomes through data-driven decision-making.
- Developed advanced reporting metrics including Compound Metrics and Custom Groups to meet complex reporting needs.
- Optimized SQL queries for enhanced performance, and fine-tuned complex T-SQL queries and stored procedures for efficient reporting.
- Enhanced SSRS reports using advanced features like snapshots, caches, and embedded queries, showcasing deep expertise in Microsoft Reporting Services.
- Resolved data migration issues, converting Excel reports to Tableau for automated reporting.
- Utilized TFS for version control to maintain code integrity.
- Implemented data governance standards and enforced security measures to protect sensitive client information using Alteryx.
- Created around 1000 custom SSRS reports and converted DTS packages to SSIS to enhance data integration.
BI Developer Consultant
Bank of America
04.2011 - 03.2013
- Designed and implemented robust data models and ETL processes, streamlining banking data for asset management to ensure data integrity and seamless analytics.
- Developed advanced BI reports using Power BI, Tableau, and SSRS, providing visual insights into key banking metrics to support strategic decision-making.
- Authored advanced T-SQL queries and stored procedures to enhance data analysis, processing, and financial reporting efficiency.
- Implemented client-side validations using Alteryx to optimize data workflows and ensure accuracy of data processing.
- Developed PL/SQL stored procedures and packages to streamline data management, enhancing efficiency and accuracy.
- Leveraged Thought Spot for intuitive data analytics and insights, driving actionable business intelligence.
- Managed and optimized data warehouses to ensure data consistency, supporting robust banking analytics and reporting.
- Built and maintained interactive dashboards to monitor financial KPIs, compliance metrics, and performance trends.
- Developed custom SSRS reports and converted DTS to SSIS, migrating over 1,000 reports to enhance data integration and analysis.
Education
Master’s in Computer Science -
California Lutheran University
Thousand Oaks, CA01.2010
Master’s in Information Technology -
Karnataka State Open University
New Delhi, India01.2008
Bachelor’s in Computer Applications -
GGS Indraprastha University
New Delhi, India01.2007
Skills
- Business Intelligence (BI) Expertise
- BI Enterprise Data Warehouse Leadership
- Comprehensive BI Experience
- Reporting & Visualization
- Tableau Specialist
- Data Management Excellence
- ETL Design & Agile Project Management
- Advanced Data Analysis Google Cloud
- Alteryx Expert
- Informatica & ETL Proficiency
- SDLC & Agile Methodologies
- Google Big Query Specialist
- SharePoint Specialist
- SQL Expertise
- Control M & Version Control
- Leadership & Interpersonal Skills
Certification
SAFe® 5 Scrum Master
Alteryx Designer Core Certified
ThoughtSpot Professional Certified.
Timeline
Business Intelligence Manager
Charles Schwab
11.2020 - 01.2024
Sr Technical Analyst & BI Solutions Architect
PricewaterhouseCoopers (PWC)
05.2018 - 11.2020
Sr ETL Consultant/BI Analyst
JP Morgan Chase
07.2014 - 05.2018
Software Consultant/Business Analyst
Quest Diagnostics
04.2013 - 07.2014
BI Developer Consultant
Bank of America
04.2011 - 03.2013
Master’s in Computer Science -
California Lutheran University
Master’s in Information Technology -
Karnataka State Open University
Bachelor’s in Computer Applications -
GGS Indraprastha University