Identified bottlenecks in SQL Server 2012 with over 200 tables Optimized the performance by adding indexes and SQL code improvements by 400%Researched and coded script for data transfer between heterogeneous databasesTransferred 30+ tables with live data from old server to the new one during the data migration for the version upgrade while maintaining the referential integrityResearched Angular code for SQL reports and performed optimizations in SQL code or schema

C# and REST API for payroll data from multiple accounting systems: Ultipro, Kronos Workforce Ready, and MasterTax. I have created an API application that queried Kronos clients' reports and compiled the data into SQL database. Creating of an banking application in C# for the Accounting Department. The resulting ACH (Automated Clearing House) file would be uploaded to the bank for the employees payroll. Maintenance and creation of SSIS packages that created and uploaded 4010 HIPAA medical insurance coverage files to different vendors, and vendor proprietary format Excel and CSV files with payroll deduction for 401K and other benefits, and other ETL activities.Reports as an attachment - I have created a working prototype of an app that looked in Outlook shared mailbox for a specific subject, analyzed the Excel attachment, and imported the data (while checking for duplication) into a SQL database.Developing of proprietary software - I have created an app with the purpose to make fixed-length files, after I was disappointed with SSIS approach. One of the highlights of that app is ability to support a different string structure, e.g. the output string doesn't have to be in the same format, for instance it can be a file header, transaction start record, end record, file footer, etc - all with different formatting requirements, and all in the same file, all defined in a customizable formatting configuration file.

Software Support Engineer / Software DeveloperAs Software and Technical Support Engineer / Software Developer I am responsible for providing technical support and resolving escalated issues concerning software, databases, data, connectivity, and servers for users. When not actively engaged in support, I research and diagnose code bugs and defects, optimize SQL queries, develop new stored procedures and reports. I use SQL, C# and Crystal Reports to produce new reports. My other duties include: Troubleshooting and making improvement to Health Care project in C# , upgrading existing databases and installations to a newer version, researching medical information and medical order history, and a number of other duties, such as writing documentation and troubleshooting guides, backing up / restoring databases, and 1 week of 24/7 support each month.I am able to multitask and work in a fast-paced environment, and can prioritize my tasks.