SUMMARY:

• An experience SQL Server Database Programmer /Application Developer with MS in computer science with areas of expertise include database development, code modification/deployment, strong analytical/problem solving skills, performance tuning, creating database objects like stored procedures, views, tables, constraints, Indexes, functions using SQL Server(linked servers), Oracle, MySQL, SSIS/SSRS development, object oriented programming and Web application development.

TECHNICAL SKILLS:

Databases/ Database Objects: SQL Server 2008/R2/2014(SSIS/DTS,SSAS), MySQL5.5, OLTP,OLAP, ETL, SQL profiler, Oracle 10g, Access, Stored procedures, Tables, Views, Functions,Triggers, schema, Constraints, Indexes and PL/SQL packages.

Database/Web Programming languages: T - SQL (sub queries, CTE, temp tables, SQL Joins), DML,DDL,PL/SQL, C++, ASP.Net/VB/C#, PHP 5.3, Python(intermediate), JSP, JQuery, JavaScript, CSS3, HTML4/5, DHTML, Excel, VBA and XML.

Designing: Logical/Physical databases designing/Normalization, ERD, Data Mapping, Reading data Models, User Interfaces.

Compilers and Editors: Business Intelligence studio 2012,ER/Visual Studio.Net 7.1, TOAD, Eclipse, Visual C++, Editor Vi.

Servers and Operating Systems: IIS 7.0, Configuring Web Servers, CF Server, Tomcat 5.0, Linux(basic), UNIX (Sun Solaris)

Reporting/Designing Tools: SSRS, Crystal Reports 8.0, Toad Data Modeler, VSS, TFS, Visio 2000 and Photoshop 5.5.

PROFESSIONAL EXPERIENCE:

Senior T-SQL Database Developer

Confidential, Deerfield, IL

• Created a script using system tables like sysobjects, sysconstraints,sysindexes and temp tables to get list of associated constraints, indexes on a single table or group of tables, purpose of this script to verify creation of constraint(s), indexes after successful partition of table(s) in the database.
• Created a stored procedure with two input parameters i.e. clientid and userId,used different type of sql joins and temp tables, purpose of this stored procedure to give permission to ordering and servicing providers according to their registered regions Like( east or west coast and etc) by adding into database system so they can recommend treatment/tests/medication to the
• patients according to disease symptoms. Checked in, checked out SQL code in Team foundation server
• Created multiple tables partition using rang type partition on the basis of partition key to retrieve the data faster from table(s)/ to improve the database performance, created re-runnable scripts using IF exists, If not exists, with combination of alter table, add/drop commands to drop and recreate all primary/foreign keys, check constraints, indexes on all the tables in question.

Senior SQL Database Developer 

Confidential, Jersey City - NJ

• Analyzed T-SQL Code to understand the business logic of different stored procedures to make changes accordingly.
• Participated in meeting to understand different banking databases, Installed different software like SQL Server and Remedy.

SQL Server Database Application Developer II

Confidential, Greenville, SC

• Created schemas and migrated database objects i.e. stored procedures, tables by creating scripts from Development Server to a UAT server and made logical changes according to business rules,debugged errors, Used Try Catch construct to trap errors.
• Applied data cleansing/validation rules using Substring(),Right(),Cast() in the where clause as well as different type of Joins like INNER/Left Outer Join for data loading T-SQL stored procedures to extract right data as a part of data Migration project.
• Created T-SQL stored procedure using Merge statement to do the Insert/Update operation on the target table as a part of database migration. Created primary and foreign keys accordingly to create the relationship between multiple tables.
• Converted all SQL views of NII (Net interest Income) project into stored procedures by modifying the existing T-SQL code according to new business requirements to create pool tables using SQL server 2008.
• Created SSIS package(s) using Data Flow, Control Flow to extract data from Excel, CSV files to SQL server, mapped target and source columns and used data conversion control to handle Unicode vs. Non Unicode data type error.
• Discussed business requirements with Business analyst before creating any stored procedure(s), table(s) or function.
• Managed projects successfully according to the deadline and communicated with Business analyst, Senior Manager and etc..
• Developed a procedure using CTE with Row Number() function to delete the duplicates from the source table before inserting into target table as a part of migration project. Answered Business analyst(s) SQL business logic questions regarding NII project.
• Created Dimensional and fact tables, created relationship using primary and foreign keys then developed T-Sql stored procedures using Case statements, different date/cast functions and Joins like Inner/outer to populate this Star Schema tables.
• Optimized slow running T-SQL stored procedures by creating clustered and non-clustered indexes to improve the performance.
• Created a stored procedure using T-Sql to track the start, end and elapsed time of all the procedures to create a log in log table.

Completed Several Database Development and Web projects

Confidential, New York, NY

• Created a rebuild index Task in SSIS package to rebuild indexes by setting fill factor equal to 80% using BI Studio.
• Created an Insert, update and delete triggers to track changes of user’s actions in an audit table i.e. who created the trouble ticket to repair any hardware like printer, fax machine and who updated trouble ticket status.
• Designed screen layouts of a course Registration Web application keeping in view logical flow of application using Html5/css.

Senior level SQL Database Developer 

Confidential, NYC, New York

• Created an Insert -Update T-Sql stored procedure using to process new eBook order(s) OR to update any existing order(s).
• Created/implemented ER schema diagram using Toad Data Modeler i.e. added new columns, tables to Order Recon Database.
• Participated in Design meetings on weekly basis for front end of this eBook project and helped in fixing lots of design issues.
• Created a Complex C# application with visual Studio 2008 using classes like DirectoryInfo, DirectoryPath and methods like GetDirectories,GetParent, purpose of this application was to loop through all folders, sub folders starting from root directory and to move all the files from every .Ingest folder to one level up folder.

SQL Database Developer/Software Engineer

Confidential, Charlottesville, VA

• Designed and developed the reporting website from scratch using Visual Studio 2008,SSRS, SQL Server 2008,sitemap xml file, ASP.Net/ C#, IIS and menu control. Implemented existing drill down reports for equipment main category, subcategories
• and reports with input parameters as block size(i.e. 8, 32 bits and etc) to see equipment information.
• Fine tuned a T-SQL statement in stored procedure by replacing Substr () function with LIKE Operator with wild Card ‘%’. Developed database driven C# application using Visual studio 2008,SQL sever 2008,purpose of this application was to move updated or new Sql script files from source to target folder and then to run these SQL  scripts to perform database manipulation instead of storing and running these scripts from SQL server to keep database  running smoothly.
• Created a T-SQL script using sub-queries, Inner joins to create a new import table from the existing import table by adding, deleting and modifying the existing import table by importing data from WSTR-535,537,544 Excel files to SQL 2008 tables.
• Wrote a stored procedure using While loop, sub-queries, Not Exists to compare the source and target tables if new records have been added to source table those will be added to target table using INSERT Into Select by getting newly inserted records from temp table, if any of records have been changed then target table will be updated using Update statement.
• Created T-sql scalar function, purpose of this function was to find the special character & to replace it from the equipment name
• and then to limit the equipment name to 24 characters if it’s less than 24 characters then return the name of the equipment.
• Created an XML document using C# by using XmlWriter class as well as using WriteStartElement,WriteEndElement methods.
• Designed database schema diagram using ER Studio by Importing Create-table T-Sql scripts from Sql Server to ER studio.
• Created SSIS package(s) by mapping data using BI Studio to load data from excel files to SQL table to perform data analysis.
• 08/2009 - 05/2010 PHP/MySQL Developer - Developed number of Database driven projects using PHP5, MySQL. New York,NY.
• Designed and developed database driven User Interface using HTML5, CSS, PHP5 to handle activities of Radiology department patients like adding new patients, searching existing patients, created JavaScript function to validate zip code and etc.
• Created a history table to track patient status of treatment (i.e. pending, x-ray room) and to display information on web in PHP.
• Designed and developed database driven web interface using html5, CSS, php5 to generate status reports of different patients.

T-SQL/PL/SQL Database /ASP/JSP Application Support Developer III

Confidential, Melville, NY

• Exported heating equipment data from excel sheet using DTS packages and vice versa by mapping the data to keep prices of these equipments up-to-date, fixed any data errors after the analysis for successful data export to SQL server tables.
• Gathered project requirements from Senior Project Managers before designing and developing any application via phone.
• Solved outstanding data loading issue by removing duplicate declaration of variables from the data loading stored procedure. Created a new complex T-SQL stored procedure called Cus NewSalesOp using different data conversation functions like Cast() and date() according to logical business rules flow diagram to pass some out put values (i.e.incidenttypeid, assignedTo and etc) to main stored procedure to create new sales opportunity. Purpose of this stored procedure was to retrieve record on basis of Bar Code value from the interface of ASP bar code application.
• Created an extract by creating complex T-SQL query from five tables by using multiple Inner Joins and temp tables, purpose of this extract was to get active NYC, LI VPIs with their address whose preferred method of appointment was either fax or email.
• Created two PL/SQL stored procedures to support JSP web application this application will give ability to an investigator(s) to update any wrongly created work order of any damage caused by any another party to the company’s property.
• Provided technical support to users of JSP based Damage Tracking System application on phone to solve their problems either by implementing a part of JSP page using Eclipse or deleting some wrong work order numbers by running a PL/SQL delete script for different tables in Toad.
• Developed and designed a database driven web report called No Call Damage report using JSP and by creating PL/SQL function, this report will display Excavator name, address, methods of excavation and root causes of the damage and created a JavaScript function to disable couple of fields like region, type of claim, collection status, damage town for this report.

SQL Server Database / Cold Fusion Application Developer

Confidential, Melville, NY

• Created SQL Server stored procedures, views, functions using T-SQL and made calls to these stored procedures in Cold Fusion to create Returned leads report, this report will show the LenderID, lender Name, associated states, how many leads were returned and reason for returning the leads with associated sales person.
• Created Lender demographics report, purpose of this report to show different Salesperson names with associated lenders with assigned areas like state and counties, how many leads were sold with purchase amount and application fee and at the end it will show the subtotal and then the total revenue generated for all the lenders. Used HTML,CSS and JavaScript for front end.
• Developed and designed Preferred Partners (i.e. Appraiser, Inspector and Title) Analysis Report by creating stored procedures from multiple tables, purpose of this report was to show partner’s name, ID, startDate, ExpirationDate, Total Revenue and counties subscribed with associated Account Executive.