Abhishek Patil
Ottawa,ON
Summary
Experienced ETC tester and data analyst with a decade of proficiency in ensuring software quality and reliability. Proven track record in conducting comprehensive testing procedures and analyzing complex data sets. Adept at identifying and resolving issues to enhance system performance. Demonstrated expertise in optimising data-driven decision-making processes Detail-oriented designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.
Overview
13
13
years of professional experience
6
6
years of post-secondary education
Work History
Senior Data Engineer
Quantiphi
04.2022 - Current
- Spearheaded thecreation and maintenance of 15+ Tableau dashboards and reports, tracking key metrics for cross-functional stakeholders and executives, resulting in a 25% improvement in data-driven decision-making
- Conducted proactive stakeholder meetings, gathering, and implementing requirements promptly, leading to a 30% reduction in turnaround time for meeting data needs
- Seasoned Business Analyst with a proven track record of utilizing Jira to streamline project workflows, track tasks, and ensure timely delivery of software solutions
- Successfully transformed and aggregated data from multiple sources, optimizing presentation efficiency in an enterprise environment, resulting in a 20% improvement in reporting speed
- Proficient in translating business requirements into Jira user stories, epics, and sprint planning, fostering effective communication between development teams and stakeholders
- Maintained up-to-date knowledge of technology developments, ensuring alignment with the latest advancements in BI and Reporting, leading to a 20% increase in system efficiency
- Collaborated with BI, Data Science, and Marketing teams on data investigations, contributing to the successful resolution of 90% of data-related inquiries
- Facilitated group meetings of various sizes for solution design, decision-making, problem-solving, security, testing, COE Review, and solution implementation
- Orchestrated the development and execution of 200+ test cases, resulting in a 20% improvement in identifying and addressing data flow issues within the existing data warehouse architecture
- Played a pivotal role in requirement analysis and design, contributing insights that led to a 15% reduction in post-implementation issues
- Successfully led cross-functional teams in implementing Jira-based project management methodologies, optimizing processes, and enhancing overall project efficiency
- Established and implemented robust test standards and procedures, resulting in a 25% increase in testing efficiency
- Maintained a comprehensive documentation system for test results, reducing the resolution time for issues by 30%
- Conducted thorough reviews of test outcomes, ensuring a 100% alignment with functional and technical requirements, and providing actionable feedback to stakeholders
- Collaborated effectively with development engineers, business analysts, and support groups, contributing to a 15% improvement in cross-functional team communication and synergy.
Business Intelligence Analyst
Experis
07.2016 - 04.2022
- Designed Tableau report that automated, integrated, and replaced traditional Commission reports saving 50% of the finance department’s time
- Pioneered a project to detect and prevent user input errors
- Inspired teams to adopt this report which amplified efficiency and data reliability by 90%
- Headed, planned, and implemented the organization's trial balance report which accelerated the generation of accurate financial statements by 400%
- Discovered and assessed gaps in the software
- Coordinated with software developers and recommended rectifying/incorporating fields that strengthened the reporting capabilities by 20%
- Introduced centralized and standardized reports for all critical metrics of the organization
- It facilitated executives to determine and diagnose business issues daily maximizing profit by 30%
- Examined and identified inconsistencies in the conventional Excel HR report
- Spearheaded HR Tableau project and engineered data marts/models that yielded an overhauled HR report
- Campaigned and persuaded various departments to migrate from legacy Crystal reports to clarified and refined Tableau reports
- It opened the door for greater scalability for the future and enhanced user experience
- Researched, Investigated, and assembled KPIs for sales and recruiters
- Consolidated and launched reports against those KPIs which enabled them to take prompt and decisive judgments driving sales revenue, consultant/client retention, and productivity
- Developed & maintained an understanding of various operational workflows the business uses for future digital transformation
- Integrated Tableau in the workflow to significantly increase the speed/performance of the process by 30%-50%
- Efficiently managed and optimized Tableau Server environments, guaranteeing uninterrupted functionality and user accessibility
- Implemented stringent security protocols, resulting in a 20% enhancement in data governance and user compliance.
Project Intern
Canadian Food Inspection Agency
02.2014 - 04.2014
- Developed a set of operational, robust, swift, spontaneous, and visually alive reports utilizing Agile Development (Kimball) Methodologies to create an Organization Chart for CFIA HR department and influenced the department to a successful BI implementation by re-analyzing and re-evaluating their ETL process and laying out a Data Governance roadmap
- Established proof of concept (POC) of methodical integration of current data islands in the organization into a comprehensive data warehouse and trained key stakeholders on the advantages of the system-wide BI implementation.
Software Specialist
eClinicalWorks
08.2012 - 08.2013
- Collected and interpreted data from various data sources
- Prioritized and transformed dozens of Tableau reports reviewed daily by the executive team to provide accurate information about various KPIs
- Ensured the stable operation and supervised data integrity of data sources
- Conceptualized and enforced a suite of automated error checks, maintenance, and governance processes with Tableau reports
- Reduced operational overhead and increased data quality in various departments by creating more efficient, robust, and scalable processes.
Reports Developer
Cactus Communications - Medical Communications
06.2011 - 08.2012
- Advised and restructured SQL procedure which improved its speed by 40%
- Inspired and cultivated behavior of updating and documenting data glossaries for data governance daily in a team of 10
- Trained 15 stakeholders on Cognos functionality and resolved their technical issues.
Education
Post Graduate Certificate - Project Management
Durham College
Oshawa, Canada 09.2014 - 05.2015
Post Graduate Certificate - Business Intelligence and System Infrastructure
Algonquin College
Ottawa, Canada 09.2013 - 05.2014
Bachelor's - Computer Science
Pune University
Pune, India 09.2006 - 05.2011
Skills
Data Security
Data Modeling
Machine Learning
Data Warehousing
ETL development
Metadata Management
Python Programming
Data Pipeline Design
Advanced SQL
Spark Development
SQL Programming
SQL and Databases
Advanced analytics
Business Intelligence
Database Design
RDBMS
Data Analysis
Relational databases
Timeline
Senior Data Engineer
Quantiphi
04.2022 - Current
Business Intelligence Analyst
Experis
07.2016 - 04.2022
Post Graduate Certificate - Project Management
Durham College
09.2014 - 05.2015
Project Intern
Canadian Food Inspection Agency
02.2014 - 04.2014
Post Graduate Certificate - Business Intelligence and System Infrastructure
Algonquin College
09.2013 - 05.2014
Software Specialist
eClinicalWorks
08.2012 - 08.2013
Reports Developer
Cactus Communications - Medical Communications
06.2011 - 08.2012
Bachelor's - Computer Science
Pune University
09.2006 - 05.2011