Sql Server Project Management

MICKEY BAEZ

Phone: 404-***-****

**********@*******.***

**** ********* ***** *******, ** 30041

PROFESSIONAL SUMMARY

Results driven Team Lead Senior Developer / Technical Project Manager with 15+ years experience implementing technologies to provide greater efficiency and streamline operations for the Public and Private sector. Extensive knowledge in Web and Windows application design and development (SDLC) using Microsoft .Net Technologies. Proficient Experience in BI solutions and Reporting Services. Exceptional communicator who effectively interacts with clients at all levels of management. Creative out of the box thinker and analytical problem solver with demonstrated ability to manage projects from planning through execution/completion under the pressure of fast-paced time sensitive environments.

TECHNICAL SKILLS

Languages: C#,Visual Basic, VBA

Database: SQL Server, Oracle, MS Access, MYSQL, SSAS, B.I./SSIS

Web Programming: C#, .NET, ASP.NET, VB.NET, ADO.NET, HTML, XML, WSDL

AJAX, JavaScript, IIS

Reporting: Crystal Report, MSAccess, SSRS

Project Management: MSProject, Visio, Visual Source safe, Team Foundation Server

PROFESSIONAL EXPERIENCE

Unisys / Molina Health Care yr. 2010– Current

Health Information Management Analytics Technical Lead

Team Lead for USVI Business Intelligence Implementation (SSIS/SSRS)

Medicaid Reporting for State(s) of West Virginia, Idaho, United States Virgin Islands.

Create Stored Procedures and SSIS packages for data workflow

Create Crystal / SSRS reports for States HealthCare Financial Departments

Participates in management meetings and recommends feasibility criteria for projects

Create SOW Estimates, Documentation and Release Notes

Conversion of over 500+ packages from DTS to SSIS to SSRS

Environment: SQL SERVER 2008 R2/2012, Crystal Reports, SSRS, SSIS, Team Foundation Server

Amtrust Financial yr. 2009 – 2010

Senior Systems Engineer / Consultant

Design/Develop Management Reporting Dashboard in ASP.NET/Crystal Reports

Create .Net User Controls for Company Framework.

Design/Develop Web and Windows interfaces for proprietary Insurance Software

Create Data File Extracts for transmission to Insurance companies.

Database Design, Implementation, queries, reports, migration(DTS/SSIS) and stored procedures

Data Conversions from Legacy Systems to Enterprise Applications.

Scope and requirements collection

Participates in executive meetings and recommends feasibility criteria

Environment: ASP.NET 2.0, VB.NET2.0, SQL SERVER 2008 R2, Crystal Reports, SSRS

PeachTree Settlement Funding yr. 2007 – 2009

Senior Systems Developer/Structured Settlement Team Lead

Created ASP.NET/XML Extract Software that facilitates data to Financial Facilities on a bi-weekly, monthly, quarterly, yearly basis. XML Extract Software enables over $300 million dollars in funding to PeachTree from different financial facilities annually.

Composition of Project Management Weekly Reports with staff and project updates.

Continuous Software Support, Enhancements, Customizations of Structured Settlement & Servicing .NET Systems.

SQL Server 00/05 backend development for Structured Settlement & Servicing .NET Systems

Statistics & Financial report writing with Crystal Reports for monthly Board Meetings

Responsible for leading a team of 3 developers and supporting 120 users with Structured Settlement & Servicing Windows and Web Based ASP.NET Software Systems.

Design/Develop Lead Web-Based Solutions

Responsible for Managing multiple web development projects

Environment: ASP.NET 2.0, VB.NET2.0, SQL SERVER 2005, Crystal Reports, SSIS

Dekalb County yr. 2005 –2007

Senior Systems Developer III

Implemented & Configured .NET environment for Judicial Team & Probate Courts.

Support / Report Writing with Crystal Reports for Probate Judicial Court System (Banner)

Design & Customized Development of Pistol, Marriage and Wills SafeKeeping .NET Systems.

Technical lead of SQL DB & IIS Servers for Judicial Team.

Provided Software Development & Support for 200 users in Dekalb County Court System.

Assisted Management in RFP writing and software selection for new software acquisitions.

Firearms License

FireArms System issues licenses to Dekalb County Residents. The system contains modules Arrest, Rehab, Imaging, Employment, FBI/GBI Background, and Accounts Receivable/Payable. Batch process modules are used to send and receive Mental Health Waivers to the State of Georgia. System designed using 3-Tier Web Based System.

Environment: ASP.NET 2.0, VB.NET2.0, SQL SERVER 2005, Crystal Reports

Will Safekeeping

The System keeps tracks of Wills for Safekeeping for Dekalb County. Wills for Safekeeping has AP/AR modules to handle the Finances. Wills was re-written from a .NET windows system into web based. Wills SafeKeeping System was converted into a 3-Tier Web Based System with ASP.NET, 2.0 Framework.

Environment: ASP.NET 2.0, VB.NET2.0, SQL SERVER 2000, Crystal Reports

City of Miami Beach yr. 1999 –2005

Senior Systems Developer II

User Acceptance Training & Technical Writing of Software Documentation

Remedy Help Desk System Administrator, Programmer, DBA

Lead Developer responsible for Fire Dept. CAD Software System.

Provided Software Development & Support for over 500 users in the City of Miami Beach.

Departments that were supported were Police, Fire, City Manager, Finance, City Clerk, Arts.

Resort Tax

This receivables system collects all Resort Tax revenues (Alcohol, Food, Rooms) from the businesses within the City of Miami Beach. In addition to maintaining an open item receivables for over 2,000 businesses within the City the system includes billing statements, dunning letters and an auditor's module. Every year the system is used to collect and manage over $20 million in revenue for the city. Converted 20 years of data from the mainframe HP3000 to the new client/server software developed.

Environment: ASP.NET 2.0, VB.NET2.0, SQL SERVER 2000, Crystal Reports

Remedy Help Desk Implementation

Implemented New Remedy Help Desk Package for the City of Miami Beach.

Converted 10 yrs of Data from legacy Help Desk Software into Remedy.

Provided in-house training for the 50 member I.T. Staff.

Environment: Remedy AR 5, SQL SERVER 2000, Crystal Reports

Capital Improvement Projects

This system is used to manage restricted funds for Capital Improvement projects throughout the City. It provides for the controlled "rollover" of funds between fiscal years as well as budgetary control for the life of the projects. The City currently manages some $360 million in capital improvement funds for hundreds of projects using this system.

Environment: VB6, SQL SERVER 2000, Crystal Reports

Hr Evaluation System

This system is used to keep track of employee reviews and evaluations for all Firemen working in the City. This system has built in triggers to the Fire Chief(s) to alert them when evaluations are due. It also contains a customized hierarchy/security module, which filters reviews by position to the appropriate supervisory staff.

Environment: VB6, SQL SERVER 2000, Crystal Reports

EDUCATION

Florida College Jan.1997 – June 1999

A.S./Computer Science

Studies focused in application development, IT project management, multimedia design, technical planning, and business case analyses. Created working prototypes for numerous web site projects and desktop applications

Trinity International University Jan. 1992 – Dec. 1994

Public Administration

Studies focused on principles involving strategic planning, resource allocation and leadership techniques

IBM Business Institute June 1991 – June 1992

Certificate of System Administration

Studies focused on System Administration and Operating Systems

Training

AppDev SSRS (2010, 2012)

AppDev SSIS (2010,2012)

AppDev SQL (2010, 2012)

AppDev .NET (2010, 2012)

Oracle/PL SQL

Banner Record Mgt Judicial System

Crystal Repor t(9, 10,12)

ASP.NET 2.0, 3.0, 3.5, 4.0, 4.5 framework

SQL Server 2000, 2008, 2012

Remedy System Administration 5.0, 5.1

Certifications

Remedy System Administration 5.0

Contact this candidate