TECHNICAL SKILLS

• Designing, Programming, and Administering MS SQL Databases
• Created and Supported customized Business application in C#
• Developed Reporting Solutions using SSRS, Excel, VBA.
• Microsoft Office product suite, Crystal Reports, FRx, Cognos, MS Access
• VBA, VB, VB Script, XML, C#, HTML

PROFESSIONAL EXPERIENCE

Confidential

SQL Administrator | Business Intelligence Developer

Responsibilities:

• 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/Recovery
• Performed data transformation services and BULK INSERT ETL operations.
• Designed SSRS Reporting site to create KPIs and Scorecards to improve corporate profitability measures and comparative financial analysis
• Move 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

Confidential

Database Analyst

Responsibilities:

• Design and Architect data models to house different sets of data from vendor feeds and various systems
• Set-up and Support SQL Agent Jobs for ETL Transactions
• Design and Develop database schemas
• Designed, developed, implemented and troubleshoot customized dashboards and reports
• Create and Maintain documentation on database systems
• Troubleshooting and Performance Tuning of SQL views and queries
• Designed, Developed and Supported C#.Net Application for users to view and print reports on trade information and commission data
• Provided Ad-hoc queries as needed.
• Design and Develop SQL Views, Functions and Triggers for database
• Administer SQL Server

Confidential

Access Programmer

Responsibilities:

• Worked with Confidential team of programmers to provide technical support to over 200 users of custom business oriented programs created by our team and other technical support personnel 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 Confidential 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 Confidential and Litton Loan
• Set the standard for company-wide documentation on all maintenance and enhancements to current programs with Access Databases
• Entered and maintained work orders in the ClearQuest Software, along with all documentation for each work order assigned.

Confidential

Operations Analyst

Responsibilities:

• Create complex sql queries to obtain data from oracle database using Toad for Oracle
• Performed 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 programs
• Monitor MAGIC Service Desk for user issues assigned to my team
• Work with Confidential 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 SQL stored procedures to summarized data for deals and push to another table used for storing monthly summary information.
• Used SQL stored procedures to extract loan level information from database to generate payment files for Bloomberg, Intex, and Loan Performance on all Confidential issuance deals.
• Monitor e-mails from our capital markets division to make sure that all data entered in our proprietary program CATS is correct.

Confidential

Database Programmer

Responsibilities:

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

Confidential

Data Mining/Data Migration

Responsibilities:

• Manipulate, Organize and Extract data from Confidential legacy Cobol Database and prepare to move to SQL 2000 Standard Database with Vantage 8.0 front-end
• Analyzed large volumes of data seeking any possible relationships between data
• Created SQL Stored procedures to clean up Vantage Tables
• Create SQL Views to be used for accounting reports
• Developed 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.

Confidential

Database Programmer

Responsibilities:

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