SOFTWARE ENGINEER / DBA

• Hands-on technologist and accomplished Software Engineer with five years of professional experience in different areas of software engineering, leveraging Java and OOP in the full life cycle of the software design and development of information systems critical to business operational performance.
• Improved market research for various clients by developing CRM tool for data mining and business intelligence.
• Robust experience ensuring data integrity, conducting web analytics and enhancing data reporting.
• Strong hands on Databases Design Relational Model, E-R Diagram, 3NF using MSSQL and MySQL.
• T-SQL, SQL, Stored procedures.
• Strong applied knowledge in ETL.
• Solid analytical skills including the ability to identify problems, collect data, establish facts, and draw valid conclusion.
• Excellent relationship building, communication and interpersonal skills.
• SDLC Java Programming OPP Design Patterns UML
• Database SQL ETL Backup and restore Relational Model Implementation
• Reporting CRM Web Analytics Email marketing
• Collaborative Approach Issue Resolution Communication Adaptability Detail-Orientation
• Languages: Java, C
• Web: PHP, HTML, XML
• Databases: MSSQL Server DDL-DML , SSRS, MySQL, Microsoft Access
• Tools: SQL Server Management Studio, Microsoft Visual Studio, MySQL Administrator, MySQL Workbench, SQL Developer, Crystal Reports, SugarCRM, Google Analytics, Adobe Marketing SiteCatalyst Omniture , Silverpop, Visual Paradigm, Rational Rose, Eclipse, NetBeans,
• Platforms: Windows XP / Server
• Networks: Windows NT

PROFESSIONAL EXPERIENCE

Confidential

Leading creative advertising agencies with major clients including McDonald's, Nintendo, Kellogg's, and Allstate.

Database Analyst / DBA

Accountable for all phases of the database life cycle DBLC and data analysis of the different major Company Clients. Headed client database research, analysis, and database system improvement. Assist development teams to ensure the correct data access and modification into application programs.

Responsibilities:

• Requirement Analysis, Database Design/implementation/Management
• Performed Database Tuning and data mining tasks.
• Created/analyzed statistical reports and Customer's KPI across campaigns.
• Designed and implemented Stored Procedures
• Added functionality to existing tools and created backups and restore routines.
• Provided Database support and communicate new changes with developers and software architect.
• Understand client's requirements and give support in report creation/generation.
• Managed SugarCRM, cleaned and standardized data loaded into the CRM, updating the information stored in the CRM to maintain the data integrity and wrote different types of reports.
• Using ETL techniques/tools, migrated the data and verified consistency in the migration.

Key Projects:

Samsung's Customers Database: Led the requirements, analysis, logical/physical design, implementation, monitoring, modification, maintenance and reporting phases of two major databases that significantly enhanced efficiency and operational processes at Samsung Colombia.

Confidential

Led the Confidential Morris campaigns database creation from requirement to implementation, helped the client to identify and to translate its business needs and technical requirements into a concrete and solid data store and write regular reports of each campaign.

Confidential: Accountable for Database centralization and ETL for all Chrysler's dealerships across the country.

Toyota Clients and Transaction Management System: Responsible for creating/maintaining tables, triggers and stored procedures that enabled Toyota to launch a loyalty and rewards campaigns for attracting and retaining new and existing customers. Led the ETL Migration Process .

Key Highlights:

• Exceeded client's expectations by skillfully managing all aspect of the database, creating reports and KPIs which gave insight about the clients and their preferences This supported the company on taking critical business decisions.
• Due to the high quality results and performance of de configuration Implementation of CRM System, I received special recognition from Samsung's headquarters.

Confidential

National emergency telephone number, equivalent to 911.

Software Engineer

Led the process/project of enhancing the real time tracking system in the district from scratch to the point to get all the systems up and running Analyzing and getting insights from data using balance score card help us to take decisions that resulted in a well efficient and optimal solution that helped to dispatch units and take issues to resolution in a shorter period of time.

Responsibilities:

• Develop Information Systems according to the needs of the Emergencies Line
• Requirement Analysis, Database Design/implementation.
• Performed Data mining/Analysis task.
• Created/analyzed statistical reports and operator's KPI.
• Manage operators in the emergency office 30 persons under my supervision
• Sing documents/reports that made me accountable of the veracity of the data.

Key Projects:

Real Time Tracking System Improvements:

• Established the process of collecting requirements to define OPIs Operator's performance indicators .
• Created a website to visualize office performance at team/individual level.
• Created an End to End application Database, business Logic and UX to register and keep track of every emergency call.
• Generated reports/KPIs that helped to pinpoint bottleneck and root cause in delays and misunderstanding from different units Police, ambulance, firefighters

Key Highlights:

• Generated reports that were sent to the Mayor office and were important piece of information in budget/cost discussions.
• Created OP Operator Performance system, which tracks, evaluates and display performance of any operator, the system was successful to the point that efficiency and operators score were impacted/improved positively over time.