WORK EXPERIENCE

Confidential

Business / Data Analyst and Critical Reports Development Supply Chain - Contract Consultant

Oversaw Supply Chain SouthEast and Gulf Markets for AT T mobility sparing. Provided process improvement by developing automated system that gathered and collected data from multiple systems which sent reports out to field which previously 4 people provided at 4 hours a week thus saving department 40,000 annually. Developed metrics which was used to reduce spares expense budget by 40 million annnually. Developed senior management level report and scorecard. Developed modeling strategies for operation efficiency. Provided excellent customer service to market clients. Developed reporting engine for adhoc reports using SQL and VBA. Analyzed data and provided automated data conversion systems to collect data from multiple systems.

Technical Environment: Excel VBA, VB6, Access VBA, SQL, CATS, Oracle, TOAD, SQL Navigator

Confidential

Data Analyst - Contract Consultant Confidential in customer satisfaction surveys Analyzed customer service data as a foundation for incremental revenue modeling Analyzed VIP product data in support of price testing Supported collection and analysis of market data and organized using MS Access/MicroStrategy. Automated and developed dashboard module for executive management that tracked revenue and customer satisfaction on a weekly basis. Automated/Developed a system that collected monthly dealer information, scored dealer and created monthly reports. Technical Environment: Excel VBA, Access VBA, SQL, Gemini, MicroStrategy

Confidential

Senior IT Business System

• Frontline planner on acquisitions. Gathered, analyzed and manipulated data from multiple sources / multiple platforms and integrated into an executive summary system. Provided automated data solutions to field operators to minimize the need for purchasing additional licenses, thus saving the organization several thousand dollars.
• Worked with Users, SME's Subject Matter Experts and IT i.e. developers and DBA's to evaluate and enhance the performance of AT T's Network Application Systems: CAT Cellular Asset Tracking System , Oracle 11i E-Business WMS.
• Served as Subject Matter Expert and provided all aspects of end-user support for AT T's Network Application Systems: CATS Cellular Asset Tracking and Oracle Procurement. Served as back-up SME for WMS team provided subject matter expertise to application upgrades including Red Prairie, WMS, CATS and planning applications Manugis
• tics to Oracle ASCP , interfacing error handling. Responsible for requirements gathering, documentation, QA UAT Testing, debugging, data analysis, disaster recovery, script development and problem resolution.
• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation. Prioritized and resolved multiple complex and critical issues logged by the end-users via the Remedy Help Desk Ticketing System provided Tier 1 Help Desk Support.
• Proactively suggested ways of improving system stability, availability, performance and reliability. Identified improvement opportunities associated with Supply Chain applications and/or process procedures and develop supporting business supporting cases and project plans. Protected and insured the stability of the operational systems as well as maintain the integrity of the data they contain.
• Worked on complex information model, logical relationships, and the data structure that supported different AT T's assets and parts. Responsible for creating training documentation and delivery, executing internal process jobs and work error logs. Provided support for strategic supply chain projects in warehousing, order management, distribution, demand planning and supply chain planning systems. Prepared KPI Key Performance Indictor Summary Reports MS Excel for all Supply Chain interfaces. Technical Environment: Excel VBA, VB6, Access VBA, SQL, CATS, Oracle

Confidential

Business Analyst/Database - Contract Consultant

Developed Supply Chain FTE model database. Interviewed several planners across multiple business units. Gathered requirements of each business unit. Developed a cohesive system that would integrate all needs across business units while provide dashboard summary information for Executives. Technical Environment: Excel VBA, Access VBA, SQL

Confidential

Reports Developer - Contract Consultant

Confidential to create Excel spreadsheets to automatically populate all the data on a monthly basis and into executive summaries for 140 stores under Macy's South. Took actual raw data from different data sources and continuously rolled it to all the levels of Macy's south to generate reports that rolled out to the intranet and were accessible by all the Regional Vice Presidents.

Technical Environment: VB6, Excel VBA, Access VBA, SQL

Business Analyst/Database Designer - Contract Consultant

Met with senior management to design specifications for new functionality. Coded functionality in VBA. Integrated outside client data into system. Redesigned and updated system for greater flexibility. Technical Environment: VBA, MS Access

Confidential

Business Analyst - Contract Consultant

Acted in roll of Business Analyst. Worked directly with Senior Management of Finance in developing accounting and management reports in Crystal Reports from their current ERP system Navision . Designed specifications using GAP. Planned meetings and timelines. Wrote complex SQL queries. Designed reports in Crystal Reports to specifications. Technical Environment: SQL Server, Crystal Reports

Confidential

Systems Analyst - Contract Consultant

Responsible for reporting and database development in MS Access, SQL Server, and SQL. Re-engineered/re-designed a legacy interface product of ADP payroll software that made adjustments to clients' payroll using VBA, VBScript and Access. The redesigned software eliminated over 100 man hours per run thus allowing ADP to provide a faster response to their clients and eliminating several thousand dollars. Technical Environment: VB5, VBA, VBScript, MS Access, SQL Server

Confidential

Systems Analyst, Database Developer Contract Consultant 11/99 to 02/01 then made permanent.

Created new database applications and maintained and troubleshot existing financial applications and databases. Assisted senior management with analyzing business processes and developing solutions to improve efficiency. Wrote complex SQL queries. Developed numerous reports in MS Access, MS Excel, SQL, and Crystal Reports v. 10.x. Automated functions in databases. Developed SQL Server 2000 database using TransactSQL and stored procedures. Dealt with MS SQL Server 6.5 issues involving indexing and backup procedures for the MIS Department. Responsible for integration and migration of data from the current environment to new systems. Provided application and database support to internal users.

Technical Environment: MS Access, MS Excel, VBA, VB, MS SQL Server 6.5/7.0/2000, SQL, Transact SQL, UNIX, LegalKey, Carpe Diem, LMS Financials, ADP HR/Payroll, Windows 2000/2003/XP.

Confidential

Lead Analyst, Senior Database Analyst - Contract Consultant

Developed MS Access databases and application that interfaced with MS SQL Server 2000 and MS SMS Software Management System Software. The SMS software pulls all hardware and software specifications off of more than 1100 workstations in the company, but has no reporting mechanism except for individual SQL querying. Developed the application in MS Access 2000. The application is attached to an SQL back-end. The application inventories software and hardware throughout company. Through use of the application, senior management can track how many licenses they are paying versus using. This allows software/hardware to be tracked departmentally. It also allows the detection of unlicensed software throughout company and allows software/hardware inventories to be reported by matrixes.

Confidential

Lead Database Analyst, Programmer - Contract Consultant

Serve as Lead MS Access/SQL Server database analyst and programmer. Responsible for evaluating technical operations at three markets and developing processes and recommendations that would make operations more efficient and more cost-effective. One implementation based on evaluation saved each market 4200 annually by converting modem systems into a DSL LAN system. Reengineered a client tracking system that included a drill-down capability and more efficient reporting. Automated the reporting system for executive reports.

Confidential

Senior Database Analyst - Contract Consultant

Developed an MS Access database to track the development and roll-out management of 2000 cellular telephone sites in a joint venture between BellSouth Mobility and Ericsson, Inc. for the Southeast market. The system uses relational logic to generate and produce multiple variations of data input. All reports were designed dynamically for future growth and expansion if new markets or sites were added. Converted over 175 spreadsheets and data from midrange systems through the use of import/export and ODBC to establish a foundation for the data. Developed a personnel tracking system for field personnel that handles personnel working on sites and their market transfers. Also acted as Project Manager for this project. Interviewed the Project Manager and field staff for all variables that needed to be coordinated. Managed the entire project using MS Project 98.

Confidential

Senior Database Analyst, Business Analyst - Permanent

Responsible for redesigning the Medical Stop Loss Insurance System OASIS , based on DataEase DOS-based RDMS for greater accountability and preservation of historical data. Converted old historical data from a MicroFocus COBOL system and integrated it with the new design. Worked on a Novell 3.11-4.0 and Windows NT platform with MS Exchange. Acted as a backup Network Administrator. Provided remote support on a daily basis using pcAnywhere. Supported MS Outlook. Led the data specifications and design team through full-cycle development. Developed management reports in Windows using Crystal Reports 6.0, MS Access 95, VBA, Visual Basic and MS Excel through an ODBC driver to transition to a Windows environment. Migrated large amounts of data from a DOS-based systems and COBOL to MS Access and MS Excel. Integrated MS Access, MS Word and MS Office documents. Managed help desk operations for users troubleshooting DataEase and MS Office issues , upgraded and replaced hardware network cards, hard drives, memory, etc. , and created a problem-tracking system. Analyzed department policies and practices for incorporation into the OASIS system. Consulted with senior management and led reinsurers Investors on data-integrity issues. Designed and directed the unification of fragmented modules into a single system. Coordinated and led biweekly steering committee meetings on Medical Stop Loss Division System needs. Developed and presented recommendations to reinsurers and senior management on conversion issues and enhancements. Supervised a staff of three Programmers. Maintained project priorities and provided updates/completed tasks using MS Project.

Confidential

Product Support Consultant - Permanent

Provided first and second level support of the COIN Banking System DOS-based loan processing system created in C running on Novell 3.11 Servers at each clients' location. Managed 14 banking clients' accounts. Analyzed customer needs and provided business solutions. Interacted with System Administrators and executive management. Provided remote support on a daily basis using pcAnywhere. Maintained inter-departmental communications by interfacing with other Microbilt departments as needed for problem resolutions and research. Designed and developed a comprehensive account management system in DataEase that tracked clients, changes on accounts, and problem-resolution data. Created an integrated BBS system for clients to reduce paper traffic between clients and the Microbilt support department.

Confidential

Senior Applications Developer - Contract Consultant

Designed and developed database applications for clients using 4GL and Client/Server databases. Developed financial applications for ACOG Atlanta Committee for Olympic Games budgeting and maintenance software, FFMC First Financial Management Corporation order processing, and ARMS Atlanta Records Management accounting and record tracking software. Served as the primary Developer on most applications. Used CASE tools in design analysis. Used relational database theory. Worked in Novell and Banyan environments.

Confidential

Database Developer, Consultant -- Contract Consultant

Served as a team member on a project at Equitable Real Estate Corporation with 17 Consultants. Responsible for application design on an asset management system. System managed over 350 properties and over 3 billion in assets. Developed an ownership mapping procedure that tracked properties' ownership third parties, joint ventures, etc. . Gained experience with Oracle, while writing select statements from DataEase. Relied heavily on financial background including accounting Gap, etc. . Designed corporate reports of portfolios for executives.

Confidential

Level II Customer Support Analyst - - Contract Consultant

Trained in-depth on OS/42 and IBM DOS technical functionality. Provided Level II customer support technical sales for IBM's OS/2 and DOS operations department for the entire country. Level II support was the next step when the initial help desk operators were not equipped to handle the challenge that the caller had. Handled an average of 50-75 calls daily amount depended on detail nature of calls and time involved in providing answers .

Confidential

Office Automation, Database Consultant - Permanent

Responsible for helping clients choose software and hardware to serve their business management needs. Broadened clients' perspective on how to move from manual operations to computerized operations. Developed databases to manage clients' day-to-day functions and special projects. Two primary clients included the American Cancer Society and the Georgia Legislative Black Caucus.

Confidential

Senior Applications Programmer

Served as primary project leader in automating departmental management functions. Designed, implemented, maintained, and trained personnel on database management systems for targeted departments. Successfully used relational database theory normalization, optimization, etc. in analyzing and designing database systems to meet executive management's needs. Created a revolutionary planning and budgeting database that enhanced the budgeting process and fiscal responsibility of the entire National Office American Cancer Society . Saved the organization thousands by initiating innovative in-house graphics production for graphic projects previously sent to outside suppliers.Created and computerized file management systems. Developed databases and created spreadsheets and desktop publishing presentations. Established computerized filing systems for service and rehabilitation data. Typed reports and agendas for committee meetings. Provided staffing for committee meetings.

TECHNICAL SUMMARY

Databases: MS Access 95/97/2000-2010, SQL Server 2000-2005, T-SQL, Oracle 8 -11i, PL/SQL, DataEase 4.53, Paradox 3.5 , Dbase III, Spreadsheets: MS Excel, Lotus 2.01-3.1, Quattro Pro

Desktop Publishing: MS PowerPoint, FreeLance, Adobe Products

Web Development: HTML, MS FrontPage,

Word Processors: MS Word, AmiPro, WordPerfect 5.1

Report Writers/ Query: Crystal Reports, IQ Report Writer, TOAD, SQL Navigator

Operating Systems: Windows 2007-Windows 95/98, MS DOS 3.3 , OS/2 2.1

Networking Systems and Administration: Windows Server 2000, TCP/IP, Windows NT, Novell 3.11

Project Management: MS Project Telecommunciations: CATS by Fulcrum Technologies Legal / Office Software: Interwoven, LegalKey, PCDocs

Financial Systems: Quickbooks ADP Payroll, UltiPro, LMS