Software Engineer, Software Developer, Business Analyst, PL/SQL

RODRIGO ECHEVERRY GRANADA

Fairfield, Iowa ***** (C) 641-***-**** *******.*********.*******@*****.*** https://www.linkedin.com/in/rodrigoecheverry/en

SOFWARE ENGINEER/ORACLE PL/SQL

Accomplished professional with experience in different areas of software engineering, Business System Analyst/ Business Analyst.

Knowledgeable Open source tools (Linux, MySQL, PostgreSQL, Hadoop, Java, Spring/Spring Boot, C, C++, PHP) environments with 1+ years experienced in systems development, testing, implementation, integration, and support of business-critical enterprise-level applications

Knowledgeable Java Developer, OOP with 1+ years experienced in systems development, testing, implementation, integration, and support of business-critical enterprise-level applications

Knowledgeable PL/SQL Developer and Software Engineer with 10+ years experienced implementing custom modules and distributed system solutions within Oracle databases, Software Development Life Cycle.

Robust experience in OSS/BSS for Telecom and/or Utilities companies.

Skilled technical support professional providing solutions for the problems related to system.

Solid analytical skills and excellent relationship building, communication and interpersonal skills.

AREAS OF EXPERTISE

PL/SQL OSS/BSS Business Analyst Database ORACLE ETL Developer

Java Programming OPP Design Patterns UML Business Requirement Analysis Software Development Life Cycle Functional Testing Adaptability Software Engineering Software Architecture Software Consulting Systems Integration & Upgrade Client Relations Technical Troubleshooting & Reengineering expert • Team Collaboration & Leadership • Communication People-Oriented Approach Collaborative

Languages: PHP PL/SQL SQL Plus Pro*C PostgreSQL SAP ABAP R Software Java C C++

C# Visual Basic AWK Cobol RGP Pascal Spark Weka SPSS COBOL

Databases: MySQL Oracle 7, 8, 8i, 9i, 10G, 11G Microsoft SQL Server Hadoop PostgreSQL and NOSQL

Oracle Tools: Oracle Warehouse Builder Designer & Developer Developer 6/6i Forms / Reports SQLDeveloper

Web: HTML/HTML5, XML JEE JavaScript JQuery JSON AJAX CSS Angular.js Web services (REST and SOAP) Microservices JSP React.js Bootstrap Typescript

Tools: UML/VisualParadigm Eclipse NetBeans SIEBEL Open SmartFlex application OSS-BSS Systems for Telecommunication Utilities Industries SAP WEB DYNPRO Tableau TOAD

Frameworks: Spring/Spring Boot Spring MVC Hibernate ASP.NET, ASP.NET MVC, JSF, EJB, REST, JUnit

SDLC: Rational Unified Process (RUP), Waterfall, Agile, Visio

Platforms: Windows Linux UNIX AIX/SOLARIS

PROFESSIONAL EXPERIENCE

CAREER NOTE: Completed on-campus studies and currently taking distance education courses to complete a EMBA Degree in Information Technology (Authorized to work for ANY employer in the United States, Available for full-time, W-2 employment, I can work 40+ hours on week).

ASSOCIATED CRAFTS & WILLET HAUSER ARCHITECTURAL GLASS (JAM ARCHITECTURAL GLASS INC), Winona, MN 10/2018-Present

The stained glass industry in the United States over the past 120 years belongs to Willet Hauser Architectural Glass Inc. while more recently, Associated Crafts® has contributed to industry innovation.

Associated Craft & Willet Hauser Architectural Glass. has released a Software product re-marketed as http://www.stained-glass-window.us/. Also, We use our Software for proposal and other applications. Located in Winona, MN.

Full Stack Software Engineer: Gathered Information to translate to Business Requirements documents.

Experienced in the manager of Technical Specs, Functional Specs, Business Process Documents, Data Documents/Reports, Training Manuals, User Guides, QA Documents, Use Cases

Analyzed, developed, designed, tested and implemented new requirements/modules.

RODRIGO ECHEVERRY GRANADA Page 2 (C) 641-***-**** *******.*********.*******@*****.*** https://www.linkedin.com/in/rodrigoecheverry/en

Systems management, deploying, securing and upgrading computer instances (Rackspace servers, cloud servers, local servers, network engineering).

Ability to read, analyze, and interpret common scientific and technical journals, financial reports, and legal documents.

Ability to respond to common inquiries or complaints from customers, regulatory agencies, or members of the business community

Designed Blueprints of UI for new requirements

Provided Analysis and Data maintenance information, technical and integration support for key applications

Analyzed, Designed data modeling for key application.

Analyzed data with discrepancies through error files and log files for further data processing and cleansing

Achievements:

Responsible for troubleshooting for Web application “Associated Crafts Willet Hauser http://www.stained-glass-window.us/” and MY SQL databases.

Led integration strategy for Content Management System module, Logging module, User Management module for all Web applications.

Fix Responsive Design for all Web applications.

Experienced in Data Analyst, Problem solving to make decisions.

Implement the software architecture for the company website (PHP, HTML, CSS and JAVA script elements to make the front and back end of the website data driven from my sequal).

Back-end web applications, testing, debugging, commenting and supporting the code (Proposal systems, JAG, Vehicle db, Accounting systems, CMS, Project gallery).

Technical Skills: PHP, HTML/5, CSS/3, Javascript, Apache, Linux Ubuntu LTS 18*V/Unix, Bash, together with MVC Design Patterns. Google & Apple applications (Google Documents, Safari, iOS 9/macOS, Chrome, etc)

CANINEPEDIGREE INC, Bloomfield, IA 11/2017-07/2018

Canine Pedigree Inc. has released a new Pet Industry Software product re-marketed as DogOnWeb.com. Located in Bloomfield, Iowa.

Data Maintenance and Coding Specialist: Gathered Information to translate to Business Requirements documents.

Experienced in the manager of Technical Specs, Functional Specs, Business Process Documents, Data Documents/Reports, Training Manuals, User Guides, QA Documents, Use Cases

Analyzed, developed, designed, tested and implemented new requirements/modules.

Responsible for troubleshooting for Web application “DogOnWeb.com” and MS SQL Server databases

Designed Blueprints of UI for new requirements

Provided Analysis and Data maintenance information, technical and integration support for key applications

Analyzed, Designed data modeling for key application.

Experienced in Data Analyst, Problem solving to make decisions

Analyzed data with discrepancies through error files and log files for further data processing and cleansing.

Experienced in the manager of Technical Specs, Functional Specs, Business Process Documents, Data Documents/Reports, Training Manuals, User Guides, QA Documents, Use Cases

Achievements:

Analysis, design, code, test, and implementation from specifications requirements for Web application.

Conducted the maintenance strategy of analysis of data, track and monitor queries and/or the process on the Database.

Fixed problems in the duplicate data in the Database, Defined control validations in SQL statements.

Developed procedures related to new requirements for the web application in the DB

Technical Skills: .NET, C#, Javascript, MS SQL Server 2008 – 2012, SSIS, Windows Server 2008,

MAHARISHI UNIVERSITY OF MANAGEMENT (MUM), Fairfield, IA 05/2017-11/2017

Maharishi University of Management, formerly Maharishi International University, is an American non-profit university located in Fairfield, Iowa and features a "consciousness-based education" system.

Assistant System Administrator: Capacitated to analyze, trouble-shoot and answer questions accurately regarding the use and functions of the applications systems at MUM.

RODRIGO ECHEVERRY GRANADA Page 3 (C) 641-***-****

*******.*********.*******@*****.*** https://www.linkedin.com/in/rodrigoecheverry/en

Experienced in the research, problem solve and provide timely responses to questions received via telephone calls, email, etc)

Provided web application support (e.g. active directory, sakai, infosys, act, antiviruses, printers, drivers, etc).

Experienced in the research of new technologies (e.g. clouds, security, help desk, ITIL, etc).

Experienced to end-user support (could be field support, classroom support, phone or email support, maintain ownership of caller queries until issues are resolved, etc)

Detailed and oriented ability to multi-task & support multiple priorities.

Executed system and integration test scripts.

Experienced in Software Development Life Cycle (e.g. Analysis, Design, Code, Test, Support) with a strong understanding of software development principles.

Technical Skills: Java, PHP, HTML, CSS, SQL, MS SQL Server, Windows, Linux, Sakai, Infosys, Act, Active Director, Javascript, Angular.

CREAERESOFT, Medellin, Colombia 08/2016-04/2017

Technology and consulting Company specializing in ORACLE-based services and solutions.

Freelance Software Engineering: Gathered Information to translate to Business Requirements documents, Technical Specs, Business Process Documents, Training Manuals/User Guides, QA Documents, Use Cases. Analyzed requirements provided from Transportations and Civil Engineering industry clients.

Designed and developed robust, scalable system integration components under a Service Oriented Architecture in accordance with business needs for a distributed systems.

Developed Web services. Defined and designed Mock up or prototypes for UI and process.

Developed solutions for user stories with troubleshooting skills.

Created test scenarios and deployed the application.

Participated in SCRUM meetings.

Used SCRUM board to pick up user stories.

Work with Agile methodologies.

Achievements:

Design and code from specifications, analyzes, evaluates, test, debug, document, and implement and deploy code for the next project: CIVIL360 CivilWorks Management System for Omega firm, STC Transportation Management System, Payment System for Magallanes firm.

Technical Skills: Java, JEE, JavaScript, JQuery, Ajax, JSON, Angular, MySQL, SQL Server, Spring, MVC, Servlets,

HTML, CSS, SQL, PL/SQL, IntelliJ, Netbeans, taiga, Eclipse, SQL Heidi

MVM INGENIERÍA DE SOFTWARE (MVE SWE), Medellín, Colombia 03/2012-04/2015

Software development company with approximately 200 employees.

Software Engineering Specialist: Gathered Information to translate to Business Requirements documents. Analyzed, developed, designed, tested and implemented functions and modules for OSS/BSS of telecom systems, public utilities, cable television systems, mobile communications systems, computer servers, and ORACLE databases.

Defined and Designed Mockups, prototypes for UI and modules/process.

Provided technical and integration support for key applications.

Analyzed, Designed data modeling for key applications.

Proficiency in data warehousing techniques for data cleaning, and Surrogate Key Generator in the process of loading Dimension and Fact tables.

Supported a Java application (back-end).

Experienced in the manager of Technical Specs, Functional Specs, Business Process Documents, Data Documents/Reports, Training Manuals, User Guides, QA Documents, Use Cases

Achievements:

Led integration strategy for SIEBEL 8.1 application to OSS/BSS System solution “OPEN SMARTFLEX v6+” platform for major Colombian telecommunications company – Client: Une EPM Telecomunicaciones S.A.

RODRIGO ECHEVERRY GRANADA Page 4 (C) 641-***-****

*******.*********.*******@*****.*** https://www.linkedin.com/in/rodrigoecheverry/en

E.S.P. https://www.tigo.com.co/ (https://www.bnamericas.com/company-profile/en/une-epm-telecomunicaciones-sa-esp-une.)

Provided advanced technical support and user interface design for FENIX application in ORACLE platform for large Colombian telecommunications firm – Client: Une EPM Telecomunicaciones S.A. E.S.P. https://www.tigo.com.co/.

Technical Skills: PL/SQL Oracle Java Javascript Angular XML XSLT, XPath .Net Siebel Application CRM UNIX Solaris OSS/BSS System solution “Open SmartFlex application (BSS Billing Module)”. ETL process TOAD tool

OPTIMA CONSULTING, Cali, Colombia 02/2011-02/2012

Technology and consulting Company specializing in ORACLE-based services and solutions.

Consultant: Provided in-depth analysis, design, development, and implementation expertise for OSS/BSS of telecom systems, public utilities and cable television systems.

Experimented in Data Warehouse concepts, ETL process, Reporting solutions for key applications, BI Business Analyst.

Experimented Business Analyst to gather information to translate for BR documents, define Mockups, prototypes for modules/process or UI.

Proficiency in data warehousing techniques for data cleaning, and Surrogate Key Generator in the process of loading Dimension and Fact tables.

Analyzed data with discrepancies through error files and log files for further data processing and cleansing.

Experienced in the manager of Business Requirements Document, Technical Specs, Functional Specs, Business Process Documents, Data Documents/Reports, Training Manuals, User Guides, QA Documents, Use Cases

Achievements:

Provided key analysis, design, construction, QA (testing), and support of OSS/BSS System solution “Open SmartFlex v6+ / v7+ application” in Oracle platform for major Colombian energy company.

Business Requirements gathered, Reporting Solutions and implementation for Business Intelligence project in Oracle platform for Puerto Rico mobile company – Client: Open Mobile - http://www.openmobilepr.com/

OSS/BSS System solution “Open SmartFlex V6+ / v7+ App”: Assisted in development of BSS reports on ORACLE platform for Nicaraguan telecommunications company. Designed user interfaces and led UI integration - Client: Enitel Nicaragua https://www.claro.com.ni/personas/ (https://www.bnamericas.com/company-profile/en/empresa-nicaraguense-de-telecomunicaciones-sa-claro-nicaragua)

Streamlined SIR reporting on .NET application within Oracle Warehouse Builder.

Technical Skills: .NET Java, Javascript Oracle Oracle Warehouse Builder PL / SQL UNIX AIX/Solaris Business Intelligence (BI) Open SmartFlex Billing (OSS /BSS Modules) ETL process TOAD tool

EMPRESAS MUNICIPALES DE CALI (CALI MUNICIPAL COMPANIES), Cali, Colombia 10/2009-02/2011

Public utility company providing energy, water and wastewater services to city of Cali.

Support Engineer: Gathered Information to translate to Business Requirements documents.

Analyzed, Designed and implemented functions and modules BSS.

Performed quality management; analyzed billing process and oversaw cross-order processing.

Defined and Designed Mockups, prototypes for UI and modules/process.

Experimented in Data warehouse concepts, ETL process.

Designed Data Modeling for key applications.

Achievements:

Supported and performed web application construction of questions, complaints and petitions module for OSS/BSS System solution “Open SmartFlex v6+ application (BSS module)” in ORACLE platform.

Technical Skills: PL / SQL .NET Oracle OSS/BSS System solution “Open SmartFlex application (BSS module)” UNIX AIX ETL process TOAD/SQLDeveloper tool.

RODRIGO ECHEVERRY GRANADA Page 5 (C) 641-***-****

*******.*********.*******@*****.*** https://www.linkedin.com/in/rodrigoecheverry/en

OPEN SYSTEM INTERNATIONAL, Cali, Colombia 02/2008-09/2009 and 02/2001-02/2006

Software development firm specializing in technical solutions for utility and telecommunications sectors.

Professional Service Engineer: Gathered Information to translate to Business Requirements documents, design Mock ups, prototypes for modules/process or UI.

Provided expert support of OSS/BSS System solution “Open SmartFlex application” for public utilities and telecommunications companies.

Experimented in Data warehouse concepts, ETL process.

Designed Data Modeling for key applications.

Achievements:

Led implementation of OSS/BSS System solution “Open SmartFlex v6+ application (BSS/OSS modules)” in ORACLE platform for Nicaraguan telecommunications company; supported HD, broadband, wireless, and IP services - Client: Enitel Nicaragua https://www.claro.com.ni/personas/ (https://www.bnamericas.com/company-profile/en/empresa-nicaraguense-de-telecomunicaciones-sa-claro-nicaragua)

Implemented AVANTI billing solution; supported billing process to develop liquidation module and support OSS/BSS System solution “Open SmartFlex application” in Oracle platform – Client: EPM Empresa de servicios públicos de Colombia https://www.epm.com.co/site/ (Note: On 2006 the telecommunications services were separated from other public services. In other words, UNE company was created in 2006).

Provided quality management and technical / functional support to all phases of billing process. Implemented OSS/BSS System solution “Open SmartFlex application (OSS/BSS modules)” in Oracle

platform; developed and implemented FIFA/FIDU printing programs for major Brazilian and Ecuadorian telecommunications firms – Clients: Sercomtel – Brazil – Telecsa and Enitel - Ecuador).

Coordinated major upgrades to Colombian telecommunication firm’s SATPLUS application (OSS/BSS modules) in ORACLE platform; modified and refined FIFA – FIDU printing programs – Client: Telefonica de Pereira.

Technical Skills: PL / SQL Java / JavaScript C Oracle OSS/BSS System solution “Open SmartFlex application (BSS/OSS modules)” UNIX AIX/Solaris Pro*C SQL*Plus AWK ETL process Oracle Warehouse builder TOAD tool

AXEDE, Medellin, Colombia 02/2006-08/2007

Software development company specializing in telecommunications, with approximately 250 employees.

Analyst & Programmer: Gathered Information to translate to Business Requirements documents, design prototypes

for modules or UI. Performed analysis, design, and implementation of functions and solutions for BSS systems.

Developed integrity systems according to a business needs.

Experienced in Data Analyst to execute scripts to retrieve information to be analyzed to find metric, insight and root cause problems.

Experienced in ETL process tointegrate and/or define DW, BI Analyst systems on the client.

Achievements:

Customized OSS/BSS System solution “Open SmartFlex application” in ORACLE platform for Colombian public utility; oversaw technical and functional support of all phases of billing (BSS), security, and service processes. – Client: EPM Empresa de servicios públicos de Colombia https://www.epm.com.co/site/ (Note: On 2006 the telecommunications services were separated from other public services. In other words, UNE company was created in 2006).

Led quality management for AVANTI implementation and testing of OSS/BSS System solution “Open SmartFlex application” for Colombian public utility Company – Client: EPM Empresa de servicios públicos de Colombia https://www.epm.com.co/site/ (Note: On 2006 the telecommunications services were separated from other public services. In other words, UNE company was created in 2006).

Technical Skills: PL / SQL C Oracle OSS/BSS System solution “Open SmartFlex (BSS module)” UNIX AIX/Solaris Pro*C SQL*Plus AWK. ETL process Oracle Warehouse Builder TOAD/SQLDeveloper tool

EDUCATION

EMBA Information Technology

(In Progress Via Distance Education; Expected Completion June 2021)

Ottawa University, Brookfield, Wisconsin

Master of Science in Computer Science

Completion June 22, 2019

Maharishi University of Management, Fairfield, Iowa

Key Courses: Fundamental Programming Practices, Modern Programming Practices, Big Data Analytics, Advanced Software Development, Web Programming, Algorithm, Software Engineer, Project Management, Web Application Architecture WAA, Database Management Systems (DBMS)

Bachelor of Science in Systems Engineering

San Buenaventura University, August 2003, Cali, Colombia

ACADEMIC PROJECTS (2019-2021)

Projects completed at Ottawa University include:

• Database Architecture & Design, Human Resources (HR) Employee Management System, 06/2019-08/2019: I'll to develop a database from the ground up, including the conceptual modeling design, entity relationship diagram (ERD), logical modeling design, relational schema, physical modeling design, Structured Query Language (SQL), Database Management Systems (DBMS), and implementing the DBMS.

Academic Projects (2015-2017) completed at Maharishi University of Management include:

• Web Application Programming, Voting System, 06/2019: I developed a Voting System web application using the technologies such as HTML, CSS, JavaScript, JQuery, Ajax, MVC model, Servlets, JSP. The search operation was developed using Ajax and JSON.

• Web Application Programming, Car Pooling, 04/2017: I developed a Car Pooling web application using the technologies such as HTML, CSS, JavaScript, JQuery, Ajax, MVC model, Servlets. The search operation was developed using Ajax and JSON.

• Project Management Project, E-Bazaar Online Shop Store, 10/2016: I developed an Online Shop web application based on the SAP WEB DYNPRO and SAP ABAP.

• Software Engineer Project, Online Shop Store, 07/2016-10/2016: I Developed an online shopping web application following the principles of Rational Unified Process and Software Engineering. I used Java and UML.

• Big Data Analytic Project, Importance of Health to Generate Income, 05/2016-06/2016: I applied tools and practices in the application of data analytics in health care to generate income. I performed information gathering and analysis to draw valid conclusions. Using tools and techniques with Excel, R software, Weka, SPSS

• Web Application Programming, Dictionary Enquiry, 03/2016-05/2016: I developed a Dictionary Enquiry web application using the technologies such as HTML, CSS, PHP,JavaScript, JQuery, Ajax, Spring framework, Servlets. The search operation was developed using Ajax and JSON.

• Banking System Framework, 01/2016-02/2016: Java project for banking and credit card processing systems. Created class diagrams for both systems. Developed frameworks using a variety of design patterns, including Command, Factory, Observer, Strategy, Singleton, Composite and MVC.

• Library Management System, 06/2015-12/2015: Implemented a Project through design, coding and testing of a feature rich Library system enabling addition of books and library members, check out of materials and tracking of activity history. Formulated UML diagrams. Develop using Java, JavaFx, Eclipse.

Contact this candidate