SQL
USHA RANI PERLA
Inventory and sourcing Analyst
Hyderabad
Summary
- Organized Supply Chain Analyst skilled in assessing client needs and cultivating compelling solutions. Well-trained decision-maker with focused attention on detail and drive to manage order flows with expert precision. Offering exemplary client relationship and support skills.
- As an Analyst responsible for Data Modeling, data presentation, visualization, optimization, risk assessment, predictive analysis, advance Data Analysis, Business Research and Quantitative Analysis.
- Experience in SQL and Power BI.
- Hardworking and passionate job seeker with strong organizational skills eager to secure Mid-level {Data Analyst} position. Ready to help team achieve company goals.
- Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
14
14
years of professional experience
3
3
Languages
Work History
Inventory Planning and Sourcing Analyst
Sears Holding Corporation
09.2019 - 10.2023
- Conducting an in-depth analysis of sales trends and inventory patterns, strategically optimizing stock levels to meet forthcoming demands across diverse USA stores using SQL Data base.
- Develop reports that support the assessment of operations and continuous improvement including sales trends and exceptions by running SQL Queries to fetch data at different levels.
- Fostering productive vendor relationships through proactive communication and collaboration
- Develop comprehensive buy model files for new styles by leveraging historical trends, ensuring alignment with future sales projections, using SQL
- Publish and distribute Monthly Business review dashboards, and scheduled operational reports highlighting performance related to sales trends.
- Preparing project SOP's and updating the same on a timely manner for the team to access the latest version.
Freight Claims Specialist
DELL Technologies
11.2009 - 06.2018
- Orchestrated the successful transition of three critical processes/projects from the Dell Philippines site to the Dell Hyderabad site in 2015, ensuring seamless continuity and operational excellence
- Designed business analytics dashboards using Microsoft Power BI.
- Publishing reports related to Freight deliveries using Power BI.
- Provided instrumental support for high-priority claims spanning the US, EMEA, and ANZ regions
- Single POC for all VP level escalations across the project.
- Trained new hires on a regular basis and created training manuals along with business SOP's and held bi-weekly check in sessions to learn their professional development goals, helping 10 new hires advance to next level.
- Conducting monthly Audits for new hires and providing areas of improvement.
Education
Bachelor of Arts -
Nizam College, Osmania University
HEC -
Govt Junior College For Women, Board of Intermediate
SSC - undefined
Rama Krishna Vidya Niketan High School, Secondary School Education
Skills
Power Bi Analyst (DAX Functions)
SQL
Data Analytics
Pricing Analysis
Strategic Sourcing
Supplier Relationship Management
Supply Chain Optimization
Freight Claims Analysis
MS-Office
Accomplishments
- Successfully earned a Project Management certification from LinkedIn, showcasing dedication to professional growth and expertise.
- Honored with the prestigious Dell Champions Award for the exceptional contributions made throughout the fiscal year 2015.
- Consistently recognized for Outstanding Performance, securing the Bronze Award in significant quarters of FY14, FY15, and FY16, including Q1 and Q3.
- Recognized for exceptional agility and excellence with On-the-Spot Awards in FY14 Q2 and FY13 Q3, demonstrating exceptional commitment to exceeding expectations.
Analytical Skills
- Business Development with Data Insights
- Data Analysis and Interpretation
- Quality Control and Data Validation
- Policy Planning Informed by Data Trends
- Operations Oversight and Performance Analysis
- Strategic Decision-making Supported by Data
- Effective Meeting Scheduling for Data Review
- Operations KRA Management with Data Metrics
- Client Relationship Management through Data-driven Insights
- Troubleshooting and Problem-solving with Data Analysis
Software
POWER BI
TABLEAU
MS-EXCEL
Timeline
Inventory Planning and Sourcing Analyst
Sears Holding Corporation
09.2019 - 10.2023
Freight Claims Specialist
DELL Technologies
11.2009 - 06.2018
Bachelor of Arts -
Nizam College, Osmania University
HEC -
Govt Junior College For Women, Board of Intermediate
SSC - undefined
Rama Krishna Vidya Niketan High School, Secondary School Education