Project Management Manager
Resume:
CHARLES E. MCGILL
*******@***.***
SUMMARY: 20+ years of Business Analysis, Project Management, Client Services and Operations experience in Banking products and services with an emphasis in:
Providing friendly and effective service
Developing expertise in product knowledge
Creating trust and confidence through business practices
Solving client problems and following through to a successful resolution
Effectively maximizing resources
WORK:
Documentation, Data Conversions, Quality Control, assist in Software Development, User Interface Development, Software Implementation/Configuration and testing, Data Analysis, Project Management, Loan Administration, Process and Procedure Management / Office Efficiency Consulting, Procedure consulting and writing
TECHNICAL:
Microsoft Office (Excel, Word, Access, PowerPoint, Visio, Publisher, Project, Outlook/Express), Hogan Mainframe, SharePoint, CCS CME, SunGard Optimist, Remedy, Pivotal, Business Objects, Metavante, FIS, Apropos, FTP, DOS scripts and Dial Up Networking, SQL Queries, Use Case development, Business Requirement Documents, PeopleSoft, Lotus, Lotus Notes, Novell GroupWise, Mainframe CICS, Custom interfaces (over 40) dealing with multiple data processors including BISYS, FiServ, ITI, Metavante IBS, Jack Henry, Alltel, Kirchman, DCI, Sparak, AFS, OSI DNA and others. Strong knowledge of Banking Regulations and accounting practices, Able to obtain Security clearance
EXPERIENCE:
Tata Consultancy Services, Reston, VA April 2016 to present
Senior Business Analyst
Perform Data Analysis of files received from source organization – responsible for vendor to vendor conversions
Map data from source to target – loan conversion data
Assist developers with the data transformation and ETL processes – loan conversions
Create/Validate Test Plans, Specifications – changes to database and conversions
Create/Validate Balancing Reports – vendor to vendor conversions
Coordinate with Business Unit, Project Managers, Developers, Third party vendors, etc.
Building experience on Retail Banking Applications (Deposits, Loans, CIS, etc.) within Hogan Mainframe and other ancillary systems
Fulton Financial Corporation, Lancaster, PA July 2014 to March 2016
Business Analyst
Provide comprehensive operational, analytical and technical support for projects that impact/incorporate the use of technology.
Advocate the use of technology to improve processes, controls and reporting.
Manage or assist in the management of assigned projects assuring target dates are achieved and quality is maintained.
Serve in primary role within the project team between the project manager, operational business unit and the end user.
Collect and document business, organizational, operational and user requirements.
Responsible for system configuration.
User Interface design
Analyze and define workflow, business processes and data flows.
Design new business processes or modify existing business processes utilizing various automation tools.
Document risks and their mitigation.
Develop test plans, execute plan and document results.
Coordinate with necessary parties in order to document policy and procedures for new or enhanced process/procedure, product or service.
Develop other project deliverables as assigned.
Ensure that all end work products are in compliance with appropriate laws and regulations.
Provide daily administration and operational support for assigned applications as necessary.
The Broekema Group/On-Call Staffing, Dallas, Tx August 2011 to September 2013
Senior IT Data Download Specialist
Contracted for the Federal Government (FDIC) as a Senior IT Data Download Specialist.
Responsible for loan portfolio (Consumer, Commercial & Mortgage) balancing as it applies to Acquisitions and Investors.
Effectively convert assets (ETL), loan and non-loan, for proper balancing to Government accounting systems using Access, SQL, Excel and other system and proprietary tools.
Accountable for data / file auditing, data analysis, ensuring correct input into accounting systems.
Assist in balancing of system data to the main accounting system.
Participated in system design (RDBMS), process improvement, quality control and UAT for proprietary software.
Created and maintained technical documentation.
Consultant, Customers Bank (NY/NJ/PA) March 2009 to July 2011
Financial Institution Business Analyst
On-site and off-site operational, procedural and system analysis, building office efficiency, client relationships and expanding account presence
Deep knowledge of lending industry (16+ years commercial, consumer and mortgage lending) helps to create options for new products clients offer their customers, then follow through with proper testing for performance of portfolios
Gather system and bank requirements from stakeholders for loan portfolio (Consumer, Commercial and Mortgage) conversions
Effectively convert portfolios (CIF, Consumer, Commercial and Mortgage Loans) using appropriate system tools and data mapping (EFT) dealing with multiple data processors including BISYS, FiServ, ITI, Metavante, Jack Henry, Alltel, Kirchman, DCI, Sparak, AFS, OSI DNA and others.
Demonstrated success in training bank employees and management on CIS (Customer Information System), Consumer and Commercial loan systems
Assist internal and external auditors with high-level research for operational corrections and legal cases
Open Solutions Inc. / Bisys Totalplus, Cherry Hill, NJ May 2005 to March 2009
Lending Business Analyst
Successful track record in on-site and off-site operational, procedural and system /data analysis, helping to build office efficiency, client relationships and expanding account presence
Participated in upper level strategic planning process, including writing test scripts, for new products and setting bank procedures to allow for smooth operational transitions between departments
Work closely with conversion analysts on data mapping/conversion (consumer, commercial & mortgage) projects associated with Financial Institutions move from prior processors (mainframe work with CICS)
Wrote requirements for clients on system upgrades to accommodate Consumer, Commercial and Mortgage loan portfolios as well as Customer files
Provide troubleshooting and root cause analysis on client issues with the systems
Charles Jr, Inc. (dba Corporate Leasing Solutions), Cumming, GA September 2003 to March 2005
Owner / Manager / Leasing Agent / Inventor
Provide lease funding for business to business software, hardware and equipment
Responsible for all sales and follow-up calls with vendors and their clients
Work closely with vendors to put together leasing programs for client needs
Documented invention requirements with system use-case methods and diagrams for legal and patent purposes
Fiserv Atlanta, Atlanta, GA July 2002 to December 2003
Manager, On-Line / Micro Client Services Division
Responsible for QA testing and setup of new Fiserv/ITI products on the Fiserv network and client sites
Managed a staff of 8 people whose purpose was to solve new and on-going issues for clients between processing and network compatibility issues
Knowledgeable on interface specifications (CIS, Deposit and Lending) related to Data Processors and clients
Gathered requirements, helped write specifications and test scripts for software implementation
Defined and perfected office workflows for specific projects
Digital Insight, Norcross, GA July 2000 to July 2002
Supervisor / Senior Technical Business Analyst
Set and maintain ‘user options’ for Financial Institutions and their clients use of Internet Banking Systems, including Cash Management for Commercial accounts
Effectively managed a staff of two analysts to research file issues (CIS, Deposit and Lending) for Data Processors as they pertain to the Digital Insight Importer/Database
Knowledgeable on interface specifications (CIS, Deposit and Lending) related to Digital Insight and Data Processors, gathering requirements, writing specifications and test scripts for software development (part of interface team)
Data mapping and conversion work (EFT) dealing with multiple data processors including BISYS, FiServ, ITI, Metavante, Jack Henry, Alltel, Kirchman, DCI, Sparak, AFS, OSI DNA and others
Defined and perfected office workflows for specific projects pertaining to Digital Insight interface functionality
Created and maintained system and procedural documentation for research and training
NetBank, Alpharetta, GA November 1998 to July 2000
Consultant / Loan Servicing Administrator
Assisted both internal and external auditors with high-level research for operations and cases. Worked closely with large auditing firms and government agencies.
Converted portfolios from one system to another system using Excel spreadsheets, Access database and system tools
Responsible for the ODP/LOC product delinquencies and correcting errors on system
Provide detailed reports to board of directors regarding monthly loan servicing
Assisted with ACH and Wire transfers (FundTech) as needed
Bisys Totalplus, Cherry Hill, NJ January 1996 to October 1998
IL/CL Lending Specialist
Trained bank employees and management on usage of Consumer, Commercial and Mortgage loan systems for bank loan portfolios (mainframe work with CICS)
Created user options for new Loan products (Consumer, Commercial & Mortgage) banks offer to consumers, follow through with proper testing for guaranteed performance of portfolio
Responsible for setting bank procedures to allow for smooth operational transitions between departments
Converted several banks onto system as part of conversions team, supported both on site and via telephone, consumer, commercial and mortgage applications
Provide troubleshooting and root cause analysis on client issues with the systems
Worked (helped write specifications for system changes) closely with 4 credit reporting bureaus on projects associated with Financial Institutions and credit reporting
Assisted 3rd party vendors with connectivity and data mapping
EDUCATION:
Stockton State College, Pomona, NJ: B. A. in Business Administration/Finance
Cumberland County College, Vineland, NJ: A.A. in Business Administration/Marketing
Community College of Baltimore County : SQL Certification
Contact this candidate