PROFESSIONAL SUMMARY:

• Results - oriented fully bilingual (English/Spanish) IT Professional with over 25 years of solid experience in application development for the Pharmaceutical Manufacturing industry. Specialized in the Windows development technologies and database-backed multi-tier web development. Highly customer-focused in terms of requirements, deadlines, quality levels, priority management, independence or team work adaptation. Outstanding negotiation and communications skills that provide the customer with absolute transparency and daily reporting of project status. Both a scientific/technical and business management background with actual design and coding in either area guarantees correct interpretation of customer requirements on any project.

TECHNICAL SKILLS:

Development tools: Microsoft Visual Studio (2005, 2008, 2010, 2015), SharePoint, InfoPath

Languages: Visual C#, and VB.NET (Windows and ASP.NET web applications development), C++ XML, HTML 5, CSS, JAVA, JavaScript, jQuery, AJAX, ANSI C, UNIX Shell Scripting, AWK, SED

Frameworks: Microsoft .NET( 2.0, 3.5, 4.0, 4.5). Development within the .NET Framework includes Web Services used as a middle tier for database transactions in web applications.

Databases: MS SQL Server including Transact-SQL (T-SQL) ORACLE 9i, 11g, 12c (including PL/SQL and the Toad for ORACLE IDE) MySQL (including JDBC access from JAVA applications) Development experience on either MS SQL or ORACLE includes stored procedures, views triggers and functions.

Operating Systems: Microsoft Windows ( 2000, XP, 2003, Win 7), UNIX, Linux Windows Server (2003, 2008 R2)

Reporting Software: MS Reporting Services (Includes Reporting Services configuration, report design, integration to ASP.NET applications and deployment from Visual Studio)

Crystal Reports, Business Objects, ASP Report Viewer

PROFESSIONAL EXPERIENCE

Confidential, Caguas, PR

• In charge of coding enhancements and providing user support/troubleshooting of custom web application “C-Seguro” which had been locally designed to record and handle Environmental Health and Safety (EHS) observations resulting from inspections to designated areas as well as general observations recorded by employees. Also, performed JavaScript and jQuery source code review on a custom Contractor Safety application.
• Completed development of “Inspection Request Tool”, an InfoPath/SharePoint application designed to expedite the workflow of requests submitted by inspectors during internal or external QA audits taking place at Lilly del Caribe.
• Coordinated the system retirement activities of multiple legacy applications. Activities included submission of System Retirement plans and summary reports as well as data conversion and archival strategy for long term retention as per company policies.
• Incorporated code (VB.NET) fixes to DeltaV/SAP custom interface.
• Migrated a print services web application from Windows Server 2003 to Windows Server 2008 R2.
• Provided custom (gawk script) coding support to generate data extractions from an open source application database as part of a Lilly social responsibility initiative.
• Coordinated the migration of a Business Objects BI project to release 4.1.

Confidential

• System for Mortgage Insurance - Developed the necessary ASP.NET web forms, code-behind and SQL procedures to implement the automated processing and management of a government-sponsored mortgage insurance. This government program had been approved as an additional stimulus for the housing industry. Coding tasks required the enhancement of an existing application in order to in corporate the new interactive web forms and insurance approval business rules that would be used by financial institutions and government underwriters. Most complex business rules were implemented as Javascript-supported function calls in order to alert financial institution users of potential insurance request rejection before actually submitting completed forms.

Confidential

• System for Mortgage Insurance - Developed necessary SQL procedures and web forms to increase the record search options available to the AFV insurance request analysts. Implemented SQL procedures to provide transaction history tracing and included web forms for record history view through AJAX-enabled tabs.
• Developed Test Scripts and application manuals for the Closing Cost Bonus web application.
• Environment: .NET Framework 2.0, Visual Studio 2005 Team Edition for Developers, MS SQL Server 2005
• Accomplishments:

Confidential

IT Services Consultant

• Development work at Wyeth-Guayama concentrated in the area of report development for a LabWare LIMS implementation using the Crystal Reports product. Report areas included certificates of analysis and statistical data represented both in graphical and tabulated form.
• Environment: Windows Server 2003, Crystal Reports XI, ORACLE 9i
• Accomplishments:

Confidential, San Juan, PR

LIMS / CSV and Technology Senior Specialist

• Performed a complete ORACLE and LIMS installation and configuration of THERMO’s iLIMS 9.3 at Confidential ’s offices in order to reproduce a customer’s environment for subsequent support. Activities included but were not limited to identification, downloading and installation of required UNIX and ORACLE patches, ORACLE tablespace planning and the installation and configuration of iLIMS 9.3 server side and client side components.
• Updated customer client/server VB applications in order to make them compatible with new LIMS version being deployed.
• Developed two VB.NET applications for Confidential internal work. One application for the automated generation of customer quotes and one application to expedite generation of validation Test Scripts. Initiated development of a .NET web service that would centralize sharing of Test Script templates among Confidential employees over the public network in a secure manner.
• Environment: Windows 2000 and 2003, .Net Framework 2.0, UNIX (HP-UX), ORACLE 9i, Visual Studio 2005
• Accomplishments:
• Reproduction of Pfizer (Caguas, PR) database/application environment that allowed us to diagnose and troubleshoot their system without requiring on-site service.

Confidential

TECHNOLOGY ANALYST IV

• Designed and coded many custom LIMS applications in order to migrate them from a legacy platform to an HP 9000 / UNIX / CALS 8.4a based platform. Migration work included changing file addressing and access methods, conversion to ORACLE tables, and redesign of external interfaces.
• Revised numerous procedures that were aimed at complying with Software Development Lifecycle (SDLC), security and data preservation corporate policies.
• Designed and coded numerous laboratory applications to support laboratory processes such as automated calculations and evaluation, Custom coding included upgrading an old automated dissolution to newer technology using a Service Oriented Architecture (SOA) Web based model with the windows .NET framework. Some LIMS applications required design of special ORACLE tables, PL/SQL code and a custom .NET client with integrated Crystal Reports objects.
• Provided support to TrackWise initiatives by designing PL/SQL procedures and SQL views that could simplify Crystal Reports reporting.
• Environment: Windows 2000 and 2003, .NET Framework 1.0 up to 2.0, HP 9000, UNIX (HP-UX 11.1), ORACLE 7.3, VB 6.0
• Environment: Windows NT, Novell NetWare, VAX/VMS, Novell, IPX/SPX, DECnet, LAT
• Accomplishments:

PROGRAMMER ANALYST

• Coded LIMS application in FORTRAN.
• Actively participated in the design of multi-platform interface programs to integrate Quality Control with material handling and manufacturing operations.