Sql Server Data

Nirav Patel

**** ******** *** #**, ***** Clara, CA 95051 • (321) 684–8199 • **********@*****.***

OVERVIEW • 2+ years Experience in designing, developing and testing ETL solutions using

SSIS as well as custom JAVA and VB programs

• 2+ years Experience in developing T-SQL, Stored Procedures, Functions, Triggers

as well as Query Optimization

• Expert in Analyzing database schema from various databases like SQL Server,

oracle, Sybase etc.

• Lead multiple Data migration projects simultaneously from requirement gathering to

testing phase

• Direct interactions with the client fetching hands on experience on skillful handling

of client requirements, expectations and negotiations.

• Experience in Project Management, END user training, Documentation and tools

like SSAS, SSIS and SSRS.

• Served as a mentor and reviewer for new hires in all area of ETL.

• Highly adaptable in changing technical environment of IT industry

• Always interested in designing solutions for addressing new challenges with best way

possible (Never go for a workaround).

SKILLS Languages: Java, VB, VB.NET

Database: MySQL, Oracle, MS SQL Server with SSIS, SSAS and SSRS

Scripting: XML, JavaScript, Python

EXPERIENCE eClinicalWorks Inc., Pleasanton, CA July 2011 - Present

Data Migration Specialist

• Gather requirements for Data Migration by working closely with business users

and also provide timeline and cost estimates.

• Extract Data from various Client based and Cloud based EHR systems, which

uses different database like Oracle, SQL server, Sybase etc.

• Generate scripts to parse data from various file formats like XML, .CCR, .HL7,

.TXT, Flat Files etc.

• Extensive Database Analysis of database schema to find required data for

migration

• Determine vivid relations between data across the database and generate

crosswalk tables.

• Create specification document, which includes detail data migration plan

• Negotiate client requirements and set expectation for data migration.

• Migrate data into eClinicalWorks products like PM, EMR, eHX, CCMR etc.

using SSIS and custom JAVA and VB Programs.

• Preform detail Quality check after migration

• Provide and discuss Exception report for the migration

• Guide business users to data validation process after migration

• Provide after migration support to client for any data migration questions or

issues.

• Design and Create JAVA and VB Programs to export data in various formats

like .PDF, .HTML etc.

• Design and create JAVA and VB programs to perform different tasks like

merging documents, Converting documents, Moving documents, Generating

file index etc.

• Generate SQL scripts for data cleansing as per client requirements.

• Train new hires for ETL process and tools.

BISAG, Gandhinagar, Gujarat, India

Database Developer July 2008 June 2009

• Designing Logical schema for knowledge center Database.

• Design and implemented tables, stored procedures, views and triggers.

• Build and maintain SQL scripts, indexes, and complex queries for data analysis

and extraction

• Migrated Data from their legacy files to SQL server using SSIS

• Install, configure and maintain MS SQL Server 2008

EDUCATION Florida Institute of Technology, Melbourne, FL

Masters of Science in Computer Science Dec 2011

Gujarat University, Ahmedabad, India

Bachelor of Engineering in Computer Engineering May 2009

Relevant Coursework

• Advanced JAVA, Artificial Intelligence, Data Structures and Algorithms

• Software Testing I-II, Software Architecture

• Database Management system I-II, Formal Language

• Computer Networks, Network Security

• Discrete mathematics, Applied statistical Analysis

Academic Project Work

• Program iCreate robot to perform given task, avoiding obstacles and reducing

mechanical errors by using Hidden Markov Model(HMM) and Python(pySerial)

• Program R12 Robotic arm to inspect object in 3D environment using Python

• Created JAVA application to implement brute force attack and encryption and

decryption of DES algorithm

• Created JAVA application to fetch and parse SIL data of languages of the world

and SSDI (social security death index).

• Created JAVA application to manage Lottery for gas station environment

• Created a JAVA program to extract notes from MIDI file and represent that

information in 2D environment as time interval v/s beats

• Black Box Testing for components of Open Office Writer and Impress

• Implemented Quick Sort Algorithm using agile development and JUnit

• Design architecture of hospital management system

• Review papers for Association for the Advancement of Artificial Intelligence

REFERENCES Available upon request

Contact this candidate