Luis Paniagua Email & Phone Number

Strategic ConsultingDatawarehouse Consultant Database management SQL, Oracle, SAP, IPCProject Manager Activities & Development

Monterrey Area, Mexico

- BI Implementation Project for BANORTE Generalli through QlikView including Analysis, Design, Development, stabilization, definition and improvements to new and existing reports over SQL and ORACLE.

- Rollout Project for Vitro Colombia, Brazil and Bolivia; managed of the reports, end-user roles and assignation heading for a transparent go live. Since January to March 2011.- Operation Support for BW/BI/BO all over VITRO and in the main areas of SRM, Supply, PP, SD, Maintenance, Sales, and Inventory. Since January 2010.- SAP-BW/BI/BO VITRO project; involved on all aspects BBP’s (Business Blueprint) and BPP (Business Process and Procedure) over Finance, logistic, Inventory with COPA, SD, FIGL, SRM, MM, FICO, RH, APO; Since January 2008- BW Implementation, Business Content activation, Data source replication, Info sources Assignment, Routines, Update rules, Process Chain loads, Generic Data Sources- Adherence analysis for activated Cubes requirements, integrate information from R3 and SRM; Report Generation (BEx & Web queries); Operation Support

- ETL process project over NEORIS, all 2007- Information Generation from AS/400 DB from JDE for the process with AS/4000 access over JDE Databases for the processes and repositories of Desk Group.- Management of Historical Data Consolidation Project; involving over 40 different CEMEX companies and Databases such as Fortran, Oracle, SQL, Access, FoxPro, DB2, Ownership databases between others and have them consolidated into a single repository having the final data de-normalized and ease of use, administer and manage for historical information needed

- Management of Data Warehouse Projects, served as project leader for the development and deployment phases- Coordinated scripted on-site tests with vendors and drafted all technical documents (Single Unit Testing, IST and UAT)- Incorporated business new areas such as Mortgage, Auto, GE Money and Retail into the Data Warehouse ODS Layer, and subsequently into Data Marts therefore Business Objects Reports.- Served as SPOC (Single Point of Contact) on Mexico for Global initiatives regarding Global DW projects, technical lead for the project, and implementation of the initiatives. Features included support, business involvement, analysis, coordinating local efforts and resources from the business with corporate and Risk down to the vendors.- Build a Data warehouse Team (Business Objects, Informatica, DBA-Oracle)

- Stabilized and prepared Sales Interface tool for Insurance purposes; 3rd Party vendors automatic load to SI sales; define and improve new & existing reports. Improve and clarify the process having a client complain reduction in about 20%. From CICS (V+) into Web sphere.- Setting and keep track of FICO Score System to reduce fraud risk 5-10%- Developed and implemented a temporary solution for Risk Management System. Strong tuning process with the Business Units involved getting the final layout up and running.- Part of "Actimize" and “Falcon” Team working on the initial process to reduce Money Laundry on about 10-15% on the Business Units of Retail, Auto, GE Money (Bank Cards & Personal Loans) and Mortgage.- Part of Bridger Team; application that allows us to screen our customers and suppliers on watch lists.- Coordinate Data warehouse projects

- One year trying to be auto sufficient; Analysis, Design and Development of Information Systems for individuals, stand alone and build companies.

- Three years of experience in teamwork Analysis, Design and Development of Information Systems for stand alone and remote systems as a professional; working with MS Access and Visual Adelia.- Technical and computer systems support for users of AXA-Yazaki as a Team Project Leader Analysis System Engineer.

- Teamwork Analysis, Design and Development of Executive Information Systems (EIS's) for stand alone and remote systems as a professional.- IT Consultant for ESSsalud (Peru). Development of a new Executive Information System (front and back end construction), using Pilot Analysis Server, Pilot Designer and Pilot Internet Publisher. Technical and computer systems support for users of ESSalud as a Team Project Leader Consultant System Engineer. - Design and Development of an Executive Information System for Petróleos Mexicanos (PEMEX). Team Project Partner Consultant System Engineer.- Analysis, Design, Development and Management of a Executive Information System for Vector Casa de Bolsa (Vectormex, Incorporated). - Analysis, Design, Development and Management of a Executive Information System for CYDSA. Technical and computer systems support for CYDSA. As a Consultant Senior System Engineer. - Analysis, Design and Development of Prototypes for Potential Customers (QUIMOBASICOS a Company of CYDSA, TELMEX, Vector Casa de Bolsa, AXA). Back-End Support for our partners down in Mexico City with clients such as BANRURAL, and Sales del Itsmo (a Company of CYDSA).- Development of a Executive Information System for Sigma Alimentos. Part of a team of developers of an Executive Information System. Computer systems support for users of Sigma Alimentos as a Trainee. - Some additional issues in all of the projects: Interviewed users, analysts, managers, and executives to plan and report project advances; Directed teams of 2-5 people, delegating according to required skills and project complexity; Coordinated application testing; Prepared project documentation for quality assurance purposes, and user guides.- Six months of experience in teamwork, Analysis, Design, Development and Management of Hand Held Computer Systems as a trainee.

Isc

Activities and Societies: - Presidente de la Mesa Directiva de Ingeniero en Sistemas Computacionales; a su vez miembro del Comité.

Education record

Education record