SUMMARY:

• Database Developer with experience working in all types of software development environments.
• Database experience - SQL Server, Access, Oracle
• Data modeling and design experience

TECHNICAL SKILLS:

• SQL Server, Stored Procedures, SSIS, SSRS, Access, Oracle
• C#,VB.net
• Software tools: Visual Studio, TFS, Visio, SSIS, SSRS, SQL Server Management Studio

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, Fl

Database Developer

Environment: SQL Server 2008/2012, SSIS, SSRS, TSQL, TFS, Visual Studio 2015

Responsibilities:

• Database developer for major systems and their subsystems. SQL Server resource to development staff in all phases of development and implementation.
• Updated BRD and Functional requirements for federally mandated 871 regulations.
• Designed, wrote and implemented SSRS reports for Reg871 project. Interfaced with business community to gather reporting requirements.
• Created and modified SSIS packages as part of the ETL process for staging and transforming transaction, position and account data.
• The ETL process read Accounts, Transactions and Positions from daily files into a SQL Server database. The incoming data was validated and various control tables, processing queues, archive tables and extraction logs were updated when jobs completed or produced errors.
• Wrote several stored procedures to move and transform the data using several processing queues and tables. The procedures updated control tables that could be used to retransmit data.
• Developed a process to reconcile transmitted trades with current account positions.
• Coded, tested, implemented, documented and provided on-going support for applications.
• Optimized queries and stored procedures.
• Created indices for large tables in Custody database that greatly improved performance.
• Knowledge of Securities and Fixed Income derivatives. Understanding of work flow for calculating dividend equivalent amounts for warrants, structured notes and fixed income derivatives.
• Updated stored procedures for Microsoft 110 compatibility.

Confidential, Tampa,Fl

DBA, Business Intelligence Analyst and Developer

Environment: SQL Server, TSQL, SSIS, SSRS

Responsibilities:

• Created an ETL Solution that read Product, Vendor and Order Data from .csv files on a network share into a SQL Server database. Solution validated incoming data and performed notifications when jobs completed or produced errors, which were subsequently written to history and error files. The order data was loaded into SQL Server and used to generate reports. Scheduled and executed SSIS Packages for above mentioned clients using SQL Server Agent.
• Created Conceptual, Logical and Physical database models based on formal and informal meetings with business analysts, quality assurance and other stakeholders.
• Generated parameterized reports, snapshot, drill through and linked reports for above mentioned stakeholders using SSRS.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Created stored procedures and triggers to implement business logic.
• Created functions and views used in the process of displaying data to the business community.

Confidential, Tampa,Fl

DBA,Database Developer

Environment: SQL Server, SSIS, SSRS, TSQL, C#

Responsibilities:

• Maintained clinical integration application.
• Followed Agile methodology with daily scrums. Involved in sprint planning meetings with Scrum master, PM, developers and test team. Sprints were 2-4 weeks long. Tracked functional spec, development and test items in TFS.
• Added third party payers to database driven application based on business rules for payers. Updated patient/clinician lookup, patient, case and medication tables as part of cost containment, uncovering fraud and ensuring patient health.
• Wrote SSIS packages and SSRS reports to track health insurance claims.
• Created Stored Procedures, User Defined functions, & Triggers to update tables and perform validation when third party payers were added to the database.
• Creation of complex database queries, & indices.
• Designed, developed, deployed, and supported inbound and outbound data transformation solutions using SSIS Packages, SSRS Reports and SQL Server Agent jobs.
• Created backup and restore jobs as part of the production implementation as well as during production support.

Confidential, Oldsmar, FL

Application DBA/Developer

Environment: SQL Server, SSIS, SSRS, TSQL

Responsibilities:

• Involved in reverse engineering Confidential in Review and Global Model applications. Intimate knowledge of data model, data access and business layers for related projects.
• Worked on production support issues and bug fixes for stored procedures and reports. Involved understanding how several applications interfaced with each other and how they impacted external systems.
• Migrated data from legacy system to Confidential in Review platform. Scheduled master and on demand data loads to synchronize data with legacy system using SQL server agent jobs, SSIS packages and SQL scripts.
• Wrote stored procedures to improve application performance.

Confidential, Tampa, Fl

Application DBA/Database developer

Environment: Sql Server, Data Modeling, TSQL, C#

Responsibilities:

• Designed and developed Data Model for new Returns application.
• Application determined and identified medication to be destroyed and allowed reverse destruction for certain reasons. Return and destruction logic was built into the same interface.
• Added prompts to allow user to dynamically reconfigure cost threshold for each RX to determine if it was cost effective to return medication and to allow user to specify if a drug was a partial return if it could not be determined automatically.
• Created customized SSRS reports by Resident, Facility and Pharmacy for Returns project.

Confidential, Tampa, Fl.

System Architect/Team Lead/Senior Application Developer

Environment: SSIS,SSRS,SQL Server, TSQL, Visio, C#, Javascript

Responsibilities:

• Created customer complaint database of residential and commercial properties to be accessed by web application by customer service when customers called in to file a complaint. Pulled data from other SQL Server database.
• Created Revenue database to as part of an overall company desktop optimization effort. Data loaded from excel spreadsheet, mainframe, Access and other SQL Server database.
• Interfaced with business contacts in Billing and Payment services department to gather requirement for revenue recap project.
• Added ability to reconcile revenue on a daily basis instead of having to wait until month end to reconcile out of balance conditions. Rolled up Monthly data on a daily basis.
• Developed SSIS packages to download historical data and merge with daily revenue data. Created SSIS packages to download various residential and commercial adjustment transactions to be used by billing services as part of the revenue balancing process.
• Created central location for revenue reporting and added new reports to aid in year end balancing.

Confidential, St. Pete, FL

Application DBA/Developer

Environment: Sql Server, Stored Procedures, TSQL

Responsibilities:

• Worked with QA and Product Manager to gather Requirements for Medlocker Project
• Modified and Created Triggers and Stored procedures
• Wrote SQL scripts for fixes to be sent to customers
• Store Manufacturer PO Number, Part Number (UPC), serial number and tracking number as part of EDI XML document
• Save data to XML file to be parsed and passed as parameters to stored procedure

Confidential, Tampa, Fl

Application DBA, Application Developer, Team Lead

Environment: Sql Server, Stored Procedures, SSIS, SSRS, TSQL, C#, Javascript

Responsibilities:

• Responsible for managing and implementing Energy Planner Data Warehouse and WebBillCalc projects
• Gathered requirements and added processing for work orders and tied that functionality in with invoice and payment approval processing
• Coordinate with data providers, Application Development and implementation teams, Data Base Administrators and data center staff as part of Change Management process.
• Added Dashboard reporting displaying results from questionnaires sent to customers
• Perform complex data acquisition, transformation, mapping, mining and generation of simple and complex queries to support business reporting and analysis needs
• Responsible for data conversion and reporting using SSIS and SSRS
• Worked on several databases including EMDW (Energy Management Data Warehouse), WebBillCalc, Energy Planner Signup and Thermostat.
• Responsible for fulfilling EMDW SSRS reporting requests from Business Community.
• Created test data through the SSMS. Converted the WebBillCalc application from Access to use stored procedures.
• Created SSIS packages to convert mainframe tables to SQL Server Energy Management Data Warehouse tables.
• Downloaded tariff pdf documents and embedded SSRS reports.
• Interfaced with main Business contact to gather requirements for WebBillCalc. Worked closely with the QA team to fix defects, promote new releases and thoroughly test new system. Responsible for merging changes between Dev, Staging, Maint and Prod for the team.
• Developed classes for most of the rates for the WebBillCalc application. WebBillCalc was an internal website that was converted from an Access platform and used to calculate electric bills for various customers in different locations for each rate class. Created complex classes for Pole and Lighting and city, state and county tax calculations.

Confidential, Palm Harbor, Fl

Senior Analyst/Senior Application Developer

Responsibilities:

• Interviewed business community to gather requirements for document scanner sold to Hillsborough county and eventually marketed and sold to several counties in Florida.
• Used visio, word and excel to create concept diagrams, functional specs and detailed design documents.
• Created use case diagrams, class diagrams and interaction diagrams using UML.
• Worked with business users and test team to develop test plans for document scanning product.
• Coded and implemented document scanning application used by Hillsborough county.

Confidential, St.Petersburg, FL

Senior Analyst / Senior Application Developer

Responsibilities:

• Claims Processing System - Payer Edits and Map Edit Processing - Import screen images and X12 837 UB92, UB04 Institutional and HCFA Professional claims submitted by Providers (Clients) to expedite claim processing and payments from Payers.
• Coded maps and edits using C#, VB.net, ASP.net, XML. Database was SQL Server.
• Interfaced with users to gather requirements. Tested and implemented changes and made recommendations.

Confidential, Tampa, FL

Team Lead/Senior Consultant

Responsibilities:

• Team lead on Harcourt ISBN remediation project
• Senior Developer on CVS maintenance project.
• Fixed defects and resolved numerous issues with CVS inventory product.
• Developed test plans for Brassring Online talent tracking, skills matching and job search tool.

Confidential, Tampa, Fl

Senior Analyst/Application Developer

Responsibilities:

• Merge outcollects from previous days suspense file and display dashboard reports for Alltel.
• Parse clearinghouse records and accumulate totals for Alltel.
• Create Stored procedures and DTS scripts for daily transaction files and flag errors for Daily throughput reporting.

Confidential, Tampa, Fl

Senior Analyst/Application Developer

Responsibilities:

• Identify and document programs in nightly batch cycle for SQL conversion.
• Coded, System tested and implemented above programs

Confidential, Brandon, FL

Technical Officer

Responsibilities:

• Worked with users to create numerous XML/XSD templates for imports, exports and standby letter of credit for web applications used to display balances and make payments.
• Supported and made changes to Visual Basic letter of credit application replacing mainframe product.
• Managed all phases of SDLC for Trade Services/Treasury Solutions Letter of Credit Product. Analysis, design and implementation of Trade Information Exchange reconciliation process for Imports, Exports and Standby Letters of Credit. Supported all Letter of Credit products, Trade Origination Product and Bank to Bank Reimbursements.
• Involved closely with project managers, product managers, quality assurance, business analysts, developers and functional users. Analyzed current system and designed changes based on functional specifications.
• Produced and provided reports for Production support - GL, A/R, write off recovery, end of day and several other management reports for the business community.
• Managed conversion of mainframe trade services product to client/server based product. Included GAP analysis, Proof of Concept and detailed design and implementation of database and file conversions for Global Trade System.
• Interfaced with Client Access, Global Clearing and DDA users and developers in the U.S., U.K. and Hong Kong to gather requirements, analysis, design, implement and document changes in accordance with CMM, Quality Assurance and Change management procedures.
• Developed and implemented communications programs to send telex and swift messages, funds transfer wires, DDA, Trade Information Exchange and Bank to Bank transactions.
• Wrote and implemented Disaster Recovery test plans and data center Disaster Recovery tests.
• Responsible for QA, operations, customer service, production, scheduling and implementation support of ALPS (automated letter of credit productions system).