MAHINDRA REDYAALAW
Mount Pleasant
Summary
Data-driven IT Analyst with 4+ years of experience leveraging data insights, optimizing processes, and implementing robust fraud mitigation strategies to drive strategic decision-making. Translates complex business requirements into actionable data solutions. Excels at fostering cross-functional collaboration to achieve operational excellence and surpass business objectives.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Workflow Analyst
Amazon
04.2021 - 06.2022
- Monitored the (inflow) queues across all marketplaces and ensured >90% SLA (Service Level Agreement) adherence through capacity planning and cross resource utilization
- Collaborated with the Machine Learning team to leverage ML scripts to process incoming volume resulting in upstream resolution of ~25% of total volume per month
- Handled 3 high severity (severity 2) tool related issues and coordinated with the software development team for resolution with
- Demonstrated ability to work with large data sets
- Ensuring daily service levels in all Operational Units
- Coordinating site staffing needs, including the reporting of site headcount numbers by shift and Operational Unit
- Placement of new hire associates and individual shift changes
- Identifying workflow headcount deficiencies and overages thus driving overtime hours and Voluntary Time Off as needed
- Developing/maintaining a series of workflow related trackers that drive day to day site-wide production efficiency (Voluntary Time Off, Absences, Shifts, Overtime), updating the Worldwide Capacity Planning group with site email targets for coming weeks
- Contributed to Agile ceremonies, such as sprint planning, sprint reviews and retrospectives to drive continuous improvement
- Utilized Jira for project management, issue tracking and workflow management
- Worked with Data SMEs /Modelers and Architects to design the source data to be able to achieve meaningful insights
- Managed multiple priorities, customer expectations and relationships with all stakeholders
- Supported training development for end users and staff members
- Presented findings and recommendations to stakeholders using clear visualizations and concise summaries, facilitating data-driven decision-making processes.
- Coordinated with clients and vendors to determine project scope and define timelines for completion.
Transaction Risk Analyst
Amazon
08.2019 - 03.2021
- Investigate customer accounts, and arrive at proper decision, with bias towards customers
- To follow customer eccentricity at all times and assure customers towards safer online transactions at Amazon
- Determine fraud characteristics causing potential business losses and share with peers and manager to work further
- Retrieved quality and productivity data
- Built reports on these datasets and shared it using Excel/VBA/SharePoint
- Identified Fraud risks like Money Laundering, Social Engineering, ID Theft, Credit card Fraud, Reseller Scam
- Triangulation Scam using order/customer attributes
- Reduced bad debts received by 30% over span of 6 months
- Created and maintained 5 dashboards using Tableau to communicate fraud trends to business stakeholders
- Conducted regular performance audits/ad-hoc (adhoc) analysis using Excel, Tableau to provide areas of improvements and suggestions for process
- Developed and maintained 5 dashboards on Tableau corresponding to department wise quality and productivity metrics
- Maintained Employee performance metrics (KPIs) on MS SQL Server and performed SSIS/SSRS/SSMS for this Data analytics to assess and maintain healthy decision accuracy
- Performed data cleaning and analysis using Power Pivot, Power Query and other data management and ETL systems
- Used and developed automated tools on Excel VBA to report bugs and communicate performance trends to the team
- Led team of 20 junior analysts
- Assigned and resolved incident tickets within SLAs
- Coordinated among cross functional teams to communicate priorities to maintain SLAs and manage workforce
- Fraud reinstate rate was missing for entire team because of 4 investigators who were not able to understand scenarios and on-going MOs. Audited defects of 4 investigators for couple of weeks and analyzed root cause for same
- Arranged SBS (Side by Side) sessions with individual investigators and helped them understand misses
- Post that team's FRR got controlled by ~10% and never saw investigators defects with same misses.
Associate Data Analyst
Clocr Inc
06.2018 - 07.2019
- Performed Data Mining using Python to assess and clean data
- Collaborated with cross-functional teams, including data scientists, Business analysts, and project managers, to align data analysis efforts with business goals and priorities
- Performed monthly report monitoring to optimize Dashboard performances and overall reporting capabilities
- Ensured proper product documentation including user guides, use cases, implementation guides, Source to target mapping, functional and business requirements, and release notes
- Built new Database objects like Views, Tables, Procedures, Functions, Packages, Triggers, Indexing in SQL Server
- Developed different data connections from source to Tableau Desktop for report and dashboard development
- Created MicroStrategy Projects that involve creating Attributes, Facts and Hierarchies
- Within the MicroStrategy Environment created Users, privileges and roles as an Admin.
Data Analyst Intern
Clocr Inc
01.2018 - 05.2018
- Translated complex stakeholder requirements into effective BI solutions, facilitating data-driven decision making within the organization
- Conducted extensive data analysis to identify trends, patterns, and insights crucial in shaping strategic business decisions
- Collaborated cross-functionally to integrate new systems and enhance existing processes, contributing to overall operational efficiency
- Ensured data integrity by implementing meticulous data cleanup processes enhancing data quality
- Proficiently Utilized SQL for data querying and manipulation, aiding in data extraction and analysis
Education
Master of Science - Management Information Systems
Central Michigan University
Mount Pleasant, MI05.2024
B.E/B.Tech - Civil Engineering
Vellore Institute of Technology
Vellore, India05.2018
Skills
- SQL, Python
- Pandas, Numpy
- SDLC, Agile, Waterfall
- Excel(Power Query, Pivot tables), Tableau, Power BI
- SQL server
- Azure Data Studio
- Dimensional modeling, star schemas, snowflake schemas
- Data cleansing, profiling, and validation
- Data Warehousing Architecture
- Report Generation
- Workflow Management
- Workflow Analysis
- SQL knowledge
- Resource Management
- Deadline Management
- Stakeholder Management
- Quality monitoring
- Data Analysis & Visualization: Leverage Python for data mining and cleaning, crafting compelling dashboards and reports using Tableau, MicroStrategy, and Excel to deliver actionable insights
- Database Management: Design and maintain efficient databases using SQL Server, including views, tables, procedures, functions, and packages, ensuring data integrity and optimal performance
Key Skills:
Accomplishments
- Fraud Detection & Mitigation: Possess a keen eye for identifying and investigating suspicious activity, implementing data-driven strategies to reduce fraud risks and safeguard financial assets
- Workflow Optimization: Proven track record in analyzing workflows, optimizing staffing levels, and ensuring consistent adherence to service level agreements (SLAs) for maximized efficiency
- Project Management: Lead data analysis projects from conception to completion, ensuring alignment with business goals, timelines, and resource allocation
- Leadership and Communication: Demonstrated ability to lead and collaborate effectively
- I can communicate complex technical concepts to diverse stakeholders, manage teams, and foster a collaborative environment
Certification
- Microsoft certified: Fabric Analytics Engineer Associate
- Lean Six Sigma Green Belt.
Timeline
Workflow Analyst
Amazon
04.2021 - 06.2022
Transaction Risk Analyst
Amazon
08.2019 - 03.2021
Associate Data Analyst
Clocr Inc
06.2018 - 07.2019
Data Analyst Intern
Clocr Inc
01.2018 - 05.2018
Master of Science - Management Information Systems
Central Michigan University
B.E/B.Tech - Civil Engineering
Vellore Institute of Technology