Overview:

• I am an experienced IT professional with 12 years working with t-SQL and SQL Server. I have written hundreds of stored procedures which implemented complex business rules. I am very adept at writing, tuning and debugging stored procedures, functions etc..
• I have utilized DTS, SSIS to write scripts for ETL. I have used SSRS and Crystal to generate reports. I also have EDI experience and a great deal of VB6 skillls. I learn new technologies quickly and am quick to come up to speed on legacy software.

COMPUTER SKILLS:

Application Programming: Visual Basic 6, VBScript, VBA, Progress, some VB.net

Database Programming: T-SQL, ETL, DTS, SSIS, SSRS, SQL Server 2000 / 2005, Stored Procedures, Functions, Triggers, Access Jet , XML

Operating Systems: Windows, DOS, some UNIX AIX, HPUX

ERP Systems: familiarity with QAD MfgPro, BPCS, Symix SyteCentre, e-SPS 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:

Confidential

Sourcing Systems Specialist

• Researched complex database schema to retrieve data, then wrote SQL Scripts to generate reports for Senior Management. Reports were presented in Excel.
• Administered ERP systems, e-SPS and PDM, including managing user accounts, system security and troubleshooting issues.
• Analyzed key areas of the database for data integrity.

Confidential

EDI Analyst

• Researched current 4010 documents to identify and verify adherence to that standard.
• Identified qualifiers and segments to determine if they could migrated directly to the next version.
• Converted EDI documents 837 from the 4010 standard to the 5010 standard, which is mandated to be complete by 01/01/12.
• 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

Confidential

Database Analyst

• 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

Confidential

Software Developer

• 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 very limited exposure to C and ASP doing bug fixes and enhancements .

Confidential

Database Developer

• 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 Confidential

• Wrote T-SQL stored procedures, DTS packages, SSIS packaged 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

Confidential

Senior Software Engineer Consultant

• Managed, maintained and enhanced web site.
• Performed DBA duties backups, monitoring the server's health with small SQL Server 2000 database

Confidential

EDI Developer Consultant

• 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

Confidential

Software Developer

• 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.

Confidential

Software Engineer

• 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

Confidential

Senior Database Software Developer

• 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

Confidential

Systems Analyst / EDI Manager

• 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

Confidential

Systems Analyst

• 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

Confidential

Information Technology Manager

• 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