Sql Server Data

Ann Merin Peter

**** ****** ***, *** ****, CA – *5119

www.linkedin.com/in/annmerinpeter

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

Phone: 669-***-****

Overview

Senior Business Intelligence and Data Analysis developer with 9 years of IT experience.

Skills

BI tools: Tableau, Power BI, SSIS, SSAS, SSRS, Business Objects, Crystal Reports, Xcelsius

Scripting Languages: R, Python, T-SQL, PL/SQL, MDX

Database: SQL Server, Oracle, Vertica

OS: Windows

Experience

University of Alabama in Huntsville

Graduate Assistant

August 2016 – May 2017

Responsibilities included aiding faculty with exploratory data analysis with regards to data science courses. Assist in editing research paper works and grading different courses.

Hewlett Packard Enterprise, Bangalore, India.

Technology Consultant

February 2011- July 2016

Architected and implemented different data warehousing projects using Microsoft Business Intelligence, SQL Server, SAP Business Objects, Oracle and HP Vertica.

Developed SSAS models and SSIS Packages for managing the Analysis and ETL for collating various data across different databases including SQL server and Oracle.

Wrote scripts to pull data from SQL server and SSAS cubes using procedures and MDX queries to develop SSRS reports.

Designed reports using infoview and crystal reports by pulling data from HP Vertica.

SQL scripts performance turning.

Succeeded in onboarding new customers by implementing end to end data analysis requirements.

Worked with different delivery teams in a day to day basis to manage multiple projects.

Proactively worked to keep up the expectations of the stake holders by automating different weekly activities and implemented scripts to notify any failures in advance.

Managed the team with training, involved in hiring and employee engagement activities.

Sonata Software Ltd, Bangalore, India.

System Analyst

February 2006- January 2011

Led the team to achieve the business goals

Achieved implementation of data warehousing, data modeling, data mining and forecasting projects for different domains such as sales, marketing, healthcare, banking, finance and insurance.

Designed ETL using Business Objects XI universe and SSIS and analysis using SSAS.

Developed dashboard reports using Crystal reports, WebI reports and SSRS from SQL server and MDX, implemented dashboards and data visualization using Xcelsius.

Conversion of Crystal reports to SQL reports, migration of BO reports and SSRS to latest versions.

Education

University of Alabama in Huntsville, AL.

May 2017

Master of Science, Business Analytics

Birla Institute of Technology, Pilani, India

April 2012

Master of Science, Software Systems

Relevant Coursework

Statistics and Quantitative Methods, Advanced Analytics using R, Business Intelligence & Analytics using R and Python, Operations Management with Supply chain, Decision Modeling, Modeling and Simulation, and Financial Accounting.

Course Projects

Advance Replacements

Developed Data mining and predictive model for ADTRAN from the data associated with advanced replacement using R, Python and data visualization with Tableau.

UAH Enrollment

Succeeded in implementing predictive model for UAH enrollment details with the past enrollments details using R and Tableau.

Certifications

Microsoft 2012 Certified Professional

Oracle 11g Certified Associate

Contact this candidate