SUMMARY

• A Business Analyst with over 7+ years of experience in the field of Finance Industry, Mortgage Industry, Insurance Sector, Retail Banking, Investment Banking etc.
• Working knowledge in writingSQL queryfor identifying databases involved in the application development.
• Has experience as ServiceNow Business analyst in Support, Implementation and Enhancement Of ITSM modules.
• Development, implementation and integration team member of debit and credit cards generation solutions department (Software and Hardware) for different banks.
• Experience in AML tools such as Actimize and related topics knowledge and understanding of fixed - income trading, asset management and portfolio management applications
• Proficient in developing and executing Test Procedures, Test Cases, Test Scripts, Test Plans, performing Functional Testing, GUI Testing, Usability Testing, and Ensuring that the software compliance with the system requirements
• Understanding of Financial Statements, Cash Flows, Financing Structures, Capital Management, Portfolio Analysis, Stock Valuation, Bond Pricing, Budgeting, Asset Management - Risks and Returns, Optimizing Cash Flows, Cash Management and enhancing Liquidity Management.
• Hands on experience with integration record mirroring between two separate ServiceNow instances Working Knowledge and hands on experience with ServiceNow Process flows across the organization.
• Extensive experience in Finance industry, Credit Card, Investment Banking (GL, Personal Accounts, Check payment, ATM, Fraud - AML) and Mortgage industries.
• Adept with differentSDLCmethodologies-Waterfall, Rapid Application Development RAD, Rational Unified Process RUPandAgile SCRUM.
• Has experience in Software Testing Life Cycle in domains like Debit Card Management system, Debit Card Reconciliation system etc.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration into the CI System Knowledge Data Base in Microsoft Share Point.

TECHNICAL SKILLS

Project Methodologies: Waterfall, Agile

Business Modeling Tools: MS Visio, Rational Clear Case, JIRA

Defect Tracking Tools: Rational Clear Quest, Quality Centre

Languages: SQL, HTML, XML, Java

Business Applications: MS Access, Excel, Word, Outlook, PowerPoint, Visio and SharePoint

Operating Systems: Windows, UNIX/Linux

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, Pennsylvania

ServiceNow Business Analyst

Responsibilities:

• Responsible forcontent managementusing SharePoint to alleviate project's features usedSQLEditor to query databases to extract records per customer request
• Analyze, Review & propose enhancements for Web Creative deliverables, ensuring adaptability of the UI to CBOL guidelines, identify potential fraud scenarios & traceability back to Requirements.
• Developed BO reports to present the data broken down by the countries regulatory office and to highlight any suspicious activity that needs to be acted upon to prevent money laundering (AML) and fraud.
• Involved in Implementation, Customization and Maintenance of ITIL modules such as Incident, Change, Problem, Knowledge, Service Catalog, CMDB, Reporting and Integrations in ServiceNow.
• Conducted Several Requirement gathering sessions with Business Users to obtain the requirements needed to frame the Business Rules for attribute in the Retail Schedule
• Worked on Domain - Payment System (Visa/Master card/Amex/CUP/Diners/JCB), POS/EMV, Credit Card, Debit Card, School Education management systems, Banking (Prime/Online-Card & Merchant, Fraud Guard, Case Management & Dispute Management) & Content Management.
• Participated inData Mapping,Data Conversion, creation of theData modeland usedSQLandToadtoextract, filter and validate data and performedSale, return transactionsby using Credit card, Debit Card etc.
• Conducted Meetings and interview sessions with Business users and Subject Matter Experts to discuss the FAQs and the impact it had on the Business Rules of the Attributes in the Schedule Retail, Wholesale and Retail Other
• Worked with complex integrations within the ITSM environment such as ServiceNow - Web service integration with third party application (CSC, IBM and CGI ) and migration of legacy tools like SM7 and Standard life geographically separated business partners.
• Proficient with Microsoft Excel, Microsoft Access and understanding of Structured Query Language (SQL)
• Facilitated business user sessions on requirement analysis, data analysis, and data modelling sessions for the system development and utilized Microsoft Team Foundation Server TFS to manage the team's software development lifecycle including deriving product backlog items, assigning sprint work items to developers and conducting sprint review meetings
• Closely interacted with designers and software developers to help them understand application functionality and navigational flow, by creating MS PowerPoint presentations and Wireframes.
• Gathered requirements for solutions in the servicenow platform that are ITIL compliant and defined business solutions for ITIL users, creating and modifying Service Catalogs and Request Workflow Designs, Designing the Content Management System which involved CSS and service catalog work.
• Handled Tableau admin activities granting access, managing extracts and Installations. Generated tableau dashboards for sales with forecast and reference lines.
• Test execution and co-ordination with vendor FDR on a daily basis to validate all types of Debit card transactions and ATM transactions. Including withdraw, Purchase, Deposit and Reversal.
• Experience of taking ownership for core ServiceNow module delivery with minimal management support Document existing processes and tools to assess gaps against the global solution prior to the ServiceNow roll out.
• In - depth working knowledge of SDLC methodologies including Agile/Scrum/Kanban, and Waterfall.
• Review alerts to detect fraudulent activities for internal accounts to identify potential suspicious transactions to investigate fraud claims and to ensure in compliance with Regulation E with in the the timeframe that govern disputed transactions
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Tested different transactions by using Credit card, Debit Card, Gift Card, and Cash transactions on POS and MPOS devices
• Involved in developing, testing, and writing programs and reports in SAS according to specifications as required.

Confidential, Buffalo, New York

Business Analyst

Responsibilities:

• Responsible for importing, manipulating and generating weekly and monthly list reports using SAS Enterprise Guide
• Set up Server based data sources and Mentored business power users to create reports/dashboards using tableau desktop.
• Accommodate work volumes to enhanced customer satisfaction. Understand charge - offs involving fraudulent activity and provide resolution to prevent future cases Investigate the fraud alerts to protect the institution from fraud related losses and improve customer experience on all.
• Manage Microsoft Project Server to store project information in a central SQL Server database, protect from unauthorized access and corruption
• Involved in the analysis of the existing creditcardprocessing system, mapping phase according to functionality and data conversion procedure.
• Act as a liaison between business users and IT project team on ServiceNow Enhancement projects and implementations.
• Prepared user stories documentation in JIRA for Agile projects, documented requirements for the development and data migration epic to convert customer data to oracle instance with upgrades.
• Performed data analysis by accessing the data using queries or reporting tools, including mapping the business functions to the data and data model, data reconciliations, gap analysis.
• Worked in mainframe environment and used SQL to query various reporting databases
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Worked very closely with ITSM Process Architect, customer personnel, Business Analysts, IT Architect, IT support teams and other technical teams to ensure that business needs around implementation of ITSM processes and ServiceNow are in a controlled and predictive manner.
• Designed, developed and tested Intents and Action classes for the Device Payment Collection flow for New Credit/Debit cards and saved Credit/Debit cards.
• Worked on Data Analysis/Profiling, Data Traceability, Metadata Management, and Data Compliance
• Imported raw data files in excel format in SAS and subsequently created SAS datasets and performed data cleaning and data manipulations for further analysis and reporting
• Involved in all phases of the company new Mortgage Origination system: Encompass and new line of mortgage product projects
• UsedRUP and SDLC methodology and managed the iterative cycles through an TEMPeffective project plan created using MS Project.
• Responsible for on-going enhancement and maintenance of the ServiceNow platform.
• Worked with data flow diagrams, data analysis, and Process flow diagrams. Performed extensive requirement analysis including data analysis and gap analysis
• Defining the end-to-end technical architecture for an entire pre-paid debit card processor back-end including detailed technical architecture for all required processes, services, components, and infrastructure
• Created different graphs and charts such as Pie Chart, Bar Chart, etc using Ms Excel and also created reporting presentation using Ms PowerPoint.
• Gathering requirements from stakeholders, slotting stories in ServiceNow SDLC SCRUM module and monthly releases.
• Allowed the User Stories under Agile - Scrum methodology into the Sprint based on team velocity and individual capacity.
• Interacted with various members at the management level to understand business decision and analysis needs in order to generate appropriate and relevant data analysis reports
• Documentedfunctional specificationsto automate theloan approval processforhome Mortgageonline application, workflow - for the credit department, upon approval the system routes the application to the underwriters for review
• Gathered business requirementsthrough interviews, surveys, and observing from account managers and UI User Interface of the existingBrokerage Portal system
• Demonstrated strong MS Excel skills in order to facilitate consolidation and analysis of financial and/or other data
• Develop solutions to ensure information relating to ServiceNow is kept current, applicable and available through efficient use of Intranet and SharePoint sites.
• Managing system configurations, gathering and documenting user and process requirements, developing workflow customizations, and performing quality assurance testing, user acceptance testing and third party integration for ServiceNow platform.
• Uncovered vulnerabilities through SQL Queries by advancing Python scripts across SQL views of customer Data.
• Assisted Management in construction of short term and long-term plans with associated benefits of strategies that were developed to reduce fraud exposure while working TEMPeffectively across the organization to maximize company resources
• Participated in data modelling, data analysis and requirement documentation.
• Worked closely with business power users to create reports/dashboards using tableau desktop.

Confidential, Cleveland, OH

Business Analyst

Responsibilities:

• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.
• Planed stories for sprint work in agile methodology. Developed user stories and to be process flows to support design and development of salesforce solutions for the users.
• Developed thorough understanding of the working of theprime brokerage, margin, clearing and settlement divisionsand conductedknowledge transfer sessionsKT for different project users
• Managed requirement activities using an iterative and incremental methodology such as Agile usingUser storiesandAcceptance Criteria.
• Documentedfunctional specificationsto automate theloan approval processforhome Mortgageonline application, workflow - for the credit department, upon approval the system routes the application to the underwriters for review
• Create and assess mortgage process models for the purposes of creating common understanding and uncovering process issues. Conduct analysis on fixing and enhancing the process issues.
• Responsible for gathering and prioritizing requirements, working with the development team on the delivery of functionality, to confirming that the end result meets the specified requirements.
• Performed Excel Spreadsheet modeling, including building discounted free cash flow models, net-asset-value models, and other financial models for the current and potential production projects in the company
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology.
• Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Prepared web statistical presentation to the Lead Executives for their strategic planning for Online Digital Channel. UsedAdobe InDesignfor preparing brochures for seasonal promotional discounted interest rates of mortgage.
• Identify business logic and prepareBusiness Process Modellingdiagrams,Use Case Scenarios, Use Case Storiesand describe the requirements with relevantUML Diagrams.
• Responsible for generating various reports for business users usingExcel and MS SQL Server.
• Developed scrum reports and artifacts to include user stories, velocity charts, burn down charts and sprint retrospective notes
• Prepared UML Diagrams like Activity Diagrams,Sequence Diagramsfor the requirements, also preparedBusiness Process Modelfor the complete Online Mortgage Application Processing System.
• Implemented a suitable Change Management processand supported the existing banking solution upgrade by coordinating multiple projects

Confidential, Atlanta, GA

Business Analyst

Responsibilities:

• Used MS Excel and MS Word to create a field-to-field data map that was used as a main specification document for the conversion program.
• Worked diligently on many Global Banking Global Markets Compliance, Credit Risk and Operational Risk initiatives, gathered requirements and developed BRD, FRD, and BPM documents.
• Used SQL queries for data validation retrieving the date from the back end.
• Worked with Mortgage Loan selling personnel to executers, loan processors, underwriters and accountants to understand the process flow, interacted with risk analysts to understand the risk measures involved like PD, LGD, LTV, and LTI.
• Used Oracle Financial Analytics for accessing the information of AR, AP, General ledger, Profitability and produced Cost/Benefit Analysis to support proposed changes.
• Coordinated and led the development efforts of client reporting infrastructure, creating the methodologies, procedures for Client Reporting Infrastructure and common components for successful teamed development.
• SQL's Database Diagram used to create Table Relationships, and testing of Table Relationship was performed to validate Referential Integrity
• Liaised with operation managers, operation staff, and business analysts to coordinate and establish firm-wide efforts, deliverables, and milestones.
• Extensively used MS Excel for functions and formulae for performance check and reported to PM.
• Performed requirements modelling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Innovated and help created Tickler Spread sheet to track Client Reporting on Financial Ratios, Wealth Management, portfolio management, trade automation, compliance monitoring, data aggregation, performance measurement and client reporting.