SUMMARY:

• 8 years of Industry experience as a Senior Business Analyst and Scrum Master with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Experience in conducting Gap Analysis, created data flows and Power Point presentations for the Web Applications Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Strong understanding of Software development life cycle (SDLC) methodologies including RUP, RAD, Waterfall and Agile.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Extensive knowledge on artifacts creation such as BRD, FSD, SRS, DRD, RTM and generated AdHoc reports as per the business needs using SQL queries. is (Business and technical impacts) and organizing the software requirements in a structured way using Rational Requisite Pro to track development.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Experience in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence)
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D)
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Involved in Salesforce.com application setup activities and customized the apps to match the functional needs of the organization. Implemented SalesForce.com platform and Force.com IDE Plug - in using Eclipse
• Experience in the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using Informatica Power Center.
• Developed Monthly, Daily, Quarterly, Yearly Reports in Power BI.
• Worked on R-Script Editor in Power bi for advance statistical analysis using R-Programming. have provided several assistances in the following ITSM process areas on ServiceNow such as Incident, Change, Problem, Request Fulfillment, Service Catalog, Knowledge Management, Automated Test Framework, Configuration management
• Extensive experience in developing Use Cases, creating Screen Mock-ups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Proficiently developed the ETL Informatica Mappings for importing data from ODS into subsequent financial client.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Experience in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project follow the Business Requirements.
• Extensive experience in developing stored procedures, functions, views and triggers and complex queries using T-SQL.
• Used force.com that connects interact Salesforce with lotus notes to insert contacts and add the emails and also integrates the chatter with same time.
• Extensive knowledge of Identity Access Management (IAM)
• Strong Knowledge on Capital Markets, Regulatory Reporting, Investments, Trading platforms
• Experience with COTS (Commercial off-the-shelf) and ERP (Enterprise Resource Planning) that are PeopleSoft and Microsoft Dynamics.
• Worked closely with business users to understand content reporting needs and translated in terms of AEM configuration
• Worked on developing new functionalities/customizations/configurations for Veeva/Salesforce CRM
• Played a key role in the Identity & Access Management (IAM) Information Security group in progressing the company's efforts toward maturing their IAM program
• Hard-core experience involving Business Process Re-Engineering, Software Re-Engineering using RUP methodology and ERP Systems Implementation and Continuous Improvement techniques.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Handling all the domain and technical interaction with application users, analyzing client business processes, documenting business requirements.
• Extensive experience with migrating from AEM Classic to touch interface
• Have strong experience using Informatica and Teradata combination in Enterprise Warehouse environment.
• Facilitated Requirement Gathering sessions, Feasibility Studies and Impact Analysis
• Skilled in using MS office applications for day to day activity, MS Visio for drawing flow diagrams and MS Project for prioritizing and managing individual tasks.
• Experienced in UML modeling, including Use Cases documentation and diagrams, Sequence diagrams and Activity diagrams using tools such as Rational Rose and Microsoft Visio.

TECHNICAL SKILLS:

MS Visio, Mock: Up Screens, Rational Rose

Waterfall, Waterfall Scrum Hybrid, Scrum, Agile: Scrum, Agile

Business Skills: Process Modeling, Change Management, GAP Analysis, Impact AnalysisSWOT Analysis, JAD Sessions, Project Scheduling, Project Budgeting

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Drill Up/Drill Down.

Requirement Management: JIRA, Rally, HP ALM, MS Office, Confluence, ClearQuest

Testing Tools: HQPC, Postman

Reporting/BI Tools: Tableau Desktop, IBM Cognos

Methodology Tools: JIRA, HP ALM, RALLY

Databases: MySQL, Oracle, MS Access

Languages: XML, SQL

Operating Systems: Windows XP/10, Linux, Mac OS

PROFESSIONAL EXPERIENCE:

Confidential - New York, NY

Senior Business Analyst/ Scrum Master

Responsibilities:

• Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS)
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis.
• Strong Knowledge on Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
• Acquired extensive knowledge of financial products, services & terms during day-to-day tasks, such as - Exchange Traded Derivatives (Futures, Options, Single Stock Equities, Commodities & FX Currency)
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
• Conducted UAT to confirm that all derivative products can successfully process during the trade life cycle.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Execution of Run book and gathering various requirements that include Functional Technical System to create the run book.
• Design develops and tests QlikSense scripts to import data from source systems and test QlikView dashboards to meet business requirements.
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
• Worked on Identity Access Management (IAM) and used it effectively in the design and implementation of Sailpoint.
• Work with key business leaders, stakeholder and project teams to integrate their applications into IAM solution.
• Perform requirements gathering, write and manage highly complex requirements for large application development projects on ServiceNow.
• Designed sites and created workflows, alerts, lists, libraries, and structured group permissions in SharePoint.
• Acted as a liaison between the customer and the development team to drive the implementation, translate customer requirements to ITSM processes on ServiceNow platform
• Working with service owners, service team members, project team members, ServiceNow Developers, and the ServiceNow platform team.
• Developed multiple Functional Requirements definition (FRD) documents using the Microsoft standard structure and format (business sections only)
• Executed Stored Procedures in power bi to get the data for more analysis.
• Established Content Packs in Power BI Service for Sharing and collaboration between end-users and developers.
• Developed strategy and architectural direction for the Identity and Access Management (IAM) and related initiatives
• Proficient in Data Migration from Traditional Applications to Salesforce using Import Wizard and Data Loader Utility.
• Worked with External objects in Salesforce which is another feature introduced with Lightening components.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Experienced in API Integration and Single Sign On (SSO) into a Service Oriented Architecture (SOA), web orchestrating service applications through the SSO services.
• Implemented and managed the content management system (Adobe AEM 6.2) and created business requirements/user stories.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.

Environment: Agile-Scrum, Rational Enterprise Suite (Rose, ClearCase, ClearQuest), Github, Visual Basic, MS Project, SQL, SQL Server, Oracle, WebLogic, SailPoint, Salesforce, ServiceNow, Tableau,IAM, AWS, IPFR MS Visio, Services, Dreamweaver, Power BI, Windows Forms, AEM 6.2, Oracle CPQ, Web Forms, ServiceMax, LoadRunner, WinRunner, DOORS, Project Management.

Confidential - New York, NY

Senor Business Analyst/ Scrum Master

Responsibilities:

• Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI..
• Used Agile Software Development process viz. Scrum, as this was a time bound project.
• Performed as assist to the project manager by tracking consultants' travel expenses, document control, scheduling meetings on the systems integration of 2 brokerage systems for the company merger.
• Facilitated JAD sessions with end users, development and QA teams.
• Authored Business Requirements Document BRD with project teams. Extracted, discussed, and refined business requirements from business users and SME's.
• Prepared Use cases and Activity flow diagrams and Work flow diagrams, considering the scope of the project with Microsoft VISIO 2003.
• Assisted in creating wireframes for web interface with the GUI design team.
• Moreover, I also authored functional requirements documents FRD by interacting with development team for improving client's legacy system.
• Conducted status report meetings with the business and the IT team on a weekly basis, as the most important aspect of the project was Data Mapping.
• Executed Stored Procedures in power bi to get the data for more analysis.
• Presented Identity and Access Management (IAM) strategy and direction to management and executives
• Performed the role of Business Analyst, interacted with various business user groups for gathering the requirements for salesforce.com CRM implementation.
• Experience in analyzing organization processes, converting business workflows into Salesforce.com workflows and configuring Salesforce.com to meet business requirements.
• Developed use cases, process diagrams, and requirements documentation using stories and scrum tasks in ServiceNow (Implementation Hub)
• Worked closely with IAM experts to understand and analyze existing Information security standards
• Recognize and identify ServiceNow (SNOW) for gaps in processes or data content reporting results to Service Management team
• Updated and maintained SharePoint site with monthly announcements, calendar, useful documents, and links.
• Involved in analyzing the brokerage reporting needs
• Assisted project managers with the development of project schedules. Developed requirements and preliminary design for client applications. Performed analysis and design projects using a systems development methodology. Worked with all levels of client staff in solution definition.
• Worked on the Power BI reports & dashboards with SQL Server/Tabular SSAS sources Designed, developed, tested a dozen of reports helping customer to analyze data better.
• Reviewed existing IT processes in ServiceNow to identify areas of improvements & enhancements.
• Assisted the development team in preparation of the CRUD Matrix.
• Exposed to SQL queries while churning out relevant information from company's database.
• Assisted in system and user acceptance testing (UAT), free-trial demos, performed client presentations.
• Develop AEM templates and components leveraging current AEM software releases
• Design, develop and support AEM components, integrations and applications
• Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan
• Minimized defects in software application by collecting, reviewing, managing, and monitoring software application defects in JIRA through resolution as reported by various internal and external customers as Defect Manager

Environment: Agile, Advance Plax, Servicenow, Salesforce, GPP, AS/400, ServiceNow, Mainframe/DB2, J2EE, RUP, UML, Use Case diagrams, Microsoft Visio, CloudBees, MS Project, AEM 6.1, IAM, MS Visio, Postman, HP QC, JIRA, Confluence, Tableau, SailPoint, Power BI.

Confidential - Township of Warren, NJ

ERP Business Systems Analyst

Responsibilities:

• Functioned as the primary liaison between the business line, operations and the technical teams throughout the project cycle.
• Utilize critical thinking and dynamic problem-solving skills to design solutions that improve business processes or develop standardized process instructions for enterprise-wide implementation.
• Created Business Requirement Document (BRD) on the basis of information gathered and ensured that it is completed within the defined SLAs.
• Used oracle ERP system to store and access all data to manage CRM, SRM and achieve continuous improvement
• Performed GAP Analysis by understanding the AS-IS business process and the TO-BE business process along with the cost-benefit analysis.
• Functioned as an ERP System subject matter expert and provided functional training for end users in each department and worked with IT to facilitate systems integration between ERP and business needs.
• Selected by management as the ERP Implementation Project Lead for Logistics, Quality, and Security.
• Collected, analyzed and clarified IAM business requirements in collaboration with business clients
• Organized requirements into high-level Use Cases and low-level Use Case Specifications on the Functional Requirement Document (FRD), and prepared Activity and Sequence Diagrams using IBM rational Rose.
• Acted as a process flow person and prepared Business Process Model (BPM) diagrams & Data Flow Diagrams, and engaged in process analysis and mapping by using Ms Visio.
• Created Wireframes and developed prototypes of the Graphical User Interface (GUI) Design; demonstrated them to the stakeholders and business users and took feedback from them.
• Formulated Requirements Traceability Matrix (RTM) document, to track the test cases back to its business requirements & system specifications, ensuring both forward & backward traceability to make sure requirements are met in all phases of project using HP ALM.
• Expert in creating and developing Power BI Dashboards and Reports in to rich look and Stunning Visualizations.
• Involved in pairing/pair programming with the scrum team members to get the work "done".
• Assisted data warehousing team in performing data modeling and data mapping activities like defining data source, data target & data transformation rules to set-up the data load process using Informatica as well as analyzing * designing the data elements.
• Business analysis, project management, testing and UAT management for the data warehouse SSRS and Tableau reporting and analytics portion of the company-wide migration from Great Plains to the ERP system.
• Assisted Quality Assurance (QA) team to develop test plan, test script, test strategies & test scenarios to perform System Integration testing, Regression testing & User Acceptance Testing (UAT).
• Designed the test cases and ran them as well by using HP ALM.
• Create training manuals and conduct enterprise-wide formal training on the ERP system.
• Assisted the QA team in continuous integration as well as automated testing throughout every sprint.
• Conducted all scrum ceremonies.

Environment: Waterfall -Scrum, Oracle, Service-oriented Architecture, JIRA, HPALM, Informatica, IBM Cognos, IBM Rational Rose, BPMN 2.0, Microsoft Visio, Azure, SharePoint 2013, MS Dynamics, Java/J2EE, JSON, Spring, JavaScript, HTTP, XML, Eclipse, Apache Tomcat.

Confidential

Business Analyst

Responsibilities:

• Conducted brainstorming and interviews with business heads to finalize the business requirements.
• Documented requirements and created Project artifacts such as FSD, SRS and RTM.
• Prepared Data Mapping Documents for the reporting documents generated by the system.
• Led requirement elicitation & management, competently upheld business requirements on HP QC.
• Created the mocks and UML diagrams such as Use Cases, Activity, Sequence using MS Visio.
• Performed extensive business process analysis including data analysis and GAP analysis
• Assisted development team in creating prototypes based on requirements specifications.
• Prepared Data Mapping Documents for the reporting documents generated by the system.
• Integrated various OLTP to the OLAP by using Informatica as an ETL tool.
• Schema design in Erwin and implement in database and preparing the technical design document for ETL.
• Gathered requirements for Client-Side Validation, and Server-Side Validation. Gained understanding of three tire and n tire architecture, understanding of request and response flow.
• Worked with QA team in creating a test scenario, test cases, test steps. Involved in software integration testing, regression testing, UAT testing and web services API testing using SOAP UI.
• Prepared UAT test document and developed Test Scenarios for validating the Business requirements and Uploaded Test scenarios, mapped Business requirements to Test scenarios and updated defects and defect tracking in HP Quality Center.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing.

Environment: Informatica PowerCenter 9.0, Apache Tomcat, Oracle 10g, HP QC, Java/J2EE, XML 1.0, HTML MS Office, MS Project, MS Visio, UML2.2, SOA, SOAP UI

Confidential

Business Analyst

Responsibilities:

• Lead Joint Application Design (JAD) sessions to gather business requirements and to identify data stewards.
• Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.
• Worked with business users and analysts to understand the requirements for mastering the data obtained from various sources and loading the golden records to the target MDM database.
• Utilized previous experience and helped team in creation of Schema design in Erwin and implement in database and preparing the technical design document.
• Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level.
• Instrumental in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems along with data architects.
• Assisted in performing Data mapping testing in Informatica Data quality at each step of ETL mapping to ensure correct data in flow and outflow.
• Provided support to troubleshoot Dashboards and generated reports using Crystal reports, Xcelcius and helped resolved the root cause of production issues and streamline the business intelligence processes
• Collaborated with team members and management to identify and solve data quality issues
• Documented and delivered Functional Specification Document to the project team.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes accordingly.
• Gathered requirements for Client-Side Validation, and Server-Side Validation. Responsible technical writing for API development. Documented REST API request and response flow in XML format.
• Conducted UAT to verify whether all the requirements were catered by new data warehouse.
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements.

Environment: MS Project, MS Visio, Informatica MDM, Informatica Data Quality, SAP BO suit, Xcelcius, Crystal Reports, SQL, Oracle 10g, MS Office, MS Visio