Priyanka Sharma
Data Analytics Manager
Summary
Data Analytics Manager with a master's degree and 7 years in development role. Collaborated closely with various teams providing data insights to internal and external business users to achieve key strategic goals. Hired, trained, and managed a team of 4 people. Worked with Ministry or Transportation, Judiciary & Public Safety, Shipping, Finance, Manufacturing, IPTV domains. Excellent project management and process improvement skills.
Overview
8
8
years of professional experience
Work History
Data Analytics Manager
MOTI
Vancouver
05.2022 - 06.2023
- The Ministry of Transportation and Infrastructure (MOTI) plans transportation networks, provides and maintains transportation services and infrastructures
- As a sub-project of PSP (Properties Services Project), Data Analytics team was responsible for implementing a solution that records, tracks, and manages information about all property interests of MOTI/BCTFA and enables efficient operation of the Ministry's associated property business processes
- Tools Used: SSIS - Microsoft Visual Studio 2019, SSIS , Alteryx, SQL server 2018, Oracle SQL Developer, Git, VS Code, Tableau
- Produced the required analysis and application design by actively participating in development process
- Responsibilities include technical analysis, design, development, and performance enhancements
- Solely responsible for loading data into Data Warehouse and Data Marts through new ETL flow creation
- Implemented ETL process in Alteryx to extract data from multiple sources (SQL Server, XML, Excel and CSV) and schedule workflows
- Managed end to end complex data migration, conversion, and data modeling (using Alteryx, SQL), and created visualization using tableau to develop high quality dashboards
- Managed and participated ‘hands-on' in the implementation by analyzing user requirements, providing technical specifications and designs, developing detailed work-plans, monitoring progress against plan
- Validated and transformed data extracted from structured and unstructured data inputs, databases, and other repositories, using scripts and other automated capabilities, logs, and queries, as required
- Collaborated with other developers, DBA, BAs and researchers in enhancing existing projects or data structures and resolving project and programming issues
- Act as a subject matter expert for the ETL architecture for the EDW
- Create, document, and execute test plans for data loading and data validation scripts in collaboration with Agile team members.
Senior DWH Developer
Teekay Corporation
Vancouver
03.2021 - 05.2022
- Teekay is a leading provider of international crude oil and gas marine transportation services
- Working closely with System Architects, Data Engineers, and Analysts, I delivered business value through the development of data products for entities worldwide
- Tools Used: SSIS - Microsoft Visual studio, SSRS – Report Builder, SSAS – SQL server 2018, Azure, DevOps
- Converted all TK-Australia data from excel reporting to SSRS reports
- The work included modifying SSIS packages to include new data as per user's requirements, changes in transformation logics and data correction in stage tables, deploying and testing those changes in different environments, creation of new SSRS reports from scratch based on that data
- Automation of reports lead to time saving, compliant and cost-effective solution
- Created and modified API queries for Tankers to display data on a portal called “Teekay One” to be accessed by everyone leading to lesser data related queries and cost-savings on providing access to everyone
- Created and modified SSRS, SSAS reports for Tankers, Gas and Australia for Audits, Inspections and KPIs which helped identify gaps to make improvements and strengths to build upon
- Monitored and provided production support for data ingestion and data warehouse processes for smooth running of day-to-day tasks and reporting solutions
- Performed root cause analysis on data and processes to answer specific business questions and identify opportunities for improvement
- Modified Azure Pipelines to include new feature to clean historic data
- Deployed the same through DevOps in different environments.
Data Scientist
Road Safety BC
Vancouver
01.2021 - 03.2021
- The Road Safety Initiative (RSI) is a major business transformation initiative to implement electronic ticketing, on-line payment, and plan for an Administrative Justice Tribunal to resolve traffic ticket disputes out of the courts
- RoadSafetyBC is the lead provincial government agency responsible for road safety in B.C
- Tools Used: PowerBI Desktop, PowerBI Report Server, Sql Server Management Studio, t-SQL, Confluence, JIRA
- Modified the PowerBI dashboards to house them on the report server
- Rebuilt direct queries, used data warehouse instead of custom spreadsheets, worked on analysis to determine migration plan of the current dashboards to the report server data to provide an integrated source of data
- Reviewed and documented data quality issues (excel files/in SQL databases)
- Developed mechanism to easily track user access to each of the dashboards using row level access
- Organized existing reports by reviewing & updating structure
- Investigated a possible solution to employ a structure/process allowing changes to be made to a central source and cascade to established dashboards
- Established sustainable guidelines for where to house future reports.
Data Warehouse Specialist
Seaspan Corporation
Vancouver
08.2020 - 01.2021
- Seaspan is the worldwide leader in independent containership management and ownership
- Team of 7 members developing DWH to consolidate data from different sources to create better reporting solution
- Tools Used: SQL Server Management System, PowerBI, JIRA, MySQL Workbench, Advanced Excel
- Hands-on experience of the Data Modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
- Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types and corporate meta-data definitions as initiation step for DWH creation
- Created new dimensions tables and added them to the ETL workflow implementing SCDs - Type I & II
- Added Facts in ETL workflow
- Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for EDW within a metadata repository
- Rebuilt direct queries to use data from data warehouse
- Created views/datasets mapping fields in existing reports to fields in DWH for various PowerBI and excel reports
- Created Corporate Data Dashboard containing data glossary for metadata repository providing user access to business layer there by reducing ad hoc requests.
Senior Business Intelligence Developer
Guest-tek Interactive
Calgary
10.2019 - 07.2020
- Guest-tek is world's largest provider of high-speed internet & IPTV solutions to the global hospitality industry, operating in 85 countries and 3900+ hotels
- Worked as a part of data services team (ETL and reporting)
- Tools used: SSIS, Advanced Excel, Power BI, Salesforce, MySQL workbench, Logi, Synapse, Sharepoint
- Acknowledged, analyzed, and resolved issues within or before resolution time agreed on SLAs and managed to improve response time from 95% to 98.9% in the first month
- Analyzed data collected in stores (DTS Package, T-SQL, stored-procedures, queries)
- Optimized DTS, stored procedures and jobs into SQL Server to increase overall performance and time/server use of daily functions
- Developed PowerBI dashboard communicating bandwidth usage data summaries on different properties for enterprise wide data in a single view
- Utilized Power BI (Power View) to create various analytical dashboards depicting critical KPIs along with slicers and dicers enabling end-user to make filters
- Created detailed Work Breakdown Structures which resulted in drafting realistic, achievable schedules and reduction in unnecessary surprises and risks
- Applauded in top executive meeting for quick learning and delivery of high value solutions.
Sr. Business Intelligence Developer
Steria India Limited
09.2017 - 09.2019
- THALES is a leading manufacturing company, primarily in the defence sector, with Oracle ERP solutions in 15 different entities across Europe, including BI solution BICM with different data marts across various Domains
- Tools Used: Cognos, IBM Data Manager, Framework Manager, SSIS, PowerBI, Tableau, JIRA, KISS, SVN
- Developed, tested, analyzed, and maintained data models with layered approach consisting of filters and data level security for 350+ reports for 25 countries to provide real time data
- Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
- Implemented several DAX functions for fact calculations for efficient data visualization in Power BI
- Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources
- Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs
- Worked closely with functional team, developers and testers throughout the development process to identify any knowledge gaps for successful project deliveries in Dev/UAT/Prod environments
- Designed, managed and reviewed Interface/Conversion ETL code before moving to QA to ensure design standards are met for 230 ETL jobs to update data daily before business hours started
- Hired, trained, and managed a team of 4 resources (performed work estimation and workflow management) whilst collaborating with other teams within the project to support overall data needs.
Business Intelligence Developer
Steria India Limited
05.2015 - 08.2017
- British Telecom applications cater to financial reporting and consolidation team of BT and supporting their management reporting, Deals, Eliminations (Intra-Inter), Overlay, Planning and Forecasting applications
- Tools Used: Hyperion, Essbase, HSS, MMM, SmartView (in Excel), Control - M, Bridge Clarifier and HPSM
- Requirements gathering, analysis, testing and project coordination
- Generated ad hoc reports using Excel SmartView to help support daily reporting needs and queries of business users
- Carried out production pushes as per client request to inculcate new business rules and rule files into the databases and troubleshooted real-time problems on daily basis for better performance and service
- Automated ineffective processes cutting down the initiation to execution time to 3 hours from 4 hours and 30 minutes
- Worked as a critical resource during month end: managing 2 teams and all 6 Essbase applications and cutting down the overall resource requirements from a team of 3 to a single person.
Education
MCA - Computer Applications
Bahra University
Solan, Himachal Pradesh 04.2012 - 2015.04
BCA - Computer And Information Sciences
St. Bede's College
Shimla, Himachal Pradesh 03.2009 - 2012.03
Skills
ETL, Analytics & BI – SQL (8 yrs) ETL (8 yrs) MSBI Stack (6 yrs) Alteryx PowerBI (3 yrs) Cognos (24 yrs) Tableau (3 yrs) Framework Manager (2 yrs) IBM Data Manager (2 yrs) Advanced Excel (3 yrs) PL/SQL Oracle MySQL Agile and Waterfall Development Methodologies (4 yrs) Data Cleansing & Profiling (3 yrs) Metadata Modeling Data Analysis (model creation, what-if scenarios, A/B testing) JIRA Confluence DevOps Azure data pipelines Git Python
Additional Information
- AWARDS , Pinnacle Award (For showcasing excellent ownership of complex deliveries at Thales) 2019
- Customer's Delight Award (For saving 5% of budget at Thales) 2018
Timeline
Data Analytics Manager
MOTI
05.2022 - 06.2023
Senior DWH Developer
Teekay Corporation
03.2021 - 05.2022
Data Scientist
Road Safety BC
01.2021 - 03.2021
Data Warehouse Specialist
Seaspan Corporation
08.2020 - 01.2021
Senior Business Intelligence Developer
Guest-tek Interactive
10.2019 - 07.2020
Sr. Business Intelligence Developer
Steria India Limited
09.2017 - 09.2019
Business Intelligence Developer
Steria India Limited
05.2015 - 08.2017
MCA - Computer Applications
Bahra University
04.2012 - 2015.04
BCA - Computer And Information Sciences
St. Bede's College
03.2009 - 2012.03
Similar Profiles
Avesh QureshiAvesh Qureshi
Hospitality Worker at Moti MahalHospitality Worker at Moti Mahal
Shebuel MathewShebuel Mathew
Auto Parts Handler at Moti Park (AES)Auto Parts Handler at Moti Park (AES)
Tony PeñaranTony Peñaran
Physical Therapy Aide at MOTI PhysiotherapyPhysical Therapy Aide at MOTI Physiotherapy
Kiran KopperlaKiran Kopperla
Data Analytics Manager at DeloitteData Analytics Manager at Deloitte
Abhishek RathiAbhishek Rathi
Data Analytics Manager at DMI Finance Pvt LtdData Analytics Manager at DMI Finance Pvt Ltd