OBJECTIVE:

To obtain a position as a SQL Database Developer/Software Application Developer where my strong analytical, innovative, excellent problem solving, database, SSIS development, data analysis and Front/backend development skills can be best utilized.

SUMMARY:

An experienced Database Programmer/Application Developer with MS in computer science with areas of expertise include database designing, creating and implementing database objects like view, functions, stored procedures, Indexes, tables using SQL server/ Oracle, object oriented programming, SSIS/SSRS, database designing and Interactive web application development.

TECHNICAL SKILLS:

Databases: SQL Server 2008/R2/2014/2000(SSRS, SSIS/DTS), MySQL5.5, ETL, SQL profiler, Oracle 10g and Access.

Database Objects: Stored procedures, Tables,Views, Functions,Triggers, schema, Constraints, Indexes, SSIS/PL/SQL packages.

Database/Web Programming languages: T - SQL (sub queries, query tuning and scripts), PL/SQL,ASP.Net, C#/C++, Vb.Net, ADO.Net, PHP5.3, Visual Basic, JSP, jQuery, JavaScript, CSS3, HTML5,Perl(basic) DHTML, Excel, VBA and XML.

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

Database Administration: Installing SQL, Oracle database servers, Database Security Issues, Backup and Scheduling Sql jobs.

Compilers and Editors: Business Intelligence studio 2008,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, Visual Source Safe, Visio 2000 and Photoshop 5.5.

PROFESSIONAL EXPERIENCE:

SQL Server Database Application Developer

Confidential, Greenville, SC

Responsibilities:

• 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 stored procedures to extract right data as a part of data migration project.
• Created stored procedure using Merge statement to do the Insert/Update operation on the target table as a part of migration.
• Created SSIS package(s) to import 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.
• 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.
• Converted all views of NII (Net interest Income) project into stored procedures and rewrote the T-SQL code according to new business requirements to create pool tables using SQL server 2008. Created primary and foreign keys accordingly.
• Answered Business analyst questions regarding NII project i.e. logical questions about SQL queries regarding NII project. Optimized the stored procedures by creating clustered and non-clustered indexes to improve the performance.
• Created a stored procedure using t-sql to track start, end and elapsed time of all the procedures to create a log in log table.
• Created Dimensional and fact tables, created relationship using primary and foreign keys then developed T-Sql stored procedures using Case statements, different date functions and Joins like Inner/outer to populate this Star Schema tables .

Confidential

Independent Consultant, New York, NY

Responsibilities:

• 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 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

Responsibilities:

• Created an Insert -Update stored procedure using T-SQL to process new eBook order(s) OR to update any existing order(s).
• Suggested a name for eBook application as eBook Order Management System they accepted it as eBook Management System.
• Created/implemented ER schema diagram using Toad Data Modeler i.e. added new columns, tables to Order Recon Database.
• Particpated 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 /SSRS Developer/Software Engineer

Confidential, Charlottesville, VA

Responsibilities:

• 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. Created, designed and added new reports using SSRS 2008 and SQL server 2008.
• 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 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.

PHP/MySQL Developer

Confidential, New York, NY

Responsibilities:

• 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

Confidential, Melville, NY

Responsibilities:

• Exported heating equipment data from excel sheet to using SQL 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 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.
• 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

Responsibilities:

• 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.

Senior l evel ASP. Net/SQL Developer

Confidential, Westbury, NY

Responsibilities:

• Implemented different SQL server stored procedures by adding new module, according to account type to create a Cash Flow Analysis report in Excel, created new data pump tasks in DTS package to handle details for new accounts in Excel sheets.
• Implemented an ASP.Net application using Visual Studio.Net, VB.Net, SQL Server 2000,purpose of this project was to get data from text file and exporting to SQL database table, uploading it to DB2 temp table, finding matching account number on basis of taxid, first and last name displaying on browser using datagrids and exporting matched records to excel sheets.
• Created SQL scripts to move the code from development to production server, created Systems diagrams/docs using MS Visio.

Visual Basic/SQL Server Programmer Analyst

Confidential, Virginia Beach, VA

Responsibilities:

• Implemented the Visual Basic 6 application and the stored procedure(s) by analyzing the requirements and imported data from text file to database tables in SQL Server 2000 using DTS packages and Visual Basic Application. Performed code review on ther programmer’s Visual Basic code. Created sequence diagram according to the flow of the program. Created design, technical documents to explain how stored procedure(s) or Visual Basic application was implemented.
• Created advanced T-SQL queries in Query Analyzer to implement stored procedure(s) using inner/outer joins.