TECHNICAL SKILLS

Languages: SQL, PL/SQL, TSQL, RPG ILE, RPG IV, CL RPG FREE

Operating Systems: AS/400, Windows, I series

Database: SQL Server 2008, ORACLE, OS/400

Tools: MS Project, PMP, MS Excel, MS Word, MS Outlook, SSRS, Turnover SDLC, Use Case, Crystal Reports, Access SOCS

Other: ERP, MRP, VMWare, Exchange, Active Directory, Outlook, Wireless Technology, Firewall, Hand held scanners, Barcode Technology, Hawkeye, Robot, IBM Blade Servers

PROFESSIONAL EXPERIENCE

Confidential

Analyst - AS/400 to SAP migration

Responsibilities:

• Develop business cost accounting architecture using requirements such as scope, processes, alternatives and risks
• Played key role in design and execution of implementation model to capture design and development requirements in an interactive development life cycle that will create true manufacturing costs and inventory cycle counting
• Group lead directing full-time employees at client site for ability to identify, develop, and manage technological requirements through a multi-year project life cycle
• Translate stakeholder requirements into tangible deliverables such as functional specifications, user cases, workflow/process diagrams, data flow/data model diagrams
• Conduct multi-level testing including functional, regression, user acceptance, integration and performance to verify the clients need are met
• Liaise between business and technical personnel to ensure a mutual understanding of processes and application
• Liaise between technical personnel to locate, reformat, analyze, and ensure only pristine data was transferred into SAP.

Confidential

Business Analyst - FTP - SFTP migration

Responsibilities:

• Analyzed Confidential requirement and their impact in other services and features
• Worked with Confidential (Enterprise Leasing) to create solution that met their requirements and parallels overall business strategy
• Developed functional specifications based on Confidential ’s requirements and coordinated and maintained the interaction between the Product Development team and the requirements
• Shared knowledge in area of SFTP expertise
• Assisted in locating FTP code that would need to be changed by developing search programs
• Coordinated and performed unit and integration testing

Confidential

Consultant /Programmer

ENVIRONMENT: AS/400 FTP XML SQL external procedures bonded programs

Responsibilities:

• Coordinated schedules and delivery dates
• Led full SDLC software implementations for new/external clients
• Participated in an upgrade, modifications to the system, coding (RPGILE RPGFREE and SQL) for the system, troubleshooting, etc.
• Coordinated with third party software implementation
• Ensured objectives and project deliverables were accomplished on time
• Client liaison assigned to communicate with clients, design custom software, assign and assist with programming in RPGILE and SQL
• Coordinated with off-shore client stakeholders
• Built and maintained project plan, scope, tasks, work effort, charters, etc.
• Worked in an Agile environment with extensive documentation

Confidential

Consultant

ENVIRONMENT: UNIX Servers, ORACLE, SQL, PL/SQL

Responsibilities:

• Designed, developed, and deployed BI sales applications using Oracle developer tools; SQL, PL/SQL, Data Warehouse and Data Mining
• Integrated Oracle apps with custom apps
• Gained experience with database mapping and SSIS, SSRS
• Created custom forms and reports with developer. Screens consisted of current and historical sales data analyzed by region, product group and period
• Monitored system via concurrent managers, analyzed data and data flow between Oracle and custom applications with SQL

Confidential - St. Louis, MO

Consultant

ENVIRONMENT: AS/400 SQL, FTP, EDI, Adhered to all HIPPA regulations

Responsibilities:

• Led effort to create new 835 EDI records
• Supervised mapping effort
• Processed data testing
• Led implementation
• Created, analyzed, and programmed (RPG free) systems for Claims Interface department at Magellan Health Care
• Analyzed customer data file layouts
• Completed data mapping of customer data into EDI 837 and 835 file layouts
• Wrote programs to move data from database into 837 and 835 data files.
• Used FTP protocols to send EDI files to clients
• Corresponded with clients relative to 837 and 835 data
• Created programmer test grids, member of system implementation team

Confidential - St. Louis, MO

Information Systems Manager / Project Leader

ENVIRONMENT: AS/400, IBM BLADE SERVERS, SQL Server, Exchange, Active Directory, Wireless, VMware, Microsoft Dynamics, NAV MRP

Responsibilities:

• Developed and implemented Barcode Inventory Control System on AS/400 utilizing new wireless infrastructure in three warehouses, hand held scanners, and barcode printers. This system replaced a manual system, and introduced barcode technology to the company. RPGILE
• Led discussions with upper management to review new MRP software packages. Led software selection process. Migrated company from in-house business system to Microsoft Dynamics NAV MRP system. Migrated company’s database from AS/400 to SQL server
• Recommended and provided laptops to sales staff and service technicians and provided them access to online internal business systems
• Designed, coded, and implemented Interface to John Deere SAP system. System supplied market and company sales data to John Deere
• Implemented VMWare to reduce hardware costs and server down time on an IBM Blade Center and moved main servers to Virtual environment
• Implemented Microsoft Exchange and Active Directory on Dell servers
• Reduced overall communication costs by 50% annually
• Designed, coded RPGILE and implemented Service Contract Tracking System. This system collects data on service contracts, and the location of the product to be serviced. It places all the data into a calendar system, which provides the service manager an on-line tool used to schedule service techs
• Led IT Steering Committee meetings. Discussed and reviewed IT projects with VP’s and managers from four company locations. Associate priorities to projects based on companies overall needs and anticipated ROI
• Designed, coded and implemented Electronic Sales Contract System RPGILE replacing paper system. Data entry programs collect sales and customer info, BOM and description of product to be built. An automated production order is created. Data entry screens allow for the assignment of engine serial numbers to the job. Each job could be for one engine or hundreds of engines. Mechanic’s time and parts are collected and added to the production order. When production is complete, programs create the invoice, and accounting for the job and send it to the GL system.