PROFESSIONAL EXPERIENCE

Database Developer

Confidential, Alpharetta, GA

Responsibilities:

• Developed SSIS packages designed to port historical data from Oracle to SQL Server 2014.
• Also responsible for writing all validation queries for source and target databases to be used by QA team.
• Optimized several SSIS packages, creating significant time savings.
• Worked in an approximately 10 person group using Agile methodology and MS TFS for version control.
• Completed reporting project for Account Management team using SSRS.

Senior Database Developer

Confidential, Atlanta,Ga

Responsibilities:

• Data analysis, design, and ETL implementation for Business Intelligence analytics in teh health care industry utilizing teh Microsoft BI stack, SSIS, SSRS, T - SQL, and SQL Server.
• Developed a variety of well-designed reports for teh Account Management team.
• Managed 3 to 4 person team in India, facilitating teh completion of customizations to teh data flows of various Hospitals.
• Wrote ETL process automation for Analytics, a health care revenue cycle business intelligence tool targeted at large health systems.
• Wrote processes/procedures to transform data from multiple practice management software vendors into data warehousing databases for BI tool to consume.
• Worked with clients to customize how metrics such as RVUs, ChargeLag, and Primary Denials would be measured as their were instances where our analytics product did not match teh definition of those metrics preferred by various clients.
• Acted as Data interpreter/Data analyst for clients who would frequently be unaware of wat could be measured by their data.
• Developed a thorough understanding of teh revenue management cycle within a Healthcare setting.

Database Developer

Confidential, Atlanta,Ga

Responsibilities:

• Assembled data from five different media types (TV, Radio, Online Search, Print, and OOH) into one integrated report for nationwide client.
• Created and implemented SSIS packages to transform all necessary Excel files into SQL Server tables.
• Created a suite of reports for client spanning all Media types with ability to view data by a variety of time frames.
• Acted as Analyst to ascertain all business rules from various channels within BKV in order to properly document teh reporting system being built.

Marketing Director/Senior Database Administrator

Confidential, Atlanta, Ga

Responsibilities:

• Developed and implemented marketing plan from teh ground up for a startup company in teh Managed Care Recovery Industry.
• Wrote all verbiage used on company website and marketing materials.
• Served as primary contact for all prospective clients. Arranged and organized sales meetings with Hospitals’ financial representatives in order to present our services in an attempt to sign clients. Also led all sales presentations.
• Signed 13 hospitals as clients in states including Florida and Arizona.
• Implemented and administered SQL Server 2008 to serve as company’s database solution.

Senior Database Developer

Confidential, Mexico Beach, Fl

Responsibilities:

• Installed, configured and implemented SQL Server Integration Services. Created over 20 scalable packages to parse applicable information from over 50 hospital data downloads. SSIS packages were used to extract, transform and load teh data into our systems. Implementation saved manual process time and increased performance.
• Lead contact person for most major clients IT staff to insure all data was transferred correctly and completely.
• Served as Reporting Administrator. Using SQL Server Reporting Services, created all reports used by Finance Dept. Also designed all client reports and created subscriptions used to deliver those reports to clients on a pre-established basis.
• Information disbursement for various departmental data needs through SQL templates and ad-hoc reporting.
• Administered SQL Server 2005 databases to ensure maximum up time, responsible for tasks such as nightly backups, monthly maintenance, system optimization as well as troubleshooting all current processes when a bottleneck or performance hit was reported.

DBA/Senior Reporting Analyst

Confidential, Port St. Lucie, Fl

Responsibilities:

• Large mail order business shipping medications and supplies to over 1 million repeat customers. Responsible for teh management of a large OLTP database system running MSSQL 2000 and 2005 that provided data for real time order entry applications designed to create, process, and ship customer orders. Other responsibilities included teh creation and support of data processes passing data between teh companies billing system running. AS400 and SQL server databases.
• Extensive noledge of SQL jobs, DTS transformations from multiple platforms, stored procedures, user defined functions.
• Replication of teh OLTP databases to create a separate reporting environment. Converted DTS packages to SSIS for upgrades to SQL Server 2005.
• Redesign of Customer Information System for call center support using Visual Basic 6.0. Application integrated with Genesys Call Center platform and was used to create outbound campaigns, process and ship orders to customers. Project involved architecture of current system in Microsoft Visio, designing Business Object Layer and front end applications. And implementing new system without disruption to call center support. Redesign improved application performance enabling call center to handle more call volume.
• Conversions of multiple applications from VB 6.0 and Access to VB.Net.
• Developed application that handles diabetic kit testing process through mail using VB.NET and SQL Server 2005. Tracked kits from warehouse to patient to laboratory. Bar code scanning technology used for maximized processing.
• On call duties to provide 24x7 DBA support.

Software Customization Developer

Confidential, Charleston, SC

Responsibilities:

• Customized and added functionality to Blackbaud Fundraising software in order to meet individual client needs.
• Worked closely with client contacts to develop specifications for customization solutions that best meet client needs.
• Worked with non-profit organizations including Red Cross, Unicef, Charleston Aquarium, as well as several Universities and Hospitals.

Software Developer

Confidential, New York, NY

Responsibilities:

• Designed and developed client server application for investment tracking and contact management using Visual Basic 6.0 and SQL Server 7.0. Project involved meeting with users, writing technical specification documentation, and designing application. Duties also included managing bug and feature requests using Change Management software.
• Created Institutional Workstation for teh tracking of Salesmen clients for stock market Holdings and Interests as well as keeping track of Conferencing, Products, Research and Entitlements.
• Construct, design and implementation of objects for enhancement of application
• Developed wrapper for use of Crystal Reports 8.0 in application and created a majority of teh reports for application.
• Analyze database tables, stored procedures and triggers.
• Created DLLs and OCX controls to easily maintain application interface and reuse existing functionality.
• Manage all source code for department using Visual Source Safe 6.0.

TECHNICAL SKILLS

• Completed intensive program consisting of 780 hours (13 weeks) of programming in Visual Basic 6.0, SQL Server 6.5 and Visual InterDev 6.0.
• Visual Basic Skills Set: Active X Controls, Active X Documents, Active X Components, Windows API, DAO, RDO, ADO, ODBC API, COM, DCOM, and MTS.
• SQL Server Skills Set: ANSI SQL, Transact-SQL Queries, Indexes and Views Transactions, Batches, Cursors, Stored Procedures, Triggers and Replication.
• Internet Development using Microsoft Active X Technology.
• Web Site Development Using Visual InterDev: HTML, DHTML, ASP, VB Script and Java Script.