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• Responsible for validating, identifying, and displaying data in Power BI• Support with analyzing datasets, defining workflows, and making metrics more integrated for future projects• Responsible for understanding data and datasets coming from different sources and determine how to normalize data• Created key fields across the data sources to see how data flows through the processes and understand the relations between data• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Business Process• Worked with the business team to collect the business requirements, security and service level requirements and documented them• Used SQL Queries to validate and manipulate the data in SSMS• Coordinated the User Acceptance testing with the end use.

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 • Expert in using Vision 360 Machine to take high quality diamond videos• Inventory control / monitoring and maintaining documentation• Building automation process to help improve workflows and increase data management efficiency

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• Assist in adhoc projects and business case analysis as required by the sales groups.• Consulted with sales analytics managers & directors to help monitor, track, and analyze sales performance.• Transforming transactional claims data into useable datasets.• Perform data migrations, data testing & data analysis.

Manila, Philippines

Manila, Philippines

Manila, Philippines