GARNETTE PEREIRA

Cell: 315-***-****

Email: acy0i7@r.postjobfree.com

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