Senior Database Developer and Analyst

NISHIT SHAH

*** ****** **, ******* *******, PA **425 C: (484) - 753 - 4583 ac0ms6@r.postjobfree.com

Career Overview

Proficient software and senior database developer with extensive technology and business analysis experience in Advertising, Finance, Health care and IT industry.

Adept at adapting work pace to evolving client deadlines.

Around 10 years of experience in Database development, analytics reporting, large data sets, Security Control Measures, Technical Problem Solving and support.

Designed prototypes and Proof of Concepts with limited specifications which were later implement for business improvement and cost effective solutions.

Extensive experience in Enterprise Intelligence & Data Analytics

Implemented wide variety of cost effective and business boosting reporting and analytics solutions using SQL, SSRS, Tableau and Excel 2013.

Extensive experience of development using Embedded SQL, MS SQL Server, Reporting Services (SSRS), Integration Services (SSIS) and other technologies.

Experience in Performance Tuning & Query Optimization using SQL Profiler, Dynamic Management Views (DMVs) and Execution Plan.

Experience working in Agile environment.

Experience working with Business Intelligence project using Netezza and MicroStrategy

Also have some exposure to working with big data utilizing Hadoop Ecosystem (Hive).

Dedicated team player, willing to go above and beyond to meet deadlines and satisfy customer requirements and proven ability to implement solutions that decrease costs, increase performance and positively affect the bottom line.

Excellent communication and organizational skills.

Qualifications

Accomplishments

Requirements Analysis

Helped during business requirements analysis including the evaluation of systems specifications for new reporting solution and data warehouse architecture ahead of deadline.

Leadership

Served as leader of analytics reporting solution for major clients and agencies.

Quality Assurance

Streamlined QA process to increase efficiency and delivery for Analytics Reporting.

Operational Management

Developed, coded, tested, debugged and documented Custom Reporting solutions using SQL/ Embedded SQL and Excel Analytics.

Technical Training

Actively mentored, trained and supervised new hire database developers with domain and technical knowledge sharing.

Education and Training

Masters of Science: Computer Science 2006

New Jersey Ins. Of Technology Newark, New Jersey, United States of America

Bachelors of Engineering: Information Technology 2003

Shivaji University Kolhapur, Maharashtra, India

Work Experience

Senior Database Developer 09/2016 till Date

DaVita Kidney Care Malvern, PA

DaVita Kidney Care is a leading provider of kidney care in the United States, delivering dialysis services to patients with chronic kidney failure and end stage renal disease. With this the company has huge databases and applications for collecting this data which then also needs to be available to the clinics for the purpose of diagnosis, treatment, billing and analysis.

Coded new SQL Server stored procedures in Agile environment that extracted, transformed and loaded dialysis data from clinics to IT headquarters for processing and also making it available thru applications for further access.

Optimized existing stored procedures and code for optimum data processing time, quick access time thru applications to the clinics.

Assisting QA team for testing the deployment scripts and making sure they meet the standards and expected run times.

Documenting existing but unknown areas which helped team further for gap analysis and process improvement.

Creating deployment scripts for the database objects using Microsoft Team Foundation Server and Schema Compiler.

Analysis of existing C# services and documenting them for moving to new server environment.

Designing and coding new C# services for data movement requests.

Environment: MS SQL Server 2008/2014, Oracle SQL Developer, TSQL, Embedded SQL, C#, Microsoft Visual Studio 2013, Team Foundation Server, Visio 2013, JIRA.

Senior Database Developer and Analyst 09/2008 to 08/2016

POINTROLL Inc King Of Prussia, PA

Online Data Collection, Management and Reporting Analytics It is next generation rich media ad creation,

delivery and measurement tool. It combines all creative tools, media tools and ad serving functionality into a

single, powerful interface that allows total access to all aspects of the advertisements. Offers the end users

unprecedented flexibility to quickly and accurately design online campaigns, managing them from start to finish

and providing reporting and analysis from a single location.

Worked in Scalable Agile Framework environment towards building software incrementally with fast learning

cycles with best quality and value to client deliverables.

Developing adhoc and scheduled reports for internal and external clients.

Creating analytics reports using T-SQL / SQL Server 2008 Reporting Services (SSRS).

Designed prototypes and Proof of Concepts with limited specifications which were later implement for business improvement.

Applied version control to databases using Git and Subversion.

Supporting existing reporting tool, database and also enhancing its capabilities, features and metrics.

Creating, modifying and maintaining ETL processes using Embedded SQL, T-SQL and SSIS for 24/7 raw data processing, aggregating at different

levels of hierarchy and reporting as per the client requirements and performance goals.

Fixing job failures due to system failures / data issues / other causes of the 24/7 ETL processing support.

Knowledge sharing and helping new hires to get them up-to-speed with cross department training related to

database management team.

Created reporting data feeds using VB scripts and asp pages

Also worked on business intelligence project using IBM Netezza and MicroStrategy.

Data Center Move where worked on scripting out database objects to export them into another environment,

reporting services installation and configuration, documenting and setting up new server environment variables,

database backups and restore.

Researching data discrepancies and implementing the resolutions or the changes required.

Tying in data from complex SQL Server stored procedures and macros while creating the pivot tables tied to new source data.

Also includes but not restricted to database schema design, SQL programming, code debugging, 24x7

production support, testing and code review.

Continuous interaction and discussion with different individuals among various departments in the company in

case of red flags and the discrepancies issues, to get to the bottom of the issue and resolving it without affecting

the bottom line client users.

Documentation of data processing steps, reporting analysis, failure causes and resolutions which will be useful

to the developers.

Environment: MS SQL Server 2005/ 2008/2012, TSQL, Embedded SQL, VB Script, SSRS, MS Excel 2007/ 2013, ASP, JIRA, Rally.

Programmer Analyst 01/2007 to 08/2008

PERI Software Solutions Inc Newark, NJ

Advertisement Data and Investment Management: It is the powerful information tool that helps user see the complete media picture through 24/7. It provides comprehensive advertising information on 2.2 million brands across 19 media. It is a vital resource for advertising professional, media specialists and marketers. It is the gold standard for timely, relevant and actionable advertising information; delivering answers to the important media questions related to data and investments, capitals that impact your business.

Adding some new features to WBI Products with user friendly approach, enhancing new reporting capabilities/

visualization, reducing redundancy of data and many such other features.

Supported 24/7 to nightly and weekend maintenance processes to make sure the applications are getting

up-to-date data without and errors and interruption.

Also altered databases and modified scripts during production support issues.

Prepared Data Flows, Process Flows documentation for nightly and weekend maintenance.

Also prepared documentation for the data flow during data loads for different media.

Also did some of manual loads for magazine ratings data.

Flat files to databases ASE and IQ.

Also did unit testing for different modules.

Also prepared documentation for the testing environment and the processes to be run against testing environment for database migration.

Environment: C, Kornshell, Sybase, MS SQL Server, TSQL, Perl, SUN OS, Apache Web Server.

Programmer Analyst Trainee 07/2006 to 12/2006

PERI Software Solutions Inc Newark, NJ

Project Employee Record Management: This is an employee record management system to handle the

employees' record for various purposes in the company. The recipient systems and users include system

administration, security and facility management applications and personal. It has modules to maintain employee and build databases on employee required info and export to various other applications. It has reporting module for basic and advanced reporting.

Wrote the Perl code distributing data exports generated by application to recipients.

Used VB for front end forms and reports.

Used Sybase connection from VB for data retrieval and updates.

Created many Stored Procedures in Sybase and used from VB.

Worked in data export module using VB and Sybase.

Created many data outputs including PDF and Excel.

Developed different functions in Perl for data export, distributing and logging.

Worked as a developer to create various modules of the application.

Supported VB programmers with TSQL queries and Stored Procedures.

Worked in Stored Procedures related to asset creation, modify, delete etc., and created various reports which are supported by Stored Procedures.

Environment: TSQL, VB 6, Perl, DBI/DBD, SendMail, Odbc, Sybase 11.5.1, Solaris 2.4, Windows NT/2K.

Software Engineer 12/2003 to 12/2004

Disha Technologies Pune, Maharashtra

Insurance Quote Generation System: This system is mainly is designed for employees of small businesses. The insurance brokers gather the insurances needed for the employees of the small business and they are entered to the application. The system generates various benefit package and price quotes after going through the validation entered to the system by the brokers. The price quote is web-based, but could be reformatted to word and sent to the small business owner with the different insurance reports they could provide to their employees.

Wrote many Perl/CGI modules for upload, download and presentation of the documents.

Wrote TSQL queries for document information look up.

Designed and developed many Stored Procedures.

Modified front end pages using HTML.

Worked in document search module using PERL/TSQL.

Did unit and system level testing.

Created web pages using Html and JavaScript.

Used DBI/DBD modules for connectivity.

Environment: Perl, CGI, DBI/DBD, Html, JavaScript, Sybase 11.x, HP UNIX, Apache Web Server Company.

Software Engineer 06/2003 to 12/2003

Disha Technologies Pune, Maharashtra

Equity Post Trade Compliance System: This application supports legal advisory group in the firm. The business

users set up the compliance rules, which are applied on the holdings of funds. This helps to supervise the legal proposition as back and front - end tool. The system uses the security and positions data from various vendors.

Worked extensively in the back end Sybase database.

Created many Tables, Stored Procedures and Triggers on Sybase server.

Worked in performance tuning on Sybase using de-normalization techniques.

Developed Perl/CGI scripts for various user interfaces.

Created many search result pages using PERL, CGI, Sybase, and JavaScript.

Developed mail alert mechanism for alerting the users when their selection criteria are met.

This is developed using PERL, Sybase and Stored procedures.

Used Perl DBI/DBD connection for Sybase.

Developed many PERL modules and packages, Enhanced existing PERL scripts.

Created many new functionality for report distribution module and user/client update module.

Participated in Quality analysis and testing

Environment: Perl, CGI, DBI/DBD, Html, JavaScript, Sybase 12.5, HP UNIX, Apache Web Server.

Skills

Databases: MS SQL Server (2000, 2005, 2008 and 2012), Sybase, Oracle 8, MS Access, IBM Netezza, No SQL, Hadoop, Teradata

Languages: C, C++, TSQL, Kornshell, Perl, Java, C#, HTML, Visual Basic, .NET

Microsoft Technologies: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Office Excel Services, MS FrontPage

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, DBI, Crontab, ODBC, Subversion, Visual

Source Safe, Erwin, SQL Advantage, Reflection Unix Client(XDMCP Broadcast mode), E_Term32 Unix Client, Sybase

Central (Java Edition), Numara FootPrints(Issues and error tracking), MicroStrategy, Rally, JIRA

Operating Systems: Windows 95, 98, 2000, 2003, XP, Windows 7, Linux, HP UNIX, Sun Solaris

Contact this candidate