Principal Business Systems Analyst Resume
Islandia, NY
SUMMARY:
- Experienced Project Manager and Sr. Business Analyst with over 20 yrs experience, serving in both technical and managerial roles at numerous Confidential companies.
- Possesses a development background plus full life cycle responsibilities including requirements gathering, quality assurance testing, technical spec writing and user training.
- Able to work on multiple projects simultaneously from scope definition through implementation.
- Utilized Agile methodology.
- Excellent verbal, written and interpersonal skills. Currently studying for PMP certification.
TECHNICAL SKILLS:
Software: MS Word, MS Excel, MS PowerPoint, MS Access, MS Project, MS Visio, MS Outlook, Office 365, SalesForce, RallyAgile Central, HP Application Lifecycle Management (ALM), Sitecore, PeopleSoft Financials 9.0, PeopleSoft Campus Solutions, SharePoint, JIRA.
Platforms: Windows NT, MVS, ORACLE, MAC
Programming: PeopleSoft SQR, SQL, COGNOS - Impromptu, ReportSmith, COBOL, JCL and maintained various proprietary databases on the web, mainframe and client server side.
PROFESSIONAL EXPERIENCE:
Confidential, ISLANDIA, NY
Principal Business Systems Analyst
Responsibilities:
- Performed business analysis tasks to create the partner portal, test it and support enhancements to the overall partner enablement program. Lead analyis effort, meeting facilitation and documentation of the online portal.
- Collaborated with UX team to design the partner certification and accreditation experience dashboards for the end users, admin users and champion users.
- Created and tracked user stories, tracked progress and risks to the projects using Rally Agile Central. Performed regression testing using ALM. Created business process flows utilizing Visio.
- Responsible for all partner related work to integrate a newly aquired company, Rally Agile into CA's workstream. This entailed analyzing and documenting their current process, working with stakeholders to redefine the migrated partner program rules, data fields, business process and reporting rules. Creating custom reports in SalesForce to measure their leads from creation to conversion to an opportunity.
Confidential, NY, NY
Project Manager/Business Analyst Consultant
Responsibilities:
- Elicited and maintained requirements from key stakeholders for Confidential new fare payment initiative and mobile ticketing system following the MNR standards and guidelines. Mapped out the reengineering process of the new systems using Visio.
- Worked with First Data, Element and Infinite Peripherals vendors to in corporate their services for use in the iPhone sleds.
- Evaluated and documented mobile system interfaces and integration with back office systems, processes and business rules. Assisted the developer with UI design for new screens, reports and receipts. Utilized JIRA for bug tracking.
- Coordinated with outside vendors to handle credit card key injections, gateway processing of credit cards with Confidential and ensure PCI compliance of each system. Tested back end reconciliation of monies with merchant services and bank.
- Worked with senior level staff to maintain project plan, project status reports, launch plan and facilitate cross functional meetings with high profile executive stakeholders.
- Analyzed, developed and maintained high quality technical documentation, artifacts and templates. Assisted in developing the BA requirement artifact list for their new PMO.
- Created several user training manuals for the training department, quick reference user guides and Admin technical manual for device roll out.
Confidential, Melville, NY
Project Manager/Business Analyst Consultant
Responsibilities:
- In charge of performing both the project management and business analysis for their web portal initiative which creates a seamless user experience for authors, editors and reviewers to various publishing subsystems (peer review, production and hosting interfaces).
- Gather requirements and business rules from high level stakeholders, determine request feasibility, create process flows and document the current systems in Visio. Interact with the web development team to create wireframes and map 12 different system architectures including mobile apps to their Drupal front end software.
- Facilitate meetings with outside vendors, multiple department stakeholders and CIO’s technical team. Responsible for creating and maintaining the PDD(Project Definition Document), project plan and functional requirements document.
Confidential, Stony Brook, NY
Business Systems Analyst
Responsibilities:
- Acted as the liaison between the business and technology groups for the VP Finance and Accounting areas. Focused on managing the deliverables and priorities between the university business units and IT. Kept track, monitored and communicated departmental needs while helping to facilitate the timeliness of requests.
- Gathered requirements and wrote technical and functional specs for both the Accounting and Finance offices. Prepared formal documents and management reports to be understood by both.
- Tested accounting and finance transactions within PeopleSoft financials and SharePoint and traced the accounting transaction flow through the General Ledger module. Implemented and documented new business processes in PeopleSoft and the data warehouse then trained the end-users.
- Other projects I worked on included: the reengineering of the TAP student financial aid system and reconciliation reporting features; drafting and implementing the Red Flags rule policy for the university; creation of the business case and requirements template for the university. Worked with the data warehouse team to facilitate the creation of the Management Balance Sheet and Income Statement Summary reports for senior management.
Confidential, Queens, NY
Independent Consultant
Responsibilities:
- Office Manager in charge of Business Process improvements.
- Planning and management of work orders, customers and employees.
- Heavy vendor relations to negotiate equipment pricing and leases.
- In charge of all business banking related to business finances, leases and credit card merchant services.
Confidential, NY, NY
Business Analyst Consultant
Responsibilities:
- Evaluated the data requirements of both Confidential and HIP’s systems to determine what new business processes and data feeds would be required when the systems were transitioned.
- Performed data mapping of current tables to fields in a proposed data warehouse.
- Wrote the functional and technical specifications that supported the approved business requirements. Tracked the requirements and managed the project plan using SharePoint and MS Project.
- Participated in the business and technical design meetings with both outside carve-out vendors and internal business units.
Confidential, NY, NY
Project Manager/Business Analyst Consultant
Responsibilities:
- Project managed and oversaw from inception to roll out, the migration of 9 Lotus Notes databases to a web-based contract management and document retrieval system.
- Primary contact between various heads of business units and end-users in Business and Legal Affairs to define and gather application requirements for development of new web database. Learned all technical and non-technical aspects of vital and confidential music industry systems. Strong knowledge of how the following systems flow and function: Deal memo, Side Artist, Talent Roster, Royalty Voucher, Tour Short Fall Authorizations and Registered Mail tracking.
- Converted business requirements into functional specifications for small to complex systems. Wrote test plans, user manuals and all related project documentation. Tested all aspects of new application and resolved bugs before deployment.
- Managed and coordinated development and deployment of application with overseas IS&T team members.
- Provided consultation, user training and support services to users.
Confidential, NY, NY
Business Analyst/Project Manager Consultant
Responsibilities:
- Project management of the implementation and data migration to ADP’s Web based Pay eXpert and HR eXpert system.
- Wrote complete documentation and illustrations of payroll system procedures for all users.
- Data mapping, quality assurance testing and validation of all Payroll and HR related data.
- Analyzing current system of reporting and translating the requirements into new HR management reports.
- Providing status reports and documentation of outstanding issues. Escalation of critical issues to meet project deadline.
Confidential, Queens, NY
Business Analyst Consultant
Responsibilities:
- Worked with various banks to secure financing of properties.
- Worked with legal team to prepare necessary paperwork as it relates to property closings and court related documents.
- Implemented software package to track tenants, vendors and maintenance of properties.
- Negotiated with vendors for contract pricing on small construction projects.
Confidential, Hauppauge, NY
Sr. Business Analyst Consultant
Responsibilities:
- Long-term assignment at Confidential to provide business analysis/project management and QA testing of their Disability Income Underwriting and Administrative systems.
- Wrote technical specs to implement system changes and upgrades for all the new Disability Income products and screen enhancements. Wrote documentation to support all system changes. Maintained database reporting of all open implementation issues and tracked their status through post implementation.
- Wrote test plans for both users and programmers to follow for UAT testing. QA testing to insure changes have impacted all necessary systems and screens. Verified that data was uploaded successfully into the system and the information displayed in the appropriate fields. Provided application support and user training after product was implemented.
- Strong interaction with team members and users to identify and fix system defects and to do regression testing to ensure that unintentional changes weren't made to other working areas of the system.
Confidential, Melville, NY
IT Project Leader
Responsibilities:
- Interacted with all levels of users to troubleshoot and resolve errors in the Oracle HR system in a timely, efficient and diplomatic manner.
- Managed the roster of all global employees’ additions and changes to ensure that the parent company’s system accurately mirrored that of the global system.
- Prepared monthly benefit interface file for Canada by modifying COBOL programs in CA-ROSCOE on their MVS platform then FTPing the results back to the local drive for distribution.
- Utilized COGNOS-Impromptu to run various queries and AD Hoc reports against the Oracle HR system as well as provide technical support to non-technical users to assist them in building queries for their AD Hoc reports.
- Scheduled and ran monthly management reports containing highly confidential information for 5 different company divisions utilizing Oracle’s job scheduler.
Confidential, NY, NY
Business Systems Analyst
Responsibilities:
- Work with users to troubleshoot and resolve problems with the system.
- Make modifications to panels and database tables as well as installed patches to the system on an ongoing basis.
- Maintained the security for all users to the CSS Confidential system.
- Write ad hoc reports and queries using SQL, SQR and ReportSmith to access data from the HRIS system.
- Developed an SQR program to load data captured from the Open Enrollment Intranet page to the appropriate database tables.
Confidential, NY, NY
Business Systems Analyst
Responsibilities:
- Met with the officers of various departments to evaluate their current hardware and software systems and outline a plan for their future needs to bring them in compliance with company’s standards.
- Evaluated the technical skills of the users and arrange customized training sessions in Microsoft products as it related to their jobs.
- Trained all levels of employees in new software products and new technologies. Provided presentations, consultations and on-site support as needed as part of Post Implementation phase. Maintained status reports of all post implementation issues.
- Coordinated the migration of over 150 workstations in the Medical and Confidential to Windows NT.
- Upgraded 75 workstations in the Human Resources department from Lotus Notes 4.0 to Lotus Notes 4.5 with the calendar feature.
- Provided group training to all affected employees on the new features.
Systems Analyst
Confidential
Responsibilities:
- The conversion process included the setting up of new company codes.
- Meeting with the various departments to establish the new benefit rules regarding the transferring of employee’s benefits and credited service.
- Verified the data integrity of all migrated fields. Worked on the clean-up of corrupt data in the transfer.
- Responsible for the technical aspects of producing the Employee and Executive Total Compensation Statements. Consulted with department heads as to content, wrote the programmers specs, documented the data sources and calculations. Provided quality assurance of highly sensitive data then coordinated the flow of data to the printing vendor.
- Analyzed the existing manual business processes and systems, wrote the recommendations and presented it to upper management. Developed specs and worked with the programmers to implement changes. Performed manual testing to ensure compliance with the specs.
- Involved in the migration of Benefits mainframe application to a GUI LAN based system. Tested and quality assured the data that was converted. Manually tested various calculations such as pensions and group imputed income to assure system accuracy.