SUMMARY:

• Senior business analyst with over 10 years of experience and with over 20 years of experience as a technical/programmer analyst servicing a variety of industries including the financial, insurance, publishing and media companies.
• Participated in software development life cycle, writing SOW’s, business requirements, KPI’s, burn charts and project planning and timelines, along with writing business, functional and technical design documents for development, enhancements, implementations and conversions using both agile and waterfall methodologies.
• Strong interpersonal skills and am very capable to setup and facilitate meetings with executive management, as well as working with development teams to go over technical requirements.

SKILL:

• Agile
• Waterfall
• SDLC
• ARIS BPMN 2.0
• JIRA
• MS SQL
• Oracle
• TFS/VSTS
• SharePoint
• PEP+
• Actimize
• Rational Rose Data Modeling
• M, ST & RM
• TSYS Credit Card System nCino
• MS Project
• Amazon Web Services (AWS)
• Team Foundation Server (TFS)
• HP ALM
• Informatica
• TSYS
• Visio
• Policy & Procedure Manager (PPM)
• ServiceNow
• Salesforce
• Business Requirement gathering (BRD)
• Functional Requirement gathering (FRD)

EXPERIENCE:

Confidential

Business Analyst/Project Manager (Consultant)

Responsibilities:

• Worked with Product Owners and customers to write use cases, user stories and features using CA’s Rally based on business requirements and Statement of work (SOW).
• Went to grooming sessions and daily standups for mu projects.
• Wrote business requirement documents for our external and internal customers.

Confidential

Business Analyst (Consultant)

Responsibilities:

• Created user stories, Epic’s and Feature themes in VSTS and TFS for a project to automate the archiving process in a new audit system.
• Worked with Product Owners and SME’s to write use cases, work on backlog grooming and sprint planning.
• Wrote SQL queries to verify screens updated databases correctly and get test data.
• Was the scrum master on my team and ran the daily stand ups, worked with QA’s and PO’s to prioritize defects, bugs and create user stories when a deficiency is found.

Confidential

Business Analyst (Consultant)

Responsibilities:

• Created business requirements and functional design documents for the development of a client server - based GUI interface to a HP Tandem NonStop mainframe. Developed business requirements and user stories, epics, use cases and test cases using MS TFS, SharePoint and MS Project.
• Worked with developers and the business group to develop the GUI interface to read trade information from a NonStop SQL table and then matching the information to data stored in three windows SQL tables and then displaying the information to the users, so they could modify if necessary and data and then send the trades to Euroclear or Citi for clearing, depending on what type of trade was being processed.
• Also work on Clearance processing, Corporate Actions, Trade Clearance and Reorg enhancements.
• Wrote SQL queries to get test data, as well as verify programs were updating tables correctly.
• Worked with business units to perform user acceptance testing (UAT) for Corporate Actions updates, DTC enhancements, as well as for testing Bank of New York rollout.

Confidential

Business Analyst/ Project Manager (Consultant)

Responsibilities:

• Production support of Fidelity mainframe applications RM, IMPACS, ST and HX, including adding new fields to IM in support of new federal regulations and adding fields to IM1A and IM2A for Know Your Customer (KYC) changes.
• Worked on converting the bank from RM to CIF and IM, ST and SM to Accenture’s Alnova mainframe Core Banking system.
• While also working as a Business Analyst on large projects and as a Project Manager for small to medium projects writing Statement of Work (SOW), Business Requirements (BRD), Functional Requirements (FRD) Technical Requirements.
• Worked with inhouse developers and 3rd party vendor to create an interface to Amazon’s AWS to store customers loan data in Oracle tables.
• Working with the banks card processor, we worked on a project to create a new Point of Sale (POS) system for the banks Merchant Services group that would allow our clients to use almost any card reader on the market to swipe their customers credit and debit cards.
• Create epics, story boards, use cases and doing daily stand ups with our digital banking partners to enhance customers online banking experience updating the banks website and mobile app.
• Worked on a project to add two new credit cards, one for consumers and another for commercial bank clients, also worked on two projects to add feed from TSYS into the bank’s core banking system and another to add new VIP codes into the TSYS system.
• Worked on projects to enhance Alnova’s core deposit system and upgrade PEP+ systems to a newer version using both agile and waterfall methodologies. Ran SQL queries to gather test data for UAT testers and ran queries to verify loan information displayed on screens used the correct calculations.
• For all projects we held weekly or bi-weekly project meetings with product owners to update them on what was happening with their projects and get any feedback or new requirements, if any and iron out any issues that might have arisen, as well as running functional design meetings to work out any issues and to make sure the technical team(s) understood the project goal and the technical requirements and once the technical requirements were completed, we then worked on creating and finalizing the System and Technical document that spelled out the actions needed by each technical group or individual. Updated our time and project milestones in PPM.
• Worked on an agile project to in corporate nCino into the banks Small Business Associations (SBA)lending process, which included setting up an interface between nCino's cloud solution on the banks server-based loan processing system to move loan documents between the two systems, we held daily stand ups and wrote stories, use cases. We also trained the banks Loan Operations group on how to use nCino and on integrating the nCino product into their loan process flow.
• Worked on a project to install Actimize RCM on a bank server and then setup a interface to the banks Collections system to detect fraudulent payments.
• Converted SmartyPig from West bank to Confidential Compass, in this project I was the lean BA, test co-coordinator and under this role I worked with SmartyPig to create an interface with their SQL DB to BBVA’s RM system and helped SmartyPig to develop a NACHA ACH formatted file to go into the banks PEP+ system. Then worked to develop a MQ channels to move the SmartyPig transactions from a the banks Sterling system to the mainframe using Websphere MQ and Java app to read the flat file using JMS binding and put the transaction on a MQ remote queue and then the mainframe Cobol app wrote the transactions to another remote queue and a listener picked them up from there and wrote them to the banks EPE DB. During phase 2 of the project, I worked on developing a transactional file to go into the banks 2 main fraud detection systems MANTAS and Actimize to detect electronic check fraud and wire fraud.
• Did several projects working with Salesforce, one was integrating Salesforce with the banks BI system to give Financial Advisors (FA) real-time customer information and to let managers get information on how well FA’s are performing. Another project we added the banks customer VIP indicators into Salesforce to allow FA’s to know if a customer is a commercial, Wealth Management or retail VIP customer. At the same time worked on adding new fields and new extract files from the banks data repository databases, including standing up new silo’s and upgrading databases to add more keys.

Confidential

Technical Analyst (Consultant)

Responsibilities:

• Modified IM41to read a file for a new called program that read BCC transactions and created a report on those that had ODP protection.
• Designed several programs to interface IMPACS with XAD database, to add or modify records on the Multiple Price Fee Table, Rate table, PTMF, Lookup and Service charge tables.
• Designed programs to also merge the changes in to production after they have been quality tested and designed new initialization copybooks, files and PARMLIB’s.
• Wrote functional program specifications, uses cases and technical documentation for all programs in my area of responsibility that were going off shore for coding, including new programs and those with modifications to IM41, IM31 and IMSA41.
• Used FOCUS to create PDF reports on Table data and verified that the programs were creating the correct table data.

Confidential

Technical Analyst (Consultant)

Responsibilities:

• Performed impact analysis; identifying over 1,800 batch and online programs requiring modifications.
• Developed technical specifications, conversion programs, program remediation and served as the lead for joint application remediation.
• As a senior technical analyst, ensured data integrity for DB2 tables, GDG and VSAM files by reviewing code modifications developed by both ‘off-shore’ and ‘on-shore’ programmers.
• Wrote program specifications and helped write testing procedures and use cases for regression and acceptance testing

Confidential

Technical Analyst/ Data Modeler (Consultant)

Responsibilities:

• Created online and batch data models for the conversion from a mainframe based system to a client-server based system using Rational Rose from VSAM file structures.
• Designed and developed several COBOL programs that converted the mainframe copybooks and TSQ tables to the new Oracle database format. Analyzed master files and tables to identify invalid data; developed mass maintenance programs that cleansed the corrupted data.
• Designed and developed batch interface and CICS programs adding additional complexity to ensure data integrity.
• Created several GUI interfaces using Visual Basic 6.