SHEETAL RAMESH
O B J E C T I V E
Process oriented Data Analyst with proven track record of analyzing BI trends and detailed records to increase sales revenue. Reduced costs in a logistics chain by 15% by analyzing the operating data. Seeking to leverage skills and experience to guide business decisions. Strong business and technical vision with effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results oriented, and have an aptitude for learning and can maximize resources while possessing a sense of urgency.
E D U C A T I O N E X P E R I E N C E
Jan 2016 – May 2017
Master of Science in Computer and
Information Science
GPA 4.0 / 4.0
Southern Arkansas University, Arkansas
Aug 2008 – Jun 2012
Bachelor of Engineering in
Information Science and Engineering
GPA: 3.6 / 4.0
Visvesvaraya Technological University,
India
Aug 2017 - Present
Data Analyst • UPS, Atlanta GA
Collected and analyzed data on established and prospective customers, competitors and marketing channels.
Converted data into actionable insights for data scientists to predict and model future outcomes.
Ingested data from disparate data sources using a combination of SQL, Python to create data views to be used in BI tools like SSRS and Tableau.
Extracted, interpreted and analyzed sales figures, market research, logistics and transport data to identify key metrics and transform raw data into interactive reports and dashboards using Tableau.
Collected, cleansed and provided modeling and analyses of structured and unstructured data used for major business initiatives.
Designed and implemented a real-time data pipeline to process semi-structured data by integrating 150 million raw records from 30+ data sources using SQL.
Automated ETL processes across billions of data points which reduced manual workload by 33% monthly.
May 2014 – Sep 2015
Data Analyst • IGATE Global Solutions, India
Analyzed the retail product data to improve the functionality of assets.
Evaluated the reliability of the retail products and predicted the future warranty and contract prices.
Created visually impactful dashboards in SSRS, Excel for data reporting by using pivot tables and VLOOKUP.
Provided expertise in data storage structures, data mining, and data cleansing. Feb 2013 – Apr 2014
Software Engineer • IGATE Global Solutions, India
Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
Developed and managed data and databases that support performance improvement activities.
Developed complex TSQL queries, Stored Procedures and Triggers for the purpose of providing development support and application tuning. June 2012 – Jan 2013
Database developer • Cityonnet, India
Organized customer data distributed across four regions, to optimize and maintain customer information.
Built data warehouse on SQL database for customer loyalty program which increased profit of 10%.
S K I L L S
Languages: T - SQL, PL/SQL, Python
(Pandas, SciKit-Learn, NumPy,
MatplotLib, SciPy)
Certification: Certified Tableau Desktop
Specialist
Tools: Data Tools (SSIS, SSAS, SSRS),
JIRA, Visual Studio, GitHub, Microsoft
SQL Server, SSMS, SQL Profiler, JIRA,
GitHub
Reporting: Tableau, SSRS (SQL Server
Reporting Services) - Enterprise
Reporting
Data Modeling Tools: Toad Data
Modeler, Visio
C O N T A C T
Phone: +1-704-***-****
Email: adkd7w@r.postjobfree.com
LinkedIn:
http://linkedin.com/in/sheetalrkb