Objective

• To obtain a position as a Oracle PL SQL Developer where my skills and abilities can be utilized to their full potential

SUMMARY

• Industrial Engineer/IT Professional with strong mathematical and financial background
• More than twenty years’ experience managing, architecting and developing, scalable, cost effective and highly productive frameworks, desktop and Web solutions for integrated accounting, invoicing, inventory, financial, and payroll systems with Agile SDLC methodology
• Multiplatform n - tier developer with OOP languages and ANSI databases: .NET C#/VB/T-SQL and Java/PL SQL code
• Front end development for Web/desktop user interfaces with multilevel forms; backend development for business rules
• Certified as Oracle SQL Expert, Oracle PL/SQL Developer (OCA); Microsoft Certified Professional (MCP)
• Proficient shell scripting for UNIX/Linux installation, configuration and security administration with network integration (SMB/TCP IP)
• Client/Server solutions (UML, GUI, and Object-Oriented methodologies)
• Technical documentation of design, source code and specifications; user manuals for proper operation
• Expert reverse engineering and debugging abilities to discover business logic from code and databases
• Very strong analysis of process, workflow and user/business requirements; strong support and troubleshooting skills
• Self-starter, self-learner, problem solver; proactive, interpersonal and negotiation skills
• Awarded customer service skills and excellent team player with ability to work independently
• Excellent communication skills in English, native Spanish and intermediate French and German
• No professional gaps: working as a freelancer installing networks, developing software and learning new emerging technologies

TECHNICAL SKILLS

Databases: SQL Server, MS Access, ORACLE, ODBC, JDBC, Foxpro

Languages & Tools: .NET C#, VB, ASP .NET, VBA, T-SQL, LINQ, JavaScript & AngularJS, HTML, CSS, XML, SOAP, JSON, UNIX Scripting, Git, GVIM, Crystal Reports, Java SE/EE Servlets JSP Spring JSTL, PL SQL, ANSI SQL/DML/DDL

IDEs: MS Visual Studio, MS SQL Management Studio, Oracle SQL Developer, NetBeans, Eclipse

Operating Systems: Windows, UNIX/Linux

Networking: TCP IP, SMB, Active Directory, eDirectory, IIS, Apache Tomcat/Ant, SSH/KSSH & PuTTY

Applications: MS Office, MS Project, MS Outlook, MS Visio Professional, Remedy, ServiceNow, IBM Maximo

PROFESSIONAL EXPERIENCE

Confidential

Technical Analyst II

Responsibilities:

• Designed, developed application from scratch by following standards.
• Remediating MS Office VBA /.NET/MS SQL Server applications for Windows 10, MS Office 2016 with backward compatibility
• Ongoing support, enhanced & maintained existing MS Office VBA apps and macros with web services and HTML reporting

Technologies: VBA, .NET 4.7.1, VB.NET, C#, Visual Studio 2017, CSS, JavaScript, HTML, SQL Server, Stored Procedures, IIS.

Confidential

Full-Stack Developer

Responsibilities:

• Designed, developed applications from scratch by following standards according to business requirements and restrictions
• Remediating MS Office VBA /.NET applications for Windows 10 & MS Office 2016 with backward compatibility
• Ongoing support, enhanced & maintained existing UNIX/Linux/Oracle servers with integrated Windows systems (TCP IP/SMB)
• Created MS Access databases with multilevel forms for Invoice editing; pivot tables/charts for sales analysis; SQL reports
• Supported and enhanced MS Word templates containing forms with ActiveX and Content controls implemented VBA libraries
• Extract and Consolidate data from different systems and MS Access/SQL Server/Oracle ANSI databases
• Repaired and migrated UNIX/Linux ext4 and LVM partitions to new SSD systems

Technologies: VBA, .NET 4.6, VB.NET, C#, Visual Studio 2013, CSS, JavaScript, HTML 5, SQL Server, Stored Procedures, IIS, Ms. Access, Oracle 11g, PL SQL, Apache Tomcat, Java, JSP/Servlets & JSTL, Linux/UNIX Shell scripting

Confidential

Application Specialist

Responsibilities:

• Designed, developed, maintain Risk Management web applications by evaluating business needs
• L1, L2 & L3 Support and enhancement of MS Word form VBA templates for imaged documents
• L1, L2 & L3 Support for MS Access VBA applications with IBM mainframe PCOM/CICS and DB2 connectivity
• Implemented MS Word VBA code on form templates to validate data from Content/ActiveX controls using DB2 & MS Access databases
• Created MS Access/Outlook solutions for network folder monitoring with automatic email threshold notification
• Architected and developed high performance restoration services to fix MS Access corrupted databases
• Supported Java Spring Hibernate web applications with SQL analysis for DB2 RDBMS to correct data inconsistencies with DML

Technologies: VBA, .NET 4.6, VB.NET, ASP.NET, C#, Visual studio 2013, CSS, JavaScript, HTML 5, SQL Server, T-SQL, MS Access, IBM, PCOM/CICS, DB2 DDL, DML, Stored Procedures, Java Spring, JSP/Servlets, PL SQL, GIT, Shell Scripting, Eclipse

Confidential

Senior VB Developer, Microsoft Office Consultant

Responsibilities:

• Designed MS Access 2010 front/back end solutions with .NET, C#, ASP.NET, HTML, CSS, IIS, JavaScript One Click deployment, referential integrity, table constraints, optimized queries/forms, high performance VBA code for fast multiuser data
• Created SQL queries and reports to analyze and repair faulty data
• Performance tuning and code optimization for MS Office VBA solutions
• Prepared and debugged MS Office 2003 files and VB applications for Office 2010 / Win 7 compatibility
• Converted MS Excel/Access 2003 workbooks/databases into MS Office 2010 for Windows 7.
• Redesigned and corrected Excel VBA/JavaScript apps with strong error handling to produce .PDF reports from SharePoint;
• Created a solution to scan payment checks using MS Access reports and VBA code and customized fonts
• Added a new set of VB6 forms/applications with PCOM/Mainframe access using Visual SourceSafe
• Fully documented business solutions with technical details for user operation and system maintenance

Technologies: VB6, VBA, .NET 4.5, VB.NET, ASP.NET, C#, Visual studio 2010, CSS, JavaScript, HTML 5, SQL Server, T-SQL, Stored Procedures, MS Access, IBM, PCOM/CICS

Confidential

Technology Associate

Responsibilities:

• Provided master guidelines to VBA developers to properly work with Office 2010 and Visual Studio .NET projects
• Architected/developed an MS Office framework to consolidate and instantly transfer inconsistent/split Excel tables to MS Access databases to build fully integrated MS Office VBA applications (Risk Management, Capital Markets, Basel), for fast development and enhanced productivity over 3000%.
• The framework was designed with a standard to create fully customizable MS Office solutions avoiding hard coded VBA, using user profiles built with MS Access/SQL Server databases, DDL/DML/SQL queries, strong error handling, rich multilevel forms and Excel Add-Ins resulting in fully automated world class, top quality MS Access solutions replacing hard coded VBA, manual Excel processes, pivot tables and reports

Technologies: ASP.NET 4.5, Visual studio 2010, C#, VB.NET, SQL Server, T-SQL, ANSI SQL/DML/DDL, HTML, CSS, VBA, MS Office 2010 VBA (Excel/Access).

Confidential

Senior VB Developer

Responsibilities:

• Designed, developed and Customized .NET projects with SQL Server and MS Access ODBC connections for Windows 7/Office 2010
• Solved complex problems related to Word/Excel/Access, SQL and VBA applications and templates.
• Repaired MS Access link ODBC/AS400 table connections
• Converted thousands of MS Office files (Word documents, Excel worksheets and Access databases) & VBA apps into MS Office 2010 formats and find VBA incompatibilities using the Office Converter
• Remediated/redesigned VBA code/forms to work with MS Office 2010 new features backward compatible with older MS Office versions

Technologies: ASP.NET 4.5, Visual studio 2010, C#, VB.NET, SQL Server, T-SQL, ANSI SQL/DML/DDL, HTML, CSS, VBA, MS Office 2010 VBA (Excel/Access).

Confidential

Senior Software Developer

Responsibilities:

• Architected a new Financial Investment Reporting System with MS Access/SQL Server database models for MS Office 2010 VBA and .NET apps to produce Excel and Crystal reports, joining 4 financial systems made up of 8 MS Access 2003 databases, 200% faster code and queries than the old system, with highly productive and user friendly multilevel Access forms to input validated data, show datasheets, pivot tables and charts, for data analysis and processing.
• Designed, developed, Application architecture & developed code ASP.Net using HTML, CSS, JavaScript for Front End UI
• Supported and enhanced a Financial Investment System made up of 8 MS Access databases containing select and crosstab union queries, forms, macros and VBA modules to produce Excel monthly reports for further financial analysis of human resources’ costs
• Extensive performance tuning for existing VBA code, T-SQL code and queries
• Created VBA modules, SQL queries and forms for Excel reconciliation reports with enhanced functionality
• Implemented Referential Integrity for cascade updates; optimized forms, SQL queries and VBA code
• Used advanced VBA debugging tools to reverse engineer Access VBA code and Excel Macros
• Architected a new Enterprise MS Access 2010 system for the annual corporate budget, implemented with a multilevel security back end database and front-end applications containing split forms
• Created the database model of the new financial system for SQL Server and .NET applications.

Technologies: ASP.NET 4.6.1, ASP.NET, C#, Visual studio 2010, CSS, JavaScript, HTML 5, SQL Server, T-SQL, VBA, MS Access, Excel, Crystal reports, IBM Maximo, ServiceNow, Java Spring

Confidential

MS Office Applications Developer

Responsibilities:

• Developed MS Access Enterprise solutions for Private Banking system
• Designed complex select, crosstab SQL/DML queries for forms, summary reports & data update
• Created multilevel MS Access reports to create .PDF files to distribute them to branch offices in Canada
• Developed rich MS Access multiuser multilevel Forms with ActiveX controls and queries in order to update customer information and related accounts across branch offices in Canada
• Implemented security levels for a variety of users and MS Access objects
• Produced Excel VBA pivot table reports and updated data linked to MS Access databases
• Code optimization of VBA libraries, forms, reports and performance tuning for DML/DDL/SQL
• Structured technical documentation with Word, Excel, Access and Visio

Technologies: MS Access, SQL/DML, VBA, Excel, Word, Visio.

Confidential

Data Analyst

Responsibilities:

• Developed high performance Excel VBA applications for survey analysis, with validated data input, named formulas, conditional formatting, form controls, dynamic lists, and animated charts;
• Created an Excel VBA solution for survey analysis with charts and pivot tables to instantly summarize data.
• Made a survey browser, with VBA forms and ActiveX controls, for fast analysis of customers’ comments and to generate automatic summary MS Word reports
• Created an MS Access database to collect information from the Excel application for further SQL analysis
• Prepared VBA procedures to export Excel data to MS Access or RDBMS for deeper SQL analysis.
• Technical documentation of VBA Excel applications; trained users

Technologies: MS Excel SQL/DML, VBA, Excel, Word, Visio, MS Access, RDBMS, SQL.

Confidential

Excel VBA Developer

Responsibilities:

• Architected an Excel VBA application to train Inventory Analysts about the replenishment process.
• The application projected inventory distribution to create Excel reports with charts and tables, based on data extracted from SAP; used dynamic formulas and context sensitive ActiveX controls and VBA forms.

Technologies: Excel, VBA, SAP.

Confidential

Excel VBA Programmer Analyst

Responsibilities:

• Designed Excel VBA Add-Ins to patch Excel formulas and enhance remote workbooks for a pay roll system
• Enhanced the Excel VBA solution successfully made for 2008 and 2009 to work with 2010 and the rest of the century, developing customizable Excel VBA libraries of forms, macros, procedures and functions
• Developed patch version control for a suite of Excel applications

Technologies: Excel, VBA.

Confidential

.NET Developer

Responsibilities:

• Programmed multi-tier Windows/Web/Mobile/Office applications for school and sales systems using Microsoft .NET Framework 2.0 C#, VB .NET, ASP .NET, Microsoft Enterprise Library, JSON, COM+, AJAX and XML with SOAP for web services
• Created complex SQL queries and store procedures with SQL Server Management Studio & T-SQL
• Developed .NET C# and VB forms with data validation, grid views, data lists controls and Web Services
• Created Crystal Reports for Web and Desktop applications

Technologies: Excel, VBA. Microsoft .NET Framework 2.0 C#, VB .NET, ASP .NET, Microsoft Enterprise Library, JSON, COM+, AJAX, XML SOAP.

Confidential

Excel VBA Programmer Analyst

Responsibilities:

• Developed Excel VBA Add-In based solutions for the Pay Roll system containing: context macros to filter data and copy worksheets with external links and tools to convert workbooks to the next years; complex and dynamic business data entry VBA forms with ActiveX controls for data validation, search functionality, database simulation, and workbook navigation; customized menus & toolbars for application management
• Created Excel VBA Add-Ins to enhance functionality, patch and optimize thousands of Excel formulas.
• Analyzed a pay roll system in order to migrate it from MS Access/VBA to web .NET technologies.

Technologies: Excel, VBA .NET, C#, ASP.NET

Confidential

Oracle DBA & Web Development

Responsibilities:

• Developed desktop and n-tier/MVC web applications for a school reporting system
• Programmed Java class hierarchy, JavaInterfaces,Java beans, SQL queries, DMLs, PL/SQL packages with functions, procedures and triggers including sophisticated Ref Cursors to support desktop and web applications developed with Java SE/EE/JDBC, DHTML, CSS, Servlet/JSP, JavaScript, Apache Tomcat server/Ant under UNIX/Windows platforms
• Made UNIX shell scripts to prepare Linux/UNIX security for install Oracle databases, Apache Tomcat and SMB services
• DBA for Oracle databases and schema objects with Oracle Enterprise Manager on Windows/UNIX/Linux

Technical Environment: Java, SQL queries, DMLs, PL/SQL, DHTML, CSS, Servlet/JSP, JavaScript, Apache Tomcat server/Ant under UNIX/Windows, UNIX Shell Scripting