SUMMARY:

• Senior level professional with over 25 years of experience and progressive s globally in computer science and information technology. Possessing strong analytical and reasoning skills. Problem solver on tight deadline environments. Focusing on the application of technology and support to business functions both in Non - Profits organizations, Government, Health Care Industry, finance, accounting, supply chain, manufacturing, retail, medical billing and Aviation Industry for logistics.
• Strong knowledge of SSRS development environment, responsible of designing and developing Reports, Metrics, and Dashboards.
• Extensive experience in Data Analysis, Data Migration, Data Extraction and Data Integration.
• Strong knowledge of VBA for Excel and Access.
• Strong knowledge in Crystal Report.
• Expertise in MS Access Database migration to SQL Server.
• Experience in databases like MS-SQL Server and MS Access, as well as in different data access technologies such as ADO.NET, ADO, RDO and DAO, etc
• Experience WordPress and WIX Web Site Design, Adobe Photoshop.

TECHNICAL SKILLS:

Languages: C#, VB/VB.Net, ASP.Net, XSLT, JavaScript, C/C++, VBA for Excel and Access, Pascal, Assembler 80X86, LabView

DBMS: MS-SQL Server, MS-Access, Progress 4GL, Clipper, FoxPro

Reporting: SSRS, Crystal Report, MS Access.

Data Manipulation: SSIS, SPSS

Operating System: Windows, MS-DOS, VM

Source control: SNN, Team Foundation

Applications: PeopleSoft, Pharmacy Plus, Kronos, Lawson, Visionware, Meditech, Macola Progression, MFG/PRO, Microsoft Visual Studio. NET Suite, Microsoft Office, ATE IRIS 2000. Abacus Pharmacy Plus, Lawson, Kronos, Vision ware, MACOLA ERP/MRP . Exposure to HIPAA, HL7, EDI X12, CPT Codes.

Others: Telerik, WordPress, WIX, Adobe Photoshop

PROFESSIONAL EXPERIENCE:

IT Director/ Data and Reporting Analyst

Confidential - Miami, Florida

Responsibilities:

• Assess and respond to IT needs for Managers, Counselors, Social Workers, Clerks Office, and Staff.
• Provide day-to-day supervision, and delegate work assignments for all IT personnel.
• Responsible development, design, and implementation of new applications and changes to existing computer systems and software packages.
• Responsible for the design and maintenance of Company Web Site in WordPress.
• Database object maintenance, design and development ad-hoc database queries and store procedure.
• Report Server Installing, Configuration and Maintenance. (SSRS 2014).
• Recommend, design and develop new reports.in SSRS.
• Prepare daily and Monthly reports for Staff and Managers.
• Design, develop, maintain and enhance ASP.NET / C# application with industry best practices, in a timely manner.
• Utilization of the source code repository for managing all source code changes.
• Test and deploy applications.
• Provide technical first line software support for end users related to case management application.
• Train or assist with end-user materials.

Environment: SQL Server 2014, Visual Studio 2015, MS Access, Excel 2016, Telerik, TFS, SSRS 2014, Windows Server 2012, WordPress

Consultant

Confidential - Miami, Florida

Responsibilities:

• Provide solutions to enhance VBA code for MS Access applications and Excel VBA Macros.
• Migrate MS Access Databases to SQL server 2012 using SSMA 2010:
• Prepare the MS Access database to be complaint with SQL server 2012 requirements:
• Create unique index.
• Create VBA code to replace reserved words and specials characters.
• Change field types (from decimal to float,etc)
• Remove replications columns
• Remove multiples NULL Values from index
• Migration from MS Access to SQL Server 2012: Create database in SQL. Create a code to import the description properties from Access, create backups and restore jobs.
• Support the DBA task.

Analyst-Programmer

Confidential, Miami

Responsibilities:

• Worked with staff, senior programmers, and product manager, to plan program code enhancements and changes.
• Created, test and maintain program code.
• Created labels and reports using Crystal Reports
• Provided assistance to technical support staff when they are unable to resolve a program, SQL database, or IT issue by themselves.

Environment: VB6, SQL 2000, MS Access 2000, Pervasive SQL,VBA, HIPPA, Billing and Collection, EDI X12

Contract VB6 and C# Developer

Confidential, Miami

Responsibilities:

• Led pharmacy Management systems (Visual Pharmacy Plus - VB6) projects
• Developed solution to retrieve Drug Cost File in EDI format (832) from FTP Site or Flat File using different formats. (Vb6) to Updated Drug Cost Database.
• Worked on a new Purchase Orders System with the capability of Generate a PO request in EDI 850 format direct to Supplier, and Receive an 855 acknowledge of item received and accepted (Vb.NET) .(X12)
• Worked on a new solution to transfer and track into a PDA all drug delivery route, register the payments (Cash or Credit Card) and proof of delivered (Sign). After all, day, the driver must transfer the result to Computer Desktop: VB.Net, Windows Mobile SDK 6.0 (VB.NET)
• Helped Integrate Pharmacy Plus with QuickBooks: C#, QuickBooks SDK (Intuit SDK 8)
• Integrated Multicarrier Tracking System, C# 3.5 and Google Map to Get Directions to Delivery Drugs

Environment: VB6, VB.NET, C#, MS Access 2007, Visual Studio 2008, Windows Mobile Professional SDK, EDI X12,Intuit SDK 8.0.

Contract ETL/SSIS Developer

Confidential, Miami

Responsibilities:

• Provided support as a developer to existing medical management practices with medical billing systems that encompassed a multitude of Business Intelligence and management report needs.
• Created databases, views, stored procedures as well as processes involving data analysis, data migration, integration(SSIS) and data warehouse on SQL Server 2005.

Environment: SQL 2005, SSIS, SSAS, Visual Studio 2005

Financial System Analyst

Confidential, Miami

Responsibilities:

• Maintained current departmental software applications (Kronos, Lawson, Visionware);
• Provide robust compliance reports that show corporate, departmental, or individual assessment compliance (Lawson)
• Researched, recommended and implemented new HR and financial reporting using Crystal Report Xi and Business Object, and document management applications
• Supported Director of Financial Information Systems Solutions and the Vice President of Financial Services, with timely and accurate financial and productivity data, and analysis as needed in the preparation of Financial Statements, other financial reports, and productivity analysis, benchmarking, andbalanced score card reporting.

Environment: Crystal Report XI, SQL 2005, Oracle ODBC, VBA for Access 2003, VBA for Excel 2003, Lawson, VisionWork, Kronos, Meditech, OneStaff, Hyperion, Windows,, VB 6.0, Excel 2003

IT System Analyst

Confidential, Miami

Responsibilities:

• Manages development, implementation, installation and operations of the Lawson system
• Implantation of Lawson HR/PR and migration from Macola ERP HR module.
• Carried out coding, testing and troubleshooting of programs utilizing the appropriate hardware, database, and programming technology. Refined data and format final product.
• Performed maintenance and migration of current access applications.
• Maintained and modified programs, made approved changes by amending flow charts, developed detailed programming logic, and coding changes: Scheduling, Payroll, Production, Piece Work, Field Rep, ISO Documents, Systems, CAPA Systems, Imaging and Scanning Documents, KPI, Business Status, Bank Reconciliation, AR Tracking, AP, Journal Entries, Bank Reconciliation.
• Defined and implemented rules and security to prove that all the Access Application are compliant with Sarbanes-Oxley (SOX): Protecting and securing information; Documents and record management (CAPA System; Imaging and scanning all docs, Notes System, ISO Docs) and Data security policies.
• Provided daily support and problem resolution to users.
• Evaluated simple interrelationships between programs such as whether a contemplated change in one part of a program would cause unwanted results in a related part.
• Analyzed performance of programs and act to correct deficiencies based on consultation with users and approval of supervisor.
• Met with users to gain understanding of needed changes or modifications of existing programs. Resolved questions of program intent, data input, output requirements, and inclusion of internal checks and controls.

Environment: Access 2007, VBA, VB 6.0, Excel 2007, SLQ 2005, ETL/SSIS, ASP.NET, VB Script, Lawson, Macola, Crystal Report

Software Programmer/ATE Programmer

Confidential, Miami

Responsibilities:

• Supported existing application (THOR’s)
• Deployed and developed in LabWindows/CVI and ANSI C, using the .NET Library to invoke
• Converted program from COBOL to LabWindows/CVI

Environment: .NET, COBOL, LabWindows/CVI, SQL2000, ANSI C, Measurement Studio

Avionic Technician

Confidential, Miami

Responsibilities:

• Supported Confidential as an FAA Repair and Overhaul Station for avionic and accessories equipment.
• Resolved troubleshooting and maintenance of accessories Units.
• Tested, evaluated and repaired avionics Units.

Programmer Analyst

Confidential

Responsibilities:

• Developed Used Object Oriented design/programming utilizing ADO technologies, Custom ActiveX, COM Components, Windows Common Controls, and stored procedures and triggers.
• Developed Visual Basic applications: a career placement agency, and a Helpdesk using Visual Basic 6.0, ActiveX Data Objects, ASP, COM and Concepts in Object Oriented programming in a team environment.

Environment: ASP, VB6.0, VBScript, Microsoft SQL Server 7.0 and 2000, Crystal Reports 6.0, IIS,HTML

Programmer Analyst

Confidential

Responsibilities:

• Analyzed and developed an integrated system (Contawin 2000) to combine all components within the accounting department and other software applications (ContaPlus)
• Developed programs to manage centralize budgets, pacing, projections, and end-of-month reports for Senior Management.
• Implemented accounting programs for all duties including coordination with CPA on year-end tax returns and adjustments.
• Implemented programs to manage all bank procedures and related functions of Corporate banking operations.

Environment: Microsoft Visual Studio 6.0, Microsoft SQL Server 7.0 and 2000, Access 2000

Consultant Support Engineer

Confidential

Responsibilities:

• Proposed and implemented the ABANKS system to manage a comprehensive link in the Banking and Financial areas based in Progress and Xponent Case.
• Developed the following modules: General Ledger, Lending, Receivables, Savings.
• Involved in the analysis and acted in an advisory capacity towards the implementation of the system MFG/PRO and Confidential Inc. For Unilever Industries: Customer, Sales and Distribution, Purchasing system and procedures, Accounts Payable and Inventory.

Environment: AIX, Progress 4 GL, MFG PRO, Sun Solaris, Sun Microsystems

MFG/PRO Analyst

Confidential

Responsibilities:

• Customized the invoices and PO layouts.

Environment: UNIX, Progress 4 GL, MFG PRO

Research Engineer

Confidential

Responsibilities:

• Led the Automated System and Mathematics Applied to Sports Medicine in the Research center.
• Developed Software, Data Entry, processing and Statistics. .

Environment: Epi Infor, Microstat. SPSS+, FoxPro,DBase

Electronic Engineer

Confidential

Responsibilities:

• Designed microcomputer Systems under specific requirements.
• Minicomputer CID 300: Testing, troubleshooting and repair.
• Developed supporting tools and electronic devices to assist troubleshooting process of installed based