Sql Server Assistant

Mital Amin

Permanent resident of United States

** * ********* *****, ****** Plains, NJ 07076. Phone: 908-***-****.

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

[pic]

Summary:

. 5+ years of experience in Oracle (8i / 9i/10g) with a focus on design

and development of stored procedures / functions / Packages /

triggers.

. Experience with SQL Server and T-SQL in creating database Triggers,

Tables, User functions, Views, Indexes, writing Stored Procedures,

query writing, user profiles, relational database models, Cursors, T-

SQL batches.

. Well versed in all stages of SDLC - gathering and analyzing the

requirements, converting the specifications into functional and

technical design documents, coding and testing.

. Extensive experience in back-end development including Materialized

Views (using Complete, Fast and Force refresh), Database links,

Partitions, Indexes, Synonyms, Dynamic SQL, Merge using ORACLE SQL and

PL/SQL.

. Experience in Performance Tuning, Query Optimization, Client/Server

Connectivity, Database consistency checks using DBCC Utilities.

. Expertise in database backup, recovery, restoration and Disaster

Recovery procedures.

. Exposure to Data modelling and Design with ERWIN, MS Visio.

. Exhibited strong leadership qualities in handling teams, took part in

project estimations.

. Coordinating onsite/offshore teams.

. In-depth knowledge of QA activities.

. Ability to effectively multitask, meet deadlines, quickly adapt to

different project environments and ability to work with different team

sizes across geographical locations.

. Experience of working on support tickets using issue tracking system.

. Extensive experience in upgrade of clinical applications and

production support.

Technical Skills:

Databases: Oracle 9i/10g/11g, MS SQL Server

2005/2008, MS Access, Teradata V2R5

Scripting: PL/SQL, basic UNIX Shell Scripting,T-

SQL, JavaScript

Languages: C, C++, HTML, ASP.NET,CSS

Query Tools: TOAD, SQL* PLUS, Oracle SQL developer

Other Tools: SQL*Loader, Erwin, MS-Visio, PVCS, VSS,

Teradata SQL Assistant

Clinical Applications: Dentrix 3.7/6.0, Dolphin 8.5, Emodel 8.0,

Mckesson, Dexis imaging.

Certifications:

. TERADATA Basics NCR-011 certification

. PL/SQL MERITTRAC certification

. 70-432 Microsoft SQL Server 2008-Implementation and Maintenance

. 70-433 Microsoft SQL Server 2008- Database Development

Professional Experience:

Bronx Lebanon Hospital, Bronx, NY

(Feb 2012 - Current)

Position: Clinical Application Analyst

Description: Bronx-Lebanon Hospital is the largest voluntary, not-for-

profit health care system serving the South and Central Bronx, with 970

beds at two major hospital divisions, a major psychiatric facility, two

specialized long term care facilities and an extensive BronxCare Network of

medical practices, including the Dr. Martin Luther King, Jr. Health Center

as well as a 51-unit housing facility for seniors and low income residents.

Working as a Clinical Application Analyst, major roles and responsibilities

include.

Responsibilities:

. Involved in building and configuring reports in AllScripts Application

for clinicians.

. Coordinating interaction between hospital clinical users of computer

applications, the MIS Department and related vendor interaction.

. Worked with different users in identifying the core measures for ARRA.

. Managing reporting team, assigning end user reporting request to analysts

after documenting the functional Specifications.

. Implements, upgrades and supports application systems.

. Assures that all systems are fully tested before implementation into

production. Troubleshoots and resolves reported system and application

problems in the test and production environments using an issue tracking

system (BMC Remedy) and managing a ticket queue.

. Involved in work flow analysis and proposed necessary changes to

facilitate daily hospital operations.

. Developed SSIS (SQL server Integration services) packages to extract,

transform and load from OLTP (Online Transaction Processing) for

reporting data to New state/city DOH(department of health) for ECLRS

((Electronic Clinical Laboratory Reporting System).

. Trouble shooting issues in production for reports/printing.

. Implemented proper workflow to handle unplanned down time.

. Recently handled complete upgrade of Dentrix from version 3.7 to 6.0.

. On call 24/7 365 days for Dentrix, Dolphin, Dexis imaging and Emodel

applications.

Environment: MS SQL Server 2005/2008, SQL * LOADER, SSIS, SSRS, Windows

2003/2000, Windows Server 2003, AllScripts Sunrise Clinical Manager 5.5/5.5

SP1,Dentrix Enterprise 3.7/6.0, Dolphin 10.5, Emodel 8.0.

Goodyear Tire & Rubber Co., Akron, OH

(Sep 2010 - Dec 2011)

Position: System Analyst

Description: Working on Goodyear's core system, Universal Adjustments

System (UAS) which is an OLAP (On-Line Analytical Processing) for

generating various reports to analyze performance of returned tires. All

Goodyear regions submit data and utilize the UAS's analysis capabilities.

The UAS has one central oracle database. Data from various kinds of sources

are loaded into UAS. Users can request reports for analysis purpose from

UAS and reports are sent in the form of Excel files.

Responsibilities

. Implemented complex logic for new/existing reports types from scratch

using packages, procedures, functions and triggers in the UAS

application

. Developed PL/SQL Cursors to FETCH data from flat files

. Involved in fixing trouble tickets or defects of various pieces of

PL/SQL code as per the requirements of the testing team

. Involved in creating Partitions for various tables as well as

creating/maintaining indexes.

. Wrote PL/SQL scripts for loading data from various sources across regions

. Created Cron jobs for scheduling the execution of the packages.

. Involved in all the phases of SDLC i.e. Software Development Life Cycle

(requirements gathering from business users, design, implementation,

integration and unit testing).

. Used UNIX commands to run Shell Scripts, view logs (results of execution)

and perform error correction

. Worked on complex modules involving transactions across multiple

databases using DBLINK.

. Introduced autonomous transactions to log errors with the help of

Savepoint and Rollback.

. Code review for assigned work

. Performance tuning using Explain Plan and Optimization Hint. Also re-

wrote queries when required to get rid of expensive joins to reduce the

Cost of the query.

. Migrated databases from 9i to10g.

Environment: Oracle 9i/10g, Oracle SQL Developer, SQL*Loader, UNIX.

Veracast communications, San Francisco, CA

(Aug 2009 - July 2010)

Position: System Analyst

Description: Worked on multiple modules of ConferenCenter, Veracast's

Conference Management System. ConferenCenter is a comprehensive suite of

web-based software tools and utilities designed to enhance and manage the

production and delivery of interactive virtual presentations over the

Internet. ConferenCenter is a modular, web-based software application that

is comprised of the ConferModerator and ConferAdministrator.

Responsibilities

. Wrote procedures for implementing business logic in Billing module

. Wrote queries for fetching data into webpages.

. Designed various web pages using JavaScript, HTML.

. Worked on the storage and retrieval of large media files to and from the

database (BLOB data)

. Analyzed and tested systems

. Developed the mechanism for archiving old data and retrieving as required

by the user.

. Created partitions on tables to improve performance

. Involved in defining application level accessibility to users based on

designation.

. Used Visual Source Safe to maintaining all the source codes with version,

documents and tracker history.

. Designed Use Cases, Class Diagrams, Sequence Diagrams.

. Responsible for maintaining web and database servers.

Environment:

Oracle 9i/10g, Cold Fusion 8.0, Java script, HTML, DHTML,CSS

Satyam Computer Services, Hyderabad, India

(Oct 2006 - June 2009)

Position: Software Developer

Description: Worked on a project for Australian client OPTUS. The project,

OPTUS REITZ REPORTING, dealt with building an Integrated Data warehouse

(IDW) which was to be used for getting the information of all the source

systems, thus facilitating fast retrieval as well as analytical transaction

processing of data.

Responsibilities:

. Analysed specifications provided by clients

. Designed Entity -Relationship diagrams to communicate the business

requirement

. Developed Teradata SQL scripts

. Formulated Test Plan, Test Scripts and Test Cases for Functional,

System, Integration, UAT, and Regression Testing based on the Design

Document and User Requirement Document for the Functional, Security,

and Performance Testing

. Handled Client Communication and Attending regular Conference Calls and

Meetings

. Used Derived, Temporary and Volatile tables in SQL Assistant to perform

various data manipulations

. Tuned and tweaked the scripts to make them optimal

Environment: Teradata V2R5, Teradata SQL Assistant.

Education:

Master of Science in Computer Science GPA: 3.80/4.00

California State University, Hayward, California

Bachelor of Engineering in Computer Engineering GPA:3.70/4.00

Gujarat University, India

Note: References will be provided upon request.

Ready to relocate in United States.

Contact this candidate