SUMMARY:

• Dynamic and accomplished manager, project manager, software developer and report writer offering expertise in delivering products that are designed and communicated to provide detailed or summary information.
• Accomplished business, systems analysts, and manager providing detailed information using Visio, Word, PowerPoint, Project, and analysis to communicate complex, critical applications effectively. Innovative team player and strategist, instrumental in supporting visions and strategies within organizations.
• Outstanding mentor and leader of profitable project solutions. Known for implementing policies and procedures and increasing reliability and speed of development.
• Confident facilitator and communicator, skilled in collaborating with executives, stakeholders, and clients; also an accomplished instructor and trainer. Expertise includes:
• Project Management Budget Oversight Process Improvements System Integration Training / Mentoring Productivity Specialist
• Documentation Processes Team Building/Leadership Web Software Leader

COMPUTER S KILLS:

Software Packages: MS Office Suite (Word, Excel, PowerPoint, Visio) MS Project, Oracle, JavaScript, FTP, VPN, Remote Server Access, Crystal Reports (Business Objects VII), MS Reporting Services, Visio, SharePoint 2007/2010, CRM 2011/2013

Platforms & Systems: Windows 2000/2003/XP/VISTA/Windows 7, AS400, MS DOS, MAC

Databases & Tools: SQL Server 7.0/2000/2005/2008/2008 R2, MS Access 97/2000/2003 /2007/2010 , Oracle, DB2

Development Languages: Visual Basic, VBA, Visual Studio.Net 2003, ASP.NET, VB.NET, ASP, FrontPage 2000/2003, OLAP, XML, JavaScript, JD Edwards

PROFESSIONAL E XPERIENCE:

Confidential

Data Migration Expert / BI Developer

Responsibilities:

• Primary role is upgrading existing SQL Server 2000 databases to SQL Server 2012 using integration of SQL 2008 for the transformation between servers.
• ETL processes in migration of DTS packages to SSIS packages incorporating ftp transfer and file manipulation with flat files and 64bit Microsoft Office files (Excel and Access). Checking of existing files in a package using functions and archival of data files to minimize failed packages.
• In corporate Integration Services Catalogs for the deployment of the packages.
• Lead on Team Foundation Server (TFS) as the code repository of files used in development.
• Second primary role is the lead BI developer with the financial billing system to the contracted organization using SSRS; converting Crystal reports to SSRS.
• Data warehouse developer creating fact and dimension tables (Star Schema) and incorporating SSAS cubes for the development of Excel pivot tables and data analysis.
• SQL Server mentor directing the development of upgrading a SQL Server database from 2000 to 2012.
• Documentation expert on all aspects of data manipulation, business rules and training documentation.

Confidential

Data Migration Expert

Responsibilities:

• Primary role is ETL processing of property, residential and listing data nationally in the United States using SSIS, database projects and change tracking.
• Facilitate existing published data into RPR logic separating into a normalized data structure.
• In corporate existing stored procedures and function into SSIS packages using Visual Studio 2013 database projects.
• Deploy SSIS packages to Integration Services Catalogs (ISC).
• Use of Team Foundation Server (TFS) as the code repository and project communication.
• Setup jobs with the existing packages using environment variables and parameters for the facilitation of data throughout the system to minimize blocking of records.
• Troubleshoot failed packages and update as necessary.

Confidential

Senior Report Analyst / SQL Developer

Responsibilities:

• Primary role of identifying a database architect for a data warehouse with ETL processes constructed in SSIS.
• Developed CRM reports with SSRS extension which are deployed to SSRS and impeded into CRM.
• Worked on a project to develop reports using SQL 2008 R2 SSRS to in corporate information from CRM and a data warehouse for reporting dashboards.
• Incorporating T - SQL, stored procedures, functions while combining data from multiple databases to in corporate dashboard capabilities into Share Point with SSRS integration.
• Worked with existing business analysts, project managers and management in the development of new reports for the organization.
• Facilitated and developed Share Point solutions in the sharing of documents, projects, and report dashboards.

Confidential

Senior Report Analyst / SQL Developer

Responsibilities:

• Developed reports and ETL processes using SQL SSIS containing multi-split of information with variables for vendors in SQL 2005 and 2008 R2 utilizing views, stored procedure, and functions to mimic processes from existing ERP systems.
• Built SSRS and Crystal reports with graphic and drill-down capabilities to provide reports necessary for finance and member services with stored procedures and functions to mimic existing macros in related ERP Systems, CAMIS and Magic that is part of Meditech software.
• Introduction to EPIC programming with development of Crystal Report solutions.
• Extracted and QA’d processes from existing ERP systems, CAMIS and Magic using SSIS as the exporting feature.
• Supported existing Microsoft Access applications for all medical services.
• ETL and report development process on the DKD data transformation in conjunction with updating reports in completion of the archival project, saved $8,000 per month on service fees.
• Mentored co-workers on the development of SQL queries, stored procedures, and SSRS reports, including SSRS deployment, subscriptions, and user access for users.

Confidential

Senior Information Analyst (Report Analyst)

Responsibilities:

• Developed reports using SSIS and SSRS to provide reports necessary for finance, claims, operations and other aspects at the organization from three ERP database systems, EZCAP, Practice Connect and Provider Resource Maintenance systems.
• Report development consisted of complicated queries using Star Schema data warehouse, matrix writing and sub report generation per business needs.
• Consistent HIPAA regulations on practiced with annual certifications taken for compliance.
• Mentored coworkers on existing SQL processes, including functions for the development of reports.

Confidential

SQL Developer / Programmer

Responsibilities:

• Developed reports using SSIS and SSRS to provide security auditing for existing ERP applications and general ledger reports and develop documentation and procedures.
• Updates Access databases to use SQL Server and Oracle DBMS systems in support of our existing ERP system and management intermediate processes in SharePoint.
• Managed SharePoint lists, incorporated individual and group access within SharePoint. Archived data and compacted database size for continue productivity within SharePoint.

Confidential

Business Analyst/ Software Developer / Project Lead

Responsibilities:

• Interviewed existing business teams and gather requirements effectively to determine processes and procedures used to conduct business at different levels in the organization.
• Constructed a report request form to simulate ease in requesting new reports.
• Interpreted business needs related to the gathering of data into a DBMS system preferably Microsoft Access or SQL Server, building forms and incorporating project management methods.
• Identified, documented and communicated findings related to the existing processes and provide direction for enhancements to the DBMS systems on the outlined projects.
• Developed and managed reports using SSRS and SSIS with SQL Server 2008 / 2010.
• Upgraded existing UI Microsoft Access database systems and completed the process of moving the data to SQL Server.

Confidential

Sr. Systems Analyst / Project Lead

Responsibilities:

• Managed third party application to facilitate the payment of company vendors domestically and internationally using a tool created by the organization Bottomline.
• Modified existing data replication from the ERP System from Oracle and Connex database systems to SQL Server using DTS and SSIS and upgraded existing database schemas and database architecture.
• Developed reports using SSIS and SSRS to provide security auditing for existing ERP applications and general ledger reports and developed documentation and procedures.
• Updated Access databases to use SQL Server and Oracle DBMS systems in support of existing ERP functionality.
• Lead the in corporation of Active Directory as a security procedure in the applications and reports.

Confidential

Project Manager

Responsibilities:

• Analyzed the existing project management systems, processes with SDLC incorporated.
• Wrote policies and procedures for managing projects and made recommendations as to which systems to use in project management.
• Researched and reviewed two project management systems: Microsoft Project Server and SharePoint for Project Management.
• Develop several projects using Microsoft Project and SharePoint.

SQL DBA and Developer

Confidential

Responsibilities:

• Supported diverse clients and projects in various roles.
• Reviewed existing SQL Database environment for an existing home building organization to enhance the research and development department.
• Designed and upgraded DTS packages to SSIS packages for processing data on a regular basis.
• Developed new TSQL statements, indexes, stored procedures and views in SQL Server 2005.
• Utilized MS Reporting Services and SQL Server 2005 to create reports. Incorporated stored procedures and views.

Confidential, El Segundo, CA

Software Development Manager / Project Manager

Responsibilities:

• Directed a staff of five software developers and technician to develop software applications.
• Created team and integrated applications for sales and marketing, technical operations, business operations and HR using VB.Net, SQL Server, ASP.Net and other Microsoft technologies.
• Managed over 12 software applications incorporating SDLC for the Sales Leads Applications, Sales Order Entry, and Retention Database using VBA, VB.Net and SQL Server.
• Analyzed QA release notes, reviews and training documentation; supervised remedial actions, and oversaw release of application development into production systems.
• Streamlined creation of multi-tier reporting by training analysts and report writers in SQL Server skills.
• Developed business process for end-users and managers to define new application projects in regards to scope, task lists, and timelines.
• Provided technical support to SQL DBAs regarding table indexing, T-SQL statements, stored procedures, triggers, DTS and SSIS packages downloading data from Oracle databases.
• Conducted personnel assessments, identified skill sets and conducted / instituted training to increase skill levels.

Software Developer

Confidential

Responsibilities:

• Developed software and managed development to produce internal and external reporting services.
• Designed user reports and created web tools utilizing Access 97/2000/2003 , SQL Server 7/2000, FrontPage 2000, ASP, VB.NET and ASP.NET technologies incorporating SDLC project methods.
• Created and maintained on-line reporting system for data sources that included daily uploads from Oracle database and an AS400 system to SQL Server using DTS and SSIS technologies.
• Mentored and trained business analysts in SQL Server to develop enhanced database design applications using DTS packages for downloading information to SQL Server.
• Designed applications to manage customer/employee related data using VB.Net, ASP.Net and SQL Server.
• Provided programming guidance to SQL DBA, which included stored procedures with T-SQL queries, views, databases, tables and indexes to optimize query performance on the SQL server.
• Utilized IIS 5.0/6.0 with FrontPage 2000 to design/publish ASP, VB.NET and ASP.NET with DTS and SSIS.