Avp Sr. Business Analyst Resume
Mt Laurel, NJ
SUMMARY:
- IT Professional with 9 plus years of experience in Project/Program management, Cross Functional Team Leadership, Product Analysis, Business Requirement Management, Business Process Improvement, Business Process Modeling, Change Management, Business Development, and IT Application enhancement & Release Management in diverse Business domains
- Proficient in end - to-end requirement planning and implementation in Global Delivery Model covering SOWs, project feasibility, scope management, risk management, activity sequencing, effort & cost estimation, system development & testing quality management in adherence to guidelines
- Experience in consulting with Line of Business, Product Owners, Clients orIT Groups to understand the Business Processes and elicit Business Requirements
- Hands on experience in developing Business Cases, ROI, TCO, Governance and Cost Benefit Analysis
- Rich experience with Project management tools like Microsoft Project, Clarity PPM, Primavera, PlanView in building project schedules, Gantt Charts, performing cost analysis, spend analysis and generating reports.
- Experience in implementing and directing IT Projects with SDLC Waterfall, Agile SCRUM, Kanban, RMLC and PDLC methodologies
- Expertise in applying Agile SCRUM practices or principles to any traditional SDLC Waterfall methodology based IT projects to enhance delivery and provide quality products as the end result
- Expertise using ITIL Framework and ITSM Process Integrations including assessments, architecture, design, planning, implementation and tool roll out
- Extensive experience with developing and management of Business Requirement Documents (BRD, FRD, NFR), Product Backlog, Sprint Backlog, User Stories, Use Case Specifications, System Design Specifications (SDS), System Requirement Specifications (SRS), Business/System Process Flows, Usecases Specifications, RTM across the project deliverables for various IT projects
- Expert in facilitating effective Joint Requirement Planning (JRP / JRS), Joint Application Development (JAD) and Rapid Application Development (RAD) with Business User Groups, Subject Matter Experts, and IT Groups to congregate towards a solution which could be customer/ client acceptable and technically feasible for the developers, also to limit project exposure to the change request
- Experience in extracting and analyzing data from multiple sources and strong skills in Data Analysis, Data Modeling, Data Mapping, and generating meaningful reports to identifying key iteration metrics (KRI / KPI)
- Proficient in supporting Business decision and facilitating business management strategies by generation, aggregation, analysis, and visualization of data using Data Warehousing and Business Intelligence system
- Ability to evaluate user behavior for web Based application by using analytics tools and techniques such as SQL, SAS/SQL, Web Analytics and reporting tools like Adobe
- Experience inClient Management, Stakeholder Management, Vendor management and People Management
- Strong analytical, problem solving, negotiation, facilitation and communication skills, with particular emphasis on detailed business requirements, project management, monitoring variances and generating reports for management
SKILL:
Domains: Banking (Online, Mobile, Corporate, Investment), Wealth, Mortgage, Loan, Credit Card, Mutual Fund, Brokerage, Insurance, Regulatory Compliance and other FinanceProducts & Services
Primary Skills: Project Management, Planning, Requirement planning and analysis, business process modeling & improvement, GAP analysis, ER Diagrams, Process Flows, Swim Lane Diagrams, decision tree, BRD, BRS, SRS, JADS sessions, Product Backlog, Backlog Management, Sprint Planning, User Stories, Grooming Sessions, Use Cases, Test Plans
Methodologies/Model: SDLC, Waterfall, Spiral, Agile SCRUM, Kanban, Product Life Cycle (PLC), PDCL, RMLC, RUP, UML
Processes: Web Based Applications, Online Banking Applications, Mobile Banking Applications, Financial Transaction Services Apps, Credit Cards App, Out of Band Authentication (OOBA), Customer Identity Access Management (CIAM)
Environment: SOA, Web Services (SOAP XML, ReST, API, WSDL)Oracle - CRM, PeopleSoft, Mainframes, TSYS, Teradata, SAP, MSFT Solutions Platforms
Project Management Tools: Microsoft Project 10/ 13, Clarity PPM, PRIMAVERA, PlanView
Process model tools: MS Office suite (incl. Project and Visio), IBM Lotus Notes, JIRA, Confluence Team Viewer 7, IBM Rational DOORS-9.2, Rational Rose, Requisite Pro
Analytics: Abode Web Analytics, Omniture, Tableau, MS POWER BI
Testing /Bug Tracking Tools: Quality Center (HPQC), Front Ranger Solutions-ITSM Service Manager, Load runner, Win runner, JIRA, Test director, Bugzilla
Version Control: MS Visual Studio 2010, SharePoint 2007/ 2010
Databases: Oracle 11g/10g, Sybase, MS SQL server 2005/2008 R2 management studio, MS Access, Microsoft Visual Studio 2010
Quest Software: Toad Data Modeler, Embarcadero Rapid SQL XE2, Advanced query tool, SQL Server Management Studio 2012/2008, Teradata SQL assistant, SQL Server Reporting Services (SSRS)
SQL, t: SQL, PL/SQL, HTML, XML, COBOL, SAS, Java, CSS, ASP.NET, C#, C++
Operating Systems: Windows, Linux, Unix, Mac OS, iOS, Android, MVS/ESA, z/OS
Data modeling/ Warehousing/ ETL: ER Diagrams, Erwin, Conceptual, Logical & physical modeling, Teradata, OLTP, OLAP, Dimension Models, Star Schemas, Type I, Type II, Slowly Changing Dimensions (SCD), Data Mart, Datastage, FACT and Dimensions Tables, Physical and Logical Data Modeling
Other: Humming bird, Attachmate Extra, TN3270
PROFESSIONAL EXPERIENCE:
Confidential, Mt. Laurel, NJ
AVP Sr. Business Analyst
Responsibilities:
- Delivered and managed concurrent projects in cross-functional organizational structure for Confidential N.A.
- Directed and lead large and mid-size multiple Banking enhancement projects in aligning business objectives within multi-channel environment to implement rapid and cost-effective change initiatives
- Supported the Line of Business (LOBs) with the development of Business Case, Project Charter, Scope definition,BRD, MIR, Forecasting & Monitoring, and Estimation (Effort & Cost)
- Managed various enhancement projects by synchronizing with project team such as Business, Control Team (GAML, Risk, Legal, Compliance etc.), BA, BSA, Designers, Technology, Architect, Development, QA, Operations and Release Management
- Performed Risk Analysis to identify the key business risk (KRI) areas for the Business, and prioritized those within the project
- Provided leadership team with tactical and strategic recommendations based on cross-process KPI
- Worked closely with Sr. Product manager or Product Owner to develop and manage Product backlog, User Stories, Sprint Plan, Iteration plan and Sprint Backlog
- Performed and facilitated various Agile scrum ceremonies such as Sprint Planning meeting, Daily scrum meeting, Stand-ups and Sprint review meeting
- Lead the collaborated sessions for prioritizing User Stories, Sprint Planning, and breaking down iterations into manageable tasks and aligning those in the release plan
- Worked as a liaison between technology and the business clients toelicit Business Requirements (BRD), Product Backlog, Epic, Themes, User Stories, Usecases, and Process Flows to improve business processes and support critical business strategies
- Prepared and developed Project plan (PPM), Requirement Management Plan, GAP analysis, WBS, Stakeholder's Analysis, Communication Plan, Risk Management plan, Stakeholder engagement plan, Quality Management Plan, Vendor Management for projects
- Utilized Project management tools in building project schedules, performing cost analysis, spend analysis, and resource allocation
- Excavated several reports to monitor and track the project status, financials, schedule, milestones, work packages, risk and performance and reviewed those reports with the stakeholders to evaluate the project performance
- Performed and managed several project activities such as engaging stakeholders to monitor the project performance, project risk, defining change request procedure and reviewing proof of concept
- Facilitated kick off meetings, product review session, product backlog review, requirement sessions (JRS/BRS), user stories review, GAP analysis walkthroughs, Sprints review, backlog grooming sessions and joint IT (JADs)or development session,
- Supported vendor engagements and provided valuable feedback to mitigate risk and conclude procurement activities to enhance the performance of vendor based solution
- Provided insight and guidance to Business Managers to make effective decisions that improves health and performance of the product portfolio by using analytics tools and reporting
- Created, analyzed and presented reports on web traffic, trends and patterns including revenue, conversion, marketing campaign performance, and product performance
- Generated, analyzed and reported various ad-hoc reports to assist Business in measuring the performance (KPIs) and risk (KRIs) for vender hosted Online and Mobile Banking products
- Guided team in extracting activity based reports for the user behavior, and generated meaningful report to address key areas of improvement for the platform specific product groups
- Created funnel analysis for key online products performance and transformed raw data into visual format and presented at Weekly and monthly recurring analysis meetings to large audiences
- Collaborated with project teams on regular basis to identify the methods of optimizing the organizational processes and recommended guidelines to increase efficiency and decrease the lag time
- Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed
- Worked with IT and Quality Assurance teams to develop Business/System process flows, System Design Specification Document (SDS), Architectural Blueprint (ABP), and Test Strategy for the project also engaged Developers, System Architects, and QAs for various quality assurance activities
- Coordinating with Change Manager and Release Managers to address interdependencies across multiple domains, manage changes to configuration items to maximize business benefit while minimizing risk
Environment: MS Project, MS Access, MS Visio, MS Office, Primavera, Clarity PPM, Windows XP/7//8/10, IBM mainframes, Web Services, API, SOAP, XML, Oracle DB 10/11g, Adobe Web Analytics/ Discover, Omniture, JIRA, Confluence, Business Intelligence (BI), HP Quality Center, SQL, PL/SQL, SAS/SQL, UNIX, LINUX, HTML, MAC OSX, iOS, Android, SharePoint
Confidential, Fairfax, VA
Business Analyst Lead
Responsibilities:
- Work closely with Business Users and SMEs for gathering business requirements,
- Converted Business Requirements and Business objectives to functional specification document, System Requirement Specification (SRS), Business/System Usecases, Business Process flows, System Process flows and System Interaction diagram using UML,
- Facilitate series of requirement review workshop/sessions with business and IT team on discussion of the requirements and designing of the system.
- Analyzed the data requirements of the new system and map data from existing systems to the new system and conducted GAP analysis
- Facilitated and conducted various project team meetings includingstatus meeting, Requirement gathering sessions, and SRS review meetings for Stakeholders and provided daily and weekly status reports,
Environment: MS Project, MS Access, MS Visio, MS Office, PlanView, Primavera, JAVA, XML, SQL, PL/SQL, SAS/SQL, MySQL, SQL Server, Sybase, Oracle DB 10/11g, Windows XP/7//8/10
Confidential, JerseyCity, NJ
Business Analyst Lead
Responsibilities:
- Worked closely with Business users and Project Manager to plan, coordinate and define tasks for the project
- Prepared the Requirement Management Plan to gather business requirements and to aligning the plan with other project deliverables,
- Responsible to gather Business Requirements (BRD) through interviews, surveys, prototyping and observing from business managers and UI (User Interface) of the existing Brokerage Reporting system,
- Developed Business Process flows, Functional Specifications (FRD), System Requirement Spec (SRS) and System Flows to assist the ITor Technology team in understanding business requirements,
- Analyzed business requirements, incorporated development and business objectives, and used the information to develop detailed comprehensive System Design Specs (SDS) and test strategies to verify system changes that met the needs of the client,
- Lead and directed a team to prepare and execute Test Plan, Test Scripts and Test Case Document for User Acceptance Testing (UAT) based on functional and technical specifications,
- Performed UAT’s for different Source Systems to get automated feed followed by Control-M jobs and manual upload where source systems do not exist,
- Performed Business functionality testing, which involved testing of all core functions of the application,
- Executed Regression Tests for each System (FIX OPS, INSPIRE, CAMS) in INTELLIMATCH which deals with Product and Services like Fixed Income, Cash Securities, Mortgages and Whole Loans (MBS,CMBS,RMBS), Listed Derivatives, Equities, OTC, Derivatives, Global Foreign Exchange, Global Money Markets, Options, Asset Servicing, Security Financing etc,
- Allocate Resources for the project as per the Time lines and handle resource and project time lines issues with the senior management.
- Managed and analyzed requirements (business as well as system) in development of GUI, performed GUI Automation Testing using QTP in various development phases for different OS (Linux, UNIX),
- Validated the queries thru Sybase and SQL Server DB’s, run SQL Queries to generate reports on different Key Risk Indicators (KRI) like Nostros, Depots, Asset Servicing, Suspense, Fails, Payables and Receivables,
- SITed PBBD(Prime Brokerage Breaks Database) and performed Load Testing and stress Testing using Load Runner 8.0 on Oracle 11i Repository for Consolidating Balance Sheet Exposure Related Data,
- Conduct weekly meetings with the Project team and to have a weekly status report and prepare an overall QA status report and share it with the Project Manager using HPQC,
- Created and analyzed meaningful reports (using third party reporting system) to support the business in making better decisions, also ran queries on existing data sources to evaluate analytics and analyze trends
- Executed Transaction Level Queries in SAP to Reconcile Sub-Ledger with General Ledger Accounts and address the Breaks of Risk Indicators followed by Sign-Off,
- Lead the overall execution phase as well as end-to-end Testing cycle by coordinating with various focus groups
- Conducted conference call with offshore team to get a daily status to report weekly status report by Publishing the weekly score card,
Environment: OS - Windows 2000, Windows NT, Windows XP, Pl/SQL,Toad, Mercury Suites, HP Quality Center,JIRA, Business Objects XI 3.1 Rich Client and Web Intelligence, SAP, Load Runner, QTP with TML, Java, QATrack Message Que,Oracle 11i, SYBASE.
Confidential, New York, NY
Business Analyst/BSA
Responsibilities:
- Interacted with the Business Users, Technology lead, SME, Operations, Designers, Developers and Project Manager to get a better understanding of the Business Processes and gathered Business Requirements for Personal Client financial Information Systems (PCFIS),
- Lead the team to writing and reviewing Test Plans, creating Test Scripts, Team Co-ordination and Documentation,
- Analyze system requirements and formulate scenarios in Test Director for the Functionality, Navigation, Performance and Security testing of the application,
- Participated in all the phases of SDLC, starting from requirements, design, development, testing and implementation phase,
- Verified the functional aspect as per the Business Process and validated the interfaces with the other systems,
- Performed manual testing of the functionality of the application by inserting varying data on different test runs,
- Executed SQL and PL/SQL queries in oracle database
- Extensively involved in testing the GUI applications
- Submitting weekly status updates and reports showing the progress of Software UAT Testing
- Involved in developing and executing Regression tests using QTP
- Developed and executed the test plans for Functional Testing, regression testing, Integration Testing
- Performed Business functionality testing, which involved testing of all core functions of the application, also organized and executed the User Acceptance testing (UAT)
- A separate Bug tracking process using Quality Center is being used to Track Bugs periodically.
- Worked closely with users and coordinated User Acceptance testing across different projects.
- Performed the Key System Development Life Cycle SDLC/SOX Project Stages to ensure quality of work effort and ability to report on Key milestones
- Reported release summaries to the project team and Business User on the enhancements (Version Updates)
Environment: People Soft,Pl/SQL,Toad, Mercury Suites, HP Quality Center, Business Objects XI 3.1 Rich Client and Web Intelligence, SAP, Load Runner, QTP with TML, Java, QATrack Message Que, JIRA, SQL Server, SYBASE.