Jorge Paredes 978-***-**** ac5gdi@r.postjobfree.com Charlotte, NC

PROFESSIONAL PROFILE

Has 20+ years experience as an IT consultant focusing on Application Implementation and SDLC related projects, with 12+ years as a Project Manager applying several methodologies (Waterfall, Iterative, Agile, Iterative, Scrum and Prince2). With strong problem-solving and multi-tasking management skills, and over 28 years of professional experience. Experience with simultaneously supporting a large number of clients. Has an extended project background which includes managing projects and business analysis on ERP (Supply Chain Management) and EDI implementations, application configuration and Oracle DB design, development and administration as well as process re-engineering (BPM) and ISO 9000 implementation. Project documentation and report design. Strong focus on customer service and enjoys developing relationships with customers/clients.

Primary expertise is in Manufacturing and Healthcare industries, managing end to end and going on projects, started in the Automotive industry and across many manufacturing environments such as Textile, Editorial, Packaging industry for oils and additive, as well as Finance (Banking), Retail, and Transportation industries.

OBJECTIVE

To become an integral member of a dynamic, intellectually challenging, and above all innovative project team that will take advantage of my professional experience in diverse industries.

SUMMARY

Fourteen years’ experience in EDI implementation using ASC X12 Standards versions 003010 – 004010, AIAG (V002003), HIPAA 004010X092, HIPAA 005010, HL7

12 Years as Project Manager, adhering to PMP, Agile, Scrum, Waterfall, Iterative and Prince2 methodologies.

Six years as Project Leader / Business Analyst.

15 years managing Global teams both on site and offshore.

Six-year experience managing ERP software implementations mainly at manufacturing industries.

Six year experience in Analysis, Development & Implementation of in-house applications.

Twenty year experience as an IT consultant, to improve business, administrative and manufacturing processes (BPM) Business Analysis, Data Analysis and Project Management.

Two year experience in evaluating ERP systems for manufacturing industries.

One year experience in evaluation and acquisition of network design (LAN / WAN) and Operating System, as well as, communications (voice – data).

Six years of Business analysis in a formal SDLC environment.

4 years of Requirements elicitation and management.

Six years of Translation of business requirements into data and process models.

Eight years developing work products in support of project work like process decomposition diagrams, data models, data flow diagrams, entity relationship diagrams.

Strong analytical, written, and verbal skills.

25 years working directly with all levels of staff and management in the customer departments, as well as different disciplines with varying degrees of technical experience.

4 years Experience in evaluating vendor proposals.

CERTIFICATIONS

●Six Sigma Green Belt

PRIMARY SKILLS

(In Order of expertise)-- ( n years of experience, nn last year used)

ERP Software: Oracle 11i (1 year, 07), SAP/R3 (2 years, 03), MFG Pro (3 year, 97), 4th Shift (1year, 99)

Languages: PL/SQL (5 years,05), Progress (3 years, 99), C (2 years, 94), Visual Basic (1.5 years, 02), Pro C (1 year, 91)

Databases: Oracle(5 years, 03), Progress (3 years, 00), MS Access (2 years, 03)

Workflow: Microsoft Exchange (3 years), Microsoft Outlook (10 years).

Operating Systems : Microsoft Windows 3.11(5 years.97), Microsoft Windows 95 (3 years,99), Microsoft Windows NT 4.0 (3 year, 01), HP-Ux (4 years, 02), Solaris UX (2 years, 05), Citrix (2 years, 01), Windows 2000 (1 year, 01), Windows XP (4 years, 05), VAX/VMS(2, 95), Linux (4 years, 17)

Platforms: PC (9 years,05), HP 9000(3 years,98), SUN Solaris (2 years, 05), Tandem, IBM Mainframe, Digital VAX, Tandem, Linux, Cloud

Software Packages: Toad, Erwin, SQL plus, MS Office, SharePoint, Visio 2000, MS Project, Remedy v.7.5, Peregrine Asset Center, ABC EDI Excel, Crystal reports, Brio, STX 12, Optio, Sterling EDI (Gentran), VI Editor, Unix Scripts, Minitab, QDX integrator (Cloverleaf), Seeburger, Sterling OMS.

EDI Transaction sets: 830, 856, 861, 862, 820, 142, 997, 850, 852, 270, 271, 835, 837, 276, 277, 278, ORU, ORX, 821, 828, 822, 864, 824, 996, 997.

SECONDARY SKILLS

Languages: C++ (1 year, 90), Visual Basic (2 years, 01)

Databases: Access (3 years, 03). Oracle (6 years, 07)

Hardware: Cisco routers (6 months,98), Bay Networks Switch (6 months, 98), Motorola modems (6 months, 98).

EDUCATION

BS in Cybernetic and Computer Science Engineer. La Salle University, Mexico 1990

EXPERIENCE

Project Manager Aug ’17 to Present

XPO Logistics Location: Charlotte, NC

Project One XPO HR Global Audit & Compliance

Tools MS Project, Visio, SharePoint, Jira, Success Factors EC & ECP (cloud)

Methodology Waterfall

Description Developed and maintaining project plan. Identified risks/issues and provide recommendations. Maintaining risks/issues log. Ensuring stakeholders are engaged and adhering to XPO audit and compliance standards.

Project Manager May ’16 to June ‘17

Maersk Line IT Location: Charlotte, NC

Project GEMS DB Migration I & II

Tools MS Project, SharePoint, Jira, Focal Point (cloud)

Methodology: Proprietary Methodology, Prince2

Description As part of Platform Consolidation Program to move workload off the mainframe, the second phase of GEMS (Global Event Management System) Migration will address the remaining of the GEMS databases from DB2 on the mainframe to Oracle on Linux using Oracle Golden Gate where applicable. On the new platform GEMS transactions would have ample resources and avoid the database issues it’s had in the past with deadlocks, time-outs and long running processes. Managing global offshore team (India, Denmark, UK, US). Schedule, Budget, Engagement and vendor management.

Project Manager July ’15 to May ‘16

Pure Power Technologies Location: Blythewood, SC (remote)

Project SWAT Team Stabilization

Tools Teamwork, Zendesk (cloud)

Methodology: Iterative, Waterfall

Description QIS quality solution is the lynch pin for the PPT organization and is currently experiencing issues that are preventing its use effectively by the Quality Team. Managed a limited engagement activity to engage a senior level SWAT Team was used to address and resolve these outstanding or immediate needs of the QIS, focused on providing an architectural assessment of the current state QIS solution and provide a risk-gap analysis and architectural roadmap. Address and resolve identified outstanding or immediate needs captured in the Zendesk tool as of July 2015 that are preventing the QIS solution from being effectively used by the Quality team for the following modules: Engineering Change Request ECR, Product Change Request PCR, and Materials Inspection Request. Lately added two bridge projects for Eight Disciplines 8D and SSREA modules prior to engaging into an AMS contract. Acting as the engagement manager as being the face of the firm with the client. Managing near-shore development team and 1 architect, weekly status reports to upper management, daily standup calls, under an iterative/PMO approach. Schedule, budget and offshore team management.

Technical Project Manager March ’15 to June ‘15

Lowe’s Home Improvement Location: Mooresville, NC

Project: Genesis – PBI Prioritization and Remedy upgrade

Tools: Remedy

Methodology: Waterfall

Description: Managed Business Process Reengineering of a forgotten but necessary process for PBI Prioritization, created a new approach with rules and policies, improved scoring system and Prioritization request forms. Automatic generation of Prioritization Request forms from a Remedy data extract. As a collaborative effort with Remedy upgrade team performed analyses of existing (Open) PBI’s and determine selection criteria for those needed to be entered in the new Remedy version and suggested to the Business which ones should be closed due to inactivity or lack of incidents. Part of UAT for new Remedy upgrade. Acted as a reviewer for project documentation such as: Problem Management Process design, Work Flow and Policy.

Technical Project Manager Nov ’13 to March ‘15

Lowe’s Home Improvement Location: Mooresville, NC

Project: Sterling R7 – Flexible Fulfillment implementation

Tools: HP-QC, Remedy, M2O, 2020, Sterling OM

Methodology: PMO, Agile

Description: As the company’s primary goal is to better serve its client and be able to provide a true continuity of its experience while placing an order by allowing them to own their data and experience, then give them the ability to use it to guide creation and context of every future experience, an Omni channel approach has been set in place and during implementation I managed the project documentation review, such as HLD, DD, FTE, CR’s to assure traceability accuracy and documentation accountability for the following areas: Assembly, Customer Appeasements, Markdowns Review, Labor Promotions, Regional Vendors, Order Modifications, Tax enhancements, PSE, PII and EDI. Ensuring all project requirements and business rules are properly documented and effectively implemented during next SW version release of Sterling Order Management, providing the successful implementation of an Omni Channel and order fulfillment application. Monitoring SIT, providing issue resolution to Business testers and defect logging during UAT.

Technical Project Manager Mar ’13 to Nov ‘13

Lowe’s Home Improvement Location: Mooresville, NC

Project: HR Learning and Talent Management Project

Tools: SuccessFactors BizX, LMS, TMS (cloud), SiteMinder, NAM, MS Project Server

Methodology: PMO, Iterative

Description: Managed various SAS projects: LMS/TMS implementation as well as SSO implementation for LMS/TMS, Admin Connectors, Application Performance Management, Assessments project and Content Management. Overseeing CIT and SIT as well as coordinating with the vendor its new releases and various third parties to engage and complete their tasks for SSO Project. Running weekly Technical PMO meetings and keeping project plan up to date. Overseeing integration between PeopleSoft and Learning tools (LMS). Schedule, budget, engagement and vendor management.

Project Manager Aug ’10 to Feb ‘13

Lowe’s Home Improvement Location: Mooresville, NC

Project: Store Operations Maintenance

Tools: Remedy 7.6, Eclipse, Hummingbird, EXTRA! X-treme, AIX, MS Project Server, Quality Center v.11

Methodology: Waterfall

Description: Managed prioritization and coordination of incidents, PBI’s, and PKE’s. Managing incident analysis and prioritization for Self-Checkout POS. Liaison between Development, Business and Providers to find root causes for each open ticket. Analysis/Design of new Returns Authorization Management System application (web app) that will be used by the Loss and Prevention department to prevent/identify possible fraudulent returns or known criminals. Managing off-shore/on-site development resources using MS Project Server. Team lead for a major credit PCI compliance release. and subsequent PCI compliance updates. Related to Payments and credit applications, following PCI guidelines as well as those from our vendors (American Express, GE Capital & Chase) not only making sure we didn't store any sensitive client information and masking CC numbers but aligning with legal department to provide credit contracts within compliance and making sure every receipt a customer receipt a customer walks out the door from any store is in compliance too, in both English and Spanish. Coordinating several efforts to determine root causes for several areas: Taxes, credit, and finance. Coordinating and scheduling monthly maintenance and special releases through CRQ’s using Remedy (Release Management). Providing weekly team status updates through the department dashboard, providing statistical reports for PBI’s/PKE’s per period/release. Creation/Coordination of master schedule plan for CIT for Services Platforms Release 7, for Order Capture Tower. Reporting each team weekly status in a centralized dashboard/report used to identify any gaps or issues during CIT. Schedule, budget and offshore team management.

Receivables Manager TDA/PM Sep ’09 to Aug ‘10

Wells Fargo/Wachovia Location: Charlotte, NC

Project: Wells Fargo/Wachovia merger migration EDI clients

Tools: Vector Connexion, TSO, UltraEdit, Sharepoint, TIBCO, Quality Center, EXTRA! X-treme, Rumba

Methodology: PMO

Description: Managed client setup analysis for document merger creation (DSD) for IR to RM, IBP to EBox, and LBFC to RM migrations. Creating ACE forms for each customer. Training peers on IR to RM implementation and tweaking setups. Performing Customer impact analysis. Defect write-up and submittal. Performing peer reviews on customer tweaks and ACE form creation. Testing each client’s setup with real data and performing analysis/validation of outbound files, both EDI and FF formats, on two Mainframe environments: ZULU and BRAVO. Acting as the engagement manager on behalf of the Bank as being the main point of contact with bank’s clients.

EDI Global Operations Project Manager Feb ’08 to Jul ‘09

Bank of America Location: Charlotte, NC

Project: EDI clients’ migration/transformation for the LaSalle Merger

Tools: Vector Connexion, EDIkit, Infinity, ECS, CAIL, TACL, TSO, TR-IP, Ultra Edit, SharePoint

Methodology: Waterfall

OS: XP professional, Tandem, Unix

Description: Managing the migration of LaSalle’s treasury clients to Bank of America’s Mainframe platforms, transactions 821, 828 and proprietary format are considered. GAP analysis has been performed between document versions and clients have been distributed in several implementation buckets, bridges needed to be developed between the 2 banks platforms have been identified. Managing transition of e-commerce clients from LaSalle’s platform to Bank of America’s. Transactions being migrated are 821, 822, 828, 864, 996. Recently supporting the Payables network transition, implementing transactions 820. 831, 824.Using FTP/PGP, AS2, VAN, HTTPS, VPN protocols. Creating hand over documentation for live environment for customer support department for each project. Acting as the engagement manager on behalf of the Bank as being the main point of contact with bank’s clients.

EDI Project Manager Oct ’06 to Feb ‘08

American LaFrance, LLC Location: Summerville, SC

Projects: Oracle ERP Implementation, Data Migration. EDI implementation, System Integration.

Tools: Oracle 11i, Toad, MS Project, Visio, BIS, Oracle E-Gateway, Purchasing modules, Seeburger

Methodology: Waterfall

OS: Linux, Citrix, Windows XP, Solaris

Description: As part of the Management ERP implementation team managing the Oracle EDI Gateway and Order Management (Procurement) modules i-portal included, basically setting up Oracle EDI gateway transactions, suppliers, items master integration and supervising the overall OM setup and all-around Supply Chain Management. Managing a supplier dashboard to report advance. As a joined venture with IBM supervising their consultants and developing team. Project documentation. Taking care of generating technical documentation for data extraction for Freightliner to provide text files based on Oracle’s basic requirements, managing the flow of data, solving issues, verifying data integrity and managing data cleansing efforts as well as sign off on data conversion processes developed by third party.

EDI project: Defining/Designing the transactions to be implemented and standardizing the version to be used as X12 4010, develop the technical implementation guidelines and managing a third-party supplier who developed and installed the translator tool (BIS). Creating EDI guidelines for publication on company’s website for supplier access.

System Integration Project: Managing staff of developers for integration interface coding/development with current Oracle application and third party off site software. Producing project documentation. B2B integration between Oracle and customer suppliers for procurement and invoicing.

Business Systems Analyst Apr ’06 to Oct ‘06

Progress Software Corporation Location: Boston, MA

Project: Data Conversion/DW

Methodology: Waterfall

Tools: PeopleSoft, MFGPro, Progress 4GL, SQL Server, Visio, MS Project, MS Office

OS: Solaris, NT Server, Windows XP, Citrix

Description: As a Business Systems Analyst, working on identifying source information, defining migration policies, creating Functional and Technical specifications. For a migration that will consist on master files and transactional information and consolidate 34 instances of MFGPro and a single instance of PeopleSoft into and Order Management application (Softrax) and Accounting application (OpenAccounts). Updating project documentation. Collaborating along with the SOA project integration to the new legacy systems implementation. Managing requirements to integrate the new applications into their Data Warehouse solution.

EDI PM/Business Analyst Jun ’03 to Feb ‘06

Quovadx Inc. Location: Atlanta, GA

Projects: VISN10, IHS, SALEM HS, CDE

Tools: Oracle pl/sql, QDX Integrator (Cloverleaf), Access, Erwin, Toad, MS Project, Visio, MS Office

Methodology: Waterfall

OS: Solaris, Windows XP, Windows NT

Description: Serving as the EDI expert for this project and develop a validation interface using Oracle DB to perform data cleansing from healthcare customers incoming information to later be processed and create HIPAA EDI transactions. DB design and stored procedures, triggers, functions using pl/sql with Toad. Testing X.12 formats (270, 271), mappings, translations and transmissions to the Clearinghouses who then respond us using transaction 271. This implementation is to be intended for 5 mayor locations. Implementing ISO 9001 manuals and procedures writing techniques. Managing project tasks through MS Project. Creating interface documentation.

Involved in several parallel projects implementing different transactions as 276, 277, 278, 837 & 835. Basically, defining how to route claims through our application to determine which Clearing house it has to be submitted and take care of requests, payment advices, referral requests and responses to our client providing them HIPAA compliant X.12 transaction sets. Design the DB model for reporting. Setting up built-in XML maps within the Cloverleaf engine for claims and benefits eligibility. Mapping HL7 transactions ORU and ORC to multiple flat files for client DB load. Setting the strategy for integration between the engine and client’s legacy systems.

SAP Upgrade Consultant Feb ’03 to May ‘03

Software Technical Services, Inc. USA Location: Miami, FL

Project: SAP Upgrade

Customer: GM LAAM

Tools: SAP V4.0B / V4.6C, MS Office, MS Project

Methodology: ASAP, Waterfall

Description: Managing the SAP upgrade project and rollout of 5 instances by interacting with personnel of different countries: Chile, Colombia, Venezuela and Ecuador, understanding their issues with the system and serving as a liaison between them and their instances and how they’ll integrate at the corporate level for financial reporting. The following modules where upgraded: MM, SD, FI, CO. through a pretty straight forward implementation.

Business Analyst May ’01 to Dec ‘03

Software Technical Services, Inc. USA Location: Cincinnati, OH

Project: DAM Gen II

Customer: GE Capital IT Solutions

Tools TOAD, Oracle PL/SQL V8.1.6, MS Project, MS Office

Methodology: Waterfall

O/S Windows NT 4.0, Windows 2000, Citrix, Unix Solaris

Description: Analysis/Develop the second generation of Digital Asset Management as well as maintaining the current application for bug fixing. Testing and implementing with customers and preparing the Security version to be commercialized to various customers on a module by module upgrading or enhancing product. Developing the interface to the Oracle Financials Billing module, this sends the monthly movements for each customer to be billed by the main financial application. Event and Object Oriented modeling. Loading data from several sources using different methods as ASCII files, SQL loader, Dblinks. Developing backend Oracle procedures and triggers using pl/sql and Toad. Using shell scripts and cron files to FTP files from remote locations and launch the loading process. Using Oracle jobs to perform several repetitive tasks. Supervising development of several reporting needs for in-house apps. Using Crystal reports and Brio.

EDI Consultant (Project Leader), Feb ‘99 to May ‘01

Softtek Integration Systems, Inc. USA Location: Minneapolis, MN

Project EDI Implementation

Customer: GE Capital IT Solutions

Software Astea, Oracle 7.3, Oracle 8.1.5, Visual Basic 6.0, Erwin 3.5, Progress V.7.3E, MS Project, MS Office

Tools TOAD, Oracle SQL Works

Methodology: Waterfall

O/S Windows NT 4.0, Windows 95, Digital Unix V.4.0D

Role EDI Consultant / Developer

Description: This software manages all income service orders and dispatches Technicians to solve the problem on-site as well as the general ledger issues and billing matters.

Responsibilities:

Involved in the System Design, Analysis, Implementation and database creation.

Generating the Database design using Erwin.

Using Oracle scripts to add / delete indexes, constraints, views, packages with the help of TOAD.

The main application is developed under Visual Basic and uses the Oracle DB to validate all incoming transactions from trading partners. And it will address the information to the various dispatching systems depending on the originator.

Definition of a unique flat-file structure to be used by two trading partners to validate incoming data. Mapping the transactions, as well as translation of them.

Using ASCX12 release 004010 for Transaction sets 142 and 856. Working with GEIS as the Van/Translator provider.

Project Sales Prospecting tool

Customer: GE Capital IT Solutions

Software Oracle 8.1.5, MS Access

Tools TOAD, MS Access, MS Office, MS Project, Visio, Erwin

Description: Design the DB, application an implementation plan. This is a tool that will help consolidate all data from sales representatives and keep track of their prospects and their own sales performance, as well as, will be the base for migrating to the new application early next year.

Project Asset Management

Customer: GE Capital IT Solutions

Software Oracle 8.1.5, MS Access, Peregrine, Remedy, VB 7.0, MS Office, MS Project, Visio

Description This is the consolidation of several Asset management applications, validated by an interim DB that will populate the target application: Peregrine. Sources: Peoplesoft and SAP through dump files and text files. The use of creepy crawling agents across the client’s network collected asset info that was dumped into a flat file that later was picked up by us and processed. Complete asset management life cycle. Develop a managerial reporting tool that runs every month to evaluate the service performance for one of our customers.

TRAINING

Prince2 Fundamentals. Maersk facilities. Sep 16

Prince2 Practitioner. Maersk facilities. Sep 16

SCRUM training. Apr 16

Business Analyst Boot Camp. ASPE Technology. Nov 07.

Oracle Discoverer. American LaFrance. Aug ’07.

Lean Manufacturing. American LaFrance. Mar ’07.

Fundamentals of Project Management. Skillpath. Nov ’04.

Six Sigma Green Belt. FoMoCo. Jul ’03.

QDX Integrator. QUOVADX Facilities, Jun ’03.

Clear Basic for Clarify. GECITS Facilities. US. Nov’00.

L0515 Invoice Verification (SAP/R3). SAP Facilities Mexico. November '97.

L0520 Purchasing (SAP/R3). SAP Facilities Mexico. November '97.

L0525 Consuming Planification. SAP Facilities Mexico. November '97.

L0550 MM Configuration and Organization . SAP Facilities Mexico. November '97.

L0535 Materials Valoration. SAP Facilities Mexico. November '97.

Supply Chain Management (APICS). March '97 - October '97.

Cost Managing. Sistemas Integrados Facilities. July '97.

Production Activity Control (APICS). Tepeji del Rio. October '97 - December '97.

FOREX: Financial Analysis. Mexico City. November-December 1995.

HP-UX Fundamentals. Hewlett Packard Facilities. December 1991.

Series 800 Administration for HP-9000. Hewlett Packard Facilities. January 1992.

HP-UX Development Environment. Hewlett Packard Facilities. February 1992.

Progress Programming. Hewlett Packard Facilities. March 1992.

Advanced Progress Programming. Dina Camiones Facilities. November 1992.

Open Manufacturing. Hewlett Packard Facilities. April 1992.

Manufacturing Fundamentals. Hewlett Packard Facilities. April 1992.

MRP Introduction. Dina Camiones Facilities. May 1992.

MRP II. Dina Camiones Facilities. June 1992.

Electronic Data Interchange: An Introductory Course For Mexico. Mexico City Krystal Hotel. May’92.

Inventory Administration (APICS). KPMG Facilities. January 1990.

Oracle SQLPLUS, SQLMENU, SQLFORMS, SQLREPORTWRITER. Oracle Mexico Facilities. May’90.

Contact this candidate