Leonor M Rivera Email & Phone Number

Metairie, La, Us

Atlanta, Georgia, Us

Microsoft SQL database administrator (DBA) with hands-on experience in administration, performance tuning, monitoring, high availability solutions and maintenance of SQL databases. Part of the team responsible for the development, database security, improving database performance.• Managing SQL Server user roles and access controls• Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.• Developing backups, restores and recovery solutions.• Configuring High Availability (HA) and Disaster Recovery (DR) options for SQL Server• Setting up and monitoring Replication (Snapshot, transactional)• Implementing best practices for data file placement • Setting up and Monitoring Database Mirroring • Monitoring the health of the database servers (production, dev, deployment environments)• Analyse, troubleshoots and configures SQL Server systems issues

SABBATICAL, Atlanta, GA Feb2017-August 2017While taking care of a member of my family I took the following certification and training• Microsoft MSQL Server 2016 DBA Certification • Tableau Desktop Associate 10.5 Certification • Data Analysis and Visualization Training• SAP BI/SAP BO Web Intelligence Online Training• SAP BI Data Warehouse Developer 7.4• MS Excel Advanced Training• MS Access Training• AGILE SCRUM training

Atlanta, Ga, Us

Work on projects in the areas of Business Intelligence, Data Analytics, and Data Visualization while consulting with Data Analysts and Business Users, translating business requirements into technical solutions. Exposure to HANA Studio and work with BW 7.4 on HANA.Using Alteryx for data cleansing and BI Tools( Tableau, BODS, Analysis) to perform Analysis and Business Intelligence functions using Agile Methodolgy.• Because of the Acquisition of 12 new Business Units, a need of integrating all Inbound and Outbound data from this new Business Units to the Newell Model was raised. Our team extracted all the information from several Instances using SAP ERP Systems, we gathered and transformed the information and create a model using ALTERYX and finally load the transformed data into SAP Data warehouse and use TABLEAU for data visualization. Using BODS, Analysis and BW on HANA for reporting.• Delivered a Global Report and Dashboard Solution in response of the need of have an accurate and dependable Inventory and Demand Report that consolidate and standardize monthly data from the 20 Business Units located in different part of the World by extracting data from different sources, transforming the data and loading into the Data warehouse where different cubes and data containers were used to model the data.• Developed, tested, implemented, and modified Business Intelligence reports deployed analytical and dashboard solutions based on documented business requirements and expectations for Supply Chain, Financial, and Sales and Distribution teams.• Help to identify and develop innovative tools for enhanced analysis or data presentation to improve decision making and performance. • Provide clear and accurate reporting for various areas of the business using Business Intelligence Tools reducing Analysis Time and incrementing Productivity.

Monterrey, Nuevo Leon, Mx

• 6+ years as Certified SAP BW Consultant V7.Expertise SAP /Business Objects Tools (info view, web intelligence, Universe Designer) Responsible for BW DataWarehouse maintenance and troubleshooting. Expertise on Query Designer, BEX WAD, and Business Explorer.Strong knowledge and expertise in DATA Extraction ETL process for custom extractors, processes for SAP R/3 data sources. Expertise in Modeling on SAP BW, info cubes, multi providers, DSO and master data. Business Objects WEBI.SQL BI, Agile and Six Sigma Lean Methodologies.

Issy-Les-Moulineaux, Île-De-France, Fr

SQL Server Database Administrator part of the DBA Team responsible for maintaining and supporting the organization’s database servers. Ensuring database servers and systems are running efficiently and effectively on a daily basis.Performed DBA duties including database backups, restores, performance tuning, and capacity analysis• Creating Databases in all environment, Troubleshooting, defragmentation of objects and databases• Managed the products and development, Test and Production databases, performance tuning, capacity planning, SQL Server Replication, database security configuration, and database continuity• Troubleshoot databases and custom application issues. Assisted in the design, coding, testing and implementation of SQL databases instances

Bachelor Of Engineering (Beng), Electrical, Electronics And Communications Engineering

Education record