Ila Sharma

ILA SHARMA - • Toronto, ON- h ps://www.linkedin.com/in/ila-sharma-59821b230/ SUMMARY Experienced Data analyst with exper se in managing end-to-end nancial and opera onal data pipelines, consolida ng, valida ng, and reconciling records to ensure compliance and audit readiness. Skilled in automa ng dashboards and repor ng frameworks using SAP Data Processing, SQL, Python, and Power BI, delivering real- me insights that drive cost op miza on—improving inventory. Collabora ve partner to nance, supply-chain, and execu ve teams, enabling proac ve forecas ng and strategic planning. Dedicated to scalable analy cs, rigorous data valida on, and clear visualiza ons that support informed decision-making. PROFESSIONAL EXPERIENCE WORKFORCE PLANNER(Intermediate), PENINSULA CANADA EMPLOYMENT L.T.D. July 2025 - Present Analyzed workforce data to monitor performance trends, iden fy coverage gaps, and recommend sta ng adjustments. Design and automate opera onal reports to track produc vity, adherence to SLAs, and capacity planning. • Develop short- and long-term sta ng forecasts based on historical trends, service volumes, and business priori es. • Monitor real- me work ow data to ensure service levels are maintained across all communica on channels. • Provide data-driven insights and recommenda ons to senior leadership to support business planning and resource • alloca on. Work collabora vely with department leads across all Service departments to align sta ng plans with service objec ves and • client demand. Support schedule op miza on by iden fying over- or under-sta ed intervals and recommending shi adjustments. • Maintain and manage workforce planning tools and databases to ensure accuracy and e ciency. • Contribute to con nuous improvement ini a ves by iden fying opera onal bo lenecks and proposing solu ons. • Occasionally respond to internal requests regarding work ow pa erns, capacity ques ons, or repor ng metrics. • Experience working with workforce management systems and CRM pla orms (e.g., Salesforce, NICE, Genesys. • Instructor-CIMT COLLEGE (June 2025 - Present)/(Part-time) Data Analytics and Business Intelligence online classes for STEM program students. DATA FINANCIAL ANALYST, KINDLING, Toronto, ON Jan 2025-May 2025 • Managed end-to-end nancial data pipelines, overseeing the consolida on, valida on, and reconcilia on of nancial records to ensure compliance, audit readiness, and real- me visibility into cost structures and revenue streams. • Designed and maintained automated dashboards and repor ng frameworks using tools like Excel, SQL, and Power BI to analyze sales performance, opera onal KPIs, and budget variance metrics—driving data-informed decisions across leadership. • Partnered cross-func onally with nance and strategy teams to drive cost op miza on and growth opportuni es, contribu ng to annual budget cycles, rolling forecasts, and revenue planning e orts for mul ple business units. Prepared and presented detailed nancial reports, revenue forecasts, and performance scorecards to execu ve stakeholders, enabling proac ve budget planning and strategic alignment across departments. Used C++ for building automa on and for brand wise sale and pro t margins • • DATA ANALYST (Coordinator) , SAPUTO, Vaughan, ON May 2023-Jan 2025 • Implemented a scalable, version-controlled inventory data management system, improving data traceability and boos ng inventory accuracy by 10% across warehouse opera ons through reduced discrepancies and enhanced data valida on. • Automated high-volume data entry work ows and ensured end-to-end data integrity by maintaining compliant, auditable warehouse records aligned with internal quality benchmarks introducing quality control measures and audit trials. • Engineered process op miza ons in inventory lifecycle tracking, resul ng in a 15% increase in opera onal throughput and reduced error rates in stock reconcilia on. • Integrated SAP, ERP, and Maestro pla orms to support real- me data access for business development teams, enhancing decision support and streamlining repor ng work ows across supply chain and nance func ons. ti ti ti ti ti ti ti ti ti ti fi ti ti ffi ti ti ft ti ti ti ti ti ffi ffi ti ti ti ti ti ti ti fi tt ti ti ti tf ti Oct 2019-Dec 2021 tt ff fi fi tt ti ti ti ff ti ti ti ti ti fl ti fl ti ti ti ti ti fl ti tf ti ti ti ti fi fi ffi ti ti ti ti fi fl ti fi ti ti ti ti ti ti ti ti ti DATA ANALYST (ML ASSOCIATE), AMAZON, Bengaluru, KA • Conducted sta s cal analysis on customer service data to op mize support work ows, reducing average response me by 20% and boos ng customer sa sfac on scores by 15%. • Designed and automated interac ve dashboards using Excel and internal tools to track performance KPIs and sales trends, contribu ng to a 25% li in conversion rates through data-driven insights. • Partnered with cross-func onal teams to implement 15+ opera onal enhancements across service channels, resul ng in a 10% decrease in support costs and improved resolu on speed. • Recognized with the Customer Obsession Award for delivering high-impact analy cs suppor ng world-class customer experiences and eleva ng service quality across key ver cals. • Enhancing business opera ons for di erent sites using SAP ERP Solu on SKILLS PROGRAMMING & DATA PROCESSING: PYTHON, JAVA, SQL, PL/SQL, MS WORD, MS POWERPOINT, EXCEL DATABASE MANAGEMENT: HIVE, BIGQUERY, REDSHIFT, AMAZON QUICKSIGHT, AND MYSQL DATABASES. DATA SCIENCE: PROFICIENT WITH NUMPY, SCIPY, KERAS, PANDAS, GGPLOT, GLM, SCIKIT-LEARN, SVM, TENSORFLOW, LSTM, RNN. FRAMEWORKS AND TOOLS: APACHE KAFKA, AWS (S3, EC2, SAGEMAKER), PYSPARK, APACHE BEAM, PUB/SUB, BIG DATA, SPARK MLIB, AND CLOUD DATALAB. VISUALIZATION TOOLS: JUPYTER NOTEBOOK, GOOGLE COLAB, TABLEAU, AND POWER BI(DASHOARD DEVELOPER). EDUCATION BIG DATA ANALYTICS, LAMBTON COLLEGE Post Graduate Cer ca on, Data Science 2023 JAN 2022 - MAY ti ti ti MAY 2014 -MAY 2018 ti fl ti ti ti ti ti ti ff ti ti ti ti ti ft ti ti fi ti ti ti ti ti SRM UNIVERSITY, TAMIL NADU Bachelor of Technology, Electronic and Communica on Engineering (ECE)