We provide IT Staff Augmentation Services!

Sql Administrator | Business Intelligence Developer Resume

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

Hire Now