Vani M
Summary
Aspiring and goal-oriented professional with 7+ years of experience in Data Analysis and hands-on knowledge of SQL, MS Excel, and MS Power BI tools; adopt technology for processing large volumes of data collected from diverse sources. Expertise in developing and maintaining new/existing information systems and processes to support business needs. Serve as a reliable resource, communicate, and collaborate across diverse groups to build accord for change and critical action.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Analyst - Merchandising Reporting
Lowe’s India
07.2023 - Current
- Reporting and data analysis includes building reports and dashboards for business processes and projects by using Excel, Power BI and SQL, power automate,Few of them are listed below:
- TRAC Dashboard – Used to get visibility on the preparedness of stores with respect to Collateral And analysis of vendors trends on the application
- Availability for upcoming In Store Executions
- This helped in reduced tracking related issues, successful in-store execution and to understand Vendor Pattern Analysis
- Replenishment Dashboard – Built in Power BI, used as a Vendor Scorecard for tracking historical Vendor performance.
- Helped create missing images metric which over a year reduced from 10000 to 700 with scorecards.
- This had few add on metrics which proved to be “best metrics” which saved company cost and time.
- Helped to understand if stores are ordering duplicates/Aged orders/cancelled orders
- Maintained Vendor Auto emailer using VBA to send automated mails to the vendors who failed to deliver before the due dates
- Generated and processed around 200 S&C reports on a single day for the Money Management team using RPA (Power Automate)
- This saved the Stakeholders a lot of time and hassle.
- Forecasted tons of steel brought over a year and the amount.
- Helped Money management team to identify the duplicate invoices and reduce the time of invoices process.
- Setup new email process for ops team and handled over 300 emails a day and identified the issues with tracking and built po cancellation process.
- Helped create insights on vendor performance for leadership team
- Received Rock star award within 4 months of joining.
Senior Analyst - Reporting
Unacademy – Sorting Hat Technologies Private Limited
12.2020 - 07.2023
- Organizing huge data sets effectively via advanced querying visualization and analytical tools (SQL, MS excel, Tableau, Power bi)
- Developed ROI projection and seat cost dashboards for the management supporting budget allocation and enabling overall cost reduction by 20%
- Developed a single hawk eye view dashboard with 120+ metrics to streamline performance tracking, resulting in increased visibility
- Established a dynamic dashboard for the special initiatives namely loans and referrals resulting in increased login and reach counts on the same day by 4%
- Conceptualized and managed inbound IVR daily/weekly/monthly with KPI metrics and PMO report; supported the initiative by fuelling $2 M revenue in 5 months from launch
- Training the recruits in data storage structures and data cleansing while managing & maintaining master data
- Resolving issues pertaining to dashboards and reporting database environment, while overseeing quality assurance of the imported data program management
- Contributing to strategy formulation across multiple business units, distribution channels and product lines to boost KPIs across all business units
- Performed Target Simulation and revenue projection for the sales team, giving them realistic goals to strive for
- Awarded Best Team player and quarterly awards for 3 times
Senior data analyst
Cognizant technology solution
07.2016 - 12.2019
- Company Overview: Client - Core Logic | Domain - Digital operations (ETL) | Tech Stack - SQL, ETL, Informatica, and data warehousing
- Data Identification & Optimization: - Consolidating and optimizing available data warehouse infrastructure to create star schema and fetch data from different files
- Assessing & identifying valid data by importing all source files to SQL server Identifying optimized data by deploying data warehousing clustering methodology and implementing star & iterative schemas
- Data Integration & Extraction: - Performing creation of dimensions and declaring properties of the target fields
- Alleviating data extraction & integration complexity by merging optimized files with similar layouts
- Declaring primary keys and foreign keys to pull data from different files
- Performing data testing & cleansing to remove invalid data from the source file by deploying SQL queries
- Transformation Mapping & Session Property: - Creating session property to instruct Informatica on how and when to move the data from source to targets
- Defining transformation mapping to load data from source files to target files by deploying ETL Tool Deploying incremental aggregation for sessions including aggregator transformation to perform aggregate calculations incrementally
- ETL Procedures & Data Analytics: - Defining linkage between driver file with greater record count and other files present in the transformation
- Implementing ETL procedures (transformations) for the intake of data from external source files like flat files, tab files, etc
- Loading standard and valid data to the Diablo Database - from where the data gets loaded to client applications such as Credco, Teltrac, RealQuest, etc
- To be employed by the US underwriters, appraisers, loan originator, homeowners, etc
- Implementing ETL processes, functioning analytics lad, clients reporting environment, and dashboard via Salesforce
- Successfully initiated and led the Testing team’s foundation; mentored new and junior resources
- Awarded Unicorn Award 6 times and best performer award 2018
- Client - Core Logic | Domain - Digital operations (ETL) | Tech Stack - SQL, ETL, Informatica, and data warehousing
Education
BSc - Computer Science
St. Joseph's College
Karnataka, India06-2016
Skills
- Data and Statistical Analysis
- Trend Analysis
- Workflow Documentation
- Data Modelling
- Data Visualization and Management
- Client Relationship Management
- Root-cause Analysis
- Analytical and Problem-solving Skills
- Interpersonal Skills and Adaptability
- SQL
- MS Excel
- Tableau
- Power BI
- ETL
- Informatica
- Power Automate
Certification
- US Mortgage Certification Level 1, 5 modules
- US Mortgage Certification Level 2, US Mortgage Bankers Association, 14 modules
- Process Trainer Certification for Tax Roll Operations
- Certified in ETL/Informatica Testing, Besant Technologies, Bangalore
- Certified Trainer, Facets Cognizant
Timeline
Analyst - Merchandising Reporting
Lowe’s India
07.2023 - Current
Senior Analyst - Reporting
Unacademy – Sorting Hat Technologies Private Limited
12.2020 - 07.2023
Senior data analyst
Cognizant technology solution
07.2016 - 12.2019
- US Mortgage Certification Level 1, 5 modules
- US Mortgage Certification Level 2, US Mortgage Bankers Association, 14 modules
- Process Trainer Certification for Tax Roll Operations
- Certified in ETL/Informatica Testing, Besant Technologies, Bangalore
- Certified Trainer, Facets Cognizant
BSc - Computer Science
St. Joseph's College