Aakshi Jain
Senior BI Consultant
Toronto
Summary
An ambitious and result oriented professional with over 13 years of experience and proven knowledge of Power BI, DAX queries, SQL, MSBI tools (SSRS, SSIS,SSAS) Along with market leading Azure Data Factory, Azure Sql DB & WH server with excellent communication, interpersonal and creative thinking skills. Good in a crisis and can be relied upon to help the organization achieve its goals. Prudent Business Intelligence Analyst providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.
Overview
13
13
years of professional experience
Work History
Lead BI Consultant
BC Inc. (Contract With Government of Ontario)
06.2024 - Current
- Designed and implemented ETL pipelines using Azure Data Factory to automate data workflows and integration tasks.
- Leveraged ADF's data flow and mapping data flow features to transform and clean data before loading into target storage solutions.
- Monitored pipeline performance and troubleshooting issues using Azure Data Factory's monitoring tools and logs.
- Developed and deployed data processing and analytics workflows using Databricks notebooks in a collaborative environment.
- Implemented scalable data processing solutions using Apache Spark within Databricks to handle large volumes of data efficiently.
- Utilized Databricks Delta Lake to ensure reliable data storage and improve data processing speed and accuracy.
- Designed and developed automated workflows using Azure Logic Apps to integrate and streamline business processes and data transfers.
- Implemented triggers and actions within Logic Apps to connect various Azure services, APIs, and third-party applications.
- Developed and optimized SQL queries, stored procedures, and functions to extract, manipulate, and analyze data from relational databases.
- Designed and maintained database schemas, indexes, and views to support efficient data retrieval and reporting.
- Implemented performance tuning techniques, including query optimization and indexing strategies, to enhance database performance.
- Utilized SQL for data migration and integration tasks, ensuring smooth data transitions between systems.
Senior Manager
Exl Service Canada, Inc.
06.2024 - 07.2024
- Established strong relationships with clients and stakeholders, ensuring long-term partnerships and repeat business.
- Implemented and developed operational standards, policies and procedures.
- Optimized data warehouse structures, resulting in a 25% increase in data processing speed.
- Automated regular data extraction, reporting in a 20% time expenditure reduction.
- Devised a Power BI reporting solution that increased efficiency in report generation by 40%.
- Assisted in the development of reports and dashboards, reducing delivery time by 15%.
- Contributed to the streamline of ETL processes, enhancing efficiency by 20%.
Lead BI Consultant
BC Inc. (Contract With Government of Ontario)
10.2022 - 03.2024
- Active participation in requirement gathering, analysis, and design.
- Recognized business requirements and used Power BI to translate them into reports that are actionable.
- Developed datasets and Power BI dataflow
- Used Power BI to create interactive visual reports and dashboards by adhering to the finest UX design principles.
- Developed deployment pipelines for datasets, reports, and dashboards.
- Developed intricate DAX Measures and computed columns for intricate Power BI Report computations.
- Developed and maintained SSIS ETL packages to retrieve data from various sources.
- Developed MDX queries using SSIS packages to retrieve data from SSAS cubes on the source system.
- Worked to match our performance SLAs with the slow-running reports' performance.
- Developed dimensional data modeling (views & tables)
Worked on stored procedures, tables, views, and indexes in a database
Lead BI Consultant
Apptoza (Contract with TCS)
01.2022 - 08.2022
- The objective of the application is to archive the governed data of the firm in a central data repository
- The data available is used to develop analytical solutions for different business lines
- Mentored junior team members in BI best practices, fostering professional growth and development.
- Actively participated in industry events, staying current on best practices while expanding professional network connections for future collaborations.
Senior ETL Developer
Circle of Care, Sinai Health Systems
06.2019 - 01.2022
- The goal of the company was creating an integrated health system that provides more efficient, coordinated care for patients
- Documented technical specifications, enabling seamless knowledge transfer among team members.
- Mentored junior developers, sharing knowledge of best practices in ETL development and design.
- Addressed critical issues in a timely manner, minimizing downtime and ensuring uninterrupted service levels.
- Collaborated with cross-functional teams to define requirements and deliver high-quality solutions.
- Implemented robust error handling techniques, resulting in fewer data discrepancies during the ETL process.
BI Consultant
Nagarro Software Pvt. Ltd
08.2015 - 05.2019
- Upgrading of all operational report from excel to PBI
- Optimized data quality by conducting thorough data validation and cleansing procedures.
- Conducted ongoing maintenance of established BI solutions, ensuring optimal performance during periods of growth or change.
- Identified areas for improvement in existing BI systems through regular system audits and evaluations.
- Enhanced business decision-making by developing and implementing effective BI strategies.
- Leveraged visualization techniques, making it easier for stakeholders to understand complex patterns within their data.
System Analyst
Verizon India
06.2011 - 07.2015
- Project involved the development of home network management solution, which manages the entire database of STB's and routers at customer premises
- It also takes care of registration and activation of devices, diagnosing problems in devices, and resolving the issues
- The main target of this project is to reduce the number of FSC calls made to customer care.
- Executed successful integrations with third-party applications, expanding functionality available through core systems platforms without compromising stability or security considerations.
- Implemented rigorous testing procedures to ensure optimal performance and minimize errors in software applications.
- Conducted comprehensive system analyses to identify areas for improvement and optimization.
- Facilitated training sessions for staff members on new software applications, promoting efficient adoption of new technologies across the organization.
- Designed custom reports for management teams, providing valuable insights into key performance metrics and facilitating informed decision-making processes.
Education
Bachelor of Technology -
BMIET
Sonipat, Haryana 06.2007 - 2011.04
Higher In Secondary Education -
C.B.S, Hindu Vidyapeeth School
Sonipat, Haryana 05.2006 - 2007.04
Bachelor's degree -
C.B.S, Hindu Vidyapeeth School
Sonipat, Haryana 05.2004 - 2005.04
Skills
Crystal Reports
Azure DevOps
Power BI, Tableau
Microsoft Azure (Data Lake, Azure Data Factory, Azure Data store (Tables, Blob), Runbooks etc)
MSBI
Agile project management
Requirements Gathering
Data Warehousing Management
Dashboard development
DAX Language (SSAS)
SQL Server database 2018/2016/2014/2012/2008/ R2 with T- SQL
Accomplishments
- Received ON SPOT Award multiple times for Best Performance in team
- Got highest rating in my team in my first year of job
- Organized trainings on Knowledge Transfer in Verizon Data Services India
- Won Prizes in cultural activities in college festivals and intra-college competitions
- Won many prizes in various sports and extra co-curricular activities at school level
References
References available upon request
Languages
English
Hindi
Timeline
Lead BI Consultant
BC Inc. (Contract With Government of Ontario)
06.2024 - Current
Senior Manager
Exl Service Canada, Inc.
06.2024 - 07.2024
Lead BI Consultant
BC Inc. (Contract With Government of Ontario)
10.2022 - 03.2024
Lead BI Consultant
Apptoza (Contract with TCS)
01.2022 - 08.2022
Senior ETL Developer
Circle of Care, Sinai Health Systems
06.2019 - 01.2022
BI Consultant
Nagarro Software Pvt. Ltd
08.2015 - 05.2019
System Analyst
Verizon India
06.2011 - 07.2015
Bachelor of Technology -
BMIET
06.2007 - 2011.04
Higher In Secondary Education -
C.B.S, Hindu Vidyapeeth School
05.2006 - 2007.04
Bachelor's degree -
C.B.S, Hindu Vidyapeeth School
05.2004 - 2005.04
Similar Profiles
Winifred OliverWinifred Oliver
Medical Claims Processor Remote at BC Forward (Contract Agency)Medical Claims Processor Remote at BC Forward (Contract Agency)
Alannah DelgadoAlannah Delgado
Private Contractor at Contract-OntarioPrivate Contractor at Contract-Ontario
Shawnna HooverShawnna Hoover
Sales Associate at BC Government Liquor StoreSales Associate at BC Government Liquor Store