Design and Implement reports using SQL Server Reporting Services Provided Database Administration on Production Servers with server configuration, performance tuning and maintenance Write effective documentation and specifications.Responsible for writing stored procedures, triggers and functions in T-SQL.Proficient in SQL Server Replication, Backup/RecoveryPerformed data transformation services and BULK INSERT ETL operations.Designed KPI and Scorecard reports to improve corporate profitability measures and comparative financial analysisMove existing Excel and Access applications into current version of SQL (2016) Performed detailed design and mapping specification creation for translation between Legacy and EDI formats.Acted effectively as point-of-contact on status of EDI transactions from internal and external customers.Designed and implemented all Barcode labels used on production floor

Created a customized SQL Database to track and report commission and trade data.Created ETL process and code that uploaded Daily Trade Data to in-house database every morning and send out morning reports on trade information from prior dayCreate Customized Dashboards and Commissions Reports for monthly reporting processesCreated & Supported C#.Net Application for users to view and print reports on trade information and commission dataProvided Ad-hoc queries as needed.Created SQL Views, Functions and Triggers for databaseCreated database back-end and user front-end for Loading and Tracking Customer Account Information and Documentation.

Worked with a team of programmers to provide technical support to over 200 users of custom business oriented programs created by our team and other technical support personal at Litton.Created Add-On features to custom Access database programs to assist business users in processing of daily functions. Created custom excel worksheets using excel functions and VBA to create custom reports for company.Work with a team of analyst/programmers to create javascript files for parsing information from pdf files and into the proprietary program CATS.Created an Access database program to extract, manipulate and create loan level files for all deals reported on by C-BASS and Litton LoanSet the standard for company-wide documentation on all maintenance and enhancements to current programs with Access DatabasesEntered and maintained work orders in the ClearQuest Software, along with all documentation for each work order assigned.

Create complex sql queries to obtain data from oracle database using Toad for OraclePerformed data entry of deal information into CATS for deals that could not be automated Worked on the help desk with the operations team to provide technical support to users of CDM and CATS programsMonitor MAGIC Service Desk for user issues assigned to my team Work with a team of analyst/programmers to create javascript files for loading deal information into proprietary program CATS.Work with investor accounting at Litton Loan and trustee's to balance loan level data before pushing data to external website for investors.Work with PL/SQL stored procedures to summarized data for deals and push to another table used for storing monthly summary information.Used PL/SQL stored procedures to extract loan level information from database to generate payment files for Bloomberg, Intex, and Loan Performance on all C-Bass issuance deals.Monitor e-mails from our capital markets division to make sure that all data entered in our proprietary program CATS is correct.

Created New Reports for plant using Access 2003Created New Tables for tracking Utility Usage throughout manufacturing plant.Created New Forms for entering utility dataTroubleshoot and resolve database issues related to access modes, access times, device allocation of databases and applications, and validation and organization of the environmentWorked with Network Administrator to resolve user issues regarding database access and access times

Data Mining/Data Migration Consultant through Robert Half TechnologyManipulate, Organize and Extract data from a legacy Cobol Database and prepare to move to SQL 2000 Standard Database with Vantage 8.0 front-endAnalyzed large volumes of data seeking any possible relationships between dataCreated SQL Stored procedures to clean up Vantage TablesCreate SQL Views to be used for accounting reportsDeveloped custom reports, modified existing reports, prepared reports for deployment on the web, and prepared reports that will be sent out in an Excel spreadsheet using Crystal reports 11.Used DTS and SQL Code to manipulate and reorganize data for Vantage Tables.

Provided technical support for maintenance of complex database structures and associated applications, which includes development of databases, performance tuning, backup and recovery, and release of upgrades Troubleshoot and resolve database issues related to access modes, access times, device allocation of databases and applications, and validation and organization of the environmentAssisted functional and technical users with functional and technical testing in all environments Performed tests of application and database processes to ensure processes work accurately and meet technical user requirements. Developed technical documentation on developed processes

Designed & Administered 2005 SQL Server with Access front end to track employees, jobs, job purchases, employee time, accounts receivables and accounts payables transactionsAdministered the Accounting Program Small Business Manager with a 2000 MSDE SQL Server, including user creation, system back-up and network printing configurationDeveloped all financial and time audit reports for Small Business Manager program using Crystal Reports, Visual Basic & ExcelManaged & Trained all office employees on computer software & office proceduresProvided on site troubleshooting and technical support to 20 usersAdministered Accounts Receivables, Accounts Payables, Invoicing, Payroll, Human Resouces & Benefits

Administered the JOBBOSS Software ProgramManaged and trained all office personal; Created Detailed written instruction manuals on how to perform all office tasks Administered Accounts Receivables, Accounts Payables, Invoicing & Payroll