JAMES BRADFORD ADKINS, MSCIS *** N Broadway # B818, Los Angeles, CA 90012
Email: adbpt8@r.postjobfree.com
Mobile: 925-***-****
CAREER OVERVIEW
Experienced Financial Accountant and and Systems Analyst in various fields such as IT, Telecommunications, Big 4 CPA Firm, Utility, Accounting, Health Care and Government. Professional experience includes Requirements Analysis, Technical Writing, High-Level and System Designs, Coding in COBOL, DB2, Oracle, SQL, Application Software Development, Migration from Legacy Systems to Web-based ERP Systems, Configuration Management and Control, Functional Testing, End-to-End Testing, System Testing, Performance Testing, Project Coordination, Project Management, SDLC, Fit-Gap Analysis, Data Mapping, Business Process Improvement, Functional Design Specifications, Cost/Benefit Analysis and Disaster Recovery Planning. Qualifications
• Strong Analytical Thinking • Data Manipulation and Research
• Excellent Problem Solving Skills • Business Process Management
• Diligent and Resourceful • Infrastructure Planning, Budgeting and Forecasting
• Organized Document Recording & Technical Writing • Network and Desktop Support Technical Skills
Skills Experience Total Years
Project Management and Coordination Capable 10+
Technical Support, Data Reporting & Writing Capable 10+ Asset Management, Tracking, Inventory, Budget Capable 10+ Applications and Data Mapping Capable 10+
Oracle, PeopleSoft, SAP CRM & Financials Capable 10+ Windows, MS Office, Excel, Visio, Outlook, Project Capable 10+ QuickBooks / Quicken Capable 10+
MVS/COBOL, DB2, SQL, HTML, Software Testing Capable 10+ TSO, ISPF, RACF, NDM, SDSF, IOF, SAR
Capable 10+
Accomplishments
Business Processes
§ Performed full accounting cycle processes such as preparation of Bank Rec, Check Rec, Journal Entries, AJEs, GL, A/R, A/P.
§ Prepared design specifications, developed reporting and analytics end-user acceptance testing.
§ Worked as a Systems Analyst on Supply-Chain Management for offices, branches, and plants/facilities.
§ Managed business relationship with vendors, departmental and other global operating units, and partner developers.
§ Performed full SDLC processes starting from requirements to testing and implementation.
§ Created processes for inventory management, warehousing, and logistics.
§ Supported the achievement of SEI CMM Level Certification and meeting reporting metrics. Project Coordination
§ Created Project Documentation, High-Level Designs, System Designs, Business Plans and Management Reports.
§ Monitor and review Project milestones, quality, and costs.
§ Created Functional Specifications and Request For Proposals.
§ Created IT and Telecom Infrastructure Project Plans, Budgets and Schedules ($20Million/Year).
§ Created User Acceptance Guidelines, test strategies, test cases, test plans and facilitated UAT.
§ Managed on-site equipment deployment and configuration. 2
Software Development and Technical Support
§ Acted as primary point of contact for major technical issues, including power outages, system failures and disaster recovery.
§ Oversaw Performance Testing Team charged with stress-testing code changes to PeopleSoft CRM & Financials application.
§ Managed IT Assets (desktop, laptop, Fax/LAN printer) from acquisition, to installation, to maintenance, to upgrade, and finally to retirement.
§ Planned, configured and installed, computer roll-outs including desktops, laptops and LAN Fax/Printers.
§ Supported Data Center servers, desktop and Wi-Fi clients, and network LAN/WAN equipment including routers, switches, load balancers and wireless network.
§ Trained newbie programmers on billing systems, walkthru documentation, available tools and utilities. PROFESSIONAL EXPERIENCE
SYSTEMS ANALYST / ITS DESK SERVICES – Deployment (Limited Position) April 2019 – December 2019 Los Angeles Department of Water & Power (Utility)– Northern California
§ Deploys Windows 10 computers and replaces old Windows 7-based computers.
§ Images brand new desktop PCs and laptops via server using Microsoft Deployment Toolkit (MDT).
§ Updates Asset Management System (AMS) in scanning in and out PC inventory.
§ Performs remote PC troubleshooting using DameWare Mini Remote Control.
§ Uses System Center Configuration Manager (SCCM) in pushing out software packages/updates to client PCs. BUSINESS ANALYST / INFRASTRUCTURE SUPPORT – Technology and Consulting Services April 2013 – April 2019 PG & E (Utility) Independent Contractor – Northern California
§ Prepared weekly reconciliation between SAP Financials reports versus Actual Departmental Project Construction Costs.
§ Prepared Monthly Project Cost Reports for high-level executives. Worked on Asset Knowledge Project for PG&E focused on reconciling construction project costs against the General Ledger accounts in SAP Financials.
§ Prepared monthly ad hoc project costing reports for various high-profile government agency-mandated initiatives. Worked on data upload project for the PG&E Academy.
§ Responsible for coding and uploading learning assessments and general data into SAP and QuestionMark software. TAX ACCOUNTANT / ANALYST October 2012 – April 2013 KPMG LLP (Big 4 CPA Firm) Independent Contractor – Northern California
§ Prepared thousands of tax returns (Trust, Corporation, Partnership, Single Proprietorship).
§ Updated and maintained client tax files in the web-based databases, TrustTax and TrustEase.
§ Analyzed and corrected client information for Quality Assurance.
§ Liaised with the bank managers, IRS auditors and clients to ensure taxes are filed completely, accurately and timely.
§ Trained on new hire Tax Accountants on policies, procedures, documentation, software tools and utilities. LEAD SENIOR ACCOUNTANT / BUSINESS ANALYST October 2009 – October 2012 Kaiser Hospitals (Health Care) Independent Contractor – Northern California
§ Prepared monthly bank reconciliation, inter-company eliminating entries and month-end closing entries.
§ Prepared Preliminary Trial Balance, Income Statement, Balance Sheet and Statement of Changes in Financial Position.
§ Supervised Staff Accountants to ensure tight deadline deliverables are met.
§ Liaised with other branch managers and external clients in resolving reportorial issues and challenges
§
SYSTEMS ANALYST / ITS DESK SERVICES – Deployment (TERM Position) March 2009 – October 2009 Los Angeles Department of Water & Power (Utility)– Northern California
§ Deploys new computers, laptops, printers and peripherals. Replaces old computers.
§ Images brand new desktop PCs and laptops using Symantec GHOST Imaging Software.
§ Updates Asset Management System (AMS) in scanning in and out PC inventory.
§ Performs remote PC troubleshooting using DameWare Mini Remote Control.
§ Uses Active Directory in resetting User Access and passwords. 3
SENIOR TECHNICAL TEAM LEAD March 2010 – February 2009 AT&T INC. (Telecommunications) Regular Employee – 2600 Camino Ramon, San Ramon, CA
§ Documented IT Business Processes through Center of Excellence Approach.
§ Determined and analyzed business requirements from clients and developed detailed equipment and configuration solutions to meet those needs.
§ Served as technical support to resolve issues related to technology domain and discipline.
§ Contributed to develop best practices instructions and manuals to guide end users.
§ Assigned and systematically distribute projects to programmers by providing time and cost estimates to the Technical Director.
§ Trained users on new software and business processes. Conduct User Acceptance Testing (UAT). TECHNICAL ARCHITECT September 2008 – March 2010
AT&T INC. (Telecommunications) Regular Employee – 2600 Camino Ramon, San Ramon, CA
• Business Case Presentation
§ Tracked IT and Telecom equipment for Asset Management and Budgeting.
§ Managed IT and Telecom Capital Expenses for equipment from procurement to maintenance.
§ Presented business cases/projects to top management.
§ Written Feasibility and Cost/Benefit Studies, Gap Analysis and RFPs.
§ Initiated Application Programming and Systems Development outsourcing program.
§ Researched and analyzed market conditions. Created Marketing proposals and strategies for particular niche/segment.
§ Assessed customer needs and provide product solutions.
§ Presented customer experience to the marketing group for post-sales analysis.
§ Proposed process and product improvements.
PROGRAMMER ANALYST April 1999 – September 2008
AT&T INC. (Telecommunications) Regular Employee – 2600 Camino Ramon, San Ramon, CA
• Infrastructure Analysis and Business Continuity Planning
§ Met clients to collect business requirements, ensures right level of detail, challenges and refines client requirements to find a simple technical solution for the problem, presents a variety of solutions with advantages and disadvantages and recommends preferred technology (web-based interface, data base application, or MS Office products)
§ Application developer: Programs technical small sized applications self-sufficiently (clients mostly work with MS Office). The new applications will interface to in-house systems or vendor applications such as Oracle/PeopleSoft. Examples: Combined reporting, automated email sending and web-based applications which simplify HR processes within a continuously changing environment
§ Self-sufficient project lead: Owns the entire project live-cycle from end-to-end (define requirements, design solution, program and organize sufficient testing, launch and implementation maintenance and create support documentation).
§ Customer support: Supports and trains end users, resolves issues, documents and enhances solutions to meet future business requirements.
• Telecom Data Analysis and Migration
§ Extract and analyze Telecom traffic and provide management and metrics reports.
§ Designed Use-Case diagrams on IBM Rational for Business Process Management to migrate Customer Management System
(client-server) to Enterprise-Wide System (web-based).
• External Compliance and Business Systems Audit
§ Ensured and documented Payment Card Industry (PCI) Compliance - Quarterly Systems and Network Audit
§ Provided documentation for Business Systems Algorithms and Procedures.
§ Responded on periodic and unannounced audits from parent company, Contractors and 3rd party Accounting Firms. 4
• Systems Analysis, Design, and Development
§ Developed Sales System for Satellite TV Subscription and Prepaid Telecom Cards.
§ Collaborated in the migration of databases from Alpha5 DBF to SQL Server tables.
§ Administered Windows NT 4.0 and MS SQL Server 6.5/2000.
§ Implemented PeopleSoft Financial Systems particularly GL, A/R and A/P. STAFF ACCOUNTANT / STAFF AUDITOR / TAX AUDITOR /SYSTEMS ANALYST March 1995 – April 1999 CITY OF LOS ANGELES- CONTROLLER’S OFFICE (Government) Regular Employee – Los Angeles, CA
• Business Process Management
§ Prepared journal entries, balance sheet reconciliations, financial statement analysis, financial reports and variance analysis.
§ Developed and maintained complex financial spreadsheets (Excel) and databases containing advanced functions.
§ Audited the City’s 42 Departments (City Controller’s, Transportation, Building and Safety, Parks and Recreation, Airports, Fire, Police, among others). Prepared audit plans, audit procedures and publicly-published audit reports.
§ Applied technical skills to independently research, interpret, analyze, compile, and present data and information.
§ Experienced in decision making, problem-solving and analytical skills to independently research issues requiring mature judgment and tact and document it all in the audit papers and audit reports.
§ Improved Audit Processes through automation of audit client file retrieval using Microsoft Access.
§ Installed thousands of desktops, laptops, software, and peripherals for end users. COMPUTING ENVIRONMENT:
Network: Mainframe MVS O/S, Windows PC, MACs, UNIX and mobile devices. Wired and wireless networks. Windows NT on a global WAN is connected via public internet and private leased lines, wired/wireless LAN, VPN. User access thru AD and eToken authentication.
Software: MS Office Pro, SQL Server, Microsoft Access and Databases. Citrix and Terminal Services to access SAP and CRM applications. Crystal Reports. Remote Access such as Team Viewer and Remote Desktop. QuickBooks/Quicken Programming Languages: COBOL for Mainframe MVS, DB2 for Mainframe, Visual Basic, SAS, PeopleTools, PeopleSoft, SAP, HTML, JavaScript
Other Systems: Mercury LoadRunner Automated Testing Application, Quick Test Professional (QTP), Ghost by Mercury Systems, Xpediter, FileAid, CompaRex and CuteFTP.
EDUCATION AND TRAINING
EDUCATION:
Master of Science Degree in Computer Information Systems (MSCIS) University of Phoenix (Pleasanton, CA)
Graduated – Class of 2001
CPA Candidate in the United States
Bachelor’s Degree in Business Administration (BSBA) Major in Accounting (Passed/Certified Public Accountant in the Philippines) National College of Business & Arts – Manila, Philippines TRAINING AND SEMINARS:
• Attended Productivity seminars in Project Management, Total Quality Management, Team Building, Managerial/Supervisory Skills, Technical and Requirements Writing, Communication and Interviewing Techniques.
• Attended technical computer courses in MVS COBOL/JCL, TSO, ISPF, DB2, RACF, SAS Programming, SAP, PeopleSoft, PeopleTools, UNIX, Windows NT Systems Administration, MS Project, UNIX Systems Administration, TCP/IP, MS SQL Server, Advanced Excel, REXX
& CLIST Programming, Network Data Mover (NDM), HTML, JavaScript Programming, Visual Basic, Java. 5
PERSONAL INFORMATION: US Citizen. Willing to learn new technologies and processes. Resourceful and responsible. Has leadership abilities and can work independently or as part of a team. Able to work well under pressure. Available immediately. REFERENCES: Available upon request.