Andres Valencia Email & Phone Number

Chicago, Illinois, United States

Developer in charge of development and support of APEX applications.Migrated Applications to ORACLE 19c and APEX 21Implemented OAuth 2.0 to meet bank standardsMigrated applications to use OS/Kerberos AuthenticationImplemented CI/CD pipeline using Jenkins.Migrated application to private cloud, using docker and Kubernetes for orchestration. Implemented monitoring technologies such as dynatrace and SPLUNKImplemented automated testing integrated with CI/CD pipeline using UTPLSQL,Cucumber and Selenium

Developer in charge of development and support of APEX applications.

Chicago, Il

Developer in charge of development of new interfaces for the Accounting Hub. Responsibilities include development of ETL process to transform and homogenization of large amounts of data for consumption of the ERP Systems. Lead engineer in charge of design and implementation of Github, Sonarqube and other quality processes.

Greater Chicago Area

IT developer in charge of support and development of ETL financial processes using Aptitude Accounting Hub, PL/SQL development, UNIX scripting and scheduling of tasks using ASG-Zena.

Greater Chicago Area

IT Developer in charge of design and development of data warehousing processes for regulatory reporting:Design, development and support of ETL processes from different source systems to the corporate NETEZZA data warehouse, using custom inhouse python loaders.Design and implementation of the migration process of data and logic from NETEZZA to ORACLE Exadata.

Richmond, Virginia Area

IT Developer in charge of design and development of new web solutions and interfaces, and support of existing systems, on ORACLE 12c responsibilities included:Design and development of an ESB interface including design of the messages XDT, development of the data extraction process, and support of the data transmission.Development and support of a new web application using HTML5 for the user interface and PSP technologies for the back end, with several hundred concurrent users.Development and support of data maintenance and report screens using ORACLE APEX.

Senior Oracle Developer part of a team responsible for development, implementation of new features and tuning of existing forms, reports, and database program units.Responsible for the implementation of new requirements based on technical specifications provided and using SQL, PL/SQL, Oracle Forms and Reports and utilities like PL/SQL Developer to speed up the development process, Serena for control version management and Bugzilla for bug tracking.Responsible within the IT Finance team for the analysis, design, development and deployment of a new costing system supporting several business units during the transition process. Also responsible for business support, end-users support and general system troubleshooting.

Database Administrator, in charge of support to development teams, responsabilities included:Development of dynamic SQL and PL/SQL in VBapp to create reports querying multiple Oracle databases simultaneously and exporting data into Excel and Word files, Unix Shell scripting to extract data directly from Oracle database servers and windows batch programming to implement routine tasks over several Oracle databases.Development of internal control alarms using Unix shell scripts and PL/SQL at the back-end. Development of internal control applications using Oracle Application Express (APEX) 3.0. Responsible for improvement and tuning of new program units such as Stored Procedures, Stored Packages, Stored Functions and Database triggers before implementation, checking the use of existing indexes and use of adequate SQL access hints for better access paths and performance, using tools such as TKPROF, SQL Trace, Explain Plan, TOAD and PL/SQL Navigator. Database performance analysis using Oracle Enterprise Manager 10g, Oracle EAP, Oracle RDA and Oracle Stats Pack. Responsible for analysis, development and implementation of new features and enhancements for applications running on Oracle database RDBMS 9i and 10g. Responsible for the maintenance and tuning of Oracle databases, installing patches and upgrades needed to maintain the production environment according to the application requirements. Assistance in support, maintenance and performance monitoring of COMCEL’s Oracle databases in a 7x24 production environment using tools such as TOAD, SQL, PL/SQL Navigator, Oracle Enterprise Manager. Implementation of Oracle database changes in production environment according to the established policies. Coaching to other developers about Oracle development best practices and features. Support to existing applications in SQL Server 2000 and 2005.Coaching to other developers about Oracle development best practices and features.

Senior Oracle Developer part of a team responsible for analysis, design and implementation of new application’s requirements for the Public Utilities system (SISPO) offered by the company. In this position Microsoft Solutions Framework was used for analysis, Rational Data Architect was used for database modeling and process modeling, and Oracle Developer Suite including Forms Builder 6i and 9i, Reports Builder 6i and 9i, and Microsoft .Net 2005 were use to implement reports and front-end interfaces for different clients/environments. SQL and PL/SQL were used to develop the core components of the product and PL/SQL Developer was used to speed up code development. As part of this project, we implement a financial data warehouse used to consolidate bill and sales information and to generate summary reports for upper management. Implementation and use of PLUnit, a PL/SQL unit testing framework used for automatic unit testing of frequently modified PL/SQL program units such as Stored Procedures and Stored Functions. Responsibilities also included analysis and design of a web-oriented application for process management and workflow using PSP (PL/SQL server pages). Eclipse was used to build and test Javascript and HTML components and PL/SQL Developer was used for PSP development. We were also responsible for end user support.

Oracle Developer in a team responsible for Utilities Information System Open SmartFlex BOSS maintenance and development of new features and enhancements in the area of Collection. Responsible for analysis, design and implementation of client/server Oracle-based information systems using the Oracle Developer Suite 6i, and Rational Data architect for database and process modeling. Use of Oracle Forms 6i and Oracle Reports 6i for front-end development. Use of SQL, PL/SQL and TOAD for back-end development and implementation of Stored Procedures, Stored Packages, Stored Functions and Oracle Database triggers. Responsible for the analysis, design, development, and implementation of large batch processes, including multithreading processes using Pro*C.

Oracle Developer leader of a team responsible for the analysis, design and implementation of the company‘s Work Orders information system, using Oracle CASE methodology and Oracle Designer 6i to design and model new product requirements and database structures, and Oracle Forms Builder 6i and Oracle Reports Builder 6i to implement user interfaces and reports. This team was also responsible for the migration of all mainframe applications to the new Oracle-based ERP, unit testing, system testing and end-user acceptance testing for all applications migrated. Other responsibilities include the maintenance and support of Inelco’s intranet and company’s e-mail system, configuring several Windows 2000 servers to support the email and http services and developing the company’s intranet using Macromedia Dreamweaver, HTML for static content and PHP for dynamic content as HHRR news and additional information extracted from an Oracle Database. We also were responsible for end-user support of the new Applications and the intranet.

Junior Oracle Developer responsible for support for the School Library information system and the Graduates’ system, offering training and expert advice to the existent users base and analyzing and developing new functionalities required by the users. We used Oracle CASE tools and Oracle Designer 6i for database generation and application generation. For database generation, all Entity Relationship diagrams were created in Oracle Designer and converted to a database model and database objects using auto generated SQL scripts. For application generation, all screens were modeled using the Function Modeler and generated into Oracle Forms. I was part of the QA team responsible for the improvement, supervision and standardization of all IT process related with the university’s information systems and unit testing and end-user acceptance testing according to black box testing techniques.