Data Analyst Sql Server

Sonal D. Raghani

Marietta, GA

Phone: 925-***-****

E-Mail – ac157b@r.postjobfree.com

CORE COMPENTENCIES

Expertise in database Administration, database management, database development, data migration, data modeling, data analysis, requirements gathering, customer interactions.

An efficient communicator with excellent leadership, team building, organizational, motivational and project management skills

A result oriented professional with an analytical mind capable of delivering timely and desired results even in most challenging situations

PROFESSIONAL EXPERIENCE

Soraa, Fremont, CA May 2016 – Present

Data Engineer

Designed and developed SSIS packages for loading LED test data into SQL Server databases

Performance tuning of the application to achieve up to 50% faster response time

Tuned databases/code/loaders to get space savings of up to 60%

Managed and administered production SQL Server databases

Developed/Supported MATLAB applications to get the data related graphs

Ybrant Digital, Hyderabad, India Aug 2012 – May 2014

Senior Data Analyst

Designed and developed databases for business application, which help Ybrant Digital a digital marketing company optimize rendering of ads on websites.

Managed and administered Production Oracle, MySQL and SQL Server databases including database installation, backups and recovery.

Performance tuned databases to achieve batch performance of up to 50% and response times up to 30%.

Performed hands-on tasks in data modeling, data migration, SSIS development and shell scripting.

Acted as an off-shore liaison (in India) for the global teams based in Israel and USA in a trusted advisor capacity.

InRhythm Solutions, Hyderabad, India Mar 2012 – Jul 2012

Senior Data Analyst

InRhythm solutions has a capturing data from convenience stores and using it to effectively manage the inventory and sales

Developed database modules for the InRhythm data warehouse catered towards retail industry to provide business analytics on sales and inventory data.

Developed database procedures in TSQL

Enabled automation and workflow management using SSIS packages

Honeywell Technology Solutions, Hyderabad, India Dec 2010 – Feb 2012

Senior Data Analyst - Data Management Group

Ownership of project activities like building Business Use Case Scenarios, Functional and Integration quality testing of the systems, Driving the UAT, Migration Planning, User Training, User adoption plan, and Post Go Live Support.

Data migration from legacy systems to current application

Database development involving advance pl/sql and t-sql

SSIS package development

Active involvements in tech talks, POCs and white paper.

Mentoring/guiding two team members.

Database design using ERStudio

Honeywell Technology Solutions, Hyderabad, India Dec 2008 – Dec 2009

Data Analyst - Data Management Group

Responsible for analysis of the data and creating design of the database in MySQL.

Core member of the team involved in the development and the data flow for a product used for generating reports.

Development of embedded mysql queries in PHP code.

POCs for understanding new features of MySQL

Honeywell Technology Solutions, Hyderabad, India Nov 2007 – Nov 2008

Data Analyst - Flight Support Services

Responsible for analysis and documentation of requirements based on interaction with customers.

Core member of the team involved in the development of prototype.

Supporting production oracle database server involving basic backup and restore activities

Developing intermediate level pl/sql code

Honeywell Technology Solutions, Bangalore, India Feb 2006 – Nov 2007

Data Analyst - Data Management Group

Responsible for developing pl/sql and t-sql codes.

Assisting in DB design, ER data modeling

Involved in data migration activity

Support and administer sql server 2000.

AWARDS & ACTIVITIES

Won several Team Excellence and Spot Awards

Green Belt Six Sigma certified

SKILLS AND KNOWLEDGE

Programming Languages: Java, JSP, C/C++, T-SQL, SQL, PL/SQL,C#

Web Technologies: XML, HTML

Operating Systems: Windows (NT, 2000)

Database: Oracle 10g/11g, MS SQL Server 2005/2008/2012, MS Access

Database Design: ER Studio

EDUCATION

Diploma in Advanced Computing, Hyderabad University Jan 2005 – Dec 2005

B.E (Electronics & Telecommunication), Amravati University May 2000 – Apr 2004

Contact this candidate