Summary of experience and skills

• Over 17 years of combined experience in software development, database development, project management and Information Management.
• Knowledge in several areas such as Healthcare, Insurance, Financials/Banking, Transportation Management System TMS, Telecommunications, Services, workers' compensation, Environment, Marketing, Manufacturing, and Retail, among others.
• Extensive experience in all phases of software development life cycle - SDLC- including coding, testing and debugging, modifying existing programs, writing and maintaining user documentation.
• Thorough understanding about Scrum, Agile and Waterfall project management methodologies.
• Significant experience in Business Process Management and Management of Innovation.
• Knowledge about Capability Maturity Model Integration -CMMi- process and ITIL.
• Proficient in English and Spanish.

Professional Experience:

Confidential

PowerBuilder Software Developer

• Migrated PowerBuilder application for Johnson Controls Inc -Automotive Division- from version 6.0 to 10.5 and the database from Oracle 8.0 to 11g.
• Migrated PFC 6 to version 10.5.
• Development enhancements to PowerBuilder application in PB 10.5.
• Troubleshooting and remediating all application issues.
• Data analysis and ad hoc reporting.

Confidential

Software Developer and Analyst

• Analyzed, designed and programmed two applications for Technology Foresight and Competitive Intelligence using Power Builder 12.5.x with Oracle 11g and VB.Net with SQL Server 2008.
• Designed database model, graphic interface, reports and audit trails/logs, among others.
• Created web services in PowerBuilder 12.5 that connected to a Competitive Intelligence application utilizing external web services, using .NET C .
• Designed and developed system test plan.
• Worked on version controlling PBLS using Version Controlling Systems of PowerBuilder.
• Created new visual and non-visual objects for application functionality.
• Applied the SDLC for application development.
• Occasionally contacted customers as needed to clarify the intent of new features or to resolve issues.

Confidential

IT Consultant

Software Consultant

• Performed business analysis and created requirements and functional documents.
• Maintained, extended and migrated several applications written in PowerBuilder 4.0, 5.0 and 6.5. to PowerBuilder 10.
• Created and maintained new and existing visual and non-visual objects for application functionality.
• Designed and coded an interface between PowerBuilder and Microsoft Office.
• Incorporated a corporate framework library between the PFC and PFE layers of the PowerBuilder Foundation Class library.
• Produced reports in Microsoft Project for resource planning, allocation and follow-up.
• Reengineered application processes to accommodate for differences in database engines and T-SQL language.
• Defined and implemented a version control process.
• Defined and implemented a software quality assurance process.
• Created testing documents.
• Designed and developed Packages, Stored Procedures and Functions for application functionality with PL/SQL.
• Trained and mentored team members on PowerBuilder and Object Oriented programming and concepts.
• Consultant on Technology and Innovation Management, and Management of Information Security
• Reviewed plans, agendas and studies related to Science, Technology and Innovation for Medellin, Colombia. Emphasis in the sector of Information Technology.
• Diagnosed and implemented ISO 27000 process for clients of Alta Gestion Empresarial, consulting company.
• Diagnosed the status of Information Security process, based on ISO 27000.

Confidential

Project Manager

• Managed and successfully completed over 15 software projects in the following areas: Healthcare, workers' compensation, Insurance, Financials, Transportation, Telecommunications, Services, Environment, Manufacturing and Retail, among others.
• Produced reports in Microsoft Project for resource planning, allocation and follow-up.
• Created time and cost estimates for the project
• Established the projects timelines and development responsibilities for teams of 5 to 20 developers.
• Planned, designed, developed and implemented several software projects that support business organizations using PowerBuilder 7 to 10, Java, and .Net languages as well as Oracle, SQL Server, MySQL, DB2, and SYBASE as databases.
• Documented and developed the business rules for the application.
• Performed business analysis and created requirements and functional documents.
• Migrated legacy applications from FoxPro to PowerBuilder.
• Migrated applications from PowerBuilder 6.5 / 7 / 8 to PowerBuilder 9 and 10.
• Created and maintained Stored Procedures, Packages and Functions.
• Designed testing requirements and procedures. Tested applications I developed and managed.
• Trained and mentored programmers on PowerBuilder, Oracle, SQL Server and PL/SQL.
• Assisted with Database Administrator duties such as creation of objects in the database and data modeling on Oracle, SQL Server, MySQL and SYBASE.
• Led Decision Analysis and Resolution DAR and Project Planning PP process areas for CMMi level 3 appraisal.

Software Developer and Analyst

• Designed and developed over 10 applications that support the core business of the most important workers' compensation company in Colombia, using PowerBuilder 4 / 5 / 6 / 7 / 8 with Oracle 7.3 / 8i / 9i. The database had more than 1000 tables.
• Designed and implemented an IS09000 complaint corrective preventive action system for a leading workers' compensation company in Colombia.
• Performed maintenance and enhancements to several applications of the most important workers' compensation company in Colombia.
• Migrated over 20 applications between PowerBuilder versions.
• Documented and developed the business rules for the applications.
• Analyzed, designed and developed Packages, Stored Procedures and Functions for application functionality with PL/SQL.
• Wrote custom reports in support of the applications that included nested and composite reports.
• Designed testing requirements and procedures. Tested applications I developed.
• Designed and developed the standard PowerBuilder application for the developments made by AVANSOFT.
• Created new visual and non-visual objects for application functionality.
• Served as lead PowerBuilder developer.
• Assisted with DBA duties.

Technical Skills:

• Programming Languages: PowerBuilder 4.0 to 12.5, PowerBuilder .Net, C .Net, VB.Net, PL/SQL and T-SQL.
• Power Builder Foundation Class libraries.
• Database: Oracle 7 / 8i / 9i / 10g / 11g, SQL Server 2000/2005/2008, Sybase, MySql and DB2.
• Database Tools: Oracle SQL Developer, Microsoft SQL Server Management Studio and TOAD.
• Business Modeling: Power Designer 6 / 7 / 11, Enterprise Architect, Erwin and Visio.
• Reporting: Oracle Reports, SQL Server Reporting Services and InfoMaker.
• Version Control: PB Source Control, TortoiseSVN, VisualSVN, Visual Source Safe, Clear Case and PVCS.
• Management: Microsoft Project.
• Creation of Triggers, Functions, Packages, Stored Procedures and embedded SQL.