Qualifications:
An efficient team player, that performs just as well independently. As a seasoned Consultant and Contract Developer, my record is one of progressive IT experience, ranging from mainframe to client/server and web-based applications. An Analyst with excellent communication and SDLC experience gained while performing as a Business Analyst, Programmer/Analyst, Consultant/Contractor, Trainer and Mentor. Practiced methodologies include Lean Agile, Spiral, and Waterfall methodologies. Performance in industries such as public and private healthcare benefits (eligibility and claims), life insurance (eligibility and agents), state government administration, higher education financial aid, and supply chain/warehouse management solutions.

Education:

MS (Information Technology)
campus BS (Management Information Systems)

Data Stores: SQL Server 2000-2005, DB2, IDMS, VSAM, Oracle, MySQL.
Database Components and tools: SQL Server Management Studio - Enterprise Manager, Query Analyzer, DTS/SSIS, Platinum, QMF, SPUFI, Oracle Designer, Developer 2000, Oracle Reports, SQL Developer, SQL*PLUS, stored procedures, triggers, views, ADO, ODBC, ADO.Net.
Platforms: IIS, .Net, MS Windows NT/2000/XP, Palm OS, MVS, VM/CMS, CICS.
Web Development: HTML, JavaScript, ASP, ASP.NET, PHP, CSS, FrontPage, Macromedia Suite.
Development Tools/IDEs: Visual Studio, TSO, ROSCOE, MCL Designer.
Languages: VB6, VB .Net, C#, SQL, T-SQL, VBScript, PL\\SQL, DML, COBOL, SAS, JCL.
Networks: Cisco VPN client, Citrix Meta Frame, Checkpoint VPN client, dial up.
EDI/Integration Tools: MS Integration Manager, WS_FTP, Core FTP, IExplorer FTP, SSH/SFTP, SSL, Gentran, XML, TOAD, Contivo, WebMethods (Trading Partners), SOA.
Tools/Methodologies: Source Safe, Endeavor,ChangeMan, MS Office, Visio, ADS/O, IDD, OLQ, Test Director, Heat, TrackRecord, TeamTrack, BitKeeper, NUnit, Selenium, Agile, Spiral/Waterfall hybrid.

Summary of Experience:

• Full life cycle development of the GA Health Partnership Multi-Healthnet (GHP MHN) and the SC Medicaid Eligibility Determination System (MEDS). With both projects, the Member Eligibility subsystem was written to meet the federal DHHS HIPAA guidelines and EDI transaction sets. The GHP project was also designed and written to uniquely interface with the State of GA employee benefits plans that include private insurance carriers.
• Researched and evaluated the existing loan origination and maintenance system, from the application stage through the EFT. Performed the needs/gap analysis between the legacy support system and the newly developed client/server system, in order to eliminate redundancy, and offer recommendations for the new system.
• Provided heavy customer interface and support for EDI and data conversion processes and pre-sales processes in health benefits and inventory environments.
• Provided full life cycle design and development of applications and databases such as SQL Server 2000/2005 (including database table design and optimization, automation, scheduling, external integration, etc), to solve critical business problems, such as, the creation of audit trail process' , inventory control and tracking process', and health care benefits processing.
• Provided project management direction between internal teams to design and develop complex information systems. Met with Directors and Managers to discuss the necessity of our business decisions, and to point out how the proposed changes would benefit reaching our strategic goals.
• Wrote, tested, and scheduled scripts to automate secure, enterprise level connectivity solutions across distributed systems, via EDI, between our trading partners and internal users. Used various middleware components within Windows operating systems.
• Ran QA checks on our Field Representative's laptops, peripheral equipment (electronic signature pads and printers), and business application software before delivery to the Reps.
• Data mapping, design, development, and testing of applications written in structured, as well as object-oriented programming languages, to and from SQL Server, Oracle, DB2, and IDMS databases via ADO, ADO.Net and ODBC connectivity. Created and ran stored procedures to decrease network traffic, increase security, and allow for modularity and reuse of code.
• Conversion of IDMS network database applications into DB2 relational database applications by modifying programs from DML to embedded SQL DML.
• Development and maintenance of websites using technologies such as scripting languages, ASP, .Net, ADO/ODBC, HTML, CSS etc.
• Full life cycle development of supply chain warehouse management systems that are rendered using hand-held scanners and terminals. Tasks included pre-sales analysis followed by the recommendation of hardware, based on operations research and needs/gap analysis. Once a sale was made, database design, development, and testing, interface programming and testing, and customer training were applied.
• Full life cycle development of an Oracle based college admissions and reporting system that allows for multi-institutional functionality to be centralized. Created and optimized the necessary tables, ERD's, and TIC's.
• Designed and developed a dynamic career posting and search engine on a website. Employers post jobs by credit card payment, and candidates post resumes and search jobs.
• Business Analyst, Team Leader, and mentoring roles to include, interaction with teammates, managers, end-users/customers and outside vendors, for the purpose of providing efficient solutions to business needs based on the required methodologies, business rules, and standards.

Detailed Experience:

08/08-09/09 Business Systems Analyst - Confidential, (TX Guaranteed Student Loans Organization), Austin, TX

• Consultant for Texas Guaranteed Student Loan Organization, Enterprise Project Management Team, with the responsibility of assisting with the needs/gap analysis of the online systems (Advantage Web and the Loan Guarantee Processing System), that are currently in place.
• Worked with the TG development team, end users, and business leaders to define and document the logical and functional specifications of the system. Deliverables included Business System Specifications, file structures and table schemas, data maps, process and data flows and other necessary information regarding the new Java based system.
• Evaluated and documented the re-engineering tasks required to implement the existing mainframe-based online system with the existing front end Java based online system. The evaluation tasks included analyzing existing Cobol and Java code to assure that business requirements are met, and if not, document the changes necessary to meet the requirements. The Lender Manifest, EFT and Guarantee systems were evaluated.
• Worked with the Java Developer in creating the web services that are used to consume the back end mainframe systems.
• Verified and documented the Department of Education mandates and organizational profiles for Schools, Lenders, and Servicers.

TECHNICAL ENVIRONMENT: VSAM, DB2, IDMS/ADS, CICS, TSO, MVS, COBOL II, Java, SQL, JCL, FTP, SPUFI, Visio, Word.

09/07-03/08 Software Engineer III - Confidential, Norcross, GA

• Development of internal applications within the Corporate Applications team to user requirements. Mainly focusing on security for our financial system and converting the remaining VB 6 apps into the new .Net Axiom system. The most recent conversion allows for the management of the Featured Employer product.
• Maintenance of our existing system - Axiom, which is rendered via a complex multi-tiered .Net framework, which sits on a SQL Server.
• Twice a month monitoring of our systems that includes resolving incoming issues/tickets, in a collaborative team environment, while maintaining responsibility for the particular issue.
• Testing and adjusting complex SQL that creates stored procedures, triggers, and views in a SQL Server.
• Use of the Bitkeeper change management system to control code versioning and VSS for documentation.

TECHNICAL ENVIRONMENT: Multi-tiered .Net framework, SQL Server 2005, Visual Studio 2005 & 2008, VB.Net 2005 & 2008, HTML, JavaScript, MS Office Suite, BitKeeper, Visual Source Safe.

03/07-06/07 Consultant/Developer - Confidential, Atlanta, GA

• For a distributor of VOIP telecommunications equipment, performed full life cycle development of a supply chain inventory solution, focusing specifically on a 'returns' process. Used .Net components and ADO.Net technology to access and manipulate the SQL Server database.
• Analyzed the existing database, focusing on constraints and referential integrity, and mapped the existing data with newly required data to create and normalize tables related to retailer 'returns' functionality.
• Coded stored procedures, triggers, and views to facilitate the daily processing of the returns process. The main stored procedure, which served as the backbone of the returns process reads a suspense table to determine what processing will take place - delete from suspense and load related 'returns' type tables, calculate the number of days and part number in suspense and/or call views of the Great Plains database to determine retailers and integrate the returns with Great Plains tables.
• Used ADO.Net objects, classes, properties and methods for SQL Server access and manipulation. Specifically, Data Adapter and SQL Reader controls and result sets, and data grids/views for visual representation and user editing.
• Implemented the resulting application into an ASP.Net/Web Form in case it would be required later.
• Fully designed and documented system flow, scope, specification, test plan, and a user's manual.

TECHNICAL ENVIRONMENT: SQL Server 2005 and components, Visual Studio 2005, ADO.Net, VB.Net 2005, Visio, MS Office Suite.

11/06-03/07 Consultant/Systems Analyst - Confidential, Atlanta, GA

• For the state of Georgia, Department of Administrative Services (DOAS), my responsibilities were to analyze and document existing web-based applications.
• Evaluated the costs to migrate existing Quick base and Code Charge applications into .Net.
• Composed a 'Help' manual for the existing applications.

TECHNICAL ENVIRONMENT: Oracle 9.2, Quick base, Code Charge, MS Word, Visio, MS Paint.

07/06-9/06 Consultant/Developer - Confidential, Atlanta, GA

• Updated the GE Railroad Repair application. The VB6 update generates the general ledger accounting audit file, table, and report.
• Created and modified Oracle views, packages, and a stored procedure to allow for the creation of the files and Crystal Reports, and to load the audit table.
• Documented changes to audit tables, including designing the ERD for the audit tables and their relationships with the invoice tables.
• Created a Visio workflow diagram to support the flow of the audit trail.

TECHNICAL ENVIRONMENT: Oracle, stored procedures, SQL Developer, ODBC, VB6, TOAD, Crystal Reports, Visio.

04/06-07/06 Consultant/Integration Analyst - Confidential, Atlanta, GA

• Data mapping for Liaison Technologies, that converts XML and flat file data into standard EDI transaction sets. All manufacturing transaction sets are used (810, 820, 850, 857, 860, 865, 997, etc.) and transmitted between trading partners.
• Developed and tested the set-ups between our client's various warehouse locations, Sterling VAN, and/or client trading partner's warehouses and business systems, within an Oracle database.
• Traveled to meet with our primary customer for the purposes of set up (requirements gathering, GSI information, data definition), and Onboarding.
• Provided support for our EDI system, this included mapping changes, error debugging and fixes, and working with the client, trading partner, Sterling, DBA's, network group and/or developers as necessary.
• Used WebMethods to tie various components together, such as Unified User Profile, Hub interface, UAT and the building of SOA/XML envelopes.

TECHNICAL ENVIRONMENT: XML, Contivo, WebMethods, UAT, TOAD, Oracle 9i, ANSI and EDIFACT, X12, EDI transaction sets, AS2, FTP, HTTPS, basic UNIX commands, putty.

10/04-03/06 Lead Integration Analyst/Developer - Confidential, Atlanta, GA

• As the Lead Analyst, determined the best solutions for secure, automated data transfers with over 50 hospitals, across distributed systems. Wrote, tested, integrated, and provided support for the batch scripts to automate and schedule VPN and secure FTP EDI solutions.
• Met with hospital Directors and Managers within the business offices and IT teams to explain the value of automating our data exchanges. Often had to discuss these strategies with Directors and Managers.
• Designed, developed, and tested customized files that interface with over 50 client systems.
• Performed ETL of HIPAA standardized, EDI transaction sets (835, 837), XML formatted data (HL7), and customized flat file structures into, and out of, our SQL Server data warehouse and financial database (FACS) via VB6 and DTS.
• Designed, developed and tested internal processes in VB6 and VB.Net, such as the fully automated, outpatient upload process and reports.
• Used ADO and ADO.Net objects for database access and manipulation of the SQL Server.
• Created, tested and implemented stored procedures to improve performance and data integrity.
• The stored procedures pull huge amounts of data to be formatted into files, are called and scheduled by DTS tasks across databases and linked servers, search various tables for the identification of various hospital criteria.
• Performed as liaison between the operations, financial, and IT team, for the purpose of designing a new web-based .Net eligibility system that will be the core system used throughout the company. This required the development of prototypes rendered in VB.Net, and ASP.Net to allow our representatives to access patient claims status via intranet.
• Evaluated and redesigned the existing scheduling and EDI system, which I had created, to fit into the upcoming .Net system. EDI based files were made available via ASP.net for those clients who wanted to access data and reports via site to site VPN's.
• Performed as the Lead of the design and development of a VB.Net-based reconciliation process for 3 client hospitals. The existing VB6/Excel version was created with data from distributed, linked databases and rendered in Crystal Reports.
• Provided support for our Field Reps laptops, this included maintenance of the Eligibility Determination and Crystal reporting program that runs on the machines, testing of changes, and Citrix connectivity issues.
• Trained team members on EDI solutions.
• Wrote supporting documentation for all phases of my work. Documentation was stored on a SharePoint web portal.

TECHNICAL ENVIRONMENT: EDI transaction sets,VB 6, VB.Net, ASP.Net, XML, Visual Studio, SQL Server 2000 and components, ADO, ADO.Net, DTS, MS stored procedures, Seagate Crystal Reports, WS_FTP, Citrix, various FTP clients, Secure FTP server, Cisco VPN client, MS command line, MS Office, Windows XP, SharePoint.

03/04-10/05 Web Designer/Developer - Confidential, Atlanta, GA

• Designed and developed the Boathouse Row Music website that features the production of new recording artists, promotions, and CD sales.
• Designed, developed, tested and supported the Detroit Chapter of the National Black MBA Association website. One main accomplishment was the development of the functionality to allow employers to post open positions for a fee paid by credit cards. Organization members can also search the MySQL database by keywords, for open positions.
• Created documentation, such as proposals and systems flow diagrams.
• Discussed with, and explained to hard-to-please customers, the best uses and industry standards and practices for their websites.

TECHNICAL ENVIRONMENT: FrontPage, Dreamweaver, Access, HTML, ASP, PHP, CSS, VBScript, JavaScript, MySQL, IIS, Apache, PayPal.

05/02-11/03Senior Programmer/Analyst - Confidential, Atlanta, GA

• Participated in business structural meetings and Joint Application Development (JAD) sessions with the state of GA Health Partnership (GHP) Multi-Healthnet (MHN) management. These meetings were to analyze Medicaid business rules for the Member eligibility system, and DB2 database requirements.
• Assisted in the design of the tables, batch applications, GUI interfaces, and reports for the eligibility system.
• Developed programs, interfaces, subroutines, copybooks, stored procedures, and reports that map the incoming and outgoing Medicaid, Medicare (Buy-In), and state employees data into the HIPAA mandated EDI transaction sets (270, 271, 277,834, and 835), private insurance carriers requirements, and other enterprise-level applications. The modules were written to meet ACS programming standards.
• Administered the planning and design of the GUI interfaces, back-end processing and reporting, and swipe card portion of the web portal. Developed prototype windows and functionality in VB6.
• Created reports from QMF to be used by developers to shorten the learning curve of the complex system.
• Created and ran test plans in SPUFI to assure the accuracy of the newly created applications and stored procedures.
• Composed required deliverables and documentation, such as specifications, Visio charts, and test plans.
• Performed as a Business Analyst by assisting with the development of the Requirements Analysis Documentation (RAD), Detailed System Design (DSD) documentation, and subsystem exhibits documentation (data/object modeling).
• Performed integrated testing and monitoring of batch and on-line processes, which also included logging and follow-up of defects until they were corrected.
• Utilized Endeavor Change Management software to organize and monitor programs, plans, and packages during the development of phase 1 and phase 2, of the GHP MHN project.

TECHNICAL ENVIRONMENT: VSAM, DB2 v8, OS/390, TSO, MVS, EDI, COBOL II, SQL, stored procedures, JCL, VB6, Windows 2000, MS Office 2000, Endeavor, Expediter, Test Director, SPUFI, QMF, Platinum, Niku, Visio.

09/01-04/02 Consultant/Developer - Confidential, Greenville, SC

• Analyzed and consulted with the users and managers of Clemson ISD to point out design flaws andlogical errors, and, suggest proper solutions to facilitate the development of the state of SC Medicaid Eligibility Determination System (MEDS).
• Re-engineered the CMS Medicare Buy-In application within the MEDS system. The system had to be converted from IDMS to DB2.
• Generated on-line Buy-In alerts to the Worker, and hardcopy reports detailing the results of the monthly processing.
• Performed integrated testing of the newly developed member and claims applications, with the conversion (IDMS to DB2) programs and data. Monitored these tests to identify and escalate production showstopper and performance issues. This required 24/7 support while running in a parallel production environment, and the creation of QMF reports for debugging.
• Developed required status reports, COBOL/SQL generated reports, deliverables and documentation.

TECHNICAL ENVIRONMENT: OS/390 Pilate Enterprise Server, MVS, COBOL II, IDMS, DB2, SPUFI, QMF, JCL, SQL, Windows 2000, TSO, Changeman, Track Record.

01/01-08/01 Consultant/Developer - Confidential, Norcross, GA

• Provided pre-sales situational and needs/gap analysis for bar coded, warehouse management solutions, followed by hardware and software recommendations for bar coded solutions.
• Configured, developed, and tested customized supply chain and warehouse management software for hand-held scanners and terminals that read bar codes and signature pads.
• Tested the hand-held solutions with various printers to assure compatibility.
• Designed, developed and normalized Access and SQL server database tables to facilitate inventory control and in-house administrative applications written in VB6 using ADO connectivity.
• Composed proposals for the sale of the hardware and software solutions, that included graphical exhibits using data modeling and use case scenarios.
• Configured and tested the middleware (HotSync, ActiveSync) that provides serial communications between the host machines, barcode scanners, credit/smart card readers, and printers.
• Tested and evaluated hand held devices and electronic signature pads to determine if they would meet our customer's needs and if we should sell them.
• Proposed, designed, developed and tested an in-house time tracking application utilizing VB 6 with an Access database. The savings achieved with this application amounted to more efficient human resource allocation and project planning.
• Proposed, designed, developed and tested a sales staff control system that stores customer, order and salesperson data. Written in VB6 and ActiveX controls to manipulate MS Access databases, the application provides for interactively tracking inventory and customer orders.

TECHNICAL ENVIRONMENT : Windows NT, Connect Software, Symbol/Zetes,MCL Designer, LabelView, Hot sync, Active sync, Symbol Scanners/Phasers/Terminals, PDA, Zebra Printers, VB6, ADO, MS Access, SQL Server, Enterprise Manager, Visio, MS Office.

06/00-12/00 Consultant/Developer - Confidential, Myrtle Beach, SC

• Development of the ADSO GUI, and back-end applications that capture real-time recipient eligibility data within the Household Maintenance System (HMS) of the SC Medicaid Eligibility Determination System (MEDS).
• Led brainstorming sessions on standards development and deployment. Increased productivity by creating standard business tier component modules for reuse by other teams.
• Developed the required status reports, and documentation such as test plans, and change sheets.

TECHNICAL ENVIRONMENT: OS/390, TSO, MVS, COBOL, IDMS/ADSO 14.0, DB2, IDD, ADS Alive, JCL, SQL, Windows 2000, MS Office, Changeman, Expediter.

01/99-12/00 Consultant/Developer - Confidential, Atlanta, GA
Student - Confidential, Atlanta, GA
Volunteer Site Editor - Confidential, Atlanta, GA

• SDLC of a college alumni web portal that provides real-time, dynamic modification and searching of its backend database via its IIS, business tiers and ADO/ODBC.
• Design and development of online shopping catalog and cart applications written in Java/JavaScript. The first catalog lists miscellaneous items; the second is a catalog of customized gift baskets. Thecustomization allows the customer to select various items to place in the basket. Theshopping cart provides the means to select different methods of payment and shipping.
• Maintenance of the Cares web site that is used by volunteers working for Hands on Atlanta to review the activities of the regional offices throughout the nation.
• Updated the site and SQL Server database with new procedures, policies and events.
• Saved the organization phone and postage expense by performing these actions.
• Compiled, edited and loaded meeting minutes and highlights from the annual conference, to the Cares website.

TECHNICAL ENVIRONMENT: VB, Active X controls, FrontPage, ADO/ODBC/JDBC, Visual Café, Java, VBScript, JavaScript, ASP, HTML, CSS, SQL, MS Access, MS SQL Server 7, IIS, Dreamweaver, MS Project, Oracle Reports.

06/98- 06/00 Consultant/Developer - Confidential,, Atlanta, GA

• Led the strategic planning, modification, and user acceptance testing of the existing batch and online applications, for Y2K compliance, that support the GA State University benefits, financial, and continuing education systems.
• Assisted the DBA with the scheduling, unloading and loading of conversion data from a IDMS network databases to IDMS relational databases. Also, from an IBM 3380/MVS system to an OS/390 system.
• Creation of supporting documentation.
• Streamlined processes, and purged duplicate processes, resulting in improved quality assurance.
• Full SDLC of a college admissions system that allowed centralized user-friendly access to all facilities within a distributed, multi-facility organization. Created the necessary ERD's and TIC's to facilitate the normalization of the database. All forms, though the use of Forms Builder, allowed for consistent GUI and security throughout the application, with the data being rendered through the use of stored procedures and triggers. Oracle Reports was used to create break reports, and tabular reports.

Prior to 1998, Mainframe/MVS/Cobol and Management positions:
Performed as a Senior Programmer/Analyst for insurance, government, and medical industries (4 years with Delta Dental Plan of MI), within mainframe environments. T

TECHNICAL ENVIRONMENT: IDMS, COBOL, SAS, JCL, DB2, CICS, VSAM, TSO, Roscoe, MVS, CMS.

EDI Specialist for auto parts supplier, United Technology Automotive. Most widely used transaction sets include 810, 850, 857, 860, 865, and 997.

The Manager of 12 Account Representatives for the PA Department of Higher Education Assistance Agency (PHEAA), Student Loan Servicing Center.