Data Analyst

Kashyap Patel

**** *** ******* *****, ***** Cloud, FL 34771

Cell: 321-***-**** ***************@*****.***

Summary of Qualification

Experience in SQL, Database Analysis

Creating various summary using excel and pivot tables

Experience in Oracle, Database Analysis, Database Management in various domains

In-depth knowledge of backend Oracle PL/SQL program to interact with frontend application development

Diverse skill set, which enables holistic approach towards addressing risks, with the ability to bring together knowledge of business dynamics, and understanding of the working of application systems supporting the business

Proven ability to execute, manage and deliver assignments adhering to strict timelines

Analytical bent of mind and excellent problem solving skills

Effective team player and ability to take responsibilities

Professional Experience

Data Analyst

Black Knight Financial Services (Contractor)

June 2016 - October 2016

Quality checking of the property and land dat from the source file.

Generating business rules for resolution of the bad data to be cleansed

Creating and running SQL queries to enhance the dara and do automate searches

Data Analyst

Healthfirst, Inc. Lake Mary, Florida (Contractor)

December 2015- June 2016

Manipulating, cleansing & processing data using Excel and SQL.

Writing T-SQL script to retrieve data for the purpose of data loading and extracting

Advising on the suitability of methodologies and suggesting techniques

Supplying qualitative and quantitative data to colleagues & clients

Analyzing raw data, drawing conclusions & developing recommendations

Carrying out specified data processing and statistical techniques

Performing daily system checks

Develop new picture charts and update automatically

Data Analyst & Oracle SQL, PL/SQL Developer

EnviroApps Inc. Orlando, Florida

January 2013 – June 2015

Planned, organized and carried out projects including time budgeting, resource planning, people management and work management to ensure efficient and effective performance of database management project

Working as backend Oracle PL/SQL programmer to interact with Flex, Java and ActionScript based RIA front end that was implemented using BlazeDS, Cairngorm, MVC Architecture, XML and Data

Actively involved in writing PL/SQL stored procedures (packages, procedures and functions) and database triggers throughout the product development (SDLC using Agile and Scrum Methodologies) that involved user interface design

Created database object such as Tables, Views, Index (B-Tree and Bitmap), Synonyms, and Constraints (PK, FK, Not Null, Unique, and Check)

Analyzed and created RDBMS (OLTP) model using Erwin while maintaining referential integrity between parent and a child entities

Debugged and fine-tuned database by running and querying test loads

Export data/metadata as Excel file using built in Import/Export wizard and SQL Loader.

Worked with source control - Subversion (SVN)

Extensively worked on data extraction, transformation, loading between various databases

Developed mappings to integrate data from varied sources such as Oracle, flat files (fixed, de-limited) and SQL Server and loaded into target (OLAP) database

Developed test cases, conducted unit tests, and migrated Metadata from development to production system

Create high quality, clear, concise technical and functional specification documents

Identifying, Testing and Documentation of Business Cycle Controls and General Computer Controls

Reviewed Business Cycle Controls and General Computer Control which includes testing and documentation of controls to ensure that all critical areas / relevant risks has been covered during testing and documentation and they are as per firm standards and policies

Report and follow up of the findings reported to the management to ensure that necessary action has been taken by the management

Provided training to colleagues on various issues in Oracle SQL

Kashyap Patel

2 of 2

Data Manager

DC Liquor Fine Wine & Spirits Orlando Florida

April 2008 – December 2012

Maintained Point of Sale Database

Responsible for maintaining vendor information on a regular basis

Provided data required for identifying business purchases

Coordinated with various teams for accounting data needs.

Fine tuned data to achieve the maximum credit period for the company and reductions in cost of the products

Developed reports to support purchasing through higher negotiation skills and adapting cost reduction strategies.

Established and strengthened effective working relationships at all levels.

Effectively managed the data inventory of the business.

Also responsible for the payroll and shift management data.

Data Analyst

Gas Station

Ticketing Agent

Virgin Atlantic

Domain Expertise / Technical Skills

Database: Oracle, MYSQL, MS SQL, ACCESS

Operating System: Windows, Unix

Languages: PHP, JAVASCRIPT, HTML5, CSS3

Source Control: SUBVERSION

Tools : POS, MS Office

Education

Major in Accounting, AA – Seminole State College

Visa Status: US Citizen

Contact this candidate