Data Analyst
Resume:
GARNETTE PEREIRA
Cell: 315-***-****
Email: **********@*****.***
Address: * ********* ****, ***. ***, West Chester, PA 19380
EXECUTIVE SUMMARY
Adaptable Data Analyst skilled in gathering, processing, interpreting and analyzing data in high pressure environments specializing in all aspects of SQL Server, Microsoft Power BI, Excel, T-SQL and SAP HANA Cloud Platform PROFESSIONAL EXPERIENCE
SAP America, Newtown Square, Pennsylvania Sept 2015 - Dec 2016 Data Analyst Intern
Built dashboards using DAX queries and SQL queries to gather accurate data tailored to the team’s reporting requirements
Improved an existing SQL job’s performance by implementing ETL solution in SSIS
Designed BI reports using PowerView in Excel to analyze trends in data and create dynamic visualizations
Improved reports using PowerPivot in Excel to reduce data refresh time and automated data entry process using DAX queries
Built and managed an application using a Zero Coding platform and SAP HANA Cloud Platform Syracuse Center of Excellence, Syracuse, New York Jul 2015 - Sep 2015 Database Intern
Lead the CoE’s database migration project from SQL Server to MySQL
Responsible for designing migration strategy, test plans and scripts to verify and migrate data from SQL Server to MySQL
Worked with website's data to create a user-friendly website for over 100 users Datamatics Global Services Limited, Mumbai, India Aug 2010 - May 2014 Associate Consultant
Used SQL to analyze trends in customer data and generate user reports using SSRS
Collaborated with Agile team members in the Scrum Teams to create financial reports
Archived legacy data using Informatica ILM to drastically improve database and application performance
Built packages for extracting and transforming data using PLSQL Developer to reduce execution time
Performed root cause analysis of high priority defects and eliminated them in a timely manner
Created SQL scripts to fetch and manipulate data and tuned SQL queries and procedures to improve system performance
Mentored new team members during development of new Oracle Reports to accelerate software delivery process Junior Consultant
Analyzed Healthcare functional and technical requirements to boost application enhancements within fixed deadlines
Diagnosed application failures and fixed critical issues in VB.NET and C# to significantly increase application stability
Upgraded 200 Oracle reports from Oracle 6i to Oracle 10g to eliminate incompatibility of the obsolete Oracle reports EDUCATION
M.S. in Information Management Certificate in Data Science, Syracuse University (GPA: 3.9) May 2016 B.E. in Information Technology, University of Mumbai (GPA: 3.2) May 2010 ACADEMIC PROJECTS
USA Crime Data Visualization and Analysis Jan 2016 - May 2016
Analyzed crime datasets, cleaned and exploited data and investigated external factors and their influences on crime statistics
Devised visualizations to analyze safer states to reside in the US based on crime influencing factors using R and Illustrator North Central Cancer Treatment Group (NCCTG) Lung Cancer Data Analysis May 2015
Performed statistical data analysis on the dataset to identify, correct and clean outlier data and to transform data using R
Modelled information visualizations from dataset to facilitate informed decision making and make data more accessible Syracuse University Student Enrollment Data Warehouse Jan 2015 - May 2015
Designed and built a data warehouse for Syracuse University to provide strategic solutions for improving enrollment process
Implemented ETL using SSIS, built MOLAP cubes and KPIs using SSAS and developed BI reports using Advanced Excel TECHNICAL SKILLS
Databases: Oracle 10g, MS SQL Server 2008/2014, MySQL, T-SQL, MS Access Programming Languages: SQL, PL/SQL, ASP.NET, C#, VB.NET, VB6, HTML 5, R, Python Applications: MS Visio, Advanced MS Excel, Oracle Report Builder, TOAD, PLSQL Developer, TFS, MS Project, MS Visual Studio, Informatica ILM, SSIS, SSAS, SSRS, MS Power BI, SSMS, MySQL Workbench, Illustrator, SAP HANA Cloud Platform
Contact this candidate