SOFTWARE DEVELOPMENT ENGINEER
Analytical IT professional with experience in the spectrum of software development phases using IT development life cycle methodology. Effective technical leader ~ demonstrating strong verbal and written communication skills, attention to detail, mediation, negotiation, root problem solving, direct, honest and customer focused skills. Expertise in technical team leading, data analysis, data modeling, data management, business intelligence and reporting. Excels at streamlining processes and system run times; systems integration; and developing and implementing standards. An inclusive team player that takes initiative; encourages team participation / collaboration / brainstorming to create optimal business solutions. Possesses creative problem solving skills, is organized, conscientious, detail-oriented and has an innate desire for continuous process and run-time improvements. Interest in expanding data warehousing knowledge.

KEY ACCOMPLISHMENTS

• Automated 588 Dashboard reports, reducing monthly manual processes by 1,000 hours. Used Microsoft SQL Server 2005 and Excel, with SQL and stored procedures.
• Made performance improvements in webMethods that resulted in a reduction of run time from estimated 56 hours to 2 hours for 100,000 incoming retail store files with 1 million records that met the available one-time 8-hour window for processing. This process then became part of daily processing, which increased server performance significantly.
• Took initiative to learn methods that facilitated administrative, configuration and ongoing support of Oracle Financial Integration applications in a webMethods systems integration environment. Improved runtime and established standards in a new production environment.
• Designed and developed two billing policies in a time tracking system for consultants; using Perl, HTML, JavaScript and Sybase database. This provided greater flexibility and accuracy in tracking consulting time and performing financial billing.
• Conducted numerous benchmark/stress tests, run time improvement (RTI) efforts and enhancement projects involving a retail store ordering system enhancing system designed for 30 stores to successfully accommodate 3000 stores.

TECHNICAL SKILLS
webMethods - IS, TN, Broker, Workflow Stored procedures Rational tools
ERwin Data Modeling Oracle Mercury tools
Perl Unix SQL/TSQL
XML Visual Studio, SSIS Java
EDI Systems Integration Excel with VBA
SQL Server 2000-2005, SSIS Access Business Intelligence

PROFESSIONAL EXPERIENCE

Business Intelligence Metrics Specialist (2007 - 2009)
Established analytical processes and reports delivered to executive leadership team for workforce planning. Developed an automated environment for HR executive workforce planning reporting. This included administration, establishment of standards, reporting requirements gathering, analysis, development and implementation.

• Developed metrics dictionary, defined terms and formulas. Designed and built a metrics reporting Business Intelligence cube with facts and dimensions. Investigated business intelligence tools ~ Microsoft ProClarity, Panorama, Oracle Essbase.
• Developed automated data cleansing and load processes using SSIS packages, participated in the design of the database (CA ERwin 7.2) with 100 tables to support various and rapid fire HR executive reporting needs.
• Designed and built a metrics reporting Business Intelligence cube with facts and dimensions. Used SSIS packages for data integration.
• Project manager for business during re-engineering of the HR Business Warehouse on the Oracle 11g platform - liaison for the business to the technical team, defined requirements and metrics for standard HR global dashboard.

Information Specialist Senior, Retail (2004 - 2007)
Served in various technical lead roles in establishing a webMethods systems integration environment. This included administration, configuration, established standards, standards adherence, analysis, implementation, run time improvements, and proactively troubleshooting.

• Established and communicated development standards for a webMethods (now Software AG) environment for HR, Payroll, store data synchronization, eProcurement, AP Oracle Financial applications.
• Installed, set up, configured and tuned Integration Server (IS), Trading Networks, Workflow and Broker environments in version 6.1. Coded in the webMethods Flow tool and Java, including EDI processes. Contributed in problem solving, runtime improvement and establishment of standards in the new environment.

Project Leader/Information Specialist Senior, Retail (2003 - 2004)
Managed of team of eight, tasked with supporting the Retail Information System (RIS) Level 2 store order processing system and related applications.

Information Specialist Senior, Consulting (1998 - 2003)
Renovated code for Year 2000 date considerations and enhanced a time tracking, billing and reporting system.

• Enhanced the Solutions Consulting Time Tracking System (TTS), involving Perl, HTML, Java, JavaScript, JavaBeans, JSP, OO design, design patterns & UML, data modeling with ERwin and using the Sybase 12 database. Involved in corporate Utilization initiative building a corporate hierarchy tool using Microsoft (MS) VB .NET, MS SQL Server database - SQL Analyzer & Enterprise Manager, MS Visual Studio .NET. Interface between Bank of America's MS Project 2002 Server and a time tracking system, involving Perl and webMethods. Limited Rational Rose training.
• Enhanced transportation sector Demand Resource System, involving Microsoft Active Server Pages (ASP), HTML, JavaScript, ActiveX Data Objects (ADO), Microsoft SQL Server database, Visual Source Safe. Developed an ad-hoc reporting system providing approximately 40 selection parameters and allowed users to customize and save their repetitive reports.

Senior Systems Engineer, Retail (1993 - 1998)
Supported a convenience store main order processing distributed system.

• As the technical lead ~ planned, gathered and documented requirements; scheduled, designed, developed, and assigned tasks to team members; tested and implemented business solutions. Coordinated internal and customer groups and hardware platforms (HP, NT, Compaq, Stratus, IBM mainframe, PCs). The system used 'C' programs and UNIX shells executing on an IBM RS/6000 39H model under the AIX OS with an Oracle database; and console messaging. Microsoft 'C' and command files executed on PCs under OS/2 with modems, TCP/IP, distributed processing.
• Gathered customer requirements, uncovering solid opportunities to improve business outcomes.
• Served on the account Architecture Committee contributing oversight.

Data Modeling Engineer (1992 - 1993)
Responsible for the logical data modeling of retail templates - for example for Accounts Payable, Accounts Receivable, General Ledger.

Technical Instructor (1990 - 1992)
Tasked with developing, maintaining and teaching various technical courses to internal employees.

• Instructor in VSAM, CICS and CLIST courses. Worked as lead technical SE on training development projects for CICS, VSAM in both stand-up and Interactive Distance Learning Network (IDLN) courses.
• One of a team of three that designed and developed a client/server (C/S) lecture style course, called the Client/Server Application Development Workshop. This course consisted of instruction in C/S considerations, application architecture, GUI design, relational databases and SQL, as well as hands-on experience to develop a C/S application in a workshop environment.

Confidential
10 years of Medicaid claims processing experience in multiple capacities, culminating in lead technical and project lead roles with breadth of capability in problem solving and runtime improvements.

• Technical leadership
• Proposal writing
• Claims processing - Edits/Audits, Cash/Financial, Third Party Billing
• Consulting in problem solving and runtime improvements
• VSAM, CICS expertise in eligibility, claims processing subsystems

Education
BBA, Business Systems Analysis
Certifications / Training / Associations
ITIL Foundation Certificate in IT Services Management
Java Metroplex Users Group - member since 1999, Plano Java Users Group - charter member since 1999
EDS Technical Consulting Program, EDS Systems Engineering Development (SED) Program
Numerous technical and leadership courses as well as self taught; including Unix scripts, Java, OOD (Object Oriented Design), XML, HTML, Perl, JavaScript, SAP, Tomcat, Apache, IIS, Visual Basic, CICS, VSAM.