Provide specialized application/system expertise and assistance in the analysis, design, deployment, and support of critical business functions within BP’ information technology systems portfolio. Individuals work closely with both external and internal customers, department colleagues, system vendors, and other stakeholders to define user requirements and provide integrated solutions based upon BP’ standard, and occasionally customized, computer/systems architecture and applications.
Reviewing and developing application build/design specifications.
Performing as business/technical liaison between end users, departmental managers, IT and other service providers/partners
Identifying key implementation deliverables and timelines and providing content accountability for specified deliverables.
Converting business requirements to functional requirements to create business rules, scripts and procedures that are accessible, usable, efficient, re-usable, cost-effective, and supportable.
Designing test procedures which enumerate the conditions to be tested.
Participating in operational, system and customer acceptance planning and testing, supporting full end-to-end deployment of application/system solution.
Preparing, distributing, and conducting training and/or providing input to written documentation for technical methods, procedures, functions, or processes to support the installation, operations, training, and lifecycle of information technology solutions.
Act as a point of contact for management and staff in assigned business areas related to information systems services. Actively participate in interdepartmental meetings and provide advice related to the managed care business and information systems.
Developing BI Analytics reports using Cognos Impromptu Version 8 and 10
Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports on Cognos 10.1
Design, Develop and Implement Reports on Crystal Reports and Microstrategy
Development of Reporting services used to link applications related with IBM Maximo software used to administrate assets and maintenance equipment.
ETL, queries and data migrations from SQL to Oracle Data Base
Crete Executive reports for Directives areas using Power Point, MS Excel(Pivots table), Project and Visio
Inventory control and management; also be responsible for tracking inventory trends, discovering ways to save money and maintaining consistency in material quality.
Assists in auditing data for accuracy and preparing summary reports, spreadsheets, graphics, Commodities Reviews, Request for Quotation, BOM, pricing, forecast, financial, Impact Analysis and charts based on the analysis of data using different tool such as Excel, SQL, Oracle, Cognos BI, Teradata, SAP, BAAN, Crystal Report.
Identify and escalates potential issues related to metrics, data analyst and support over SCRUM.
Creating queries in Access SQL, Oracle (Database) or Impromptu (Business Object) to download and manipulate information and represent them on Charts reports.
Working with ETL’s Scribe and Microsoft SQL Server Integration Services (SSIS) to load data into oracle, SQL and Teradata using ODBC and jdbc conectors.
Design, development and full life cycle software
Project management related with Development, support and metrics
As a part of material department and IT representative, responsible of developing web application to administrate Part Numbers, inventory and design parts used on new Flextronics Projects
Application design, development and integration for the new web tool (DWA). Used to negotiate best prices related with design Centers around the world. This tool was developed on PHP5 and MySQL as a web front end running over own virtualized Server(ESX/ESXi), Integration with Flextronics ERP systems using a combination of web services and APIs. In addition the application featured a full High performance Queries running over Java to best performance and scheduling abilities. Reports were made using Crystal reports and impromptu, implement QA over Mercury
Implement Web Server to HOST the PHP tool previously mentioned
Data Migration from SQL Server to Oracle and Data migration from Oracle to Teradata, retrieving queries and regression testing for current and new queries using Tsql
Development of reporting services using Net framework 3.0 over Serialization
Support and Training to different team members of the organization
Raise Tickets on Servicenow when support L1 and L2 is required
Implement SCRUM as a QA on development phase
Databases: SQL, Access, Oracle, Microstrategy
Platform: Windows /IIS, Apache, Linux
Technologies: SAP, IDOC, Cognos(Report Studio, Analysis Studio, Query Studio, Cognos Connection), Framework Manager, Cognos Impromptu, PowerPlay Transformer),Cognos Express, SharePoint, Office, EDI, Microstrategy, ETLs, Service Now, Mercury
Analysis and requirements gathering on Electronic Data Interchange connectivity for reporting Sales/Inventory Reports to HP located on EMEA and APJ Region. The goal is the B2B analysis and end to end testing to meet the HP IT Security requirements. In order to make sure there are no interruptions on the communication between HP and all the partners, the job consist on involvement in analysis and Design on all required process to create the new Business setup.
Working with designated contacts for each partner group, maintain overall calendar of testing and setup’s scheduled to be launched or process to follow and communicate to the partners.
Provide overall metrics reporting weekly for all partners supported (Serve as a primary point of contact for any questions or issues that the partner has during new tool).
Assist with identifying gaps between what types of data fields are available to us via automated feeds, And coordinate B2B and A2A teams.
Mapping development, Mapping specs, regression testing and support on Gentran Webmethods and seeburger
Work with different standard data transfer information as EDI, X12, IDOCS, EDIFACT and XML and XSD.
EDI Transaction, data mapping, data translation Types X12- 820, 823, 824, 828, 831, 835, 997, IDOCS, XML on different tools like Cyclone, Gentran, Webmethods and Seeburger
Coordinate “Move to Production” process; release new changes or implementation from Test or UAT environment to Production environment, test and establish communication between partner and HP to avoid any data transfer error.
Created stored procedures for data processing in MS SQL 2008 R2
Databases: SQL, Access, Oracle
Platform: Windows /IIS
Technologies: SAP, IDOC, EDI,X12,XML, SharePoint, Office, FTP, HTTP, HTTPS, CIFS, SeeBurger, Cyclone, Gentran, Webmethods, Mercury
Analysis and requirements gathering to GE Treasury around Mexico and USA. Providing accurate and business analysis of client issues along with appropriate solutions to meet the client’s requirements, Provide creative and practical solutions to facilitate improved client processes and smooth project implementation.
Assist with the implementation of treasury platforms to improve reporting, treasury controls and liquidity, Create business requirements and functional specifications as part of the implementation process including planning, documentation and execution of supporting test cases, Maintain correspondent bank documentation including user authorization and roles management, Create and maintain Excel tools to improve the efficiency and effectiveness of the Bank's cash management processes, Work closely with corporate treasury and external investment manager to provide detailed investment reporting and analysis for risk management purposes.
* To provide day-to-day production application support for Front and Back office Private Banking users in Worldwide region24x7 support over ITIL foundation.
* To manage production issues and respond in a timely manner in accordance to the Service Level Agreement with business and interface systems working with Service Now.
* Development of bug fixes related with Bank Account Administration System. Using native ASP tools, PGP encryption and SWIFT transactions
Works with a multitude of different teams including CRM Implementation Consultants throughout the project lifecycle from strategic definition and proposal through scoping, requirements gathering, development, and implementation, user acceptance testing, and establishing and documenting business processes where needed, responsible for process definition and management oversight of small and medium sized CRM projects, Determine Project needs and business resources required to execute CRM projects between Mexico and Phoenix, Work with Client Executive Project Sponsors to clarify and define strategy & objectives, scope and CRM business requirements, Responsible for the coordination and creation of project documentation and project processes. Facilitating requirements definition meetings with customers.
Understand the business issues and challenges of the client's organization and industry, review and edit requirements, specifications, business processes and recommendations related to proposed solution. Work with customers/prospects to identify key business issues and their priorities
* Microsoft CRM Design, Development, Implementation and Customization
* SQL Server Database Administration and Database Design, queries and ETL transformation
* Synchronizations in Outlook CRM Laptop Client Devices, Integrations with SharePoint, Web Services and BizTalk
Instituto Tecnológico de Hermosillo
BS in Computer Engineering
1999 - 2004
Universidad de Sonora
Six Sigma, Poka Yoke, 5‘S, Lean Manufacturing Diploma
Instituto Mexicano Americano de Relaciones culturales
English Course Certified
General Electric, Flextronics, HP
CMMI, SIX Sigma, Metrics, 5’S at, ITIL Foundation, SCRUM
Hewlett Packard, Flextronics
Project Management Course (PMI)
Windows (User/ Server), Linux, ESXi
TCP / IP, DHCP, DNS, AS2, EDI, HTTP, FTP, SFTP, VPN
Oracle, MySQL, MS SQL Server, MS Access, Teradata
Scrum, CMMI, Project Management, Six Sigma, Lean Manufacturing, ITIL, 5S, Poka Yoke, EDI, B2B
Office, Crystal Report, Cognos Impromptu, Seeburger, Toad, Subversion, MS Visio, MS Project, SharePoint
Teléfono / celular: 662-***-****
Citizen: Mexico, Visa TN(USA)
RAMSES OMAR DIAZ DERAS
Ingeniero en Sistemas / PM, Business Analyst Developer
Ramses Diaz has been involved over 10 years, as business analyst and PM in projects for Manufacturing, Banks, Supermarkets, Parking, Oil and Gas management, Education, Restaurants and sales using CRM, ERP and Data transformation tools.
Project Manager System Specialist – Houston, TX
April 24th, 2014 - Current
Sr Material Analyst IV – Guadalajara, Jal.
July 4th, 2011 – April 24th, 2014
Sr. Business Analyst – Guadalajara, Jal.
Jan 5th, 2009 – Jun 17th, 2011
Sr. Business Analyst – Aguscalientes, Ags.
Jan 5th, 2009 – Jun 17th, 2011
Jan 30th, 2008 – Dec 26th, 2008
Development Project Manager – Hermosillo and Phoenix
Jan 5th, 2009 – Jun 17th, 2011
Jul 10th, 2006 – Nov 30th, 2007