Aditya J. Email & Phone Number

Toronto, Ontario, Canada

• Researched and identified data catalogs available in the market for the purpose of implementing a Data Governance Solution at Flexiti.• Involved in data design for new data architecture as part of migration project from Microsoft SQL Server to Databricks.• Designed Database tables, views and relationships between these tables in Databricks for bronze (raw) data layer.• Processing, cleansing, housing and verifying the integrity of data used for analysis.• Conducted detailed level mapping of data objects for Flexiti's Finance reports that are needed when moving on to the new architecture.• Worked with the Finance team and Product owners to design a system that serves as master system of reference, essential for effective financial reporting.• Created data lineage artifacts capturing the data flow across the Databricks platform to articulate the data transformations.• Extracted and transformed data from multiple data sources to storage for use in the data warehouse.• Created various artifacts on confluence such as business requirement documents, data transformation strategies and data analysis results to document all the data pipelines supporting thenew project launch at Flexiti.

Toronto, Ontario, Canada

• Worked with Data Architect to design data transformations needed to move data from Data Lake to Snowflake.• Designed complex SQL queries in Snowflake for the purpose of mining actionable insights from retail sales data.• Performed gap analysis of current business practices and identified a 40% potential for increased workforce productivity• Designed a scheduling algorithm using Python to automate optimized scheduling of staff for their assigned tasks while taking into account changing deadlines, staff vacation days, evolving priorities and business rules.• Designed Web Application tied to a backend database. This serves as a front end interface for users to login and check their schedule and for the administrator to update deadlines and priority dates based on evolving business needs.• Processing, cleansing, housing and verifying the integrity of data used for analysis.• Designed Database tables, views and relationships between these tables which effectively resulted in a data warehouse that enabled data and analytics reporting capabilities.• Developed Power BI dashboards for reporting on resource utilization.

Toronto, Ontario, Canada

• Designed custom workflow for national estimate of dollar value (a few million $) of reverse flow SKUs.• Designed store specific yearly forecast logic using historical sales of target store and its respective peer stores.• Leveraged sales and inventory data (a few Million $) of automotive parts, store and region vehicle populations for store specific automotive SKU recommendations.• Built tens of SQL queries as part of AdHoc Master Workflow to automate recurring requests of reports. These reports include national sales reports, currentinventory, stock up numbers for up to 6 months, and lost sales analysis for all of CT's 500 stores.• Using historical data of peer stores, performed analysis and data visualization if a new retail store will meet sales targets in excess of dozen million $ or not.• Designed customer migration heat map using Microsoft Power BI to investigate declining sales (in order of a few million dollars) of one of Canadian Tire'sbiggest Retail stores and made adequate recommendations for some categories.

Columbus, Ohio Area

Worked as a consultant in a Developer role with clients in insurance, health and finance industries.• Designed over 100 custom reports with SQL by leveraging data from tens of tables.• Improved processing time of Application Engine program by over 90% by modifying the existing underlying SQL.• Generated I-9(Employment Eligibility verification) forms for over 10000 employees by customizing a delivered Application Engine program. Fields in the form are filled by leveraging HR data from multiple tables in the PeopleSoft database. • Identified anomalies in the interface files consisting of dozens of fields (missing required information, incorrect date and field formats, displaced fields etc.) that resulted in incomplete status of the conversion programs and fixed them.• Actively communicated with the third party business users and technical teams to gather business requirements and discuss technical design for the interface files.• Created database credentials for dozens of users as part of integration between the Desktop engineering team and PeopleSoft.• Created UAT scripts to validate business functionality and evaluate user experience.

Dubai, United Arab Emirates

•Actively involved in business correspondence with the company’s clients. It included setting up meetings with clients, answering phone calls and email communication.•Learned about the various Access Control and Intrusion Detection mechanisms widely used today.

Data Science Career Track

The Springboard Data Science career track curriculum covers data analytics with Python (Pandas, NumPy, data visualization with matplotlib.

Master Of Science - Ms, Electrical Engineering

Bachelor Of Engineering - Be, Electronics And Communications Engineering

High School Diploma, High School/Secondary Diplomas And Certificates, Distinction

Last studied 10th Grade

Senior Secondary, Distinction