Pamela Cedillo

Experience

• 

  Grupo Scanda

  Sept 2009 - Apr 2011

  Junior Technology Engineer

  Implemented data quality practices on different projects.▪ In charge of generating a full discovery profile of the data, analyzing data quality findings, identifying different patterns to implement the data standardization.• Managed tool Trillium Software System to identify duplicate records on the data bases of the customers.• Developed maps for the ETL of Informatica Powercenter to create the distinct flows required.Main Achievements✓ Generated data quality patterns to clean databases for INFONAVIT (government enterprise for mortgage loans) Show less

• 

  Deloitte Consulting

  Jun 2011 - Apr 2013

  IT Junior Analyst

  Managed development teams to create technical documentation.▪ In charge of carrying out all the technical specifications, tracking the status of all technical developments and delivering timely project risk reports.• Analyzed functional specifications and created the design of functional requirements for project implementation.• Developed requirements for different modules for Payroll and HCM Suite (Peoplesoft).▪ Participated in PeopleSoft upgrade from version 8.8 to 9.1 of the HCM Suite (PeopleSoft). Implemented new developments in version 9.1 using Application Engine, PeopleCode, Component Interface, Excel to CI and SQR reports.Main Achievements✓ Supported a team of more than 22 persons that developed technical documentation. Show less

• 

  Citibanamex - Banco Nacional de Mexico

  Oct 2013 - Feb 2019

  • Generated project budgets and Initiative Expenditure Expense (IEP) reports, ensuring accurate financial planning and allocation of resources.• Reviewed North American allocation hours reports to monitor project progress and resource utilization.• Conducted regular reviews of Cash Flow and Profit & Loss statements for project tracking and financial analysis.• Provided comprehensive financial reports to managerial staff, accompanied by recommendations for cost-saving opportunities and efficiency improvements.• Maintained the financial health of the department by implementing effective budgetary controls and monitoring financial performance.• Ensured on-budget execution of global programs totaling $3.2M, analyzing OPEX against budget and forecast figures.• Supervised the hiring of external resources, negotiating contracts to optimize value and minimize costs.• Collaborated with global and local teams to support various initiatives, ensuring data validation and alignment with organizational objectives.• Managed financial resources for multiple initiatives, including planning, budget allocation, and procurement of licenses, in alignment with financial plans.• Directed engagements with business and technology teams to ensure timely delivery of project requirements and monitored project progress to ensure adherence to timelines and completion of deliverables.• Coordinated sessions with internal stakeholders to define data measurement controls and ensure data accuracy, orchestrating the coordination of internal resources, external contractors, and vendors, including IBM, TCS, Wipro, PWC, and Softtek, for seamless project execution.Main Achievements-Decreased P&L impact by 5%, equating to $80K in savings.-Delivered annual savings of up to 10%, totaling $500K for the enterprise.-Maintained budget variances within a narrow range of ±5%.-Achieved an outstanding 98% effectiveness rate in the payment of purchase orders. Show less • Established data quality rules and procedures for data sharing with upper management and internal stakeholders.• Analyzed raw data, identified data quality findings reports and statistics assessment of the output of the data profiler software in order to help internal customers to minimize issues and streamline the data migration.• Identified local critical data elements using as a reference global critical data elements.• Generated the data lineage for local critical data elements.• Worked with global and local teams to support different initiatives through data validation by cross referencing distinct information sources.• Directed engagements with business and technology areas to ensure their participation and commitment to deliver the project requirements in a timely manner.Main Achievements✓ Obtained and monitored more than 363 critical data elements in Mexico.✓ Acquired mapping documentation from 48 legacy systems in Mexico to create lineage for Optima and Genesis applications.✓ Analyzed more than 100 data profiling reports for Rainbow Data Conversion to cover 28 local legacy systems.✓ Identified and coordinated with data owners to use the SAS application. Show less

  • SENIOR BUSINESS ANALYST- FINANCE BUSINESS PARTNER ROLE , IT DATA GOVERNANCE AREA

    Aug 2017 - Feb 2019

  • Junior Business Analyst

    Oct 2013 - Aug 2017
• 

  Fundación Rafael Dondé IAP

  Feb 2019 - now

  • Diligently oversee company budgets and financial forecasts to ensure accuracy and alignment with organizational goals.• Skillfully prepare and present detailed financial reports to senior management, providing insights for strategic decision-making.• Expertly develop and execute comprehensive financial budgets, optimizing resource allocation and financial performance.• Proactively manage overhead expenses, identifying and implementing cost-saving initiatives to enhance efficiency and profitability.• Conduct thorough monthly financial projections, offering timely insights to support informed decision-making processes.• Meticulously review and track external auditor deliverables, ensuring compliance and accuracy with regulatory requirements.Main Achievements -Drove collaborative and real-time forecasting processes, enhancing decision-making accuracy and agility.-Streamlined budgeting processes, ensuring consistent achievement of financial targets.-Implemented cost-saving initiatives resulting in reduced overhead expenses and improved profitability.-Developed and presented financial reports, providing senior management with crucial insights for informed decision-making. Show less • Coordinated and oversaw the preparation of budgets and financial forecasts for the technology department, analyzing variances and reporting findings.• Ensured adherence to on-budget financial plans, implementing corrective measures when necessary to maintain financial stability.• Developed comprehensive financial analyses to support business cases and decision-making processes.• Implemented robust controls to monitor income and expenditure, optimizing profit margins across various departments.• Presented detailed financial reports to senior management, providing insights into financial performance and opportunities for improvement.• Designed and monitored internal financial controls to ensure compliance and mitigate risks.• Regularly reviewed financial plans and budgets to identify and implement cost reduction strategies.• Evaluated project contracts to ensure alignment with deliverables, milestones, and scopes, maintaining strict financial controls.• Managed vendor payment processes, validated invoices, and coordinated payments with the treasury department, negotiating contractual terms to optimize value and minimize costs.• Coordinated with over 60 vendors, reviewed economic proposals, and ensured alignment with organizational objectives.• Oversaw the creation of purchase orders for new services, optimizing procurement processes.• Procured software licenses and managed domain acquisitions to support organizational needs.• Developed human resources plans for the IT department, collaborating with the accounting team to create budgets and resource allocation strategies.• Prepared project budgets for the IT department, ensuring alignment with organizational objectives and financial constraints. Show less

  • DEPUTY FINANCIAL DIRECTOR, BUDGETING DEPARTMENT

    Dec 2022 - now

  • DEPUTY FINANCIAL DIRECTOR, INFORMATION TECHNOLOGY AREA

    Feb 2019 - Dec 2022