Rafael Mendoza López

• Spearheaded the data practice, providing strategic direction and leadership to cross-functional teams.
• Defined and implemented data governance policies and procedures to ensure data integrity, security, and compliance
• Collaborated with business stakeholders to identify and prioritize data-driven initiatives that support strategic decision-making
• Collaborated with the Data Architecture ecosystem primarily in the AWS cloud.
• Worked with data models for credit risk and AI
• Worked with the Data Architecture ecosystem in the GCP & Azure cloud.

• Improved customer satisfaction by addressing and resolving complaints promptly.
• Developed strong working relationships with staff, fostering a positive work environment.
• Maintained a clean, safe, and organized store environment to enhance the customer experience.
• Completed regular inventory counts to verify stock levels, address discrepancies, and forecast future needs.
• Conducted employee performance evaluations, providing constructive feedback for growth and development.
• Managed inventory levels to minimize stockouts while reducing overhead costs.
• Developed marketing strategies to attract new customers, increasing foot traffic.
• Conducted performance evaluations, identifying areas for development and rewarding strong performance.
• Conducted performance evaluations and provided constructive feedback to employees.
• Improved operational efficiency by adopting new technology for inventory management.

• Designed, developed, and deployed data models and consumption reports on the Azure platform
• Established robust data quality frameworks and processes to maintain accuracy and reliability
• Mentored and coached team members, fostering a culture of continuous learning and development

• Played a pivotal role in driving the adoption of Azure cloud technologies and best practices
• Conducted in-depth research on emerging data technologies to identify opportunities for innovation
• Provided technical guidance and support to the sales team, assisting in the development of POCs and proposals

• Led the design and implementation of data analytics solutions on the Azure platform for Microsoft (SUNAT Perú)
• Optimized data processing and storage utilizing Cosmos DB and other Azure services
• Successfully managed project constraints and delivered projects on time and within budget Improved practice revenue through effective financial management and strategic cost reductions.
• Supervised team of 30 office personnel.

• Development of geo referencing systems with database storage and external components for political campaigns, both in client/server environments and web environments with Google Maps components. Focused on land campaigns. (Winner of the 2012 Victory Award in Washington, DC, Winner of the 2013 Victory Award in New York)
• IT coordination for consulting projects.
• Generation of reports and data models for predictive analysis and social media monitoring with Rapid Miner and Data Studio.
• Management of Azure, AWS, and Google Cloudera.

Azure Cloud Solutions for SUNAT: Information Exploitation & Stabilization

Working with Microsoft in Lima, Peru, I was responsible for the exploitation and stabilization of information for SUNAT within their Azure cloud environment. My contributions included:

• Architectural Redimensioning: Redimensioned the Data & Big Data architecture on the Azure platform, leveraging HDInsight.
• Streamlined Data Ingestion: Reviewed and adapted data loading processes, focusing on SSIS, Data Factory, and Spark Jobs.
• Proactive Architectural Enhancement: Provided continuous improvements and strategic suggestions for the current architecture.

Information Management & Optimization for SUNAT on Azure

Collaborated with Microsoft in Lima, Peru, to exploit and stabilize information for SUNAT within the Azure cloud. This included:

• Resizing Data & Big Data Architecture: Optimized the Azure platform using HDInsight.
• Data Load Process Refinement: Reviewed and adapted data loading processes within SSIS, Data Factory, and Spark Jobs.
• Continuous Improvement: Provided ongoing enhancements and recommendations for the current architecture implementation.

Data & Sentiment Analysis Solutions
We offer comprehensive data solutions, encompassing:

• Sentiment Analysis & Social Network Evaluation
• Data Mining and Sentiment Analysis:Leveraging advanced techniques to extract insights from vast datasets and understand public opinion.
• Social Network Analysis for Sentiment Evaluation: Utilizing RapidMiner with streaming connectors for real-time data ingestion from Twitter, LinkedIn, Facebook, and Google Data Studio.
• Information Exploitation: Creating dynamic dashboards with Qlik Sense for clear, actionable insights and data visualization.

Technical Project Proposals & Architecture

• Technical Proposal Development: Crafting detailed technical proposals for projects, including evaluation and integration of proposed architectures.
• Team Integration & Component Detailing: Defining the integration of the project team and providing thorough descriptions of each component's functionality and scope.

Big Data Infrastructure & Optimization

• Deployment Architecture Design: Developing robust deployment architectures tailored to your needs.
• Data Modeling and Storage: Designing HBase data models and optimizing HDFS structures for efficient file loading.
• Performance Review & Optimization: Conducting comprehensive reviews of processing times and implementing adjustments within the Cloudera ecosystem for optimal performance.
• Ecosystem Recommendations & Administration: Providing expert recommendations for ecosystem adjustments, along with ongoing Cloudera administration and optimization.

Data Processing & Integration

• Flat File Processing with Spark-Scala: Efficiently processing flat files using Spark-Scala.
• XML Generation & Validation: Developing a Java component for XML transformation with integrated business rules and integrity validation against SAT XSD version 3.3.
• Batch File Transmission: Utilizing a Spark-Scala component for sending generated files in batch.
• Real-time Data Transport: Implementing Kafka producer and consumer components for reliable data transport.
• HBase Integration & Storage: Employing a Spark-Scala component for integrating and storing data in HBase.
• Validation & Visualization: Facilitating data validation and visualization through Hue.
• Automated Execution: Creating shell scripts for one-command execution of processes.

Advanced Analytics & Machine Learnin

• Data Analysis & High-Volume Processing: Analyzing information and processing large volumes of data using a Hive model for both Twitter streaming and flight flat files.
• Flight Delay Prediction: Developing a logistic regression model in Python for predicting flight delays.
• Scalable Data Processing: Utilizing Spark-MLlib and Scala for distributed data processing across multiple nodes in the Cloudera ecosystem.
• Integrated Data Storage: Storing processed data efficiently in HDFS and HBase.

Requirement identification and mapping of data points to business processes for integrating unique customer data into a single database and executing processes for information exploitation via ETL.
Identification, implementation, and integration of Business Processes (BPs) with Primavera Unifier, including interfaces with various data sources such as TXT, XLS, CSV, SAP, Oracle, and SQL Server.
Additionally, I have experience in project coordination for both government and private sectors, managing teams in MDM, DWH, EDQ, ETL, and BI (Cognos, Webfocus, QlikView, Tableau).

Key Projects:

• Implementation and integration of Unique Customer solutions for Fichosa Bank in Honduras.
• Implementation and integration of Unique Customer solutions for Actinver Bank in Mexico.
• Implementation and integration of SAGARPA Producer Registry using business rules and data quality initiatives in Mexico.
• Data integration for Business Intelligence reports for Seguro Popular in Mexico.
• Construction and integration of a Business Intelligence viewer for OmniSuite.
• Primavera Unifier Proof of Concept (POC) generation for CICSA and Oracle process integration."

• My responsibilities included identifying requirements and mapping key metrics to business processes. This was crucial for integrating unique customer data into a centralized database and for executing processes designed to leverage information through ETL.
  I also led and coordinated various government sector projects, overseeing teams focused on Master Data Management (MDM), Data Warehousing (DWH), Enterprise Data Quality (EDQ), and Business Intelligence (BI).

• Identifying requirements and mapping key data points to business processes for the integration and execution of ETL-driven processes designed for information exploitation. My responsibilities also include defining and creating information cubes, data marts, and ad-hoc reports for the DGSTI department, in addition to coordinating projects with my team.
  Why it's better: This option adds a bit more detail, using phrases like "key data points" and "designed for information exploitation" to provide more context without becoming verbose. "My responsibilities also include" clearly delineates your role.

• Summary of Experience: My role involved comprehensive requirements identification and providing dedicated key user support across Latin America and Canada. I was responsible for rigorous validation of data mapping against business processes, ensuring accuracy and alignment. My expertise extended to generating ad-hoc and active reports, and executing ETL processes for effective data exploitation. A significant part of my work included the monitoring and administration of DataMarts for critical pharmaceutical information, specifically from key audits like DDD and CLOSE-UP. Furthermore, I managed and coordinated projects with a team under my supervision.
  
  Technical Proficiencies: I leveraged various information technologies, including developing Stored Procedures and Triggers, implementing ETL solutions, and utilizing Excel and Oracle for data validation, delivering ad-hoc information to users, resolving data discrepancies, and defining business concepts and rules for developers. My experience also encompasses Cognos, where I managed data marts using DataManager, Framework, and Transformer, utilized other BI tools, and generated Novartis reports with Report Studio.
  
  Key Tools & Methodologies: PMP, Pharmaceutical Audits (DDD, CLOSE-UP), Cognos Framework, DataManager, Cognos Transformer, Cognos Report Studio, Cognos Analysis Studio.

• My experience encompasses the full lifecycle of data management and business intelligence, primarily within the pharmaceutical sector. Key responsibilities include:
• Identifying business requirements and providing direct user support.
• Ensuring data accuracy through rigorous validation of figure-to-business process mapping.
• Generating various ad-hoc reports and executing sophisticated ETL (Extract, Transform, Load) processes to facilitate data exploitation.
• Overseeing the monitoring and administration of the data warehouse, which handles critical pharmaceutical information sourced from major audits such as IMS (PMM, INTE, NRC, OCHL), Close-Up, ATV, Nadro, Internal Sales, GSDT, SUAGuilar, and the Commercial Model for distributor payments.
• Providing essential support in the administration of Oracle databases.
• Managing the acquisition of data from SAP, including its integration and subsequent administration within the data warehouse.
• Developing robust web applications using ASP.NET 2010 in C#, incorporating DevExpress components.
• To achieve these objectives, I have consistently applied various information technologies. This includes developing stored procedures, triggers, DTS packages, and crafting complex SQL and Oracle queries for both web-based environments and Excel reporting. These efforts have been crucial for supporting validation processes, delivering ad-hoc information to users, resolving data discrepancies, and defining core business concepts and rules for development teams.
• Furthermore, I possess strong proficiency in Cognos for data warehouse maintenance, utilizing tools like DataManager, Framework, and Transformer. My expertise also extends to various BI tools and the generation of Merck reports using Report Studio.
• Technologies and Tools Utilized: PMP, Pharmaceutical Audits (PMM, INTE, CLOSE-UP, ATV, AUDIT PHARMA, NRC, OCHL, NADRO, GSDT, SUAGuilar, Internal Sales, SAP), SQL, .NET C#, ASP.NET, Cognos Framework, DataManager, Cognos Transformer, Cognos Report Studio, Cognos Analysis Studio, SQL Server 2005, Analysis Services, Reporting Services, and Integration Services."

• Developed web applications using .NET (C#, ASP, ASPx) and SQL Server for AMEX expense control. This included building interfaces for provider file integration and creating/modifying Stored Procedures, Triggers, and DTS for data querying.
• Why this works:
• Active voice: "Developed" is strong and direct.
• Concise: Gets straight to the point without unnecessary words.
• Clarity: Clearly links the technologies to the outcomes.
• Specifics: Mentions "AMEX expense control" and "provider file integration," which are key details.
• Tools integrated: The tools are naturally integrated into the description of the work.

• Experienced Application Developer with a strong background in .NET C#, ASP.NET, SQL Server, and Oracle.
• Provided consulting services at Pfizer laboratories, where I was responsible for the full lifecycle development and management of a training control application for Medical Representatives, utilizing .NET VB and ASP technologies.

• Marketing Applications Coordination at Schering-Plough}
• During my time at Schering-Plough, I was responsible for coordinating the Marketing Applications Division. My efforts included spearheading the development of object-oriented applications for the Marketing department, utilizing technologies such as PowerBuilder and Visual Studio 2003 .NET C#. This was accomplished through a combination of internal development initiatives and strategic vendor contracting.
• My responsibilities extended to administering the company's Oracle and SQL Server databases. I was also instrumental in generating critical reports for the Directorate and Presidency of Schering-Plough Mexico.
• A significant project involved the implementation and creation of a specialized application for the accurate calculation and timely payment of commissions for approximately 1,000 medical representatives. Furthermore, I coordinated and oversaw the implementation of the System for Medical Area Control.
• Throughout my tenure, I provided oversight and guidance to more than 10 project leaders, each managing teams of 2 to 5 external programmers. These teams were engaged in various corporate development projects across both client-server and web environments. I also ensured seamless communication and information transfer between PC and AS/400 systems.
• I was proficient in managing interfaces with external pharmaceutical databases including Close-Up, Audit Pharma, and Pharmamix. A key aspect of my role involved extracting and analyzing data from various pharmaceutical audits such as DDD, Inte, PMM, Close-Up, and Audit Pharma. This data was then used to produce comprehensive management reports and detailed graphical sales reports for the Sales department.
• These audit-derived reports included: Incentive Payment Reports, Territory DTs Reports, Sales vs. Market Product Charts, Product by Molecule Reports, PMM Reports for Market Validation, Multi-level Diagnostic Reports, and Prescription Reports.
• Key Technologies & Tools: PowerBuilder, Visual Studio 2003 .NET C#, AS/400, DB2/400, Pharmaceutical Audits (PMM, INTE, DDD, AUDIT PHARMA, PHARMAMIX, INTERNAL SALES, DTs).

• "I was responsible for driving Clipper application development within the Market Research department for data capture. This included processing information from DBF databases using SPSS to generate essential tables for data analysts. My role also encompassed coordinating Novell network administration and establishing Linux communications. I managed a team comprising 6 programmers, 2 capture supervisors, and 30 data entry operators working in two shifts.
• During my tenure, I successfully initiated and led the development of Ingres applications for the Construction department's data capture on an HP-UX 9000 system, leveraging Ingres for both database and programming aspects. I administered network communications with PCs via Reflection and developed applications for both internal and external clients using VB, Clipper, Visual FoxPro, and DBase. My responsibilities also extended to Windows and LAN Manager network administration, monitoring the sales department's Telemagic application, and ensuring database security and protection for company clients. Furthermore, I managed Linux communications and facilitated dial-up access for downloading subscriber information. I oversaw a small team of 1 programmer and 1 technical support professional.
• Key Technologies: Clipper, DBF, SPSS, Novell, Linux, Ingres, HP-UX 9000, Reflection, VB, Visual FoxPro, FoxPro, DBase, Windows, LAN Manager, Telemagic."