Hide Notes 

Slide 1: Africa 17 B Col Deportiva Fracc. El Cazahuate Jiutepec Morelos. Mobile +52 998-1391-458 House +52 777 3093932 eM@il: tigre-alfa@hotmail.com Ricardo Milla Gonzalez BI & ETL Consultant Summary Qualifications Bachelor Degree in Computer Science Six Sigma (Certified – Green Belt ) PMP (pursuing). Clients: Business & Management Skills Project Management ITIL V.3, CMMI 5 Risk Management Company Country Industry Bank Of America USA US Banking Projects 8 Team Lead Skills -Able to lead others in high-demand situations -Able to prioritize team activities -Culturally sensitive and International leader DELL USA Information Technology 4 EDS MEX Information Technology Information Technology 6 FS USA 3 -Empathetic listener and persuasive speaker -Developed troubleshooting skills -Experience managing cross-functional teams Highlights Technical Skills yperion 9 acle 11i BI: Webfocus 7, Business Objects, Hyperion 9 BD: SQL Server 2003, Teradata, Or cle 11i ETL: Data Stage 7.1, 8.0 Languages: .Net, Html, Xml, Css, J vaScript avaScript Modeling Tools: Rational Rose, Erw in 4.1, WebServer: IIS, Apache, Weblogic in 4.1, Visio S.O.: Windows 2003 Server, NT, S aris 10 Mainframe olaris 10 Social Networks: SocialGo Data Mining: PolyAnalyst, SAS Enterprise miner -Jacksonville ( USA ) Implementing and Design the Jr DTL Program for Enterprise Technology and Delivery. Trainning to the ETL Team on the Data Stage Tool. -Austin TX ( USA ) Implementing and Design the ETL Components for Manufacturing Equipment and the Executive Reports for CEO and Managers with the BI Tools. Page 1
Slide 2: Africa 17 B Col Deportiva Fracc. El Cazahuate Jiutepec Morelos. Mobile +52 998-1391-458 House +52 777 3093932 eM@il: tigre-alfa@hotmail.com Professional Experience Company: Job Position: Place: Activities: AMERICA MOVIL (TELECOMMUNICATIONS) Application Manager BI México, D.F., Chile JUL 2010-MAR-2011 • • • • • Establishment of the corporate technological strategy, to analyze and get key indicators, creating a Management Information System (MIS) for the CEO, CFO & COO of the group; through the use of a BI platform – Hyperion –. Establishment of a standardized structure of information, designing and building IT solutions to analyze and exploit information for corporate office and subsidiaries in Latin America & U.S. Technical and functional support to subsidiaries of Latin America & U.S. Reduction of time in Financial Closing Process and Metrics on Revenue Assurance Process with HFM. Design, development, implementation & support to the Corporate Dashboard to manage the Revenue Assurance Process. Establishment of fundamental process for SOX compliance for the Corporate Finance Office. Project Management & budget administration, proactively tracking to manage projects. • • Strengths: • Strong experience managing financial information: P&L, Cash Flow, Corporate Debt, Planning and Forecast scenarios. • Flexibility and adaptation. • Drive and impel changes. • Improve and take advantage from the available resources. Company: BANK OF AMERICA ( US BANKIING) Jan 2010-Jul 2011 Job Position: Contractor Place: Jacksonville Florida Activities: Responsible to Implement the Hyperion Applications. Software Installation of Hyperion on Server and Client Applications. Responsible to Redesign Process and Create and Manage Applications on HFM and Hyperion Planning. Support of the Hyperion Applications for the Human Resources Department and Financial Department. Project Management. Strengths: • Synthesis to obtain results • Planning and strategic skills. • High capacity to respond under Page 2
Slide 3: Africa 17 B Col Deportiva Fracc. El Cazahuate Jiutepec Morelos. Mobile +52 998-1391-458 House +52 777 3093932 eM@il: tigre-alfa@hotmail.com pressure. Company: PEROT SYSTEMS ( DELLCOMPUTERS) Oct 2007-Jan 2010 Job Position: ETL & BI SUSTAINER Place: Guadalajara Jalisco Mexico, Plano TX., Austin TX. Activities: Developing and Monitoring components on Data Stage 8 and Manage the Teradata Databases, Manage the Solaris server Environments. Maintain the SLA for all the components on the production boxes and UAT boxes, Develop new monitors on Solaris and Perl to extract the Data and maintain a Data Quality. Working in developing, designing and implementing data mining models using neutral networks and logistic regression. Highly proficient in tools like OLAP and ad-hoc query tools, broad base. Deep understanding of Unix and Perl Scripting and C software development. Handled the task building, deploying and maintaining metadata inventories and data support tools, working with the Data Stage ( ETL ) for extract, transform and load and to manage aggregates and constraints.. Responsible for researching and evaluating emerging DWH tools and techniques. I was responsible to manage more than 10 team members in offshore ( India ) and to have implemented, assessed and procured technologies, vendors and tools. Support of the Hyperion Applications as Essbase, Planning and Interactive Reporting Studio. Achievements: • Executive DashBoards for Jack Daniels • Executive Reports for Tenet USA Company: GRUPO BIMBO ( MANUFACTURING ) Aug 2005-March 2007 Job Position: HYPERION BI Architect Place: Mexico, DF, Activities: Data Center Administration, Support to the Financial Department of BIMBO Company in applications like Hyperion Essbase, Hyperion Brio, Hyperion Planning, Hyperion Performance Accelerator, Hyperion Designer, Webfocus, Creating and Managing Cubes, Import/Export of Information, Security of Users, Create Financial Model’s, Patch Implementation, Databases Backups, 3d Party Software, charge and consolidation of daily sales of HandHelds, Tuning on Databases, Cubes Administration, Solaris 9 Servers administration ( utilization reports ), Executive Reporting, Web Servers Administration ( Tomcat, IIS, WebFocus ). DashBoard Generation on Brio, Oracle administration, Clusters, Tables Spaces, Security, Restores, Project Management of USA, MEX, Centro America, SLA’s. Maintain a secure, clean and manageable datacenter environment. I was responsible to Maintain accurate system inventory, labeling and system specific documentationm Monitors datacenter environmental factors, Maintains accurate system logs both local and via remote syslog server. Applies operating system and application security resources and product documentation in order to ensure systems are running with secure, stable, and supported software. Communicates with system stakeholders and application vendors to ensure minimal side-effects and disruptions. Achievements: • Financial Cubes Administration for BIMBO Americas • Optimization of Calc Scripts Company: M A B E S.A. DE C.V. ( MANUFACTURING) Jan 2004-Aug 2005 Job Position: IT Consultant & Data Specialist Place: Celaya, Gto Activities: Implementation, Configuration and Design of the Financial Model of Budgets, Administration in Hyperion Essbase (formulas, connections, calc scripts, import-export of data, ad in of excel and Hyperion Planning (development and administration of webforms), Development of Calc Scripts and Interfaces in DataStage (ETL), Odbc's Repository, Metadata, Transformations. Maintenance to sections of the Intranet with Html and Jsp, Maintenance and Development of Scripts for PeopleSoft 8,1 in ORACLE 9i. Pl/Swl, Administration of Table Spaces, Monitoring and Tuning of the BD, Development in SQL Developer Scripts of DataQuality with SQL SERVER 2000 for Tuning and Data Cleansing, Design of Financial Budgets for KPI’s, Modeled Star of Fact. Tables, Design of the Panel of Monitoring of Essbase with Apis. Creation of Views in SQL SERVER and in ORACLE to optimize the accesses to the tables. Designing Executive Reports in Crystal Page 3
Slide 4: Africa 17 B Col Deportiva Fracc. El Cazahuate Jiutepec Morelos. Mobile +52 998-1391-458 House +52 777 3093932 eM@il: tigre-alfa@hotmail.com Reports outside of the Hyperion Essbase, HP Quality center usage. Achievements: • Hyperion Implementation • Financial Simulator for Budgets in Hyperion Essbase Company: INFONAVIT (CONSTRUCTION) Aug 2002-Jan 2004 Job Position: Process Leader Place: México D.F. Activities: Implementation and configuration of the ERP PeopleSoft, Development of Reports with Crystal Reports for PeoPleSoft 8.1, windows modification to data capture in CRM Module (PeoPleCode), Creation, administration and programming of scripts, definition of cursors, triggers in SQL Server 2000, Tuning of BD for process of million of records per table, cursors to the forms of capture of people soft, PeoPleSoft Administration (Ambient of Tests and Production), HP QC, Reverse Engineering in Software, Relational Model (Erwin 4,1). Manage and Monitoring the Operations of the Call Center with more than 100 team meambers ( call center agents ), Issues, Performance Problems, Design Metrics, Maintain the SLA’s. Design reports for the Managers to take better decisions applied to the call center.Customer Interfacing. Achievements: • PeopleSoft 8.1 Implementation • Success of the Infonatel National Project Company: FOURTH SHIFT CORPORATION (IT SERVICES) Dec 2000-Aug 2002 Job Position: Systems Administrator Place: México D.F. & Guadalajara Activities: Participate in the development of projects for HP, John Deere and BEISA (Shering Plugh) all of them on VB 6,0 with Interdev, as well as to give technical support to users, creation of technical manual, administration of Microsoft Exchange and the network Win 2000, development of components in VB, development of reports for incorporation to Crystal Web Reports 6.0. Access to SQL Server as Creation, database engine of Scripts and DTS for import of Information to the MRP's and Repository of such. Creation and Handling of Cubes OLAP for the definition of PKÍs for news article to the Main directors. BD for the development of the system bars for HP. Achievements: • Implementation of the Bar Code System for the HP Corporation • Implementations of the Fourth Shift MRP System on HP, John Deere, Kodak Company: HIPOTECARIA MEXICANA (CONSTRUCTION) Jan 1995-Dec2000 Job Position: System Analyst/Project Leader Place: México D.F., Colima Activities: Leader of the team in assembling and configuring Pc`s for its Connection in network, as well as the configuration of cable Utp and Coaxial, to define agenda’s of endorsements, development of special routines for remote data links, conversion of near of 100 PCS of Win 3,1 to Win 95, conversion of some systems to year 2000, development of the system of weak portfolio in VBA with Excel, development of the system of status of files of the analysts of credit VB 6,0, qualification to users, development of the system: program of support to the client in VB 6.0. Participation in the development of the Page WEB. In SQL Server 7 it applies the Analysis, Design and Modeled of Diagrams E/R and Manage Databases, Definition of Fields Key, triggers, Application of the Security of Users, DTS for the Integration of Data of the system’s Satellite. Page 4
Slide 5: Africa 17 B Col Deportiva Fracc. El Cazahuate Jiutepec Morelos. Mobile +52 998-1391-458 House +52 777 3093932 eM@il: tigre-alfa@hotmail.com Achievements: • Develop and Implementation of the Systems: Credit Analysis and Cashing Remarks • • • Experience of leading projects/teams in Financial Consolidation or Management reporting. Ability to advise senior management on alternative solutions and risks with experience of presenting and influencing at a senior level. Dashboard Design Expertise. Process improvement techniques Full life cycle implementation of Hyperion Financial Management and Hyperion Applications Experience. Strong client management ability - superb verbal and written communication skills and the ability to work well with customers and peers. • • • Certifications and Relevant Training Implementing a Database in SQL Server 2000 Administering a Database in SQL Server 2000 Tuning a Database in SQL Server 2000 Focused Administration Mastering Visual Basic 6.0 Netware Administrator Novell 4.0 Hyperion Essbase Hyperion Planning Hyperion Performance Accelerator Hyperion Brio 8.3 Hyperion Essbase Integration Services 6.5.3 Hyperion I n t e r a c t i v e Reporting Service 9.3 Hyperion Planning 9.3 HFM OBIEE 11G WebFocus 7 Data Stage 7.1 SQL Server 2005 Project Management ITIL Foundations Learning PERL Teradata Advance SQL MICROSOFT MICROSOFT MICROSOFT FOURTH SHIFT MICROSOFT EXECUTRAIN ( CIS ) / MABE ( CIS ) / MABE ) ( BIMBO ) ( BIMBO ) ( BIMBO ) Oracle Oracle Oracle Oracle ( IMS / BIMBO ) KLE MICROSOFT Perot Systems Perot Systems Stonenhege Teradata Page 5
Slide 6: Africa 17 B Col Deportiva Fracc. El Cazahuate Jiutepec Morelos. Mobile +52 998-1391-458 House +52 777 3093932 eM@il: tigre-alfa@hotmail.com Page 6
Slide 7: Africa 17 B Col Deportiva Fracc. El Cazahuate Jiutepec Morelos. Mobile +52 998-1391-458 House +52 777 3093932 eM@il: tigre-alfa@hotmail.com Ricardo Milla González SINCERELY Page 7