PROFESSIONAL PROFILE

• Over 25 years of experience in many areas of information technology - - as a manager, developer, analyst, and systems administrator, mostly as a developer and database administrator.
• Expertise is in Microsoft SQL’s suite of technologies -- the BI stack and database architecture; including design, development, deployment, security, performance tuning, maintenance, backup and recovery.
• Vast experience in gathering business requirements, conducting interviews, developing customized applications, design, testing, and deploying enterprise-wide ERP solutions, and project management.
• Experience in managing computer operations, maintaining mission-critical systems, identifying and incorporating the latest technologies; and providing recommendations/reporting to all levels of management and the business user community, including external clients and partners.

TECHNICAL SKILLS:

Databases: MS SQL Server, MS Access, MySQL

Languages: T-SQL, MySQL, Classic ASP, .NET: ASP, C#, Core; Javascript, Node.js, Angular, UML

IDEs: SSMS, Visual Studio, ER Studio, Visio

MSBI: SSIS, SSRS, SSAS, PowerBI

Cloud/Web: Azure, AWS, Web Services, API, Microservices

ETL/Other: Actian, Tableau, EDI, Data Mining, XML, JSON, SQL Replication, SQL Profiler

Source Control: TFS, Git

EXPERIENCE:

Confidential, Irvine, CA

Senior SQL Developer

Responsibilities:

• Created stand-alone vendor application using C#.NET, .NET Core, and SQL Server. The vendor portal interacts directly with the main, propriety government acquisition software solution. Designed and developed database schema and SQL backend included creation of database schema and design, table architecture - indexes and keys, user security, SQL replication, fail-over clustering, integration with OAS application, and reporting services.
• Created ETL processes via SSIS to integrate data into OAS and Vendor Portal applications from client platforms with stored procedures, functions and triggers; and implemented web services and API’s.
• Responsible for all SQL database administration. Created maintenance plans for all databases - production, stage and test environments, backups, re-indexing, and ad hoc reporting with SQL jobs via SQL agent.

Confidential, Irvine, CA

Senior SQL Developer

Responsibilities:

• Created and successfully implemented ETL processes using Actian data transformation software, to move worker’s compensation information from providers within large health care networks: Anthem, Prudential, Sedgewick, Aetna, to name a few.
• Automated back-end SQL Server processing, creating maintenance plans and SQL Agent.
• Introduced/created reporting functionality (SSRS), in compliance with business guidelines and heath care metrics.

Confidential, San Diego, CA

Senior SQL Developer

Responsibilities:

• Created and implemented daily, weekly/monthly sales and inventory reports using SSRS.
• Responsible for all SQL database development and administration on company’s ERP system.
• Streamlined data replication from ERP system to multiple web site environments.

Confidential, San Ramon, CA

SQL Developer

Responsibilities:

• Created and implemented interfaces from MS Access to SQL Server with stored procedures/triggers, and produced SSIS packages to consolidate data from over 400 service stations nationwide on a daily basis.
• Successfully streamlined and consolidated daily processing of various financial systems (SSIS) - working funds, cash receipts, lottery in linked MS Access databases to master SQL Server environment.
• Developed project plan for migrating MS Access systems architecture to .NET/SQL Server environment.

Confidential, McLean, VA

Senior Programmer Analyst

Responsibilities:

• Created SSIS packages to extract and archive data from enterprise-wide timecard system (PeopleSoft).
• Developed and implanted financial/payroll reports and dashboards with SSRS, SSAS.
• Created incremental interfaces from host platform to data warehouse and budget systems with SSIS, stored procs, job scheduling via Cron (UNIX) command line utilities, transforming data out to staging folders.
• Streamlined employee data flow from HR/Payroll to and from the financial and timecard systems, to and from Oracle/SQL Server-based time and budget expense systems with SSIS and data modeling.

Confidential, Rockville, MD

Programmer Analyst

Responsibilities:

• Successfully completed software/hardware upgrades of both Financial and HR/Payroll systems, from legacy mainframe to web-based, .NET/SQL Server database server environments.
• Automated the City’s internal/external forms, including time and attendance, purchase orders, and vendor inquiries using ASP, ASP.NET, Crystal Reports.
• Developed front-end online application with ASP, SQL DTS packages for daily exporting of expense and revenue budget data from mainframe to web-based platform. This allowed for easier access to financial, HR/Payroll data throughout the City’s end-user community, and a cost savings with the removal of antiquated hardware and equipment.
• Developed SQL data warehouse environments, universes with Business Objects for financial and HR/payroll modules. Responsible for City’s water billing system - C# application, integration into City’s financial system.
• Responsible for the City’s financial and HR/payroll systems: applications and databases, interfaces, nightly cycle and payroll processes; application of new releases/sub-releases and patches; database maintenance, backups, optimizations, integrity checks. Data modeling used extensively to re-engineer processes for the data conversion and the streamlining of data flow in the new environment.

Confidential, Rockville, MD

Supervisor, Computer Operations

Responsibilities:

• Responsible for the mid-Atlantic region data communications center between host mainframe in New York and 35 regional sales offices and center personnel. Maintained client database information for all regional sales offices.
• Developed modules on the internal EDI platform to process trading data between sales offices and the NY hub and stock exchange trading systems.