L

Luis Gerardo Flores Garza

About

Detail

Mexico

Contact Luis regarding: 
work
Full-time jobs
Starting at USD30/hour
Flexible work
Starting at USD30/hour

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • K2 Partnering Solutions
    BI Consultant
    K2 Partnering Solutions
    May 2024 - Current (2 years 2 months)
    • EnhancementDevelopmentandIncidentsupportofthecurrentIBMPlanningAnalytics(TM1)forCompensation&BenefitsBudgetingintheglobal& country models implemented in PEPSICO. • UseofGITHubforthelifecycledevelopmentbetweentheDevelopment,StagingandProductionmodels. • FollowupwiththeendusersaboutthenewrequiredchangestoimplementandparticipateaccordingtotheAgilemethodology. • CreationandfollowupofUnitTestingandfunctionaltestingofeachenhancementdeveloped. Contact: United Europe Asia.
  • Conduent
    BI & Analytics & Analytics Manager
    Conduent
    Jan 2013 - Sep 2024 (11 years 9 months)
    • Creating Web Applications for the load budgets, projection within the Tools pull of Power BI, Azure Data Lake, TM1 Cognos, Alteryx, Python and Tableau • Administration ofTM1 data marts (Financial), creating reports, cubes, ETL load processes, security, reports, dashboards, and comparative tables. • ManagementandsupportfromthefinancialmodelsandDBadminfromtheBuckdatabases. • UseextractiontoolsfromJDEEdwardsinformationandloadingprocesstohaveinanaccuratewaythedatainourmodels. • Information Analysis, evaluated loads, stored procedures, creation offinancial reports (Budget, Forecast, Actuals, comparatives). • Automate process to extractthe tables and fields from the queries in SQL Server Management Studio, use ofcubes and loading process. •
  • Tata Consultancy Services
    BI Project Leader
    Tata Consultancy Services
    Mar 2011 - Jan 2013 (1 year 11 months)
    • Management,analysisandimplementationofaprojectofthePowerBIandCognosforthefinance&treasuryarea. • Automate process to extract the tables and fields from the queries in SQL Developer (Oracle) in a specific format using VBA macros in Excel files to implement in a better way for the Power BI and Cognos reports. • AnalyzingperformanceofqueriestoimplementinthefinalreportsusingBItools. • Documentalltheinvolvedprocessandtechnicalspecificationsoftherequests. • AnalysisofOBIEE(OracleBItool)asaalternativeofBItoimplementinthefutureforalltheimplementedreports. Contact: USA & India
  • A
    Business Analyst (Senior)
    ACS -XEROX
    Apr 2008 - Mar 2011 (3 years)
    • BuiltaprograminVBAandexcelfilesfortheautomationfromtheOnboardingErrorsreportwiththedataextractionsfromthesystemTALX. • Manage and develop from VURV COGNOS BI tools, building data extractions to build reports as Executive Summary, Open & Filled Positions by Month, ABC-US Bonuses and MTY RSS Dashboard & other specified data extractions solicited by Recruiting Operations. • Support the candidate's log for the MTY RSS team, where the recruiters registered its activities, and we did a match with the data extractions from VURV to validate the records of each interview processes of each recruiter. • Implement dynamic reports for the statistics from MTY Recruiters &the US Recruiters, built in VBA with Excel and using DAO references, SQL querie
  • G
    Dimension Administrator / Business Analyst
    GRUPO OPEN (NEORIS CEMEX)
    Jul 2006 - Apr 2008 (1 year 10 months)
    • Dimensions Administration (account catalogs, cost centers, products, destination, phase, etc.), which are the system core information, the base of BOP (Business Objects Planning) to execute reports, templates, and procedures, performing changes according with consulting team decisions. • Template development for budget capture, as well as statistic reports in "Corporate Expenses" model, based on BOP tool, advanced formulation and data manipulation involving macros in Excel. • Responsible ofgrant access and privileges in BOP application and workbookassignation in all CEMEX business models (Mexico, Corporate Expenses and SAC region), being the administrator of Citrix and BOP. • Developmentof load programs for uploading data to"Corporate
  • C
    Warehouse Manager
    COREFRESCO S.A. de C.V.
    Sep 2005 - Jul 2006 (11 months)
    • Warehouse personnel management and supervision and inventory Control and merchandise assignation to vendors, distribution, receiving and shipping merchandise, and sales closures.
  • E
    Business Analyst (Project)
    ERP CONSULTORES (CEMEX-Procurement)
    Apr 2005 - Jul 2005 (4 months)
    • Report generator of indicators for the procurement department of Central CEMEX, based on macros (VBA) for Excel application and data manipulation on Access by SQL queries.
  • S
    Support Site Representative
    SPECTRADYNE INTERNATIONAL
    Sep 2004 - Apr 2005 (8 months)
    • Responsible of PPV television system for a prestige Hotel Chain (Monterrey, Laredo, Juarez, Tijuana, and Saltillo y Torreon) monthly updating the systems and performing maintenance to video and computing equipment.
  • V
    Sales Account Executive
    VINTEC, S.A. DE C.V.
    Jul 2004 - Aug 2004 (2 months)
    • Responsible of the sales area of the company, performing a work strategy to capture new clients, offering administrative systems for medium business, also providing personnel to large business for software development projects as well as help desk projects.
  • S
    Business Analyst / Project Leader
    SCATEL, S.A. DE C.V.
    Feb 2002 - Jul 2004 (2 years 6 months)
    • Development of DAC (Documentation Assisted by Computer) Tool based on VBA (Word) for user's manual documentation for SAP system, used in Cuauhtémoc Moctezuma brewery. • Contribution in the development of the CIN system (Integral Control from the Business) in Visual FoxPro 7.0 • Commercial Panel (HYLSA DAP) support, in which shows the sales from all the company and the detailed for each sales manager. • Design and analysis of systems by using the UML methodology, using case diagrams and activity diagrams. • Platform migration from VBA with Word to VB for DAC system commercialization.
  • H
    Commercial Business Analyst
    HYLSA DAP (TERNIUM)
    Jul 2001 - Feb 2002 (8 months)
    • Perform a market analysis, by reaching companies in México and the United States aiming to ample the client's portfolio and develop the commercial panel, by the use or macros VBA (Excel), manipulating data, dynamic tables, and graphics.
  • E
    Help Desk Support
    EDITORA EL SOL (EL NORTE)
    Jul 2000 - Feb 2001 (8 months)
    • Client attention (Help Desk), Software Installation on Macintosh equipment, technical support and maintenance to computing and telephonic equipment.
Education verified_user 0% verified
  • F
    Bachelor's Degree
    FIME, UANL)
    Jan 1998 - Jan 2002 (4 years 1 month)
  • F
    Bachelor's Degree
    FIME, UANL)
    Jan 1998 - Jan 2002 (4 years 1 month)
  • S
    Six Sigma Green Belt
  • M
    Microsoft Certified Professional (MCP) (Developing and Implementing Web Applications with Microsoft Visual C# .NET)
  • S
    Systems Administration Engineer