SUMMARY:

• Technical: Several years (40+) developing and modifying application which entailed: requirements gathering, analysis and design, IT audit, business process & data modeling, prototyping, design, programming, conversion / testing, and documentation.
• Applications: Accounting (AP, AR, GL), Banking, Leasing & Loans, Manufacturing / Distribution, Retail, Insurance, Government, Medical, Wireless, Space Planning, various Government Agencies, Software Development, and Aerospace.
• Management: Several years (16+) in System Project management and Corporate IT Department management.
• I work on the Construction Crew doing all types of carpentry, related building skills, and Volunteer supervision on new home construction and repairs to previously built Habitat homes. In addition, I’ve worked on documenting all construction procedures and related information including materials checklists, order of building stages (with materials needed), Inspection points, and sub - contractor phases and scheduling of their work. Documentation was needed in order to standardize procedures and the explanation of them to volunteers in a consistent manner. Documentation done is in Word, Excel, Visio and PowerPoint.

TECHNICAL SKILLS:

Tools: & Databases (partial): SQL, PL-SQL, Oracle Designer and Sql Developer, Queryman, SQL Server, TOAD, Sql-Server, ERWIN, System Architect, Dreamweaver, Remedy, P+ Methodolgy, ( Visio, Visual-Basic, Word, Project, Access, PowerPoint, FrontPage, Excel), Adobe, Rhumba, Progress, PeopleSoft, Cenet HR, PeopleSoft HR, SharePoint, MySql, PowerBuilder, Business Objects, Crystal Reports, TeraData, WinSCP, Clearquest, Rational - Testing tool, Test Director, Remedy, Endeavor, others. Cobol, Assembler, Basic, Faster

PROFESSIONAL EXPERIENCE:

System Analyst and Space Consultant

Confidential

Responsibilities:

• Modified and revised software extractions and downloads from Clients DB systems to Confidential Access Data bases.
• Documented and revised software extractions, table modifications, processes and process flows, and work station standards.
• Gathered requirements: current, 5, 10, and 15 year projections on headcount, space and special area requirements for Space planning by Dept.
• Worked on other Confidential clients Space Programming and planning assignments to fill in some of the down time.

System Analyst

Confidential

Responsibilities:

• Produced and modified the detailed documentation of all critical processes, spreadsheet processing, and SQL code needed to perform the Daily reporting and distribution of commissions to the Indirect Dealers. (Daily counts of 5k to 15k and amounts totaling 150k to 350k).
• This heavily manual effort of applying functions and data lookups to create multiple spreadsheets is double checked for accuracy and Audit purposes before being Approved and sent to an EPay Vendor who distributes these commission check to the dealers.
• Quickly resolve disputes between Dealers, EPay Vendor, and Commissions group when called upon. A lot of Business Rules are constantly changing which keep this job very intense and challenging. Thus the need to constantly update documentation.

System Analyst

Confidential

Responsibilities:

• Produced FSD Functional Spec. Doc, for how to separate a current Marketing DB portfolio application into retained and divested portfolios, based on proposed Confidential &T merger. Work stopped after Confidential &T Sale was called off in December 2011.
• Worked on an automated scripting tool application which pulls in dynamic data attributes for Customer Service Reps to present Account changes aimed Confidential keeping / retaining current T-Mo Customers.
• Worked on migrating existing Sales Campaigns in an existing 10+ year old Sales Campaign Marketing application (un-documented) to a newer Marketing Application - SAS-MA implemented in 2011. Programming changes and SQL scripts / Queries & Production Monitoring.

Sr. Business Analyst

Confidential

Responsibilities:

• Wrote, Groomed, and Maintained User Stories for projects assigned to be used for Sprint Planning for the Development Agile Teams.
• Produced Impact Assessment documents (like FSD Functional Spec. Doc), tracing business requirements to User Stories.
• Attended Sprint planning sessions, grooming sessions, Dev. Team Daily Stand-ups, Requirement Stack sessions as needed to assure projects met their deadline releases. Served as business liaison between development teams and Business User Community.
• Worked with Architects, Programmers, Development testers, Quality Assurance testers, and other System and Business Analysts that represented all other interfacing Applications and Middleware components for the various Application Projects assigned.

Sr. Business Analyst

Confidential

Responsibilities:

• CTIA Compliance which incorporating Content Control guidelines across all websites, Confidential mall, and 3rd parties (i.e. Netflix)
• Wi-Fi Calling capabilities to allow Confidential to improve customer reception and CHURN by allowing customers where in-home coverage is poor to connect to their wireless network to make calls over their Wi-Fi connection.

Functional Analyst

Confidential

Responsibilities:

• Authored functional requirements developed from Business requirements and processes that documented the as-is and to-be business processes for the Wholesale and Retail Customer tracking applications.
• Quality Center triage work on My Account included: defect tracking, investigation, and resource assignments to fix and close defects.
• Created and Modified API (Application Protocol Interface) documents that included identifying: Inputs, Outputs, Exceptions, Logic flow, and DB table and column identifications between Confidential DB tables and Amdocs DB tables.
• Creation and modification of process diagrams, use cases, data flow diagrams, and swim lane diagrams, for applications as assigned.

Sr. Functional Analyst

Confidential

Responsibilities:

• Authored detailed requirements to be used by Developers / Testers for a customized web-based Oracle GUI application.
• Wrote functional requirements, use cases, test cases and managed migrating from PeopleSoft HR application to the Cenet HR application.
• Validated functional and data compliance for all upstream and downstream HR and Commission Tracking and Reporting systems.
• Translated Business requirements into Functional requirements and Test cases tracked back to the Business requirements.
• Defined data translation requirements between upstream and downstream systems using Excel, Oracle, and creation of SQL Queries.
• Created detail Process Flows and documentation on a “WorkFlow” Rules-Based front-end application to the CinglePoint Application.
• Creation and Maintenance of System Processes, Procedures, and High Level Detail Design documentation.

Business / Process Analyst

Confidential

Responsibilities:

• Regularly met with and interacted with Confidential executive management and internal and external auditors to convey findings identified through walkthroughs and testing, assessing the risk and impact of SOX GCC deficiencies.
• Performed in-depth IT Control Assessments, Documented test requirements, and remediation alternatives where required.
• Creation of extensive departmental “Swim-Lane” process flows and supporting documents for SOX 404 Key Process Controls.
• Created Audit / Test / Remediation Plans to assure client’s Processes, Procedures, and IT Application controls were SOX compliant.
• Worked with the IT Process group on coordinating Business Processes and Sox controls existing and required in the future.

Business System Analyst

Confidential

Responsibilities:

• Created, modified and got approval on Business Requirements, Functional Specs, and Detail Specs, which documented the business end-users needs and new processing requirements of a Security & Forensic Application.
• Developed new “Swim-Lane” process flows depicting the new proposed business processes needed for this application.
• Assisted in the planning, creation, and running of “Testing” use-cases documented in “TestDirector” and Excel”.
• Worked in other short term application tasks as assigned during acceptance & approval phases of the Forensic Application

Business / Process / SOX Analyst

Confidential

Responsibilities:

• Worked on identifying the key Confidential &T Wireless Network Services assets that are critical to the company’s financial operations.
• Creation of extensive departmental “Swim - Lane” process flows, that document the Applications and Key Process Controls.
• Defined Roles and Responsibilities, and worked on Designing / Creating / Conducting Test Plans and Procedures.
• Documented Test Plan results, and identified follow on Remediation Activities for Business Process Owners to correct.

Business / Programmer Analyst IV

Confidential

Responsibilities:

• Wrote the Business and Functional Requirements for downloading an Oracle Revenue System into the CFDW data warehouse.
• Developed test scripts and SQL queries to assure that the data source in balanced to the data loaded into the Data Warehouse system.
• Worked on documenting the various application systems data migration processes, using DMR P+ Methodology and Visio.
• Detailed functional requirements written in P+ methodology for other Data migrations between applications and Teradata DB.
• Productionized all JCL jobs on an IBM 3090-MVS system under OMSP which fed the NCR Teradata system on HP UNIX.
• Performed other Business Analyst and Programming tasks as assigned that fed the CFDW Data Warehouse System.

Business / Programmer Analyst

Confidential

Responsibilities:

• Worked with Business System Manager to document business planning processes in P+ Methodology and Visio Process Flows.
• Worked with WSPR technical team and Core team members as assigned gathering and documenting all business processes.
• Maintained Business Plan Adjustments, Glossary of terms, Process Tree definitions & Structures and integrated Process flows.

Business Systems Analyst

Confidential

Responsibilities:

• Y2K regression testing for on-line and batch applications extracting Oracle/RDB and Sybase table information.
• Tested application feeds to Outside Vendor applications - Call Processing, Collections, ACH, and Performance Monitoring.
• Performed analysis of processing and programming errors and corrected them for the Help Desk & Production systems.
• Produced Detail Design documents, processes flows, and program specifications required for major enhancements.
• Wrote and modified programs in COBOL, ISQL, Smarstar, and Access for file analysis, reformatting, and conversion @ Paging.

System Analyst

Confidential

Responsibilities:

• Analyzed Cobol Legacy code in order to extract business rules and requirements for the Requirement Specification documents.
• Tools used: Oracle Designer 2000, Developer 2000, Word, and Visio for documentation and programming efforts.
• Wrote COBOL programs as assigned to assist in their data conversion and migration efforts.
• Wrote and SQL queries to verify the data migration form Legacy to to Oracle Application.

Project Manager

Confidential

Responsibilities:

• Produced Requirements documents, conversion programming tasks, and detailed design specifications for new and custom modifications to this Progress Manufacturing system.
• Performed all project tracking responsibilities between the Software vendor and Client.
• Worked on a “GUI” version of the Electronic Data Interchange (EDI), and “Bar-Code” software modules.
• Developed Progress Ver. 8 (GUI) software modifications in Windows, and then ported to Sun UNIX.

Project Lead / Senior Analyst

Confidential

Responsibilities:

• Managed the re-design of the company’s Insurance Tracking products from an Empress RDB to an Oracle RDB.
• Assisted Management in the organization and tracking of all the re-design plans, phases, and development efforts required.
• Designed and programmed in Oracle 7.0, PL/SQL, SQL Plus, Forms 4.0, and SQR report writer. (team effort)
• Produced detail documentation and program specs using Visio, Word, and Oracle’s CASE designer tool.

VP & IT Director

Confidential

Responsibilities:

• Co-Managed the development and successful remarketing of a customized Lease Portfolio Management system (Sealams) in partnership with the Accounting firm of Peat Marwick & Mitchell.
• Managed the Systems department of 18 technical employees and 10 to 15 outside contractors and consultants.
• Managed the re-design of core business applications, while maintaining Production systems during a corporate merger.
• Developed an in-house system development methodology (SDM) used on all major application development projects.
• Implemented and managed a “Systems Steering Committee” to prioritize systems requests for all departments represented.
• Implemented conversion of the company’s telecommunication to LAN/WAN technologies.
• Replaced the in-house front-end “Pricing” system with a 3rd party package, which became the accepted industry standard.
• Created, tested, and revised as necessary a “Systems” Business Recovery Plan.
• Designed and had built two state-of-the-art computer room facilities, with UPS backup capabilities.
• Programmed on various applications as time and management of staff personnel allowed.