Luis Lima Email & Phone Number

Alpharetta, Georgia, Us

Portland, Maine, Us

Responsible for managing the operations of the database engineering team, responsible of the database administration and database development. Responsible for setting the database strategy and delivering a scalable and reliable data platform that supports our payment platform and other Applications. Provide leadership designing and implementing new databases for new systems and oncoming applications, execute database strategies to provide secure, high availability and high-performance environments.Maintain direct communication and relationships with key stakeholders in order to keep current with the direction of the business and the needs of the customers.

Portland, Maine, Us

Ensure that the database infrastructure is highly available and secure. Participating in daily quality assurance and development project work.A few of the notable accomplishments:• Created a database architecture that was highly-available as well as optimized our SQL Server licensing model to avoid out-of-compliance costs while improving our disaster recovery capabilities• Migrated infrastructure and upgraded SQL Server components to be on the latest Microsoft versions• Improved the speed of transaction processing (PreAuths 10x & Completion 20x faster, Monthly letters 18hrs to 3.7hrs) though upgrades and tuning• Hardened security though waves of changes and improvements specific to our SQL Server instances, in line with PCI data security standards• Built out data warehouse and BI platform including Integration and Analysis Services• Supported all development and system initiatives• Designed, Developed and Deployed an Automated Monthly Billing system - eliminating manual and sometimes inaccurate processing that where in existence for years.• Supporting a successful build out of Host.net as a DR facility.• Supporting a successful migration of Rackspace DC's• Re-architect/re-organize database models for various systems (such as billing) and initiatives (such as FleetCor)• Continuing to enhance security by working with the development team and reforming how applications access database resources.• Built Oracle database management skills to support on-premise loyalty infrastructure• Continuing to support BI projects as well as Consumer Engagement and Marketing Initiatives.

Ciudad De México, Distrito Federal, Mx

As part of the Architecture Department of Edenred Mexico I had the responsibility to design new databases solutions and develop new applications to improve the automated business processes. Review new T-SQL codes for new applications developed by the existing development teams as well as provide recommendations for best practices. I reviewed SSIS packages and RDL codes for performance enhancement. Provide technical support in critical situations in order to ensure the continuity of services.I created and set in play a new monitoring process for the fraud prevention department. That solution is an Incremental ETL process focused on capturing possible malicious transactions. By implementing this new process I help the fraud prevention department to dramatically increase the efficiency the monitoring transactions. This solution was created on SQL Server Integration Services (SSIS).I developed an application for translate information between middle office systems and different authorizers. This application was focused to improve the card approval process, payments and charge of cards. With this improvement we achieved 30% increase the daily transactional load of process. Tools: SSMS, SSIS, SSRS, SSAS, Visual Studio, Team Foundation Server

Mx

In this company I have been worked in Operations Deparment. I was responsible for installing and configuring SQL Server Instances into PROD-QA-DEV environments, responsible for monitoring and performance tuning. I performed upgrades and migrations, design and create Solutions for high availability and Disaster Recovery. Review new codes for new applications. I have deployed and configured multidimensional models and Tabular models in order to provide a suitable environment for generating reports.I documented the standard for T-SQL codes. Focused on using best practices and clarity in writing code.I implemented a security scheme based on Database Encryption by certificate. I implemented Transparent Data Encryption (TDE) to encrypt confidential assets and ensure a secure system.I configured SQL Server Failover clustering and AlwaysOn to support multiple databases in clustered environments for ensuring continuity of services in case of critical problems such as downs of nodes, electrical problems, etc. I configured Database Replication for some Databases. This configuration was focused to decrease the high transactionality and provide other options for reporting applications. Tools: Microsoft SQL Server 2012, Oracle 11g, 12c, TOAD, OAS, Application Managers

Analysis and design of database model. Microsoft SQL Server administration to support multiple databases in both clustered and non-clustered environments with replication. I was responsible for managing and developing of (SIGREX) Automated control system for rental cars. This system contains 6 Subsystems (Business, Sales, Operations, Fleet, Workshop, and Informatics). Management and Programming of Invoice System. Management and Programming of www.rex-rentacar.com reservation module. I implemented distributed databases with Merge Replication. This configuration was created to support the (SIGREX) Computer system. I installed the Publisher and Distributor on Central Server located in Main Office in Havana and 22 Subscribers in all country. I created a process to transport sales information from REX to TRANSTUR. With this process the business group (TRANSTUR) kept up to date statistics on sales.

Application developer for BPA (Banco Popular de Ahorro).Responsible for the development and maintenance of 5 subsystems of the banking system. Develop new applications for BPA (Banco Popular de Ahorro). Performed databases integration and analysis on existing systems. Design and Modeling Database for new solutions. Perfomance tuning for query optimization before to apply into productions server.