Sheetal Aggarwal

Tampa, FL ***** ac8a59@r.postjobfree.com 201-***-**** LinkedIn GitHub

Summary:

Data Analytics professional with hands on experience of working in fast paced Agile environment, large data sets and bringing out valuable insights. Proficient in SQL and Visualization techniques and familiar with all phases of SDLC. Currently seeking full-time opportunities.

Education:

University of South Florida, Tampa FL Dec 2018

Master of Science - Business Analytics & Information Systems GPA 3.76/4 Kurukshetra University, India Aug 2012

Bachelor of Technology – Computer Engineering (Honors) GPA 3.8/4 Technical Skills:

Technologies/Tools: SAS, R, SQL, T-SQL, Python (NumPy, Pandas), Tableau, Advance Excel Machine Learning Models: Regression, Classification, Clustering, Data Exploration Business Intelligence Tools: Cognos, MicroStrategy, Informatica Database: Oracle, MySQL, DB2

Other: ETL, Unix, JavaScript, HTML/CSS

Academic Projects:

Bitcoins- Bit by bit:

• Analyzed bitcoin exchanges in R and Excel for predicting bitcoin behavior using different statistical techniques to understand customer concerns and avoid churn.

• Performed data cleansing, extraction and exploratory analysis and achieved 65% accuracy model. Bull-Flix- A movies application:

• Created database models, designed the database using SQL and Tableau performed visualizations and optimization on customer and genre ratings. Implemented performance tuning, data integrity and table partition and stored procedures using SQL Developer. Statistical Analysis for Cancer Patients:

• Worked on Cancer patient datasets to analyze and predict the pattern of Cancer among male and female patients. Using SAS Studio and Excel, regression models and Statistical Procedures were applied.

• Extensively used Excel functions such as VLOOKUP, Pivot table, Macros and solver. Data warehousing – Dimensional Modelling

• Designed a Dimensional model on the S&P 500 financial stock data by identifying various Facts and Dimensions.

• Achieved data analysis by using SQL analytical queries involving aggregations rank and correlation function Work Experience:

Data Analyst Intern Wipro, Tampa, FL Jun 2018 – Aug 2018

• Facilitated requirement gathering to aid in the discovery of high-level business requirements of clients.

• Successfully implemented Security Filter in insurance reports which improved overall efficiency by 20%

• Derived insights and effectively communicated the findings about ‘less-productive test scenarios’ via visualization, statistical analysis to the management. Associate Software Engineer Mphasis, India Mar 2014 – Jun 2016

• Worked for a Banking client in the Agile methodological setup, created Business Requirement Document and Functional Requirement Document by successfully collaborating with offshore and onsite teams.

• Developed SQL queries to extract transaction data. Prepared Tableau dashboards for effective reporting regarding merchant data, chargebacks and interchange rate distribution across various regions.

• Involved in Data Analysis, data cleaning and unit testing of the reports.

• Engaged in preparation of data validation and issue log sheets for reports using SAS.

• Mentored a team of two resources in a structural reforms project through all phases of SDLC and client calls.

• Identified potential areas and performed HPSM log automation which saved 80-man hours/ sprint. Achievements & Certifications:

• ‘Pillar of the Month’ award by Mphasis in recognition for the contribution to the team.

• Analytics & BI Certificate (USF – SAS), Coursera certified – Inferential Statistics.

• ITIL Certified – Mphasis.

Contact this candidate