Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Simhachala Gorle

Toronto,ON

Summary

  • Seasoned Data and Operations Analyst with 3+ years of experience, skilled in business intelligence and enhancing operational efficiency through data analytics.
  • Proficient in using advanced data tools such as Excel, Power BI, SQL, Python, and R, tailored for comprehensive analytics roles. Developed and maintained pivotal MIS reports, aiding senior leadership in strategic planning and decision-making.
  • Led cross-functional projects improving operational processes and adherence to compliance, culminating in a 9% reduction in compliance incidents.
  • Championed initiatives that realized a 30% decrease in processing errors and a 10% increase in transaction processing efficiency.
  • Excelled in financial reconciliations and data integrity checks, supporting meticulous supply chain and inventory oversight. Versed in database management across MS SQL Server, PostgreSQL, and MySQL, ensuring robust data accuracy and reporting capabilities.
  • Advanced proficiency in data modelling and automation via ETL processes with tools like Azure Data Factory, enhancing reporting efficiency.
  • Proactively redefined business processes to maximize productivity and improve vendor service levels. Spearheaded the integration of new operational procedures, ensuring effective training and seamless team adoption.
  • Adept at managing extensive datasets, providing actionable insights to foster informed operational decisions. Communicative and adept at translating complex data into digestible information for all levels of stakeholders.
  • Encouraged continuous improvement, leading to significant enhancements in both performance and cost management.
  • Contributed valuable back end and front-end development expertise, crucial for REST API integrations enhancing system functionality.
  • Engineered and deployed APIs for Salesforce connectivity and AWS for data storage in S3 buckets.
  • Executed full-stack application builds on AWS, incorporating CI/CD pipeline testing to ensure robust performance.
  • Constructed data pipelines to refine data quality for a recommendation engine, significantly improving backend data handling.
  • Created and launched a management dashboard web application using Flask on AWS, facilitating enhanced data visualization and management.
  • Formulated scenario-based test cases in Python for a recommendation engine, strengthening testing protocols.
  • Mentored the development team to adopt sophisticated data mining and visualization techniques, fostering a culture of knowledge sharing and technical advancement.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Analyst, Finance Operations

TD Bank
02.2022 - 04.2023
  • Analyzed and maintained client financial records ensuring stringent data accuracy
  • Maintained high data accuracy in client financial records and utilized insights to meet sales targets
  • Identified and resolved problems through root cause analysis and research.
  • Queried databases for information needed for report processing.
  • Validated results and performed quality assurance to assess accuracy of data.
  • Identified clear connections between policies and business results to eliminate or reduce confusion and help employees achieve goals.
  • Recommended process improvements to continually identify, analyze and fix constraints and challenges.
  • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
  • Performed audits of subsidiaries to protect shareholders and potential investors from fraudulent or unrepresentative financial claims.
  • Guided acquisition process to capture projected cost and revenue synergies and move combined organization forward.
  • Developed and updated tracking spreadsheets for process monitoring and reporting.
  • Gathered, organized and input information into digital database.
  • Collected, arranged, and input information into database system.
  • Generated reports detailing findings and recommendations.
  • Devised and implemented processes and procedures to streamline operations.
  • Optimized customer experience by delivering superior services and effectively troubleshooting issues.
  • Provided reporting for forecast analysis and ad-hoc reporting in support of decision-making.
  • Developed effective improvement plans in alignment with goals and specifications.
  • Evaluated staff performance and provided coaching to address inefficiencies.
  • Supported creation of detailed, technical financial models to value potential acquisition targets.
  • Assessed data modeling and statistics to integrate high-level business processes with data rules.
  • Performed budget analysis to control expenditures and predict future budget needs.

Business Intelligence Specialist – Full Stack

Quarterly.ai
12.2019 - 08.2021
  • Implemented data transformations and cleansing routines using Python and SQL to ensure data quality and consistency
  • Automated ETL workflows, reducing data processing time by 25% and enhancing data accuracy
  • Collaborated with cross-functional teams to define key performance indicators (KPIs) and deliver actionable insights for business decision-making
  • Integrated data from multiple sources by leveraging Power BI to create interactive and visually compelling dashboards and reports for data-driven decision-making
  • Utilized DAX to develop complex data models, resulting in more accurate forecasting and trend analysis
  • This improved the performance of reports by 3.5 times
  • Leveraged descriptive statistics and built predictive models using machine learning algorithms to forecast sales, customer churn, and other business metrics
  • Collaborated with data engineering teams to establish automated reporting processes by creating dataflows in Azure Data Factory, reducing report generation time by 30%
  • Leveraged data analysis to identify and propose process improvement opportunities, resulting in a 15% increase in operational efficiency
  • Analysed and interpreted complex data sets to identify trends and patterns, leading to more informed decision-making
  • Produced data visualizations and reports to effectively communicate insights to both technical and non-technical stakeholders
  • Worked closely with management to prioritize business and information needs, aligning data strategies with company goals
  • Promoted a data-driven mindset within the organization, organizing training sessions and workshops to improve data literacy.
  • Extracted and assessed data from databases to drive improvement of product development and business strategies and processes.
  • Assessed accuracy and effectiveness of new and existing data sources and data analysis techniques.
  • Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
  • Identified, measured and recommended improvement strategies for KPIs across business areas.
  • Developed intricate algorithms based on deep-dive statistical analysis and predictive data modeling.
  • Analyzed large datasets to identify trends and patterns in customer behaviors.
  • Coached and mentored junior developers on SAS and data mining techniques.
  • Devised and deployed predictive models using machine learning algorithms to drive business decisions.
  • Applied loss functions and variance explanation techniques to compare performance metrics.
  • Implemented randomized sampling techniques for optimized surveys.

Data Science Intern

Apps Tek Corp
03.2019 - 08.2019
  • Built MS Power BI Sales Dashboards, optimizing data visualization and executive reporting
  • Contributed to a Transport Cost Optimization strategy, significantly reducing overheads by 40%
  • Improved data accuracy through Python-based transformation pipelines.
  • Created data visualization graphics, translating complex data sets into comprehensive visual representations.
  • Identified, analyzed and interpreted trends in complex data sets using supervised and unsupervised learning techniques.
  • Developed and coded software programs, algorithms and automated processes to cleanse and evaluate large datasets from multiple disparate sources.
  • Used SAS, SPSS and Python to manage and analyze large data sets.
  • Developed polished visualizations to share results of data analyses.
  • Analyzed large datasets to identify trends and patterns in customer behaviors.

Operations Analyst

ICICI Bank Ltd
01.2017 - 08.2018
  • Led financial data analysis, identifying critical trends and insights with Excel and Power BI
  • Introduced dynamic visualizations with Excel and MS Power BI, delivering real-time insights
  • Provided ad-hoc analysis, enhancing operational efficiency with data-driven solutions.
  • Assessed operational performance to identify areas for improvement.
  • Created custom reports and visualizations to support decision-making processes.
  • Created and managed operational databases to store and track data and maintain accurate information.
  • Conducted data analysis to identify opportunities for streamlining client operations and improving customer satisfaction.
  • Analyzed trend data to forecast operational needs and plan next course of action.
  • Investigated and resolved alerts, conducted queries and culled records to assist with maintenance and problem resolution.
  • Determined and developed algorithms to improve and optimize operational processes.
  • Devised modeling and measuring techniques using statistical and engineering methods.
  • Designed data optimization and interfaces for user interaction.
  • Identified and analyzed project risks and developed mitigation strategies.
  • Developed written documents and reports related to programs and operations.
  • Conducted research and analysis to develop model-based solutions to complex operational problems.

Education

Financial Technology -

Conestoga College
Kitchener, ON
12.2021

PGP in Big Data Analytics -

INSOFE
Hyderabad, India
03.2019

Banking & Finance PG -

Manipal University
Bengaluru, India
01.2017

Skills

  • Data Analysis
  • Database Management
  • Data Visualization
  • Data Modelling
  • Statistical Analysis and Hypothesis Testing
  • Machine Learning
  • Python
  • R
  • SQL
  • PostgreSQL
  • MySQL
  • Power BI
  • Tableau
  • Agile Methodologies
  • Version Control
  • Containerization
  • Cloud Computing
  • Web Development Frameworks
  • Jira
  • Git
  • GitHub
  • REST API with Python/NodeJS
  • Linux
  • Report Preparation
  • Trend Modeling
  • Information Gathering
  • Root Cause Analysis
  • Trend Forecasting
  • Risk Mitigation
  • MS Excel
  • SQL and Databases
  • Financial Management
  • Process Improvements
  • Data Research and Validation
  • Data Modeling
  • Budget Forecasting
  • Project Management
  • Financial Statements Expertise
  • Statistic Analysis
  • Analytical Thinking
  • Account Reconciliation
  • Business Operations Analysis
  • Workflow Analysis

Certification

  • Microsoft Certified: Data Analyst Associate
  • Career Essentials in Data Analysis by Microsoft and LinkedIn
  • Power BI Virtual Case Experience, PwC
  • LinkedIn – SQL Data Reporting and Analysis

Timeline

Analyst, Finance Operations

TD Bank
02.2022 - 04.2023

Business Intelligence Specialist – Full Stack

Quarterly.ai
12.2019 - 08.2021

Data Science Intern

Apps Tek Corp
03.2019 - 08.2019

Operations Analyst

ICICI Bank Ltd
01.2017 - 08.2018

Financial Technology -

Conestoga College

PGP in Big Data Analytics -

INSOFE

Banking & Finance PG -

Manipal University
  • Microsoft Certified: Data Analyst Associate
  • Career Essentials in Data Analysis by Microsoft and LinkedIn
  • Power BI Virtual Case Experience, PwC
  • LinkedIn – SQL Data Reporting and Analysis

Similar Profiles

CREATE PROFILE
Simhachala Gorle