Data Information Technology

GARNETTE PEREIRA

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

Email: ********.*******@*****.***

Address: * ********* ****, **** *******, 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

Radus Tek Services, Somerset, New Jersey June 2017 – Present Programmer Analyst

• Collaborate with clients to understand and define business requirements for the development in the existing database

• Develop SQL code, test and implement this code in production databases to enable smooth functioning of system

• Develop ETL workflows and data integration applications using SSIS to ensure accurate data flow between data sources Emplay, Chicago, Illinois Mar 2017 - May 2017

Consultant

• Analyzed existing data and assess the availability of data for sufficient report generation and predictive analysis of data

• Prepared data analysis report displaying potential advanced analytical approaches to showcase to senior management 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 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, MS Excel, Oracle Report Builder, TOAD, PLSQL Developer, Informatica ILM, SSIS, SSAS, SSRS, MS Power BI, SSMS, MySQL Workbench, Illustrator, SAP HANA Cloud Platform

Contact this candidate