Summary
Overview
Work History
Education
Skills
Certification
Work Availability
Timeline
AssistantManager

SAI SUBASH RAVICHANDRAN

Dallas,Texas

Summary

Personable business professional bringing successful 9-year career in Data Analyst/ Business Analyst roles within large and fast-paced corporations with experience in Finance, Automotive, Marketing & Healthcare domains. Analytical specialist trained in advanced Data modeling, Visualization & Technical documentation. Creative solutions architect with real-time problem-solving flexibility.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Business Intelligence Manager

Sagent (Mr. Cooper)
06.2023 - Current
  • Led the design and implementation of an automated financial reporting system using Power BI and SQL Server Integration Services (SSIS) to streamline the monthly reporting process for financial statements, including income statements, balance sheets, and cash flow statements
  • Developed complex SSIS packages to extract financial data from multiple source systems, transform it into a standardized format, and load it into a centralized data warehouse
  • Utilized DAX expressions in Power BI to calculate financial metrics and KPIs, such as profitability ratios, liquidity ratios, and solvency ratios, ensuring accuracy and consistency across reports
  • Leveraged Power BI's time intelligence functions such as TOTALYTD, SAMEPERIODLASTYEAR, and DATEADD to perform year-to-date calculations, compare period-over-period performance, and analyze trends over time
  • Created parameterized reports in Power BI to enable dynamic filtering and slicing of data based on user input or predefined parameters
  • Responsible for managing 3 resources, effectively allocated tasks and responsibilities among three resources based on individual strengths, expertise, and project requirements
  • Conducted regular team meetings to discuss project progress, address challenges, and brainstorm solutions collaboratively
  • Worked in all phases of BI lifecycle including design, analysis, development, testing, deployment, post-production/maintenance and documentation
  • Developed Python scripts to automate the extraction of financial data from various sources, including market databases and regulatory filings, transforming it into Snowflake-compatible formats for seamless ingestion into Snowflake data warehouses
  • Implemented scheduled tasks and event-driven triggers within Snowflake to automate the execution of data updates, analysis, and reporting, ensuring real-time access to up-to-date financial insights while optimizing resource utilization and reducing operational overhead.

Analytics Specialist, Marketing Solutions

Concentrix Services
02.2022 - 05.2023
  • Exclusively handled a major Automotive client’s project to work on analysis of marketing strategies and digital marketing
  • Primary contact between client and company to gather and document business requirements
  • Worked with SAS and PowerBI to perform analysis on weekly marketing data containing Million records to give insights into the program
  • Implemented On-Premises Gateway for Scheduled refresh of Data to keep PowerBI reports updated
  • Created several user roles and groups to end user and provided row-level security to them
  • Built custom visuals and reports to visualize marketing funnel metrics, customer segmentation, and campaign performance
  • Developed complex DAX formulas to support calculations such as customer lifetime value, return on investment, and attribution analysis
  • Conducted data analysis using Google Analytics 4 to provide insights on website traffic, user behavior, and campaign performance
  • Developed a custom dashboard in Google Analytics 4 to track the performance of the company's email campaigns, resulting in a 20% increase in email open rates
  • Conducted an A/B test on the company's homepage layout, resulting in a 15% increase in click-through rates and a 10% increase in overall conversion rates
  • Utilized Azure Data Factory to automate the extraction, transformation, and loading of large datasets from various sources into a centralized data repository, enabling efficient data analysis and reporting
  • Worked with Azure Data Lake Storage to manage and store large volumes of structured and unstructured data, implementing security and access controls to ensure data privacy and protection
  • Developed and maintained data pipelines in Azure Databricks to support machine learning and data analysis workflows, improving data processing efficiency and reducing time-to-insights
  • Conducted ad-hoc analysis of complex business data using SQL and Tableau to provide insights and support decision-making processes
  • Assisted in transition of data from Oracle database to Salesforce platform and also build visuals using Salesforce Datorama
  • Performed data scrub activities through the Apex Data loader in the non-production sandboxes
  • Provided solutions to workflow issues and structured environment for ease of use
  • Environment: Azure, Tableau, SAS, PowerBI, Oracle, Salesforce, Google Analytics, Alteryx, DAX.

Sr. Data Analyst

American College of Emergency Physicians
05.2021 - 02.2022
  • Built interactive dashboards using Tableau with drill-down and filtering capabilities to allow users to explore and analyze data in real-time for a Healthcare Analytics project
  • Created complex calculations, custom fields, and parameters using Tableau to support data analysis and visualization
  • Utilized advanced features of Tableau such as data blending, context filters, and level of detail calculations to create complex visualizations
  • Provided user training and support to ensure effective use of the dashboards and data visualizations
  • Created and maintained dimensional data models, fact tables, and dimension tables to support business intelligence and analytics
  • Utilized advanced data warehousing techniques such as incremental data loading and partitioning to improve data processing and storage capabilities using Snowflake
  • Developed automated data pipelines using Python and Apache Airflow to pull data from various sources and perform data wrangling and ETL processes
  • Developed advanced DAX formulas for complex calculations, such as time intelligence, ranking, and forecasting
  • Created PowerBI Dashboards from multiple data sources using Data Blending and wrote effective DAX formulas and expressions
  • Utilized Power Query to Pivot and Un-Pivot the data model for data cleansing
  • Analyzed large financial data and created an advanced financial dashboard with business requirements and key metrics
  • Presented Google Analytics reports and tracked customer behavior and marketing KPIs on the website
  • Created SSRS reports per ad-hoc requests for Dynamics CRM using complex Stored Procedures
  • Created TSQL 2012 and 2008 Scripts for the client services department
  • Resolved data-centric issues in a timely manner
  • Environment: SSRS, TSQL, SSIS, Google Analytics, PowerBI, Adobe Analytics, HIPAA.

Business Intelligence Analyst

American College of Emergency Physicians
10.2020 - 04.2021
  • Worked directly with the executive team to formulate and report on KPI’s, building Interactive Dashboards to give insights on weekly performance metrics using PowerBI and Python
  • Conducted exploratory data analysis to understand trends and patterns in customer behavior using Python
  • Used Pandas and NumPy libraries to clean and transform raw data into usable formats
  • Built and deployed machine learning models to predict customer churn and identify upsell opportunities
  • Utilized logistic regression, decision trees, and random forests algorithms using Python libraries such as scikit-learn and TensorFlow to build models and evaluate their performance
  • Assisted in documenting highly sensitive and confidential medical Data registry from its end- to end process
  • Integrated data from various sources to build a Data Warehouse; identified the facts and dimensions to streamline Business processes
  • Involved in documentation of Data Mappings from source data fields to their target data field and ETL specifications for Data Warehouse
  • Developed and optimized Azure SQL databases for high-performance data analysis, including query optimization, indexing strategies, and partitioning
  • Conducted performance tuning activities on Azure Synapse Analytics to optimize query performance and reduce processing times for large datasets
  • Created TeradataSQL scripts using OLAP functions like RANK() to improve the query performance while pulling the data from large tables
  • Implemented ETL process using SQL Server Integration Services Server, SQL & SSAS to design the DataMart & MOLAP data cubes
  • Set the key performance indicators (KPI) & created interactive reports to gain valuable insights using Power BI and Microsoft Excel
  • Implemented agile methodology to improve focus on business value and stakeholder engagement
  • Environment: SQL, Tableau, PowerBI, Python, ETL, SSAS.

Data Quality Analyst

Drexel University
09.2019 - 09.2020
  • Participated in migration of data sources to Salesforce apps from legacy CRMs
  • Act as a liaison between IT and business groups by building credibility, establishing rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization
  • Imported data from RDBMS to HDFS and HIVE using Sqoop on regular basis
  • Developed Hive queries as per requested analytics for report generation
  • Assisted in maintenance of Data Warehouse in AWS Redshift
  • Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables and VLOOKUP
  • Extracted, interpreted, and analyzed data to identify key metrics and transform raw data into meaningful, actionable information
  • Participated in the Data Governance working group sessions to create Data Governance Policies
  • Helped configure and customize Salesforce.com for enterprise-wide implementation for over 100 users
  • Created environment setup plan and Migration Document and checklist within Salesforce
  • Completed Data Quality projects on time delivering results (data profiling, scorecards, reports, etc.) in the right format
  • Worked with internal and external teams on data mapping and design for new initiatives
  • ETL process done extensively using Altreyx and then loaded data into Snowflake
  • Create stored procedures using SQL Server Business Intelligence Development Studio, and use them to create dashboards, charts, tables, and raw data reports
  • Implemented data blending using various data sources and created stories using Tableau for a better understanding of the data
  • Worked on creating filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau
  • Participated in the Data Governance working group sessions to create Data Governance Policies
  • Create bi-weekly reports and dashboards in Tableau and SSRS and shared it with internal and external teams
  • Wrote SQL queries to document and integrate data from various sources for real time collateral monitoring
  • Environment: SQL Server, Tableau, Alteryx, Bit Bucket, Hadoop, Hive, Cornerstone Reporting, Python, SAS.

Data Business Analyst

Aqua Design Technologies
09.2016 - 08.2019
  • Responsible for gathering requirements, troubleshooting EDI related integration issues, reprocessing failed transactions, and leveraging the capabilities of EDI
  • Worked with stakeholders to gather and analyze requirements for new software applications, developing user stories and acceptance criteria to guide the development process
  • Conducted user acceptance testing (UAT) for new software applications, working with developers and business stakeholders to ensure that the application meets requirements and is user-friendly
  • Collaborated with operations teams to develop and implement process improvement initiatives, using tools such as Six Sigma and Lean methodologies to reduce waste and improve efficiency
  • Used Salesforce to Create Roles, Profiles, Email Templates, Page Layouts, Workflows, Workflow Actions and Approval Process
  • Worked with upper management and client leads to create Salesforce processes
  • Experienced in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining
  • Experience in Extract Transform and Load (ETL) data from spreadsheets, flat files, database tables and other sources using SQL Server Integration Services (SSIS) and SQL Server Reporting Service (SSRS) for managers and executives
  • Supports ad hoc requests from providers and internal partners related to EDI
  • Created data flow diagrams, data mapping from Source to stage, Stage to Target mapping documents indicating source tables, columns, data types, transformations required and business rules to be applied
  • Exported the data required information to RDBMS using Sqoop to make the data available to the claims processing team to assist in processing a claim based on the data
  • Design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau
  • Environment: DB2, JIRA, MS Office, MS Visio, SharePoint.

Education

B.Tech., Mechatronics Engineering -

SRM Institute of Science And Technology
India

Skills

  • Data Modelling
  • Visualization
  • PowerBI Reporting
  • Advanced SQL
  • AWS, Azure
  • Data Quality Management
  • Python Programming
  • Tableau Server

Certification

Tableau Desktop Specialist

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Business Intelligence Manager

Sagent (Mr. Cooper)
06.2023 - Current

Analytics Specialist, Marketing Solutions

Concentrix Services
02.2022 - 05.2023

Sr. Data Analyst

American College of Emergency Physicians
05.2021 - 02.2022

Business Intelligence Analyst

American College of Emergency Physicians
10.2020 - 04.2021

Data Quality Analyst

Drexel University
09.2019 - 09.2020

Data Business Analyst

Aqua Design Technologies
09.2016 - 08.2019

B.Tech., Mechatronics Engineering -

SRM Institute of Science And Technology

Similar Profiles

CREATE PROFILE
SAI SUBASH RAVICHANDRAN