Project Manager Management

Mauro Gerardo Marquez

RELEVANT QUALIFICATIONS

Project Management

Led the project team by conducting project outline at various levels: project workflows, task workflows and worked with AI application (IBM Watsons) that is integrated to Azure cloud to train AI on PID’s.

Familiar with Technical concepts

Managed client database and execute data base queries to pull reports; also performed data mining using SQL queries to manage project specific KPI’s.

SUMMARY

Hands on experience as a Project Manager with expertise in assessing project issues and developing resolutions to meet productivity, technical, and quality objectives.

Managed and supported cross-functional teams by identifying project gaps and developing innovative solutions when suited. Increased project efficiency by working with clients to discover gaps in the service; also responsible for the creating learning modules for team.

Proficient in collecting, understanding, and analyzing data from various sources including the use of statistical software to provide reports that indicate significant changes, root causes for failures, corrective actions, and forecasting.

Responsible for providing executive summaries to the executive team and customers; coordinated with the technical teams to determine a detailed list of tasks that will be utilized to create workflow, schedules, and budgets.

Adept in leading and providing consultation in process improvement projects, which includes coaching and planning /professional advising for clients.

Impacted the client by hosting project closeouts and presenting overall results with onsite teams. Also worked on data management and quality which includes creation and measurement of KPIs.

I have advanced experience using various ETL software tools to automate project task, such as: Excel, MS Access, PowerShell, Python, SPSS, SQL and Power Bi.

I Can be interviewed given 1-2 days’ notice and can start 2 weeks after the offer.

SKILLSETS

Experienced with Linux OS and associated distributions, Python/ SQL for data analysis, Power-Bi, Data mining, Windows Command line, PowerShell, data management and data mining, developing project efficiency workflows, Program Evaluation techniques, Extracting, Transforming, Loading Data, Analytics, Microsoft SQL Server, Case Management, Quantitative Analysis, Quality Management, MySQL, SharePoint, Presentation skills, Data collection, Relational databases, Statistical software, Microsoft Project, Customer service, Fiscal management, Financial report writing, Analysis skills, Social media management, Teaching, Interviewing, QA/QC, APIs, Data Warehouse, Git, Visio, Data analytics, NumPy, Pandas, Big data, Pivot tables, Data structures, Microsoft Excel, Apple Pages, Scripting, Data Wrangling.

EDUCATION AND CERTIFICATIONS

Computer Information Technology- Cyber Security

San Jacinto Community College - Pasadena, TX, August 2021 to Present

Master of Science in Sociology, Specialization in Statistics

University of Texas

Bachelor of Arts in Sociology

Michigan State University

IBM-Data Science Methodology, October 2019

IBM-Python for Data Science AI & Development, February 2020

IBM-Database and SQL for Data Science with Python, September 2020

PROFESSIONAL EXPERIENCE

SEARCH Homeless Services - Houston, TX SEPTEMBER 2022 – PRESENT

Technical Data Analyst / Data Manager

Spearheaded the development of advanced data collection and processing techniques, driving proactive improvements in data initiatives using big data technologies.

Implemented rigorous research methods and advanced analytical techniques to ensure compliance with HIPAA standards, leveraging machine learning algorithms for enhanced data security.

Utilized Python to streamline data science workflows, automate report generation, and improve overall efficiency and accuracy.

Automated data extraction and transformation processes using SQL and Python, developing customized KPIs and tailored reports to meet organizational needs.

Developed and shared comprehensive Jupyter Notebooks for in-depth analysis and internal program evaluations, incorporating data visualization libraries like Matplotlib and Seaborn.

Automated reporting using Tableau and Power BI, creating dynamic dashboards and interactive visualizations.

Managed and executed multiple data projects across various grants, integrating databases with Power BI and Tableau for robust reporting and real-time data insights.

Established and monitored key performance indicators (KPIs) for multiple grants, ensuring a focus on results-driven management and continuous improvement.

Oversaw data governance for the organization, collaborating with the Coalition of Houston to ensure data integrity and compliance.

Conducted statistical analysis and hypothesis testing to validate research findings, supporting strategic initiatives in collaboration with university professors, utilizing R and Python for advanced statistical modeling.

Harris County Public Health - Houston, TX Contractor 6 Mo.

Technical Data Analyst

Engineered and automated intake referral processes, significantly enhancing operational efficiency using workflow automation tools.

Designed and implemented a localized MS Access database and an Azure cloud database to automate report generation and improve data accessibility.

Formulated and enforced data security structures, establishing internal policies for data governance and best practices, leveraging encryption techniques and access controls.

Collaborated with analyst teams to translate business requirements into technical data system specifications, ensuring alignment with organizational goals.

Created clinical reports using Power BI dashboards, incorporating real-time data visualization and interactive elements.

Developed database modeling processes, improving data structure, accessibility, and performance using ERD tools and normalization techniques.

Analyzed data to predict clinical trends and optimize daily operations, utilizing predictive analytics and machine learning models.

Utilized data mining techniques to extract valuable insights and identify patterns, employing tools like SQL, Python, and R.

Advised the Clinical Director and Operations Manager on cost-saving automation processes, implementing RPA (Robotic Process Automation) solutions.

Created technical process and procedure manuals to streamline new client enrollment and data analysis, focusing on specific metrics and best practices.

CSAT, Jersey Village, TX Contractor 6 Mo.

Technical Data Analyst

Performed data mining on localized servers to analyze current and historical data, utilizing SQL, Python, and R for comprehensive data extraction and analysis.

Developed Power BI and Tableau dashboards to monitor internal project KPIs, incorporating real-time data visualization and interactive elements.

Built MS Access databases for internal projects, enhancing data management and accessibility.

Automated data pulls and performed data analysis using Python, leveraging pandas and NumPy libraries for efficient data manipulation.

Generated client reports using SQL in Microsoft SQL Server, ensuring accurate and timely data delivery.

Conducted root cause analysis of assembly line processes, implementing strategic plans to reduce bottleneck issues and improve operational efficiency.

Managed project-specific KPIs through monitoring dashboards, resolving issues causing bottlenecks, and ensuring continuous improvement.

Coordinated with logistics teams of engineers and analysts to streamline the assessment and resolution of incoming products, ensuring timely processing and thorough testing before returning items to owners.

Collaborated with technical teams to define workflows, schedules, and budgets, minimizing risks and optimizing project objectives using project management tools like JIRA and Asana.

Presented data insights and findings to stakeholders through clear and compelling visualizations, facilitating data-driven decision-making and strategic planning.

San Jacinto College - San Jacinto College, Pasadena, TX Contractor 6 Mo.

Project Manager

Provided project coaching, planning, and advising to clients, leveraging Agile methodologies and project management tools like JIRA and Asana.

Served as a program liaison, fostering collaborative relationships with internal and external partners using collaboration platforms such as Microsoft Teams and Slack.

Developed and executed data management plans to ensure compliance with federal grant auditing guidelines, utilizing data governance frameworks and ETL processes.

Created work breakdown structures (WBS) and Standard Operating Procedures (SOPs) to meet project guidelines and auditing expectations, employing workflow automation tools.

Established project efficiency tools for new hires, including workflow training diagrams and interactive onboarding modules.

Built metrics to analyze internal project KPIs using Excel and database management systems, incorporating data visualization techniques.

Assessed project issues and developed resolutions to meet productivity, technical, and quality objectives, applying root cause analysis and problem-solving methodologies.

Managed client databases and executed SQL queries to pull weekly reports, ensuring data accuracy and timely delivery.

Provided direction for various project tasks to minimize risks and optimize project objectives, utilizing Lean Six Sigma and Agile methodologies.

Built report dashboards using Power BI and Tableau, creating dynamic and interactive visualizations for stakeholders.

Resolved project issues, ensuring productivity, technical, and quality objectives were met through continuous improvement processes.

Directed project tasks, minimizing risks and optimizing objectives using Lean Six Sigma and Agile methodologies.

PINNACLEART - PASADENA, TX

DATA RELIABILITY ANALYST JUN 2018 – MAR 2021

Managed and maintained clients’ Internal Data Management System (PCMS), ensuring data integrity and quality using data validation techniques.

Conducted database exports and imports of various layers in relational databases, including Damage Mechanisms, Corrosion Rates, CML readings, Piping Sizes, and Equipment and Piping Assets, utilizing ETL processes.

Advanced experience using various ETL software tools to automate project tasks, such as Excel, MS Access, PowerShell, Python, SQL, and Power BI.

Met with clients regularly to discuss project-related issues, including inspection, PIDs, and database values, ensuring clear communication and alignment.

Worked on data management and data quality, creating and measuring KPIs for internal projects using data analytics tools.

Managed and supported cross-functional teams by identifying project gaps and developing innovative solutions, leveraging collaboration platforms like Microsoft Teams and Slack.

Increased project efficiency by working with clients to discover service gaps and creating learning modules for the team, utilizing e-learning platforms.

Led the project team by conducting project outlines at various levels, including project workflows and task workflows, using project management tools like JIRA and Asana.

Collaborated with engineers to build corrosion models for refinery assessments and pipelines, employing predictive modeling techniques.

Completed projects for Valero Three Rivers, Valero McKee, and Exxon Rotterdam, demonstrating expertise in refinery operations.

Performed project tasks for refinery clients, including systemization of PIDs, circuitization of PIDs, development and design of PIDs, data mining piping and equipment assets, and conducting inspection grading and retrograding of equipment and piping assets, utilizing CAD software and data visualization tools.

OTHER WORK EXPERIENCE

DFPS - SAN ANTONIO, TX

INVESTIGATOR II 2013 – 2015; 2017-2018

Investigated reports of abuse/neglect to children in Region 8

Managed several cases at a time while maintaining compliance with state law.

Supervised clients placed under department supervision and engaged them in Community Services.

Innovated solutions for case management to meet appropriate timelines, and state requirements.

Improved the lives of clients by performing preliminary mental health, and drug assessments.

Resolved cases under investigation by utilizing both quantitative and qualitative resources.

Executed ad-hoc decision making to ensure the safety of children, and families in the community.

Actively utilize DFPS Policy and the Family Code of Law to resolve civil cases.

Helped families by aligning them with community organizations and leaders to provide aid.

TX - SAN ANTONIO, TX

JUVENILE COURT PROBATION OFFICER 2015 – 2017

Reduced recidivism rates by working with County Courts to engage clients in community services.

•Managed cases while supervising clients under state approved contracts.

•Engaged with community leaders to provide support to families.

•Presented Pre-Disposition reports to county judges for juvenile cases pending court action.

•Supervised children while pending court action/under state supervision.

•Conducted Preliminary investigations with clients pending criminal charges.

•Worked with District Attorney’s Office, and regional attorneys to resolve issues.

•Conducted preliminary mental health assessment on clients.

•Fostered relationships with county judges, and ADA’s office.

Contact this candidate