CESAR FERNANDO PERDOMO

*** ****** ******, *** ** acw35b@r.postjobfree.com Webster, Ma 508-***-****

Summary

Senior analyst programmer with more than ten years’ experience in major insurance companies with strong knowledge in the internal company processes.

Skills include software development to create and implement insurance products for different line of business in multiple projects for several states.

Extensive experience in Software Development Life Cycle from the requirement analysis stage until tests, evolution or software enhancements.

Vast experience in implementing massive treasury processes and integrating them to support Business Company with software development methodologies for Insurance and Banking clients.

Technical background leading software development projects for massive billing process and massive collection of receipts with different collection methods and integrate them with several banks. EFT processes.

Analysis, design, development and implementation of computing solutions from the needs and requirements of the areas used.

Ability to translate project requirements into detailed system/program requirements, to include providing alternatives, recommendations and assistance to management.

Strong knowledge in accounting entry processes and reconcile and validate the data in reports or interfaces to consolidate in data ware house platforms or ERPs.

Technical Skills

Programming Languages: Oracle PL/SQL, SQL Server, Java, .NET, HTML, XML, Crystal Reports, JavaScripts, Web services, HTTP, FTP TCP/IP, PHP

Databases: Oracle, SQL Server

Operative Systems: Windows, Unix

Application Server: Apache, IIS

Methodologies

PMI

Professional Experience

Mapfre Insurance USA April 2012-Present

Technical Lead / Analyst Developer

Responsible For:

Provide technical expertise in the technology insurance platform, specifically for the treasury module providing guidance and support in the design, development, construction and tests for the implementation of new insurance products like Arizona Property, Pennsylvania Property Dwelling Fire, Florida Personal Umbrella, Personal Lines, and Commercial Auto Garage.

Knowledge transfer sessions for the analysis and implementation of technical solutions to the different issues or defects in the treasury module in the core insurance application. Formulate technical solution to solve business problems and proficiency in creating functions, procedures and packages in Oracle PL/SQL.

Participate in the gathering requirements sessions and create and develop technical detailed documents to help in the development and implantation of new line of business for the company.

Conduct explanatory meetings regarding the definitions and requirements of the user areas. Collaborate with experts, stakeholders to understand requirements and process.

Conduct technical research over the Oracle database in order to identify wrong data or bad performance in the batch processes.

Provide technical support and guidance creating or updating Oracle databases objects during the development and testing phases.

Create and adjust billing, cancellation policies and accounting entry processes according to the business rules for each line of business and provide post implementation support and on-going production support.

Participate like a key technical member in projects like Agency compensation OFAC (Office of Foreign Assets Control), Enhance Billing Portal for Agents Project, EFT for National commercial Lines project.

Provide status report information to Project Manager following agreed upon guideline including key activities, upcoming milestones, potential risks and impacts, and issues requiring the attention using Agile Methodologies.

Environment: Oracle PL/SQL, Web Services, FTP, Eclipse - Java

4Sight Technologies Colombia May 2011 – April 2012

Senior Analyst Programmer

Customer Mapfre Insurance USA

Responsible For:

Analysis, survey, documentation and development of information systems requirements specific to the company's projects.

Identify requirements and their viability specifically in treasury area.

Implant and verify the development and solutions approved, guaranteeing correct functionality in the production environment.

Estimate effort and develop and document technical detailed requirements.

Compliant with the development standards and good programming practices.

Work with configuration management tool in order to control different versions of concurrent databases objects into the several projects.

Organize and conduct tests that permit validation and verification of proper functioning of the software solutions.

Environment:Oracle PL/SQL, Web Services, FTP, Eclipse – Java, Dot Project. Project Management tool

Mapfre Insurance Company Colombia October 2006– April 2011

Senior Software Analyst

Responsible For:

Development and modification of programs in Oracle PL/SQL for the core information system specifically in treasury module.

Analysis and design massive processes to manage and improve the requirements requested by internal customer.

Development of reports in Crystal Reports, support and maintenance the management system for paying the policies to the company.

Fine tune developed programs guaranteeing best performance.

Analyze and validate data for accounting entries.

Analyze, validate and reconcile data for data warehouse.

Develop routines that permits validate the database to guarantee the integration of data the registers the developed programs.

Environment: Oracle PL/SQL, Java, Crystal Reports, FTP, Eclipse – Java

AON Risk Services Colombia July 2002–September 2006

Systems Analyst

Responsible For:

Manage SQL databases, support of the company's own applications.

Develop, implement and support of information systems with databases in SQL Server and Oracle for the marketing products with several clients banks. (Bancafe and Santander Bank)

I was also responsible for the design and implementation of interface files with banks.

Development of views or reports of databases, according to business needs.

Development of data migration processes of insurance between different technologies platforms.

Integrate data from different data bases and different banking platforms.

Analysis, design, development and support for massive EFT process.

Environment: .NET, Microsoft SQL, Visual Basic, Tomcat, Crystal Reports PL/SQL

Education and Certifications

Project Management Institute PMI July 2015

USA, Worcester MA

Project Management Professional Certified (PMP)

Universidad el Rosario April 2012

Colombia, Bogotá

Project Management Systems.

Pontificia Universidad Javeriana July 2002

Computer Science Engineer

9/26/2016

Contact this candidate