We provide IT Staff Augmentation Services!

Senior Business System Analyst /project Manager Resume

CA

PROFESSIONAL SUMMARY:

  • Self - driven, results-oriented Project Manager/Business System Analyst with a positive outlook and a clear focus on high quality business with 8+ years of professional experience in the business areas Banking, Property & Casualty Insurance.
  • Strong understanding & experience in working for regulatory driven projects under AML, KYC, Same Day ACH, USA PATRIOT Act, Bank Secrecy Act.
  • Proven ability to work with virtual teams (Offshore/Onshore teams), define process improvements, and manage stakeholder expectations.
  • Full SDLC project management services: from initiation, requirement gathering, planning, reporting, analysis, testing, design development to adoption, administration, and execution in Waterfall methodology, Agile-Scrum and Waterfall-Scrum hybrid environments.
  • Worked in Waterfall - Scrum transition environment and made sure the team understood and enacted the agile philosophies meanwhile did not fall back to traditional documentation, rigid scope-change control methodology.
  • Well versed in breaking down Epics into User Stories satisfying INVEST criteria in grooming meeting and breaking down User Stories into Tasks satisfying SMART criteria.
  • Proficient in Technical and Business Writing skills, Business Process Flow and Modeling, Business Analysis and Testing including Black-Box testing, White-Box Testing and Regression Testing.
  • In depth knowledge Agile-Scrum methodology, Use Cases, Software Development Life Cycle (SDLC) processes.
  • Excellent Interpersonal skills with ability to interact with end-users, Subject Matter Experts (SME’s), Product Owner, Development Team and Project Stakeholders.
  • Strong experience in authoring Business Requirement Documents (BRD) by gathering Business Requirements and Expectations from Subject Matter Experts (SMEs) and defining business processes, identifying risks, business system analyst in various functions including risk management, regulatory standards and reporting
  • Worked on Process Improvements, including providing Excel expertise support to Subject Expert Matter (SEM) manager to automate Excel Templates for monthly reporting.
  • 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.
  • Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
  • Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
  • Extensively used SQL queries using joins, unions, outer joins, group by, order by and aggregate functions to extract data from different data sources and to perform DDL (Data Defining Language) and DML (Data Manipulation Language) operations to Create, Read, Update and Delete (CRUD) the data in the database for data manipulation, data calculations and data analysis.
  • Extensive experience in configuring data mapping between different Databases.
  • Worked in the ETL Procedures and processes. Reconciled disparate master data from distributed systems and synchronized this reliable data with Analytical and Operational Systems using Master Data Management (MDM).
  • Cultivated experience in working with different web services such as HTML, WSDL, SOAP, UDDI, REST, JSON under various architectures like Three-Tier Architecture and SOA for efficient information transfer and mapping.
  • Used Tableau as a BI tool for generating Analytical Reports required for the project for further analysis.

TECHNICAL SKILLS:

Modeling Tools: MS-VISIO, Mock-up Screens, Sketch

Project Management Tools/Methodology: Unified Modeling Language (UML), MS-Project, MS Share Point, Rally, JIRA, Agile-Scrum, Waterfall-Scrum, Waterfall, Extreme Programming, Kanban.

Business Skills: Process Modeling, Change Management, GAP Analysis, Impact Analysis, To-be Analysis As-Is Analysis, Risk Analysis, Cost-Benefit Analysis, SWOT Analysis, JAD Sessions

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Dimensions, Schemas

Databases: Oracle 9i/10g, IBM DB2, MS SQL Server, MS Access.

Productivity Suite: MS Word, MS Excel, MS PowerPoint, MS SharePoint 2013, MS Project, MS Visio

Requirement Management: MS Office, JIRA, Confluence, Rally, HP ALM, Team Foundation Server (TFS)

ETL Tools/Reporting Tools: Informatica, SQL Server Data Tools-Business Intelligence (SSDT-BI), Tableau, MS Excel, MS BI, Power BI, SAS

Testing Tools/Defect tracking tools: HP ALM, Load Runner, Cucumber, Selenium, SoapUI, Postman, HP QC, JIRA.

Languages: SQL, XML, JSON, C, C++, Java, JavaScript.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Senior Business System Analyst /Project Manager

Responsibilities:

  • Conducted One-on-One, Brainstorming and JAD sessions with the stakeholders and Executive sponsors for understanding the project and to gather the requirements for documenting them in the Business Requirements Document (BRD).
  • Performed the GAP Analysis between two systems (Reycer and Confidential Link) to understand the field and functional differences in the systems.
  • Performed As-Is and To-Be Analysis of the mobile application ( Confidential Pay) to develop some new ideas and improve the user experience.
  • Worked alongside with the Legal and Regulatory teams to ensure high quality standards are maintained for KYC, Ongoing Due Diligence (ODD) and Enhanced Due Diligence (EDD) casework conducted by KYC analysts.
  • Prepared Project charter, time-lines for the project and communication plan by contacting all the teams and departments.
  • Gained a good knowledge in handling the off-shore teams irrespective of the time zones.
  • Led teams across broad technical, financial and business disciplines. Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.
  • Developed project plans, schedules and assigned work to meet critical deadlines.
  • Actively involved in discussions with the Developers (off-shore) and Architects (off-shore) and assisted them in understanding the business requirements and to answer any of their business questions and ensure that there is no ambiguity.
  • Created Mockups and wireframes using MS Visio and Adobe Installer to help better understanding for the development team on what is going to be developed.
  • Created Screen-by-Screen ppt for Legal to get the Language that needs to be displayed on the screens and communicated the same with UI/UX team (third party vendor).
  • Worked with the fraud team to understand the error messages to be displayed in the application provided by the Wells-Fargo and to understand the backed process of each transaction.
  • Using Postman and SoapUI to check if the APIs are returning the data in JSON, XML format as defined in the API documentation and required by workflow.
  • Developed API documentation using Swagger and communicated it with the developers.
  • Worked alongside with the testing team, created the test cases a per business requirements.
  • Performed Beta-Production Testing before releasing the application in to the production environment (into the apple and google play store).
  • Prepared User Acceptance Testing (UAT), Test Plan, Test Cases, Testing Life Cycle schedules and implemented all the Test Scenarios along with QA Team both in Automation and Manual Testing and reported bugs in JIRA.
  • Participated in preparing the defect management documents and tracking of defects.

Environment: SDLC, Scrum-Waterfall Hybrid, Service Oriented Architecture (SOA), Salesforce.com, MS office tools, MS project, MS Visio, JIRA, Swagger, UML, My SQL, Web Services, HTML, CSS, Java Script, SOAP.

Confidential, Pennington, NJ

Senior Business System Analyst /Project Manager

Responsibilities:

  • Worked with Analysts and other Business Teams to document the required artifacts including BRD by using different elicitations techniques including Brainstorming, interviews, Focus groups, JAD sessions. FRD creation to design the FX Spot trades load from FI Order management System into Eagle Pace.
  • Performed Document Analysis to understand the AS-IS process and collaborated with the team to design TO-BE process based on the requirements gathered and designed TO-BE process using Business Process Modeling Tool.
  • Worked to ensure high quality standards are maintained for KYC, Ongoing Due Diligence (ODD) and Enhanced Due Diligence (EDD) casework conducted by KYC analysts.
  • Managing project issues and risks to prevent potential barriers to project success.
  • Led teams across broad technical, financial and business disciplines.
  • Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.
  • Developed project plans, schedules and assigned work to meet critical deadlines.
  • Actively involved in discussions with the Developers and Architects and assisted them in understanding the business requirements and to answer any of their business questions and ensure that there is no ambiguity.
  • Developed advanced SQL queries using joins, unions, outer joins, group by, order by and aggregate functions to extract data to manipulate and calculate information to fulfill data and reporting requirements including identifying tables and columns from which data is extracted.
  • Experienced in building and implementing custom applications that includes Administration, Configuration and support experience with Salesforce.com applications.
  • Implemented Partner portal on salesforce org for Partners to better connect with different business users and suppliers, thereby increasing transparency.
  • Worked on Data Requirement Analysis and identified the Source Data and assisted ETL Developer in designing ETL process using Informatica Power Center, based on the Data Mapping Documentation.
  • Created logical data interface document by collaborating with systems architect that maps the relationship between original source and fields and target destination fields. Also performed Data Profiling and Validations.
  • Using Postman and SoapUI to check if the APIs are returning the data in JSON, XML format as defined in the API documentation and required by workflow.
  • Developed API documentation using Swagger and communicated it with the developers.
  • Prepared User Acceptance Testing (UAT), Test Plan, Test Cases, Testing Life Cycle schedules and implemented all the Test Scenarios along with QA Team both in Automation and Manual Testing and reported bugs in JIRA.
  • Conducted Data Accuracy Analysis, and support stakeholders for decision-making and used Tableau for report generation of the data to be analyzed for the stakeholders in accordance with the requirements.
  • Participated in preparing the defect management documents and tracking of defects.

Environment: SDLC, Scrum-Waterfall Hybrid, Service Oriented Architecture (SOA), Salesforce.com, MS office tools, MS project, MS Visio, JIRA, Swagger, UML, My SQL, Hadoop, Web Services, HTML, CSS, Java Script, SOAP.

Confidential, Wilmington, DE

Senior Business System Analyst

Responsibilities:

  • Knowledge of NACHA operating rules, SAME DAY ACH processing.
  • Conducted GAP Analysis to derive requirements for ACH processing.
  • Interviewed Business users for eliciting requirements using JAD sessions, Interviewing, Focus Groups and analyzed the feasibility of the requirements.
  • Created Requirement Traceability Matrix (RTM) to keep track of the requirements. Also interacted with the Subject Matter Experts (SME) for better understanding of the process.
  • Conducted User Story Writing Sessions to decompose BRD into User Stories and determine Acceptance Criteria for Potentially Shippable Product Increment.
  • Helped the Product Owner to Prioritize the Product Backlog items for developing Sprint tasks by taking suggestions from the cross-functional development team.
  • Highly proficient in writing and prioritizing user stories in Product Back Log with Product Owner.
  • Used JIRA for issue tracking, user story management and requirement traceability.
  • Assisted in identifying risk needed to develop Risk analysis as required by NACHA and Fraud detection for red flags to report fraud, patterns and inconsistencies activities.
  • Processed ACH Data. This included file transmissions, processing & balancing of day-to-day batch jobs. Specifically, the role entailed the following of checklists and established guidelines to ensure that client data (files & reports) were delivered in a consistent, timely manner.
  • Assisted the lead QA in the creation, preparation, and conduct of quality assurance reviews and the development and execution of test plans & test scripts for ACH Payments Beneficiaries.
  • Performed DML (Data Manipulation Language) and SQL operations to Create, Read, Update and Delete (CRUD) the data in the database for data manipulation, data calculations and data analysis.
  • Performed the Source to Target Mapping for better understanding and to transfer the funds using same day ACH.
  • Also used ACH API and REST APIs for the communication between the ODFI and RDFI.
  • Assisted with User Acceptance Testing (UAT), developing and maintaining quality procedures and ensure that appropriate documentation is in place. Assisted in Black box, UAT and Regression testing.
  • Used Tableau for generating Analytical Reports for further analysis of the project.
  • Used Quality Center and Bugzilla to report the bugs found during testing and to document the Test Scripts.
  • Communicated effectively across company contacts and clients, internal team about the project requirements, schedules and launches.

Environment: Scrum - waterfall Hybrid, MS Visio, MS Project, MS office, Fraud management, Risk management, My SQL server, Visual studio, JIRA, Tableau, MS Office Suite (MS word, MS Excel, PowerPoint).

Confidential, Bloomington, IL

Senior Business System Analyst

Responsibilities:
  • Conducted GAP Analysis in understanding how the upgraded system carries out the business functions and assists in ensuring the timely and effective implementation and conducted feasibility study and performed impact analysis and risk analysis for proposed enhancements.
  • Conducted business process modeling and analysis, identified assessed and articulated gaps operational risks associated. Drafting elaborate KT documents.
  • Involved in preparing Software Development Life Cycle (SDLC) Documents such as Business Requirement document (BRD), Functional Specification document (FSD), Test Plan and Test Report.
  • Designed Wireframes and Mockups for making the developers better understand about the flow of the process.
  • Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams using Unified Modeling Language.
  • Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations.
  • Introduced Agile-Scrum and Scrum Hybrid methodologies to reflect liquid nature of front-office improving time-to-market with less turn-around time of claims request.
  • Planned and defined Use Case Scenario for processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of businesses (Fire, Auto, and Commercial).
  • Worked closely with the SME's like Property & Casualty Sales Representatives, Account Managers, Underwriting Directors, Officers, SVP and Chief Underwriter, Loss/Risk Control Consultant and Sr. Security Administrator.
  • Synchronized this reliable data with Analytical and Operational Systems using Master Data Management (MDM).
  • Performed the ETL Procedures and processes. Reconciled disparate master data from distributed systems and
  • Developed Hive queries using Data Definition Language including create, drop, truncate, alter, show, describe to fetch the data from the Hadoop Distributed File Systems (HDFS).
  • Performed data transformation as per client requirements using Apache Spark and Flume.
  • Automated and scheduled the process of Data Ingestion using Kafka for streaming data and Sqoop for the Relational Data Base Management System (RDBM) to store data in to HDFS.
  • Created datasets for modeling, performed visualization of data obtained from Hive and HBase using Tableau.
  • Responsible to Track, Document, Capture, Manage and Communicate the Requirements using RTM which helped in maintaining numerous artifacts produced by the teams across the deliverables for a project.
  • Collaborated with the Quality Assurance team design and develop Test Plans and Test Cases for performing User Acceptance Testing, Functional Testing and Regression Testing.
  • Involved in User Acceptance Testing scenario drafting, providing support to Business during UAT Testing. Review of test documents like Test Strategy, Test design document, Test cases, & Test Results and providing sign-off.
  • Used Cognos for Reporting and to perform analysis on the reports that were generated by different departments.
  • Used Bug & Defect tracking systems (Bugzilla) for entering and tracking of bugs.
  • Document User Manual Training Document Release Notes & Lessons Learnt documents.

Environment: Waterfall-Scrum Hybrid, Big Data (Hadoop, Spark, Hive, Flume,), Tableau, MS Project, SSIS, SSRS, SSAS, Office 365(Word, Excel, PowerPoint and Outlook), MS Visio.

Confidential, Boston, MA

Senior Business System Analyst

Responsibilities:

  • Worked throughout the SDLC process, which included requirement specification, design, analysis and testing by utilizing Waterfall methodology.
  • Prepared Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specifications (SRS) by gathering requirements through detailed discussions with Business Users and Subject Matter Experts (SMEs).
  • Organized and participated in Joint Application Development (JAD) sessions, Brain storming sessions with claims department, stakeholders and other cross-functional teams.
  • Developed Use Cases and Data Flow Diagrams (DFD) for the online claims filing method.
  • Designed Wireframes to understand the flow of the system and to assist the developers.
  • Closely interacted with developers to understand the Self-service portal functionality and kept them updated on requirement modifications to continuously improve and develop new features from existing web service.
  • Worked with front-end team in creating an enhanced User Interface using HTML, CSS and JavaScript.
  • Assisted in developing User-Friendly online claims filing and monitoring system for the policy holders.
  • Participated in various meeting, discussed enhancements and modifications with Business Users and Stakeholders.
  • Developed advanced SQL queries using joins, unions, outer joins, group by, order by and aggregate functions to extract data from different Databases.
  • Worked on API documentation using Swagger tool. Analyzed and documented domain specific API’s while conducting the Interface analysis, to interpret the data formats in their WSDL/WADL for a thorough understanding of business requirements and supported integration of compliance REST API’s with Business Rules Engine.
  • Analyzed and tested the User Interface for constantly redesigning the system to increase its user friendliness for the clients. Assisted in designing test plans and test cases, and User Acceptance Testing (UAT).
  • Designed Requirements Traceability Matrix to help the stakeholders trace the requirements.
  • Used QlikView for generating Analytical Reports for further analysis of the project.
  • Tracked open issues using weekly status and progress reports and kept project manager updated.
  • Organized and facilitated evaluation sessions with end users to examine their experience and improve functionalities of the new application accordingly.

Environment: Waterfall, MS Office Suit, Visio, Windows, SQL, Power Designer, HTML, CSS, JavaScript, QlikView, Swagger.

Confidential

Responsibilities:
  • Acted as the Primary Intermediary between the Subject Matter Experts, Business and Technical SME's to identify the Business needs, Business Rules, Business Processes & Interface.
  • Provided specifications for the enhancement of the claims processing systems, documented them in Business Requirement Document (BRD) and quantified the functional specifications of the system in the Functional Requirement Document (FRD).
  • Led and conducted JAD sessions by gathering the requirement from stakeholders by using different elicitation techniques including Brain Storming, Interviews.
  • Performed GAP analysis and wrote application enhancement specifications detailing in scope/out of scope items, As-Is/To-Be process maps and critical test scenarios.
  • Created Use Cases and UML Diagrams such as Use Case Diagrams, Activity Diagram and Sequence Diagrams.
  • Provided structured walkthrough to the developers to understand the Use Cases.
  • Using RTM, we performed Track, Document, Capture, Manage and Communicate the Requirements, which helped in maintaining numerous artifacts produced by the teams across the deliverables for a project.
  • Performed DML and SQL operations to Create, Read, Update and Delete (CRUD) the data in the database for data manipulation, data calculations and data analysis.
  • Worked on both manual testing and automated testing to perform Regression Testing, White-Box Testing and Black-Box Testing.
  • Worked with QC Teams to develop Test Cases and Test Scripts based on functional performance criteria.
  • Assisted in designing test plans and test cases, and User Acceptance Testing (UAT).
  • Analyzed and tested the User Interface for redesigning the system to increase its customization for the clients.
  • Used QlikView for generating Analytical Reports for further analysis of the project.
  • Organized and facilitated evaluation sessions with end users to examine their experience and improve functionalities of the new application accordingly.
  • Participated in Releases and Deployment to end-users after successful development and testing of the product.

Environment: Waterfall, Power Designer, MS Visio, UML, MS Office, Windows, QlikView, MySQL.

Confidential

Business System Analyst

Responsibilities:
  • Analyzing Business Requirement Documents for different phases and preparing reports for Daily, Weekly and Monthly reports to build ad hoc reports.
  • Created different levels of reports, dashboards, and analytics that are easy to understand the Sales Performance with different levels of metrics.
  • High experience in tracing requirements throughout the development process and verifying to RTM.
  • Developed prompt pages, Drill-through reports, multi-page, multiple queries to combine different reports in a single report.
  • Worked on PPC by using Google AdWords for Tutor vista and Edurite to get enough customer leads data to generate online sales for educational
  • Generated Ad revenue using DFP (Ad manager) network by Creating different line items, Creatives, Ad units and Placements including troubleshooting.
  • Performed Source Analysis to identify the source databases for the better understanding of the project flow.
  • Worked on Data Mapping, Data modeling and Data Profiling.
  • Performed Reverse Engineering to finalize the Source Systems and assisted in extracting the data into ODS.
  • Developed SQL queries to pull the data from the databases to perform analysis on the reports.
  • Performed API testing using Postman and REST to check if the APIs are returning the data in JSON, XML format as defined in the API documentation using Swagger and required by workflow.
  • Creation of Test Plan for Performance Testing, User Acceptance Testing (UAT) and In corporate Review Comments, Validation and Compare Result Strategies Development.
  • Used Tableau as our reporting tool to analyze the data from the DWH.
  • Generated various kinds of Reports (List, Cross-tab, Chart), master-detail reports using Tableau with prompts on the report page using different prompt types.
  • Worked on Bugzilla for bug tracking, issue tracking, and Defect Tracking

Environment: BIRT, Web Analytics (Google Analytics), MYSQL, Google DFP, and Google AdWords, Bugzilla, Tableau, Swagger

Confidential

Jr. Business System Analyst

Responsibilities:

  • Was involved in project implementation to facilitate on time task completion in the Sprints, analyzed and Documented the Approved Requirements List (ARL), Business requirements document (BRD).
  • Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
  • 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.
  • Worked on Process Improvements, including providing Excel expertise support to Subject Expert Matter (SEM) manager to automate Excel Templates for monthly reporting.
  • Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
  • Created Use Cases and Data Flow Diagrams (DFD) for the online claims filing method.
  • Conducted Joint Application Development (JAD) sessions, Brain storming sessions with claims department, stakeholders and other cross-functional teams.
  • Construct HTTP requests, fetch server response and parse feeds wherever required.
  • JSON parsing using GSON is done for the REST responses of the internal services.
  • Support and fix sudden Crashes and Bugs on Client Devices.
  • Contributed to the Test Planning meetings in creating Test Scenarios, Test Cases and suggesting suitable tools.
  • Was involved in Product Release Documentation for the project at regular intervals for review and feedback.
  • Gathered test data from the clients to test the forms and reports for data flow using happy path scenarios for UAT and participated in UAT signoff.
  • Participated in preparing the defect management documents and tracking of defects.

Environment: Waterfall-Hybrid, Android Studio, MS Office (MS Excel, MS Word, MS PowerPoint, MS SharePoint, MS Visio), Rational Rose, SQL Server.

Hire Now