EDI Analyst Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Derac Cook    2011 S. 90^th Drive; Arjentina, BA 40112

                                                910-725-3042

                                                Derac_cook14@ymail.com 

CAREER OBJECTIVE:

              To secure a position as a SQL Database Programmer / Analyst, ETL Developer or similar with a sound and progressive company where I can utilize and further develop my training, experience and talent in both software and business acumen.

COMPUTER SKILLS:

       ·  Application Programming:  Visual Basic 6, VBScript

            · Database Programming:  T-SQL, ETL, DTS, SSIS, SSRS, Crystal Reports 10, SQL Server 2000 / 2005, Jet (MS Access), Stored Procedures, Functions, Triggers, Progress, Access (Jet), XML

              ·  Operating Systems:  Windows NT, Windows 2000, Windows XP, Windows 9x, Windows 3x, Windows7, DOS, some UNIX

              ·  ERP Systems:   familiarity with QAD MfgPro, BPCS, SyteCentre; and as a power user in ERP systems in general

             · Application Software:  Gentran Excel, Total-EDI, Microsoft Office, SPC / SQC packages, Outlook, MS Project

RECENT EXPERIENCE:

 HMA, Inc., A MultiPlan Company  (contract through Enterprise Solutions, Inc)

                1600 West Broadway Rd.  Tempe,BA 40112 

                                EDI Analyst  (August 2011 – Present)

·  Converted EDI documents (837) from the 4010 standard to the 5010 standard, which is mandated to be complete   by 01/01/12.   This involved a great deal of analysis due to the complexity of the scope of the changes.

(note:  During these period from April - June, traveled back and forth between Phoenix and Pennsylvania because of a death in my family and dealing with disposal of the estate.  I just wanted to mention it because of the large amount of time between my last position and the HMA Job)

              Wells-Fargo (contract through Technology Staffing Solutions)

                 9380 E. Bahia Dr. Ste. A202; Scottsdale, AZ 86102

                            Database Analyst  (November 2010 – April 2011) 

                              ·  Through daily contact, implemented government (external) and business (internal) SSRS reports as needed for                                    government reporting

                              ·  Worked with the business to determine information needs, then created reports from SQL Server and DB2               databases to best satisfy those needs

                              ·  Created numerous ad-hoc queries to aggregate and analyze data for management.  Queries would be sent to the

                                                        Customer in SSRS reports, XML, Excel, XML or flat files.

                              ·  Utilized SSIS, T-SQL and Excel to facilitate ETL

              Arizona Department of Education

                 1535 West Jefferson St;  Phoenix, AZ  35102 

                            Software Developer  (March 2007 – October 2010) 

                            ·  As the legislative business rules frequently changed, I created numerous queries to aggregate and analyze

                                                                      data to display information in the most effective way possible using SSRS and Crystal reports.  Worked

                                                                      closely with the Business Analysts to help them understand what they really wanted

                            ·  Created ad hoc for the teams to help explore the data

                            ·  Created T-SQL stored procedures and functions to implement business rules using SQL Server 2000, 2005

                            ·  Refactored existing stored procedures to increase speed and efficiency

                            ·  Used SSIS, DTS, T-SQL and Excel to facilitate ETL

                            ·  Assisted DBA’s in implementing effective indexing and 3NF to speed up processing

                            ·  Maintained and enhanced the department’s numerous major information systems using Visual Basic 6, COM+, MTS,    MSMQ, XML, X-PATH, C#, ASP

                           

              Professional Consulting at various positions  (April 2005 – March 2007)

                            CVSCaremark

                                          Database Developer Consultant (2007)

                                          ·  As a member of a database design team, assisted in designing and creating a new datawarehouse.

                                          ·  Created T-SQL stored procedures and UDF’s to implement business logic

                                          ·  Used DTS for ETL to load new database to and from several disparate data sources

                            Thomson-Netg 

                                          Senior Software Developer Consultant (2006 - 2007)

                                          ·  Wrote T-SQL stored procedures and DTS packages to perform ETL from AS/400-based Infinium to SQL Server–based Softrax financial package

                                          ·  Assisted team in redesigning database for an ancillary scheduling system 

                            The Gun Source (TGS)

                                          Senior Software Engineer Consultant (2005)

                                          ·  Managed, maintained and enhanced web site using C# and ASP.net

                                          ·  Performed DBA duties (backups, monitoring the server’s health) with small SQL Server 2000 database

                            Computer Network Solutions

                                          EDI Developer Consultant (2005)

                                          ·  Worked closely with customers and suppliers implement new ANSI X.12 EDI 4010 transactions (input and  output) for external client’s ERP system, using VB 6.0 and SQL Server stored procedures for ETL

              eTelecare Global Solutions Corp

                 8901 E Raintree Dr;  Scottsdale, AZ 85260  (480-951-6390)

                            Software Developer  (Sep 2004 – April 2005) 

                                         ·  Created, tuned and enhanced T-SQL stored procedures to implement business rules with SQL Server 2000

                                         ·  Created DTS packages for ETL between various sources (SQL Server, Jet, .csv text files. Excel; etc).

                                                ·  Created and maintained VB 6.0 code to communicate with call center telephony equipment.

                            ·  Wrote IVR (Interactive Voice Response) scripts to answer and route calls in a logical structure.

              **** (Relocated from Tucson to Phoenix)

              ESPH (Environmental Services Products Holdings; Inc.)

                 2104 N Forbes Blvd, Tucson, AZ 85745  (520-624-2710)                           

                            Software Engineer  (Jun 2001 – Jul 2004) 

                                          ·  Used T-SQL stored procedures the transfer data between the testing equipment analyzers and then, to the client’s databases (ETL).

                                          ·  Created reports using Crystal Reports to display PASS / FAIL results, along with emissions data

                                          · Translated complex customer specifications into software design specifications, then followed through the implementation, testing and deployment

                                          ·  Designed, created and maintained software modules using VB6 to implement:                                       ·   serial interfaces for control of emissions testing devices including dynamometers, gas analyzers

                                                      ·   state machine transition based processing algorithms

              Symix, Inc. (FrontStep);  Tucson, AZ

                            Senior Database Software Developer  (May 1999 – May 2001) 

                                          ·  Composed T-SQL queries and stored procedures to produce both ad-hoc and hard copy reports, and presented the information in Crystal Reports

                                          ·   The project’s entire business layer was implemented in the middle tier in SQL Server 7 and SQL Server 2000.  I created and maintained hundreds of stored procedures to implement the business logic in the ERP systems modules, such as EDI, Accounts Payable, Accounts Receivable, Purchasing, Shop Floor Control, APS; etc.

                                          ·  Utilizing needs discovered in the design phase, used DTS to map, transition, import / export data for the EDI module.  I created the EDI module in VB6 and mentored others in the formatting of the EDI documents.  Visited customers and their web-sites for implementation and integration with their system using Gentran Excel

                                          · Designed and implemented user-interfaces

                                                                     

              Lisa Frank, Inc.;  Tucson, AZ

                  6760 S Lisa Frank Ave;  Tucson, AZ 85706 

                            Systems Analyst / EDI Manager (Jul 1999 – Mar 1999) 

                                          · Upgraded their ERP system, MfgPro

                                          · Utilized ETL translator software Gentran Excel to upgrade EDI system to y2k 4010 standard

                                          · Worked with vendors and suppliers to resolve EDI problems with customers and suppliers, and implemented new transactions

                                          · Mentored others in EDI document formats and the processing cycle

                                          · Managed security policies on HP9000 minicomputer running HP-UX

              **** (Studied for and received my MCSE certification (Jun 1999 – Jul 1999))

              ·  Universal Avionics Systems Corp;  Tucson, AZ

            3260 E Universal Way; Tucson, AZ  85706

                            Systems Analyst (November 1998 – June 1999) 

                                          ·  Translated VAX BASIC flat file database programs to work with Progress v6

                                          ·  Created MS Access application to document and aid in analysis of schema of legacy business system

                                          ·  Created Information Technology Resource Management System (ITeRMS) application in MS Access

              **** (Relocated from New York to Arizona)

              ALCOA - Alcoa Packaging Equipment; Randolph, NY

                 26 Center St.;  Randolph, NY 14772 

                            Information Technology Manager (Jan 1996 – Mar 1998)

                                          · Expanded, updated and replaced their legacy information infrastructure (new network, new software, more PC’s, videoconferencing) from a 10 seat Novel network to an 80 user Microsoft-centric TCP/IP network

                                          · Assisted in implementing email

                                          · Installed and administered NT 4.0 servers (PDC, BDC, DHCP, WINS, DNS, accounts, groups, security; etc.)

                                          · Provided technical support for users (software and hardware problems) and classroom - style training

                                          ·  Created MS Access/Jet/VBA applications for Sales (customer issue tracking) and Help Desk, with user-defined reports used by management to assess work load and to assign tasks to technicians

                                          ·  administered IBM RS-6000 running AIX (user accounts, groups, NFS, Telnet)

              ·  OSRAM Sylvania Corporation; Warren, PA. 

                                          Personal Computer Specialist  (1995 - 1996)

                                                        ·  I supported users in 160 seat NT server / WFW 3.11 client LAN

              **** (Went back to school to earn my degree)

              ·  Loranger Manufacturing Corporation; Clark Street; Warren, PA.

                                          Quality Systems Engineer (1990 - 1993)

                                                        ·  I developed QOS (Quality Operating System) to help win Ford Motor Company’s Q1 award

                                                        ·  Developed applications to extract and summarize data form SPC/SQC system

                                                        ·  Provided statistical analysis to support Quality and Process Engineering functions

                                                        ·  In Lotus Symphony, built database to store and analyze supplier quality ratings

                                                        ·  Provided mentoring in Statistical Process Control to engineering and productione

                                                        ·  Actively participated in Continuous Improvement teams

                                                        ·  Created graphical presentations for management

                                          Industrial Engineer (1988 to 1990)

                                                                      ·  Provided Cost Accounting functions and variance analysis for top management

                                                        ·  Provided software support to users

                                                        ·  Studied manufacturing processes and recommended improvements to management

EDUCATION / TRAINING:

              · University of Pittsburgh

                            ·  Major in Computer Science, Minor in Business                           

              · Jamestown Community College             

                            ·  A.S. in Computer Science (graduated magna cum laude)

                            ·  member of Phi Theta Kappa honor society for two-year colleges

               · Certificates of Completion - Computer Courses

                          ·  Fundamentals of UNIX                    ·  PICK / AP / D3                                          ·  Visual Basic 6.0             

                            ·  A+ Certification                                  ·  Microcomputer Technology and Data Management (960 hr course)

                            ·  Total EDI                                           ·  MS Access                                          ·  MS Project

               · Certificates of Completion - Miscellaneous

                                       · Management Development                         · Team Oriented Problem Solving        · The Dale Carnegie Course

                             · Statistical Process Control I & II               · Quality Operating Systems (QOS)   

References, transcripts and certifications are available upon request

Download Resume Format