Todd W. Lubin

*** ****** **** • Yardley, PA ***67 • 215-***-**** (home) • Cell 215-***-****

• E-Mail Addresses: ac2j2r@r.postjobfree.com OR ac2j2r@r.postjobfree.com

Profile:

A Senior Business 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.

Work Experience:

AMERIHEALTH CARITAS: Philadelphia, Pa. March 2016- Dec 2016

Senior Business Analyst/ Data Analyst / Senior Business Systems Analyst/ Project Mgt (Consultant)

•Writing functional specifications for multiple managed care organizations (MCO) that allowed these Centers for Medicaid and Medicare (CMM) providers the ability to offer their members additional medical and behavioral health services. The creation of both business and technical requirements followed SDLC phases, while working in both waterfall and agile environments.

•Creating extract, transform and load (ETL) mapping and procedures that allowed credentialing data & images associated with government providers at MCO‘s, to be migrated from their current databases to the AmeriHealth Credentialing database’s platform.

•Created business rules that allowed the 3rd party credentialing data to be standardized, refined, or created before the migration to AmeriHealth 3rd party credentialing databases.

•Writing business requirements that supported the AmeriHealth Community Care teams and Community Health Navigator teams who were out in the field supporting members. These teams were provided access to member’s consent forms and medical history, while being able to capture a member’s signature electronically on any new consent forms that were needed. The access to this information was gained through the use of mobile wireless devices.

•Creating Visio and PowerPoint presentations that detailed and explained the new processes and functionality being implemented. These processes flows were used by senior management, internally impacted groups, and external third party organizations to understand the new processes and functions.

•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.

EDUCATIONALTESTING SERVICES: Princeton, NJ Sept 2014 –Nov 2015 Senior Business Analyst/ project Manager (Consultant)

•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 (HiSET) 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 HiSET 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.

•Wrote business requirements to support the introduction of HiSET to additional states, while following standard SDLC practices.

•Responsible for determining project schedule, estimated costs and overall budget as well as determining associated risks to the project.

Todd W. Lubin

Page Two

NEW JERSEY DEPARTMENT OF TREASURY / LOTTERY DIVISION & IT Oct 2012 – Nov 2013 (Privatized)

Senior Business Analyst (Consultant)

•Documenting the multiple systems that are currently in production supporting the NJ Lottery. 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 NJ Lotteries 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.

NEW JERSEY MANUFACTURES PROPERTY & CASUALTY INSURANCE Trenton, NJ Jan 2012 –Sept-2012 Senior Business Analyst (Consultant)

• 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.

WELLS FARGO BANK Philadelphia, PA Feb 2011 – Dec 2011

Senior Technical Business Analyst / Quality Assurance Analyst (Consultant)

• 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 Wells Fargo Bank. 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.

PFIZER PHARMACUTICAL Collegeville PA Nov 2010-Feb 2011

Senior Business & QA Analyst (Consultant)

• 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.

EDUCATIONALTESTING SERVICES: Princeton, NJ Jan 2007 – June 2010

Senior Business Analyst / Project Manager (Consultant)

•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.

•Wrote 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

Todd W. Lubin

Page Three

QUEST DIAGNOSTICS: Norristown, PA May 2006 – Jan 2007

Senior Business Analyst / Project Manager (Consultant)

• 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.

INDEPENDENCE BLUE CROSS: Philadelphia, PA Oct 2004- May 2006

Senior Business Analyst / Project Manager (Consultant)

• 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.

• Created 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.

LUCENT TECHNOLOGIES, Middletown, NJ Aug 2000 – Dec 2002

Senior Business Analyst / Project Manager

•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.

RCN Corporation, Princeton, NJ Jan 1999 - Aug 2000

Senior IT Analyst / Project Manager

•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 RCN 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 RCN’s existing database and migrating it to the new customer database, which would then be used to apply all telecom and Internet charges.

AT&T, Network Implementation Systems, Somerset, NJ July 1998 - Jan 1999

Senior Business Analyst

• Writing technical specification documents for Advanced Feature Telecommunications products.

• Taking the lead project manager role in implementing Advanced 800 services for AT&T Canada. Duties included bringing all vested

participants to the table, setting schedules, timelines, and production dates, while adhering to the time lines using MS Project

• Integrating AT&T Canada’s database and usage into the AT&T domestic database within prescribed time frame. Designing the service

orders used to support the Canadian usage, and incorporating the service order functionality into the processing, rating and billing of

this residential and commercial usage.

• Implemented the specification methodology that would be used to produce both detailed system requirements as well as

Graphical User Interface specifications to support the product.

Todd W. Lubin

Page Four

AT&T, New & Emerging Billing Systems, Somerset, NJ Jan 1995 - July 1998

Senior Business Systems Analyst/ Project Manager

• Supervising a group of employees and consultants in the design and implementation of the new and emerging billing system. This product

was set up to support multiple AT&T products, bundle them together and present the user with a single bill. Included in this bundling

projects were wireless and wire line communications, cable and internet service.

•This system was set up to be an object-oriented, client-server based processing & billing system. This design was implemented with the

objective of being fast, flexible, and inexpensive. This System was created allowing service orders to support new products and services

within 60 days of them being requested by product management. Within this 60 day window, the system would be ready to process, rate,

and bill the new services within the bundled bill.

• Was involved in creating relational databases, that would have allow a single customer to order Wire-line & Wireless service as well as cable and internet products. The centralized database provided the ability to have a customer only register once no matter how or when they ordered each service.

AT&T, 800 INBOUND & Outbound Billing Systems, E.B. NJ Feb 1989- Jan 1995

Senior Business Systems Analyst

•Writing technical specifications for business telecommunication products; documenting services and domestic and

international message recording. Incorporating service order information into the message database, so the proper recurring and one time charges would be applied accurately .for commercial and residential customer.

•Leading the team that would implement the advanced feature products to be offered by AT&T. Wrote the technical specifications for advanced feature products such as ICP, ADR, RNA, PACR, Courtesy Response, Call Prompter, and Network Queuing. .

•Managing a team of system engineers that was tasked with supporting new 800 services along with upgrades to existing services. Led

the team through spec and testing reviews to insure that the functionality being added to the system, met the needs of internal AT&T teams as well as external AT&T customers.

•Designing and implementing a rating platform to support 9 unique 800 services. This system would be responsible for applying the correct rates to almost 11 billion message records a month.

•Set up interfaces with AT&T’s state and national tax departments to insure that new taxes would be applied by the tax effective date.

•Migrated multiple 800 services from other systems within AT&T’ to the 800 Inbound WEFOS system.

•Would represent the team as the SME for numerous JAD sessions.

•Managing multiple projects, allocating both human and budget resources to meet customer and system release deadlines

• Designed and implemented an automated quality assurance process that generated test cases with verifiable results. .

•Wrote and verified interface agreements for AT&T to use with the RBOCs and Bell Core.

Automatic Data Processing & National Cash Register, Dayton & Cherry Hill, NJ Jan 1983 – Feb 1989

Business Systems Conversion Analyst

• Successfully took all financial products offered by a financial institution that included mortgages & PMI, installment loans, savings accounts,

individual wealth management accounts along with general ledger information for 38 Savings & Loans, Commercial Banks and Credit

Unions, from their current system processor to either the NCR or ADP processing system. This process entailed the ETL mapping of all

data elements and defining the functionality associated with each of the individual products offered by the financial institution so that these 0

products would continue to process on the new system just as they did on their previous processing system.

Education:

Rutgers University, BA in Business Administration

Bucks County Community College, Multiple Computer Science Programming Courses

AT&T Sponsored Courses:

• Client Server • Object Oriented • Oracle • UNIX • Oracle Database Management • System Analysis Courses

• Software Defined Life Cycle (my group was one of the betas associated with the creation of the SDLC methodology)

Software Skills & Methodologies:

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 have used all of the following products throughout my career:

Sybase / Power Designer, MS Word, MS PowerPoint, MS Excel, MS Visio, MS Project, PMP, CRM, Lotus Notes, Wireframes, Mainframes, 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

Awards • Have received numerous awards from muliple employers: i have been recognized for:

innovative system solutions; CUSTOMER service & Improving production support

• articles published in industry periodicals

References will be furnished upon request.

Contact this candidate