Jan Michael C. Email & Phone Number

Los Angeles, California, United States

Los Angeles, California, United States

• Work with Operations, Integrity Management & Strategic Planning teams to provide insights with daily production stat and data monitoring
• Responsible for project closeout for high pressure pipeline installations
• Identifying, designing, and implementing internal process improvements, such as automating/limiting manual processes and optimizing data delivery
• Integrate data from many sources to produce requested or required data elements
• Work with stakeholders in Integrity Management & Strategic Planning team to assist with data-related issues and support their data infrastructure needs
• Develop automation using SSIS package to import data directly from Oracle to SQL and created stored procedures

Los Angeles, CA

• Gather and translate high-level business requirements into functional specifications for Corporate Information Security (CIS) and Information Technology (IT) organizations and manage changes to such specifications.
• Develop automation using SSIS package and stored procedures using T-SQL queries
• Designing data model for new projects
• Working on the implementation and integration with backend databases
• Designed dashboards and other types of report modified Tableau and Power BI
• Performed data migrations & data analysis

Los Angeles, CA

• Create data flowcharts and logical data analysis to support business systems projects.
• Identify and investigate operational related issues and implemented solutions.
• Participate in strategic discussions with senior leaders regarding performance, trends, and forecasting.
• Organize and schedule appointments.
• Develop and maintain a filing system by creating web forms.
• Track record exemplifying ability to quickly understand business problems, developing solutions and insights, and communicating them by leveraging data and analytics.

Lipa City, Philippines

• Maintain records of goods ordered and received.
• Locate vendors of materials, equipment or supplies, and interview them in order to determine product availability and terms of sales.
• Represent companies in negotiating contracts and formulating policies with suppliers.
• Direct and coordinate activities of personnel engaged in buying, selling, and distributing materials, equipment, machinery, and supplies.
• Track record exemplifying ability to quickly understand business problems, developing solutions and insights, and communicating them by leveraging data and analytics
• Writing advanced SQL script to automate and manipulate data extracts

Manila, Philippines

Manila, Philippines

Manila, Philippines