Resume
Senior Business Analyst Senior Business Systems Analyst Project Mgt Philadelphia, PA
SUMMARY:
- A Senior Business Systems Analyst / Technical Project Manager ; offering more than 3 decades of progressive experience in utilizing automated systems to enhance productivity and implement solutions for business concerns, as follows:
- Demonstrating history in the strategic development and planning of future corporate projects, matching client needs and budgets to available products and services and following the projects through to implementation.
- Working with all levels of management regardless their technical expertise; provided them with a level of customer and system detail that they were able to understand, by being a highly effective communicator.
- Successfully managed many technical projects, and teams, often concurrently, from initial planning phases to production implementation while adhering to budget and time constraints.
- Supported projects that have been implemented in Main Frame, Client Server, & Web Based production environments.
- Responsible for creating additional revenue streams with the introduction of new technical products and system upgrades.
- Seeking to continue my career where by my expertise will enable an organization to achieve and surpass its objectives.
TECHNICAL SKILLS:
- following are products & Methodologies that I have worked with & supported over my 30 plus year IT career. I would be considered an expert on all of the methodologies and most of the products:
- Sybase / Power Designer, MS Word, MS PowerPoint, MS Excel, MS Visio, MS Project, PMP, Lotus Notes, Wireframes, SDLC,
- MS Office, MS Outlook, MS Access, MS SQL , JCL, DOS, COBOL, UNIX, Use Cases, Data Modeling, TOAD
- UML, Java, COBOL, SDLC, Oracle, HP Quality Center, Adobe Designer, Agile, Waterfall, Planview, DOORS, Crystal Reports, SharePoint, Microsoft Office 365
PROFESSIONAL EXPERIENCE:
Confidential, Philadelphia, Pa
Senior Business Analyst/ Senior Business Systems Analyst/ Project Mgt
Responsibilities:
- Writing functional specifications for multiple managed care organizations ( Confidential ) that allowed these Centers for Medicaid and Medicare (CMM) providers the ability to offer their members additional medical and behavioral health services working in a waterfall environment.
- Creating extract, transform and load (ETL) mapping and procedures that allowed credentialing data & images associated with government providers at Confidential ‘s, to be migrated from their current databases to the Confidential Credentialing database’s platform.
- Writing the business requirements that would support the Confidential Community Care Management teams and the Community Health Navigator teams out in the field, providing them the ability to access member’s forms and medical history, using wireless devices.
- Creating numerous Visio and PowerPoint presentations that allowed those who were not as technically inclined to understand the process that would be implemented when new functionality in support of their teams or companies was being introduced.
- Working with vendors to establish database tables, define data elements and create multiple occurrences from historical files in support of the migration of health care provider’s credentialing information.
- Doing data analysis on the Confidential whose data was being migrated to AmeriHealth’s database, allowed me to implement numerous business rules that corrected and standardized the input data elements, so they met AmeriHealth’s data definition requirements.
- Working with the claims department, provided detailed process flows that were then used to help streamline the adjudication process
- Involved with writing the project plan for the migration of credentialing data from Prestige Health to AmeriHealth, which included hosting meetings, defining time lines and project’s scope.
- Creating User Stories to support the implementation of backlogged system requests while working in an agile environment.
Confidential, Princeton, NJ
Senior Business Analyst/ project Manager (Consultant)
Responsibilities:
- Utilizing both Microsoft MSBI and an internal Business Intelligence tool, EDM; I performed data analytics in support of both internal and external teams to support them in the creation of both standard and ad - hoc reports. I defined the ETL processes that would retrieve the data from multiple databases and this data would be used to create detailed reports. These reports would be utilized by teams such as R&D, Finance, and external users and could be downloaded to mobile devices. These reports allowed users to work more efficiently. Working as the business liaison in support of the High School diploma equivalency ( Confidential ) product. I would elicit information from the business, which I translated into business and technical specifications. These requirements would add new functionality, improve existing processes, reduce costs, and improve customer satisfaction.
- I created a use case test form to support the Confidential product, which would be adopted by other areas within ETS to support their QA processes, I introduced use of error codes, which allowed production support to quickly identify system problems.
- Created a data dictionary that defined educational products, acronyms and IT definitions that would be used throughout ETS.
- Worked with multiple teams in an Agile Environment writing user stories in creating a reporting data warehouse. These standardized and As-Hoc reports would use the system’s infrastructure to access other databases. The reports could be download in different formats to multiple wireless and wire-line devices.
- Using wireframe tools I helped create a secured web portal whose design was based on feedback, that came from user focus groups that I had arranged meetings with.
- Using both Visio & Power Designer, created business process models that showed system processing at both high and detailed levels,
- Worked with the finance team to create and update numerous reports, which would be used to capture revenue, generate bills and credit customers. The analysis of this data uncovered several data inaccuracies in current reporting which were then corrected.
- Worked with finance in allocating collected payments to appropriate state agencies
- Wrote business requirements to support the introduction of Confidential to additional states, working in a waterfall environment.
- Responsible for determining project schedule, estimated costs and overall budget as well as determining associated risks to the project. Would use the PMBOK earned value management formulas to determine how the project was proceeding relating to these estimates,
Confidential
Senior Business Analyst (Consultant)
Responsibilities:
- Providing detailed system flows in addition to detailing internal and external interfaces, databases, and system functionality, the work flows of the multiple departments all of which supported the 3 billion dollars in revenues that were generated annually,
- Meeting with management, vendors and developers to implement new system functionality that would improve system efficiencies reduced costs, and expedite collection of funds in support of the Confidential e-commerce systems. I created business process models detailing the new functionality that supported this e-commerce system. These process flows were done at both a general and detail level, so that they could be understood, regardless the viewers level of Information Technology knowledge.
- Designed a scan sheet that would use the lottery authorization number to calculate winnings, taxes, and an amortization schedule so that the NJ Lottery would purchase an annuity that would cover the winner’s annuity payments over the life span of the payout.
- Providing detail system diagrams that show the network infrastructure, and how the multiple systems interacted with each other.
- Introduced the Software Development Life Cycle (SDLC) methodology to the IT team, which provided them with the definition of what roles and responsibilities should be for each step of the SDLC process. I also provided a listing of what each of the steps would need relating to inputs and expected outputs to successfully move forward with the SDLC process.
- Created a data model that contained the table and data element definitions for the multiple databases supported by the lottery.
Confidential, Trenton, NJ
Senior Business Analyst (Consultant)
Responsibilities:
- Meeting with multiple business units to gather and write functional system requirements that would allow the GuideWire product to be upgraded to a supported version while insuring that the all of the NJM customized code would continue to function correctly. This process was done following standard SDLC methodology best practices.
- Responsible for writing and verifying use case test plans that would be entered and tracked using the HP Quality Center tool. These
- test cases were used to verify requirements I had authored as well as requirements from other business analysts
- Designed a web portal that would support the specs I wrote that would automate the PeopleSoft NJM expense tracking system.
- Wrote the requirements that would allow new customers to sign up and become policy holders.
- Meeting with users to design and implement reports that would follow customer trends in support of the auto insurance product.
Confidential, Philadelphia, PA
Senior Business Technical Analyst / Quality Assurance Analyst (Consultant)
Responsibilities:
- Writing technical specifications in support of a new web based international banking platform that would be run on multiple systems.
- Documented the operations and workflows of each individual department involved in supporting the international banking system.
- Working with overseas international banking operations team; gathered requirements that I used to design and implement web portals and interfaces that would take SWIFT transactions and distribute monetary and customer information across a distributed network.
- Wrote requirements that would support the e - commerce activity that was generated when multi-million dollar credit lines were established between domestic and overseas manufacturers, and Confidential . This included taking payments and allocating them to the appropriate note holders. These requirements followed traditional SDLC methodology while working in a waterfall environment.
- Writing and verifying test plans in support of the TradeWorks product as well as supporting regression testing.
Confidential, Collegeville, PA
Senior Business & QA Analyst (Consultant)
Responsibilities:
- Writing technical functional specifications in support of data migration from excel spreadsheets to a newly created Oracle database. Wrote 132 page specification detailing all data migration from excel worksheets to the new database.
- Designed a detailed test plan used to verify the accuracy of the data migration as well as ensuring the reports validity.
Confidential, Princeton, NJ
Senior Business Analyst / Project Manager (Consultant)
Responsibilities:
- Wrote the business and functional specifications for the upgraded Advanced Placement (AP) testing system. The new system would support all AP subjects and the 3 plus million AP exam takers The introduction of this new system allowed the11000 graders at 6 testing centers to meet their grading time goals which had been missed the previous several years, and saving millions in the process.
- Wrote the requirements to support e-commerce systems that would allowed AP exam takers to pay their AP exam fees electronically.
- W rote requirements for a migration from the legacy AP system to the new Advanced Placement system. .
- Working as a project manager for a new English Language proficiency exam, I created the project plan, monitored the budget, and insured that there would not be any scope creep that would prevent this exam from meeting its production date.
- Created test scan sheets for an AP exam that graded the exam and then passed the test details to multiple information systems.
- Designed and implemented the password sign on screen that would be used throughout ETS. Set the password requirement parameters that were implemented for the entire corporation, these were designed to provide as secure a firewall as could be reasonably expected
- Using Visio, I created detailed business process flows that showed how the A.P. system handled both payments and exam scoring.
- Wrote I training manual that I would use to train interns that would be sent out to the grading locations throughout the country
Confidential, Norristown, PA
Senior Business Analyst / Project Manager (Consultant)
Responsibilities:
- Working as both a Project Manager and a business analyst in support of multiple projects. Tasked with identifying impacted systems, defining team members role s, setting time lines, facilitating meetings, identifying and assigning ownership of tasks,\while adhering to budget and time line constraints. Monitoring problems that arose and leading them to a successful resolution.
- Wrote detailed technical specifications, in support of new diagnostic testing being offered to the Quest customer base.
- As the project manager, adhered to Quest s project management methodologies, leading projects that would define which users both internal and external could gain access to which specific diagnostic testing results.
- Designed a disaster recovery plan that had all Quest employees Personal Computer information backed up to a shared network drive.
Confidential, Philadelphia, PA
Senior Business Analyst / Project Manager (Consultant)
Responsibilities:
- Wrote specifications that automated the enrollment process for members, automatically generating their enrollment cards. This process would define the member s specific coverage, prescription plan, as well as vision and dental care.
- Introduced functional requirements format that applied SDLC methodologies for the consolidation of 11 customer information reports being reduced to 2, saving over 1 million in annual printing and processing costs.
- Establishing the mappings for the Electronic Data Interface supporting the 837 Health Care Claims that were government mandated.
- C reated a detailed technical specification of IBC s telephone & computer network that provided readers with an in depth description of the system s components, detailing how these components worked alone and as part of the system.
- Wrote requirements mapping EDI inputs 834 Benefit Enrollments and 835 Health Care Claim Payments to the IBC databases.
Confidential, Middletown, NJ
Senior Business Analyst / Project Manager
Responsibilities:
- Writing technical System Requirements that introduced new functionality in support of the ACTIVIEW System, which supported Verizon’s residential and business customers.
- Project Management responsibilities included identification of systems that were impacted by system upgrades, organizing and facilitating meetings, identifying and assigning ownership of issues that impacted the project. Monitoring these issues until a resolution was reached. Determining risk and allocating resources to support the project.
- Writing detailed test plans to insure that new features and functions worked as intended while verifying that the regression test bed was not negatively impacted by these new system features.
- Designed an interface that notified customers of an orders status by keying upon multiple milestones that were associated with each order. Upon completion of each milestone, notification would be generated and sent to the customer database where the order status was updated accordingly. This reduced order fallout and increased order-posting efficiency.
- Implemented a help desk monitoring system, allowing call center reps to chart, monitor, prioritize & close trouble tickets.
Confidential, Princeton, NJ
Senior IT Analyst / Project Manager
Responsibilities:
- Working with call center managers and representatives, a production solution system was implemented, capturing both the production problem and the solution. When presented with an issue, a call center rep could enter keywords that would display previous issues along with their solutions. This process enabled the call reps to resolve the problem in less than half the time that was previously needed.
- Supervising eight people whose responsibilities included systems analysis, database design, usage processing, updating of service orders, production implementation, and project management.
- Designed a web based e - commerce system that enabled Confidential to capture funds real time. This process also implemented cash disbursements to sales people, while creating general ledger transactions. This also led to a savings in billing and mailing costs.
- Created a process where rejected credit card payments automatically generated an e-mail informing customer of the rejected payment.
- Led a team that evaluated and selected a vendor to provide an oracle database, for all customers billing information. This process entailed gathering, evaluating and prioritizing all internal requirements. The new system had to meet existing product needs, while offering new business opportunities. Once a system was selected; led the data migration effort taking data from Confidential s existing database and migrating it to the new customer database, which would then be used to apply all telecom and Internet charges.