SUMMARY:

• Information Technology professional having over 20 years of experience with extensive data verification, data extraction, report creation, relational database, Business Intelligence/querying tools, and process automation expertise.

TECHNICAL SKILLS:

Database Management Systems: MS SQL Server, DB2, Teradata, SQLCI, Access, Oracle, Datacom

Applications: MS Reporting Services, Business Objects, PeopleSoft, Hyperion

Languages: SQL, SAS, SQR, SPSS, Easytrieve, JCL, Visual Basic, Java, COBOL

Operating Systems: Windows, MVS/TSO, Tandem, DOS

PROFESSIONAL EXPERIENCE:

Confidential, Fayetteville, NC

Information Technology Developer

Responsibilities:

• Coded programs to extract Active Army Soldier entitlement and language data in accordance with Department of Defense (DoDI) 1336.05
• Automated and converted manual tasks into scheduled production jobs for monthly Army G1 Strength Accountability
• Provided support for various Integrated Total Personnel Database tasks including gap analysis and SQL Server ETL monitoring
• Developed numerous programs involving complex SQL statements in support of the Human Resource Command Enterprise Metrics effort
• Provided technical guidance and documentation for several business processes

Confidential, Fort Knox, KY

IT Specialist

Responsibilities:

• Served as Product Line Manager for the Data Quality and Analysis team
• Made significant contributions to numerous data integrity and synchronization efforts
• Streamlined the identification and correction of data issues by consolidating 21 individual COBOL programs into a single program and eliminating manual interventions which decreased the total execution time from approximately 2 hours to less than 5 minutes
• Redesigned a monthly process which enabled a deliverable to be produced in less than an hour instead of the 6 hours originally required
• Revised a daily process to more accurately capture the data requested by the customer
• Assisted in the development of standard operating procedures, mapping documents, and sheets
• Provided expertise in resolving technical issues with existing processes

Confidential, Fort Knox, KY

Data Analyst

Responsibilities:

• Confidential - wide systems by reviewing the Army Portfolio Management Solution(APMS) and the HCM Domain Governance document
• Performed comprehensive quality assessments of key data elements to verify the accuracy of the Data Warehouse
• Reviewed data elements contained in the Common Human Resource Information Standards(CHRIS) and performed an in-depth analysis of the Data Warehouse's compliance to those standards.
• Compared codes in Total Army Personnel Data Base (TAPDB) to corresponding codes in the Data Warehouse
• Coordinated Army Accessions Command data management initiatives with Army enterprise-wide efforts
• Coded SPSS scripts to automate the process of converting statistical data files into relational database tables and to eliminate problems with embedded carriage returns
• Aided in the creation of project plans, standard operating procedures, and a data management regulation
• Assisted with the planning, coordination, and scheduling of a data quality seminar conducted by the Chief Data Quality Officer of the Army

Confidential, Millersville, MD

Associate

Responsibilities:

• Replaced external clients' Progen reports with SQL Server Reporting Services reports
• Designed and documented a process to quickly identify accounts discrepancies resulting in out of balance conditions within the general ledger processing
• Developed and implemented procedures to expedite the deployment of upgrades to external customers
• Provided SQL expertise and guidance to peers
• Promoted knowledge transfer by conducting a Reporting Service webinar, preparing technical summaries containing several development and problem resolution tips and techniques, and providing individualized coding assistance
• Discovered and rectified errors and inconsistencies in reports, menus, and program logic

Confidential, Millersville, MD

Software Developer

Responsibilities:

• Served as the Project Lead for the conversion of all reports in the Accounting and application from Progen to SQL Server Reporting Services
• Established project priorities and timelines which were maintained in the project plan
• Delegated development and testing responsibilities to a staff of 8 individuals
• Analyzed Progen program logic and produced over 170 code specification documents and over 240 reports utilizing SQL Server Reporting Services software
• Created numerous stored procedures, functions, and views in conjuntion with the report conversion efforts
• Devised the standard procedure for developing and maintaining SQL Server Reporting Services reports
• Automated the deployment of the new reports using scripts which resulted in significant time savings

Confidential, San Antonio, TX

Enterprise Data Warehouse Data Analyst

Responsibilities:

• Completed several data extract requests for information stored in Warehouse using both simple and complex processes developed using Teradata’s SQL Assistant, BTEQ, and SAS
• Utilized FastLoad, SQL Assistant, and MS Access to create and populate Teradata tables
• Assisted in the restructuring of Business Objects reports and the redesigning of queries for performance efficiencies
• Identified data gaps in some key tables used in a recurring extract
• Upheld quality standards by participating in peer reviews and code walk throughs prior to delivering data

Confidential, Cleveland, OH

Information Delivery Analyst/Programmer

Responsibilities:

• Provided technical support for the Enterprise Data Warehouse end user access tools including installing software, testing new releases, establishing user security profiles, resolving functional and technical problems, designing the semantic layers that interface with corporate databases, and evaluating new software
• Created and maintained several complex reports using Business Objects, SQR, SAS, SQL, and PeopleSoft
• Supplied several complex data extracts to internal clients for data mining purposes
• Assisted with the installation of the server software for Business Objects
• Created and populated several DB2 tables using supplied procedures as well as native data definition language
• Performed knowledge transfers to clients regarding using SAS to create and populate DB2 tables
• Validated Warehouse data using SQL queries, SAS, and Business Objects
• Aided peers with design of sophisticated queries on DB2, SQLCI, and Oracle Database Management Systems
• Produced an automated process utilizing the system catalog tables to generate a series of SQL queries to perform precise data comparisons resulting in significant reduction in the time required for validation
• Designed 80% of the 53 screens, coded the corresponding screen edits, and developed the COBOL program to convert data transferred from Tandem for the Replatform project
• Supported a Visual Basic application for the online maintenance of Warehouse data
• Instructed peers on the use of Geneva as an ETL and reporting tool

Confidential, Kalamazoo, MI

Programmer/Analyst

Responsibilities:

• Assisted in the installation of the Earnings Analysis System (EAS) PC software
• Aided in the preparation of the Unit Test Plan and the Quality Assurance Test Plan for the EAS
• Performed EAS system testing and discovered the solution for connectivity issue between the PC and the IBM mainframe components of the software
• Produced technical documentation for EAS including report definitions, the batch processing flow, input and output datasets, the production schedule and performance statistics
• Facilitated the production implementation of EAS by serving as liasion between the EAS project team and Production Support staff
• Outlined the resolution for an Installment Loan batch load error which could not be rectified by normal recovery procedures using DB2 load and unload utilities
• Designed and developed several profitability reports for the EAS utilizing the Carleton Query System (CQS)
• Adhered to guidelines outlined in the First of America Services Methodology to capture business objectives and requirements, define departmental roles, identify milestone, and to project completion dates
• Produced marketing reports using NOMAD and SAS which were executed via JCL scheduled jobs
• Utilized BMC and IBM utilities to query and to perform maintenance on the EAS data housed in DB2 tables
• Performed data verification for Data Warehouse Project
• Modified delivered programs to provide desired functionality including a numeric rounding feature, dynamically generated report titles, and parameter driven report periods
• Helped to integrate data from new banks and recently merged banks into the EAS
• Added close and consolidate functionality to vendor supplied code to facilitate bank merger processing in EAS saving $8,000 in vendor consulting fee
• Created several JCL programs to manipulate data using FileAid, SyncSort, and various MVS utilities

Confidential, Chicago, IL

Information Engineering Facility (IEF) Support

Responsibilities:

• Coordinated distribution and installation of the Information Engineering Facility (IEF) PC software
• Collaborated with users and third party vendors to resolve problems including those involving DB2 data
• Programmed several maintenance transactions and online screens for the Standard Codes Database project
• Provided client support and technology transfer to various internal application development groups
• Accepted a 6 week special assignment in Calgary, Canada to supplement development efforts for the Amoco Vehicle Information System (AVIS) project
• Created several Rapid Application Development prototypes
• Provided technical support for IBM's Cross System Product software including software installation and problem resolution
• Aided in the composition and publishing of guidelines, newsletters, and position papers on CASE technolog