Finance Systems Manager Resume
Washington, DC
PROFESSIONAL PROFILE:
A dynamic and result oriented Confidential consultant offering over eighteen years of experience in managing business systems, IT/IS management, data science, BI - reporting analytics, workforce development and skill building,, change management, program/project management and business process simplification and re-engineering to optimize processes in order to maximize profit. Professional experiences include emerging technologies, web services, e-commerce, marketing, customer service and relationship management, staff, talent acquisition, team building and employee retention, procurement and supply chain management in corporate, bio-technology, government, higher, hospitality and non-profit industries.
TECHNICAL SKILLS:
Operating Systems: Windows 10, Windows Server, IBM-AIX, UNIX, Solaris, Linux (Red Hat)
Programming Languages: SQL, PL/SQL, Pro*C, Visual Basic, .NET, ASP.NET, C, C++, Java script, PERL, HTML, XML, UNIX shell scripting.
Web Server, App. Server & Web services: SOAP, REST, WYSO2 (familiar), Oracle Weblogic-OFM, ApacheTomcat, Citrix, Microsoft IIS
RDBMS: Oracle, Microsoft SQL Server
Design Architecture: Waterfall, Agile with Scrum, UML
Network/Telecom & Data Communication: LAN/WAN, TCP/IP, Mobile/RF technology, PBX, VoIP
Disaster Recovery: SAN, RAID technology, clusters, Back-up and storage
Reporting Tools: Cognos with Framework Manager, Transformer, Oracle, APEX, Forms and Reports, Oracle Discoverer, Argos, Crystal Reports, Noetix, Hyperion (Brio), Microstrategy
Learning Management (LMS): Blackboard, Canvas
Project Management: MS Project, Clarity, Galaxy, DAPTIVE
CRM: Microsoft Dynamics, Salesforce and TargetX
IT Help Desk: ServiceNow (Snow), Magic Service Desk Express, Remedy, Zendesk, TrackIT
Office applications: Office365, MS-Exchange, Sharepoint
Other: Google, Luminis Portal, BEIS/BEP, WebTailor, Workflow, Sharepoint
Identity & Access Management: Shibboleth, Active Directory, LDAP, SSO, CAS and FGAC
PROFESSIONAL EMPLOYMENT HISTORY:
Finance Systems Manager
Confidential, Washington, DC
Responsibilities:
- Manage enterprise systems, infrastructure, data, Web technologies, digital content, BI-reporting and analytics to support, streamline and re-engineer business operations. Develop, integrate and support mobile and cloud technologies. Track web analytics to perform predictive behaviors and outcomes.
- Oversee Touchnet cashiering solutions, Intellicheck, Confidential banking and payment solutions, ETL data processing, modeling and EDI operations. Develop business Score cards and dashboards to capture analytic data as required by government agencies to make informed decisions, formulate strategies, help clear audits and be compliant with regulatory needs within budget and deadline.
- Advise the data governance board in IT policies, procedures, guidelines and the management of master data, metadata, data modeling for data-warehouse. Maintain systems to be compliant with the institutions cyber security standards and protocol. Mentor and train staff on financial applications and change control procedures. Manage in-house application development and production release in an agile environment.
- Oversee, troubleshoot, allocate IT resources to helpdesk requests using ServiceNow, Trackit and Zendesk to oversee the operations of over 300 work stations in finance, accounting, budget, facilities, property management and engineering division. Direct staff and perform fiscal data loading operations, batch files and automated processes from internal and external government agencies.
- SME for finance related matters with Oracle, PeopleSoft, Microsoft SQL Server and Dynamics.
- Currently help conference, events planning, guest housing, facilities maintenance to implement application on Java stack, open source and Oracle technologies to streamline scheduling, housing, space utilization, conference & events planning, property management, asset inventory and movable resource allocation.
Consultant
Confidential, South Orange, New Jersey
Responsibilities:
- Programmed and developed Confidential interfaces, forms and external applications to integrate Confidential HR with employee retirement and investment portfolio with external vendors. Managed project from conceptualization to close.
- Modeled master and meta data to implement a content management system that I developed to customized standards and to automate with scheduling software. Advised client to leverage and adopt cutting edge web technologies, hardware and open source software.
- Provided technical guidance to PMO and IT division on systems architecture and the future state to support in-house application development.
- Implemented an Identity and Access Management solutions with third party applications for in-bound and outbound provisioning with Central Authentication Services (CAS).
- Utilized ETL tools to model data into ODS/EDW environment and then report with Cognos BI v10 utilizing Query studio, Report, Metric studio, Framework Manager and Transformer to develop reports. The reports helped the institution achieve their divisional goals and targets, KPI’s and to evaluate their mission critical metrics and performance.
- Implemented Confidential Recruiter with MS Dynamics, Degreeworks, ISSM to integrate with ERP and third party applications such as 25Live, Document Management, TouchNet, Formfusion, Luminis, Atomic (UC4), Workflow, T2 and Bosscars parking management systems in helping clients to leverage technology and reduce cost of ownership, increase revenues.
- Integrated employee Identity and Access Management (IAM) solution and integrated this with HRMS, ERP and third party application. System is used for staff on-boarding, transfer and exit process for Public Safety office.
- Integrated OneCard staff ID’s to IAM that gave access to amenities (gym, pool, sports, athletic complex), dining services, restaurants, other facilities and access to parking lots.
- Manage and coordinate projects with peer consultants and PMO office to expedite projects according to PMP methodology.
- Subject Matter Expert (SME) in Confidential Student, Finance, Financial Aid, Human Resource, Alumni and Self Service modules helping clients to fulfill their ERP investments. Assist clients in student recruitment, enrollment, admissions, registrar, retention, advising, curriculum planning housing/location management and scheduling.
- Helping clients to adopt best practices and cutting-edge technology. Streamline IT-helpdesk and incident ticket reporting systems to comply with institutional ITSM/ITIL strategy when using Ellucian Service Now (Snow), Cloud support services and local IT-helpdesk.
Consultant
Confidential, South Orange, New Jersey
Responsibilities:
- Assisted client with project readiness by making sure that the technical architecture and infra structure is in place and on target with server builds, architecture, operating system install, database, application and web server installs, enabling SSL security s and encryption, opening of ports and monitoring traffic for server system performance monitoring tools and internal testing of application set ups before and testing environment is set up.
- Assisted project manager to place a technical IT governance and oversight plan of action, communication plan, change management, change control procedure and instance management plan.
- Managed third party integration and generation of extracts with OIT to develop Focus reports out of SCT*plus.
- Teamed with Integration-PM to identify requirements with Confidential student integration points with PeopleSoft finance, Workday-HR, third party and external systems.
- Consulted and advised the Identity Access Management team to plan the road map for provisioning and de-provisioning of accounts, and recommended Identropy for MSU.
- Administered the document sharing and content management using Canvas and Daptive.
- Assisted One Montclair PMO team in reaching established project milestones, change control, change management and how best to streamline SNOW incident reporting and service requests with Magic helpdesk.
Consultant
Confidential, South Orange, New Jersey
Responsibilities:
- Developed and automated e-transcripts using Formfusion, MAPS server and campus portal to leverage technology with the National Clearinghouse.
- Managed staff, department budget, daily operations and performed administrative duties.
- Allocated staff to ongoing projects and delegated tasks to trouble shoot system issues and work orders.
- Developed institutional reports using Cognos pointing to Data Warehouse (ODS/EDW), RAP/SRP.
- Converted SCT*Plus reports using Oracle Developer for real time reporting using Oracle streams.
- Authored functional design specification to customize Cognos packages from Baseline to be sent to IT data modelers to build new ETL process and staging tables to extract data outside the ODS.
Independent Consultant, Engineer and Project Manager
Confidential, Rosewell, Georgia
Responsibilities:
- Government contractor in implementing new ERP system enabling procurement and Finance department to go-live and to be in compliance with Federal and State mandate of Washington DC .
- Designed and developed new data-warehouse and implemented a new reporting methodology using Cognos BI, Argos and Microstrategy. Migrated legacy reports to Cognos and Oracle Discoverer.
- Reported directly to President, Vice Provost and Board of Trustees to report on organizational performance by presenting and simulating data showing the holistic and drill down picture of business performance through dashboards, enrollment funnels, yields. Yearly forecasting and projections were done using predictive analytics.
Business Analyst and Lead Application Developer
Confidential, Cleveland, OH
Responsibilities:
- Served as consultant and project lead at Confidential implementing Confidential HR/Payroll, position control and Workflow. Interfaced Kronos time sheet management system with Banner. Managed high impact projects with critical go-live deadlines that were production critical. Managed ancillary systems integration and migration. Trained staff and conducted on-site . Prepared clients for ERP modules and daily operations, ODS and EDW Data warehouse components. Developed and engineered Business Intelligence (BI) reports using Argos, Cognos 8 BI and Oracle Developer Reports. Supervised and mentored peer consultants, IT staff and managed project budget and outsourced resources.
Consultant
Confidential, Atlanta, Georgia
Responsibilities:
- Served as Business Analyst and application developer in implementing ERP Finance, Financial Aid, HR, ODS and EDW data-warehouse components and institutional reports. Managed and steered data mapping projects using Informatica, Oracle Warehouse Builder, ETL tools from auxiliary systems into Data Warehouse. Mentored peers and trained staff on Data Warehouse architecture, administration and technical trouble shooting.
- Managed and Steered SciQuest e-procurement implementation projects and interfaced product with ERP system, Commercial-Off-The-Shelf (COTS) and turnkey applications.
- Served as BI consultant for European bio-medical manufacturer. Engineered and developed reports using Crystal Reports XI. Consulted client on recently upgraded Trackwise 7.0 Quality Management System and BI reporting platform for QA/QC department.
ERP Consultant and Developer
Confidential
Responsibilities:
- Performed Business systems analysis, design and programming to automate processes according to Confidential regulations and CFR 21 Part 11 compliance in pharmaceutical and bio technology manufacturing.
- Authored and managed the triage process of user specification and testing guides (URS, UAT), IQ, OQ and PQ documents required by 21CFR part 11 to be compliant with Confidential regulations.
- Re-designed database in Microsoft SQL server 2003 database and stored procedures for enterprise reports and internal workflow to auto emails according to event triggers upon user events.