SUMMARY:

IT professional with 5+ years of experience utilizing Microsoft database technologies to generate reports, create integration packages, provide database administration and ETL solutions. Proven ability to support field implementation specialist by providing technical solutions, system analysis and problem resolution. I have experience in the transportation, logistics, and petroleum distribution industries.

TECHNICAL COMPETENCIES:

Database Skills: MS SQL Server versions 2000 - 2012, Stored Procedures, SQL Queries, Data Transformation Services (DTS), MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Data Archiving, Maintenance Plans, Database Backups, Database Restore, Package Deployment, Table Design, Update Scripts, Query Analysis Tuning, Triggers, Data Modeling, Database Documentation, SQL Server Installation.

Software Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio, TFS, APEX SQL Documenter, Red Hat SQL Compare, MS Office, Ultra Edit

Development Methodologies: Agile development methodology, Joint Application Design/Development (JAD), Rapid Application Development (RAD)

PROFESSIONAL EXPERIENCE:

SQL Server Developer/Administrator

Confidential, Fort Mill, SC

Responsibilities:

• Developed 15 parametrized summary and detail reports including pie charts and sub reports for a new client in accordance with specifications provided. Report types included drilled down, click through, and linked reports. Worked closely with the client to verify the results, resolve issues and make changes as requested.
• Converted 20 VB6 reports to parametrized SSRS reports. Analyzed the results of the VB6 reports for accuracy before the conversion and worked with the business to fix any issues. All reports used stored procedures to access the data needed to develop the reports.
• Designed and developed SSIS packages for loading data from previous database schema versions into current schema versions.
• Converted extracted data as needed and created new data to ensure integrity.
• Loaded excel, text, SQL Server and other source data provided from clients utilizing SQL, DTS and SSIS into SQL Server databases.
• Applied data conversions using lookup, merge join, aggregation, derived columns and script tasks.
• Verified data accuracy, data completeness, data integrity and application functionality.
• Developed SSIS packages to extract completed sales order information for export to client applications.
• Created a scheduled SSIS package to integrate client’s customer and configuration data into a SQL Server operational database.
• Provided database administration including modifying the database structure from information given by application developers by creating change scripts to modify or add tables, columns, keys, triggers, stored procedures and views. Created scheduled database backup and maintenance plans.
• Created and maintained data archive processes utilizing store procedures and job scheduler. Create and maintain database security levels.
• Developed SQL queries to extract data from table(s) to be used for analysis, testing and decision making. Used SQL profiler to analyze SQL queries.
• Provided technical support and analysis to field implementation specialists during client implementations and system upgrades.

Global Confidential Support Manager

Confidential, Charlotte, NC

Responsibilities:

• Initiated the creation of a Global Confidential support center.
• This included establishing the initial staffing, work flow processes, issue tracking, and global escalation procedures.
• Prioritized support activities, reported project status, deliverables, and issues to the business stakeholders.
• Solicited customer feedback relative to satisfaction issues with support effectiveness.
• Identified opportunities for system enhancements and process improvements.
• Eliminated redundant batch processing which significantly reduced the cost of system processing.
• Monitored key performance indicators of technical staff and administered performance appraisals based on mutually agreed upon goals and quality standards.

Project Manager/Team Lead/Developer

Confidential, Charlotte, NC, Elizabeth, NJ

Responsibilities:

• Managed application support and development for several operational systems including; Equipment Tracking, Equipment Pool Utilization and Equipment Lease Administration. Total staff of 6 local analysts and 8 analysts working off site.
• Managed the development of an Confidential solution that integrated proprietary data with a partners supply chain management system. Evaluated and selected the Confidential transformation tool. Managed the development of an Confidential message tracking application and the development of ANSI and X12 maps. Worked closely with the partner to develop design specifications, system changes, test cases, impact analysis and data flows.
• Installed desk top shipment tracking software at client locations. This included installing the software, verifying application functionality, trouble shooting issues, answering client inquires and providing training.
• Developed and supported mainframe applications for multiple business applications including: Equipment Tracking, Equipment Pool Utilization, Terminal Reporting, Financials, and Sales and Marketing.

Utilized the following technical skills: COBOL, CICS, DB2, VSAM, Intertest, JCL and Case Tools.