Ingmar Lopez Email & Phone Number

Washington, Dc, Us

Bethesda, Maryland, United States

-Revolutionized Grant Approval Process: Deployment of Azure Open AI, significantly automating and refining the grant approval workflow, achieving unmatched efficiency and accuracy.-Database Design and Implementation: Expertly planned, designed, and implemented databases using MySQL and Visio, paving the way for enhanced data analysis and actionable insights.-Advanced Data Analysis and Dashboard Development: Led the initiative to convert complex Excel sheets into user-friendly Power BI dashboards, employing advanced formulas and DAX measures. This enabled executives to easily track progress and make informed decisions based on critical insights.-Data Quality Assurance: Established and enforced stringent data cleaning protocols, ensuring the highest standards of data quality, reliability, and consistency.-Strategic Collaboration with Leadership: Worked closely with the CTO to design and implement AI-driven solutions, transforming the grant approval process and driving strategic automation initiatives.-Operational Efficiency Improvements: Identified discrepancies in the use of Zoom and Teams for panel discussions and training within the grants team. Proposed and developed a Power App using Power Automate and SharePoint lists to streamline and enhance these operations.-Emerging Technology Insights: Identified and communicated emerging tech trends, playing a pivotal role in guiding strategic decisions and driving organizational growth.

College Park, Maryland, United States

-Successfully executed a data analytics project to analyze traffic datasets and gain insights into factors contributing to traffic congestion and safety issues in a city.-Ensured the correlation and compatibility of external datasets with current datasets, while ensuring the readability of the datasets for non-experts.-Determined the sources of traffic datasets, distinguishing between federal, state, and local agencies.Used appropriate data visualization techniques, including heatmaps for city and highway data, to display insights to the client.-Developed and maintained a constantly updated database of traffic data, ensuring ease of support and adaptability for future changes.Ensured the security and integrity of the database and data visualization software, limiting access and monitoring changes.-Identified potential future requirements, including the addition of external datasets and automatic updates to the data.-Planned for user documentation and training to aid in the understanding of the data by those with access.-Demonstrated a commitment to excellence in project management and execution, providing valuable insights to the client.

Bethesda, Maryland, United States

-Coordinated and managed medical referrals and appointments for all military members at training facilities, ensuring timely and efficient care for personnel.-Implemented strategies to streamline clinic requirements, resulting in increased ease and accessibility for military members to book appointments.-Collaborated with medical staff and other stakeholders to ensure smooth and effective coordination of medical services.-Maintained accurate records and documentation of all medical referrals and appointments, ensuring compliance with regulations and policies.-Demonstrated excellent communication skills in interacting with military members, medical staff, and other stakeholders, ensuring that all parties were informed and updated throughout the referral and appointment process.-Showcased exceptional organizational abilities in managing a large volume of referrals and appointments, ensuring that all military members received the necessary care they required.

Frederick, Maryland, United States

-Conducted in-depth industry analysis to identify new and emerging trends, which allowed us to broaden our product offerings and effectively target key customer segments such as doctor's and pediatric offices.-Utilized advanced analytics to identify market growth opportunities, with a focus on expanding our presence in the pediatric nebulizer sector.-Streamlined business operations and processes through a comprehensive review and optimization effort, leading to increased efficiency and improved workflow.-Deployed robust security systems and controls, ensuring the highest levels of protection for sensitive information and customer data.-Elevated our online presence by enhancing website navigation, integrating engaging multimedia content, and staying up-to-date with the latest social media technologies.

Frederick, Maryland, United States

-Designed and manufactured innovative clinical trial kits for leading biopharmaceutical corporations, resulting in streamlined and efficient research processes.-Crafted meticulously detailed order requests in collaboration with esteemed scientists, contributing to the successful completion of numerous projects.-Strategically managed and maintained a fully-stocked inventory of essential supplies for clinical workstations and procedure rooms, ensuring seamless operations.-Implemented comprehensive oversight of equipment and system operations, continuously monitoring and assessing potential security risks while proactively identifying and executing upgrades to maintain optimal performance.