SUMMARY:

• 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.
• Accounting (AP, AR, GL), Banking, Leasing & Loans, Manufacturing / Distribution, Retail, Insurance, Government, Medical, Wireless, Space Planning, various Government Agencies, Software Development, and Aerospace.
• Several years (16+) in System Project management and Corporate IT Department management.

PROFESSIONAL EXPERIENCE:

System Analyst and Space Planning 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.

Business 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.

Business Analyst / Programmer

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 & Confidential merger. Work stopped after Confidential & Confidential 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 Confidential - Mo Customers.
• Shared weekend processing work from home every other weekend 3 to 6 hours to run processes of moving data between applications.
• 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.

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.
• 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.

Business Analyst

Confidential

Responsibilities:

• Confidential 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 & Confidential 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

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, Seattle

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.