Customer Service
Resume:
Ganesh Sastry
Business Analyst
***************@*****.***
With expertise in finance initiatives and experience in managerial accountability to enhance benefit-cost savings, I have proficiency in consultative support of fast-growing markets by multitasking product backlog items using Customer Relationship Management, market analysis, capacity planning, financial analysis, and customer segmentation. I have a proven track record in developing complex business cases for effective time management to gain insight using data-driven reporting, systematic automation solutions based on shareholder priorities, segment research, and business administration. Qualifications Summary
Increased free cash flow by 40% using data visualization tools to provide insight into capital budgeting by enhancing cash flow timing to drive better financial outcomes. Involved in quantifying business strategies with cost of capital metrics based on stakeholder requirements of capital expenditures for financing strategy using CFA, CPA, FRM, net present value analysis, Statistical Models, Supply Chain Processes, and Product Lifecycle Management.
Implemented business processes for monthly accounting close to reducing expenses by 40% with automation initiatives to coordinate seamless integration using Earned Value Management to ensure cost overrun minimized. Involved in monthly accounting close of financial reporting with transaction processing of interest income and customer deposits to achieve optimal profit margin ratios to meet investor risk appetite with loan receivables and develop transparency in revenue recognition with ASC 606.
Reduced the portfolio credit risk by 30% by utilizing linear regression to analyze the investment performance, identifying the underlying loan loss severity drivers that correlate with bond yields, and business growth to facilitate contract management with industry benchmarks.
Technical documentation of web application development using ASP.NET, Web API, MS SQL Server, and .Net. Involved in using full stack, continuously improving the service delivery quality with agile methodology, and microservices to develop scalable application architecture.
Led Research and Development efforts for complex projects by aligning Service Level Agreements across business units. Involved in utilizing QA software to lead cross-functional teams by implementing statistical methods, business performance metrics for various integrations, and B2C processes for consumer products. Also engaged in ensuring on-time product delivery with multiple modules by applying data modeling to analyze new product features.
Recommend solutions for project success with leadership skills to drive the agile team to deliver high-quality results by ensuring project progress with end-users. Involved in assessing potential impacts addressing gaps in requirements in a team environment to achieve project objectives by conducting collaborative sessions for requirements gathering with workshops using stakeholder management with technical business teams, project timelines, milestones to ensure time management and successful delivery of project deliverables. Career Experience
Parker and Sons / Phoenix, AZ 10/2020 – 07/2023
Data Analyst, IT/Program Management
Self-motivated professional in measuring consumer behavior to define innovative solutions for business unit strategies using predictive analytics use cases for recommending tradeoffs, business requirements gathering for timely delivery of analytical tools, organizational skills with self-direction in providing recommendations in financial analysis, and project cost controls to manage budget schedules for expenditure planning of materials.
Supervised exploratory data analysis to check inventory replenishment using Power BI, R programming, Tableau, and decision trees. Involved in leading business development roadmaps by developing business process automation in supply chain management by creating well-crafted reports for market share using Snowflake, SQL Server, SSIS, SSAS, SSRS, and OLTP.
Monitored GCP roadmap planning for CRM applications with scalable processes using high availability to mitigate risk exposure of user demand. Involved in creating Big Data Applications with high throughput using BigQuery stored procedures by streamlining data mining solutions for automating datasets to train machine learning models for predictive modeling using data pipelines, ETL, ELT, historical data, customer analysis, and automated testing tools.
Customer-centric approach of CRM design with UI/UX mockups for backend apps using Figma for user interface design, key performance metrics for customer success, cloud data platforms for integrating front-end web applications with data warehouse, technical design of wireframes by creating dashboards, user research for service level agreements on role-based access of modules, application interface troubleshooting, and modeling TO-BE processes.
Monitored drivers of working capital management using quantitative reporting of Accounts Receivable, Accounts Payable, Assets, and Liabilities. Involved in automating ALM software with continuous processes using key performance indicators for liquidity coverage, net interest income management by allocating balance sheet items for target returns, and business analysis of financial transactions with flux reporting. Also involved in statistical modeling of sales strategies for stress testing of the regulatory framework using SOX, Basel, Compliance, SAS software, and scenario analysis.
Berkshire Hathaway Automotive / Peoria, AZ 01/2020 – 03/2020 Sales Analyst, Sales
Goal-oriented analyst with expertise in innovation using written communication skills, presentation skills in dashboard design used by shareholders, interpersonal skills with people management to lead project status meetings for prioritization, and maintenance of project budgets to align multiple funding sources with long- term forecast.
Implemented digital pricing transformations with automation tools for financial consolidation to enhance FTE savings. Involved in computing KPIs using Master Data Management, DataOps, feature scaling, big data, data ingestion, and data governance.
Supervised designing of end-to-end pricing with time series analysis of supply chain data. Involved in integrating disparate systems using make-to-stock processes for manufacturing, SLAs, and data science pipelines in time series forecasting to analyze components with forecasting market trends and enhancing advertising campaigns with scalability metrics.
Technical writing for system integrations using process mapping, business rules, risk analysis, traceability of scrum requirements to technical stakeholders, and manuals for non-technical teams to enhance cross-functional collaboration.
Analyzed operational metrics with industry advocacy groups by translating business strategy for contingency plans. Involved in developing pricing strategies for product launches with a consistent reporting cadence to meet project timelines while maintaining data accuracy in datasets. Heterogeneous data sources to meet project deadlines.
Provided strategic insights to support decision-making processes, impact analysis, performance tuning for DAX queries, enhanced report designs, and optimized data retrieval processes for improved efficiency. Involved in incorporating V-Lookups, pivot tables, and business analytics for data analysis.
LinkedIn/Datacamp/Microsoft Certifications (10/2018 - 12/2019) Machine Learning/Object-Oriented Programming/Statistics Fundamentals with Python/Analytic Fundamentals/Artificial Intelligence Fundamentals/Exploratory Data Analysis Theory/Database Fundamentals/Data Analysis in SQL (PostgreSQL)/Data Storytelling/Hadoop American Contract Furniture / Walnut, CA 11/2017 – 09/2018 Financial Analyst, Finance
Detail-oriented analyst in root cause analysis using strategic vision for recommending tradeoffs with attention-to-detail for GAAP Accounting, data strategies for data wrangling of RDBMS with Metadata Management, and consulting for business process improvement of ERP processes.
Technical expertise in financial systems analysis to identify gaps, align enterprise solutions with business objectives to facilitate car auction acquisitions, and collaborate with end-users to define system requirements for proposed enhancements. Involved in determining key results using data visualizations for investors, automating credit enhancement in securities using quality control metrics, subordinated debt structures, and clustered data models.
Developed data solutions at the accounting close for pro forma statements with non-GAAP metrics. Involved in measuring alignment of investment viability with portfolio risk using Domo, Tableau, and product design analysis of corporate bond issuances.
Developed agile approach in prototyping using interviewing, surveys to collect user feedback, comprehensive business processes in fast-paced environments, and mockups for use case development to document system interactions.
Established a user story-splitting structure of ERP workflows for Fixed Asset Turnover by purchasing equipment efficiently with a gap analysis of business operations. Involved in statistical analysis for actionable insights in strategic decision-making with trend analysis, organizing strategic initiatives with Confluence and Asana for progress analysis on bottlenecks of releases.
Managed B2B processes for financial reporting of financial statements by identifying operational constraints within accounting workflows. Involved in leading resource allocation efforts with Return on Investment metrics, strategically releasing high-impact outsourcing projects, and utilizing requirements analysis for cloud infrastructure cost modeling.
Applied experimental design to create prototypes of machine learning algorithms in data-driven decision-making for risk management, agile software development methodologies, and managing project workflows for efficient execution.
Results-oriented software solutions with test automation to reduce query process time by establishing data validation protocols for data warehouse teams, data integrity, and database administration. Involved in ensuring system efficiency with Agile development of responsive websites using SQL, PostgreSQL, Bootstrap, Angular, and Node.js, and industry standards for digital product management.
City of Pasadena / Pasadena, CA 04/2016 – 06/2017
IT Analyst, Information Technology
Proficient analyst in agile methodologies using teamwork in test plans for data migration and team management in delegating tasks with customer service standards for user acceptance criteria.
Developed CRM software with Salesforce configuration for sales processes. Involved in budgeting by ensuring Net Present Value using free cash flow planning, project-based accounting, requests for proposals for aligning leads with client acquisitions, and standard operating procedures on prospecting new online business.
Assembled the big data features of IT infrastructure using BABOK for release management of profit margin use cases. Involved in quantifying operating plans with business intelligence tools using big data analytics for sourcing data from distributed systems in logistics management. Also involved in data engineering of data lakes with external source systems using Azure Databricks to ensure low latency for reduced data silos with Scala, Kafka, DevOps, FinOps, Apache Spark, raw data ingestion, and Lambda.
Developed a customer-focused approach with CRM software by translating technical findings of industry trends with business decision-makers. Involves in applying interpersonal skills to engage with clients successfully by demonstrating a commitment to continuous learning.
Facilitated enterprise solutions based on user experience feedback on query performance by developing functional specifications with indexing, customer preferences of government software, and table partitioning. Involved in implementing CI/CD for on-time sprint delivery for enhancing cost efficiencies using debugging, UAT, unit testing strategy for data solutions, and code reviews.
Designed streamlining of business processes using Visio for user requirements gathering, data visualization of work diagrams, agile workshops for meaningful insight, and analytical skills with variance analysis of financial statements to enhance strategic planning by collaborating with stakeholders to identify ROI trends. Involved in ensuring integration of testing teams into the Agile workflow by contributing to delivering high-quality products with business case development and project plans.
Managed efficient project execution by identifying project risks with cross-functional collaboration using Agile methodologies, Scrum Master Standards, Kanban, Extreme Programming, agile project management tools, Agile principles, boards, backlogs, sprints, and product backlog management. Involved in refining User Stories, Sprint Backlog items, Agile ceremonies, daily stand-ups for status updates, sprint reviews, and retrospectives. Also engaged in analyzing agile metrics for Continuous Integration/Continuous Deployment pipelines to streamline data pipeline development for real-time insights using Agile teams, velocity, burndown charts for project progress, and cycle time for continuous improvement of transparent data processes for stakeholders.
Monitored construction project progress to identify impediments of on-time delivery within the project life cycle using Product Backlog Refinement sessions, product owners to prioritize features for development efforts of educational facility, agile training sessions, coaching, and team collaboration. Involved in ensuring the financial integrity of a project budget by adhering to standard operating procedures, providing quality assurance to Public Works staff by conducting cost variance analysis for financial tracking of capital projects, and evaluating contract change orders with invoices for schedule adherence.
Velocity Mortgage Capital / Westlake Village, CA 08/2015 – 11/2015 Business Systems Analyst, Information Technology
Diligent analyst with exceptional critical thinking skills using communications in stakeholder engagement and project documentation for integration testing with cloud solutions.
Developed service-level agreements to enhance lead-to-cash processes using efficiency standards of conversion funneling. Involved in aligning customer credit, invoicing, inventory, lead generation, and collections using Salesforce CRM software.
Developed loan origination systems for revenue growth by aligning asset valuation, sales pipeline analytics, and accounting. Involved in feature engineering of demand drivers to estimate feasibility using investment banking, data analytics, and loan application processing to ensure a seamless user experience. Also, involved in reconciling account balances to highlight outliers using GL Coding, Chart of Accounts, and business models.
Collaborated with technical stakeholders to interpret changing project requirements, address business challenges, and define business problems to enhance project outcomes. Involved in defining project scope and ensuring project goals in dynamic environments with adaptability.
Developed mitigation strategies for project risk assessments using business analysis and software development lifecycle to align projects with organizational goals. Conducted data analysis utilizing SQL queries to inform decision-making processes by identifying data patterns for client satisfaction. Concord Music Group / Los Angeles, CA 04/2012 – 05/2015 Operations Analyst, Financial Operations
Expertise in root cause analysis using leadership in a fast-paced environment to recommend performance improvements, automation testing to ensure customer engagement, and organizational siloes by managing digitization tasks for operational improvements in customer demographics.
Implemented Oracle ERP for vendor management using market research with distribution planning. Involved in configuring billing for cash conversion cycle metrics using automated payment processing, SDLC, and data structures.
Translated complex data issues by identifying website usability trends and communicating effectively with non-technical stakeholders. Involved in articulating findings to technical audiences through client-facing presentations by deriving actionable conclusions to solve problems.
Monitored operational reporting of subscription streaming using project scope for data-driven decisions of new product features using statistical analysis of risk-return metrics. Involved in quantifying customer needs by tagging marketing campaigns for measuring advertising effectiveness to augment online sales using SOPs, Google Analytics, Adobe Analytics, search engine optimization, and conversion rates.
Developed graphical user interface applications for E-Commerce applications with digital marketing plans to enhance traffic using conversion funneling. Involved in tracking dependencies in user interactions, APIs for advanced data processing, process optimization, JavaScript, HTML, and XML.
Devised iterative project management of business intelligence technologies to ensure reliable ETL code delivery with sprint reviews for role-based regression testing using PMP, Lean Six Sigma, Scrum, Kanban, and financial planning. Involved in business process analysis using real-time sales forecasting, rapid prototyping of short cycles, and business management.
Developed test cases for quality assurance processes to capture defects for deployment using Trello, scrum ceremonies, and versioning control systems. Involved in sprint planning for software solutions with iterative progress using backlog grooming, daily stand-ups, user stories, cost estimation, and GitHub.
Implemented Relational Database Management Systems to ensure data storage and data retrieval for data warehousing solutions. Involved in managing complex Relational databases to meet organizational data requirements using star schema, snowflake schema, ERDs, and Relational Data Models.
Developed business priorities to uncover valuable insights with problem-solving techniques by collaborating with team members using Microsoft Project, Jira, and Confluence. Involved in delivering presentations to communicate complex findings, managing time efficiently to enhance retrieval efficiency, designing dimensional data models for querying aggregated data, and multidimensional data analysis for time series data models.
Utilized strategic planning for organizational objectives in product analytics. Involved in executing quantitative analysis using data platforms for user engagement metrics with Amplitude, Firebase, Pendo, business reviews, Google Cloud Platform, SPSS, Panda and PyTorch.
Performed ad-hoc analysis by leveraging data discovery using MS Access, advanced Microsoft Excel features, MS Access, and SQL queries. Involved in executing project risk assessments for developing effective mitigation strategies using business analysis techniques to align projects seamlessly with organizational goals using Entity Relationship Diagrams, Data Classification, and Business Acumen. College Education
BS / University of Central Florida / Computer Science Technical Expertise
Product
Management
Google Ads
Issues Tracking
SharePoint
PowerShell
Power Apps
Oracle Fusion/HCM
JSON
Mongo DB
Teradata
OneStream
Sage Intaact
Version Control
Tuning/Caching
IT Strategy
A/B Testing
Release
Management
Client Books
Google Sheets
Seaborn
Alteryx
Pivot Tables
V-Lookups
Source Code
Atlassian
C/C++/C#/.NET/RPA
PySpark
Use Case Diagrams
Hyperion/EPM
Change Management
Information Security
ServiceNow
Jenkins/Git
Redshift/Docker
Qlik/ Slack Workflows
Google Suite
Enterprise Software
Microsoft Dynamics
Task Management
RFP Process
Multiple Legal Entities
IT Controls
Hypothesis Testing
Lucidchart
QuickBooks
Software Development
Lifecycle
MATLAB/Stata/C++
Stream/Batch Processing
AutoML/NumPy/Plotly
Delta Lake/Airflow/AWS
NetSuite/SAP
Objectives and Key Results
Agile Interviews
Google Workspace
Conflict Resolution
Office365/MS Word/Excel
Venture Capital/Startups
ERD/ORM
Martech/Adtech/Fintech
MySQL/PL/SQL
Visual Studio/Java
SaaS/PaaS/FaaS
Visual Basic
ASP.NET
Test Planning/UAT
Content Management
CPQ
Power Platform Tools
Scripting Languages
Monday.com
Matplotlib
AI/ML/NLP
NoSQL/OLAP
Self-Starter
Looker
Attention To Detail
Predictive Models
Information Systems
Entrepreneurship
OKRs
Neural Networks
Deep Learning
Financial Metrics
AS-IS Processes
PowerPoint
Microsoft Office Suite
Non-Relational Databases
Natural Language Processing
Logistic Regression Models
Cost Analyst
Contact this candidate