Daniel Farrell

Swedesboro, NJ *****

856-***-**** : Dan Farrell linkedin.com

ac8j8p@r.postjobfree.com

Summary

Conscientious and resourceful business and IT professional with extensive experience in all phases of the system life cycle searching for a position with a progressive firm in Tristate area (Delaware, south eastern New Jersey, south eastern PA). Strong analytical skills with proven, effective and accurate problem-solving ability. Excels at multitasking in fast paced virtual environments demanding proficient organizational and interpersonal skills.

Areas of Experience

Requirements

Software Development

SDLC

Hadoop

Strategic Planning/Analysis

Waterfall & Agile Development

Oracle/SQL

Teradata

Microsoft Products

Education

Master – 2001; St Joseph’s University Information Systems

Bachelor – 1981; Shippensburg State University Accounting

K-Force contractor for JP Morgan Chase & CO. 4/2016-12/2019

Conshohocken, PA

Financial/ Technical Business Analyst

JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm specializing in investment banking, financial services for consumers and small businesses, commercial banking, financial transaction processing, and asset management.

Perform critical analysis on information consolidated from multiple sources to identify & translate business and design requirements into technical requirements for development teams and resolve conflicts including breaking down information into detailed workable requirements.

Scheduling, participating, facilitating and documenting design discussions for creation of functional requirement documents and system design. Scheduled Follow up meetings on items requiring additional break-out sessions for additional requirement definitions through the design phase.

Took ownership of the project functional and technical requirements, which were not being produced in a timely fashion, in order to have useable requirements for the development team.

Participated in various scrum meetings including daily scrum, sprint planning, and sprint retrospective meetings scheduled by the scrum master.

Created an Excel process with visual basic macros to reconcile high volume of table field names and field descriptions between developers DML, database table and users documentation to reduce reconciliation time by over 50%.

Examined existing Java programs, SQL Teradata processes and Linux shell scripts in order to modify outdated documentation and created new Functional technical documentation, and discussed these documents with the business, developers, and testers in order to obtain approvals.

Worked with project manager and product owners to define project prioritization and provide scoping/estimation.

Examined data by creating SQL queries in Teradata database to identify issues and verify requirements.

Work with developers and subject matter experts to estimate the work, and communicate risks and to the designers and project managers.

Partner with product owners and developers to maintain user guide, training manuals and release notes.

Point of contact between the Technical Development, Test, Design & Product management teams for an overview of the project statuses on a routine basis.

Began transformation from waterfall to Agile development.

Member of team that created and presented agile software basics to current Waterfall developers.

9/2014-1/2016

Open Systems contractor for Checkpoint Systems

Thoroughfare, NJ

Financial Business Analyst

Checkpoint Systems headquartered in Thoroughfare NJ is a provider of merchandise availability solutions for the retail industry, encompassing loss prevention and merchandise visibility.

Designed, developed, documented, tested, and debugged software to provide solutions to standardize, collect, consolidate, and cleanse international Asian Pacific sales and cost information for global profitability analysis.

Designed Dashboards to deliver business insights based on the data.

The new management reporting process ensured accurate information in an Oracle data base for global profitability analysis using the QlikView business Intelligence product at various levels of the business to optimize profitability.

This new process put controls in place to enforce data accuracy, and QlickView provided me with a flexible Business Intelligence platform for turning data into knowledge.

Co-ordinated weekly meetings with Asia Pacific and Latin America management teams to discuss user requirements, issues and resolutions for the Management Reporting process.

A new Management Reporting Data dictionary including SQL select statements was created to assist in the discussion and mapping of information to the proper format required by QlickView.

Developed Web based management reporting tool for global profitability analysis using PL/SQL and the QlickView business intelligence product.

Created PL/SQL procedures to extract financial information from various SAP modules including Plant Management, Material Management, Logistics, sales and distribution, and basic financial modules.

1/2011 - 1/2014

Lockheed Martin- Valley Forge, PA

Cherry Hill, NJ11111

Software Engineer SR

Headquartered in Bethesda, Md., Lockheed Martin is a global security and aerospace company that employs about 113,000 people worldwide and is principally engaged in the research, design, development, manufacture, integration and sustainment of advanced technology systems, products and services.

Planned, conducted, and coordinated software development activities for the Human Resource & Payroll departments based on requirements documented and gathered from system users. Designed, developed, documented, tested, and debugged software to provide solutions to business problems for the Human Resource/Payroll & Finance/Accounting departments. Applied strong technical skills, coupled with business intelligence and a deep understanding of the customer's needs to transform user needs into application and operational requirements. Acted as an interface between business users, technology teams and support teams.

Migrated to new web based time card system and converted back end processing to Linux server to lower costs and reduce complexity

Modified and tested Oracle PL/SQL scripts and converted back end from UNIX bash shell script to Linux server that impacted 30,000 users. Assisted users in developing user acceptance test cases for screens and reports.

Successfully implemented time card Oracle PL/SQL validation procedures and received Special Recognition Team Award for my efforts to replace with new table driven procedures.

Created and modified reports from the PeopleSoft general ledger and projects modules based on documented requirements provided by both the general ledger and project finance departments. Planned, implemented, tested, documented, and maintained Allocation, Billing and related subsystems using internally created COBOL programs and DCL processes on DEC VAX and ALPHA midrange computer systems. Understood business processes and the customer’s business requirements and translated them to specific software requirements. Effectively communicated with internal teams to deliver functional requirements in accordance with Generally Accepted Accounting practices and the Federal Acquisition Regulation.

General application risk and control considerations for complying with Sarbanes-Oxley were met for application controls, access security, general IT controls related to applications, implementation controls and considerations, documentation, testing, addressing deficiencies and reporting.

New web pages along with fields, records, tables, pages, and components in the people soft database to generate various reports, in addition to using People Code and creating SQR reports.

The COBOL billing calculation process for various unique indirect overhead, material handling, and general & administrative indirect expense calculations were tabelized to eliminate maintenance on the billing calculation process.

Technical Skills

SQL & PL/SQL for Oracle database

Unix & Linux Shell Scripting

Obtaining and creating functional requirements document.

System flow charts including process flows and data flows (Visio).

Participated in Waterfall & Agile Software Development projects.

Member of team that transformed from Waterfall to Agile software development.

Qlickview – Business Intelligence Analytical Software.

Responsible for conversion and implementation of General Ledger, Accounts Receivable, and Accounts Payables Systems.

Reconciled Physical and Perpetual Inventory

Software Integration & Test Project Management

PEOPLECODE & People Tools SAP table SQL extracts

COBOL Digital Command Language (DCL)

Job Control Language (JCL) Microsoft Visio

Microsoft Excel Microsoft Power Point

Microsoft Word Microsoft Outlook

Microsoft Access Java

C# Reconciled Corporate Bank Accounts

HADOOP (HDFS) open source Processed Capital Lease Transactions

Analyzed financial statements Visual Basic

Additional Information

Coached Youth athletics (Basketball, Football, and Baseball).

Captain of College Basketball Team.

TestDome Certificate [Oracle PL/SQL and SQL ].

Contact this candidate