SUMMARY:

• Passionate and Proactive Business System Analyst with 8+ years of experience in various phases of the Software Development Life Cycle (SDLC) in Waterfall, Agile (Extreme Programming, Test Driven Development), Scrum and Waterfall Scrum Hybrid Software Development Life Cycle Environment across various platforms
• Experienced with working in various domains such as UI Insurance, Banking, Finance and Telecom to address various solutions such as Customer Feedback Analysis, Retail cloud Banking Platform and Order & Service Management
• Hands on experience in Conducting Feasibility Analysis, As - Is & To-Be Analysis, Gap Analysis, Risk Analysis, Alternative Analysis, SWOT Analysis, Cost & Benefit Analysis for various requirements in the industry
• Actively participated in gathering requirements through various elicitation techniques such as Interviews, Survey & Questionnaires, Brainstorming, Requirement Workshops, JAD (Joint Application Development) Sessions, Document Analysis and Interface Analysis with various stakeholders, Developers, SME’s, Project Managers and Analysts
• Experienced in transforming the gathered requirement into various documents such as BRD, FRD (Functional Requirement Document), SRS (System Requirement Specification) and Use-Case specification Document
• Sound Knowledge of building and documenting the UML (Use-Case Modelling Language) Diagrams such as Use cases, Use case Diagrams, Activity Diagrams, Sequence Diagrams, ER Diagrams and Class Diagrams
• Experienced in Designing the High-Fidelity Mockups, Wireframes and GUI (Graphic User Interface) designs
• Experienced in writing the User Stories (INVEST Criteria) & assisting the PO to prioritize the User Stories using various techniques such as MOSCOW (Addressing Business Value) & KANO Model (Addressing Customer Satisfaction)
• Experienced in utilizing various Estimation techniques such as T-Shirt Sizing, Planning Poker and relative Mass Evaluation for estimating the efforts of the various user stories with the collaboration of the team
• Actively participated in various scrum ceremonies such as Sprint Planning, Daily-Standups, Sprint Review, Sprint Retrospectives and Backlog grooming for the Agile Scrum Methodology as part of various projects
• Sound knowledge of Data warehousing concepts such as OLTP and OLAP operations (Slicing, Dicing, Rollup/Drill Down and Pivoting), Data Modelling, Schemas, Data Mapping, Data profiling and Data Migration
• Experienced in Integrating Data though various sources, Mapping Source and Target Definitions, Workflow manager and monitoring the Workflows through Workflow monitor using ETL Tool such as Informatica Power Center
• Designed and implemented SQL queries using unions, inner joins, outer joins, left-join, right-join, self-join, group by and aggregate functions to extract data from different databases (Oracle, SQL Server, MYSQL) for timely reporting
• Hands on experience working & documenting various API’s such as SOAP, REST by utilizing Swagger for the documentation, and utilized the Postman tool to perform regression, security testing etc.
• Experienced working in Three-Tier Architecture and Service Oriented Architecture, and utilized the Ajax, Web Services (SOAP, WSDL) to perform the Client-side validation and Server-side validation
• Sound knowledge of Testing lifecycle, managed various testing such as Black-Box Testing, Integration Testing, System Testing, Smoke Testing, User Acceptance Testing, Load Testing and Performance testing, and assisted the QA team with documenting the Test Plan, Test Cases, Test Scripts, Test Scenarios, RTM (Requirement Traceability Matrix)
• Hands on experience with various reporting and data visualization tools such as Tableau to create various interactive dashboards and stories to acquire meaning business insights through the available data
• Excellent people management skills, Dynamic research savvy with good analytical, presentation and communication skills, Goal-driven, self-motivated with professional attitude and carry value for time and teamwork

TECHNICAL SKILLS:

Project Management Tools: MS Project, MS Share Point, JIRA, Team Foundation Server (TFS)

Methodology: Waterfall, Agile Scrum, Waterfall Scrum Hybrid, Extreme Programming, Safe and Kanban

Data/Process Modelling tools: Oracle SQL Developer Data Modeler, ER Studio, MS Visio, Wireframes

Requirement Management: MS Office, TFS, IBM Jazz, JIRA, HP ALM 11.5, Confluence

BI/Reporting/Visualizing Tools: Tableau, MS Excel, Amazon QuickSight

Databases: Microsoft SQL Server, Oracle 9i, 10g, 11g, My SQL v2012, DB2

ETL Tools: Informatica Power Center 9.5/9.1/8.6 (Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Admin Console), SQL Server Data Tools

Testing Tools: IBM Jazz, HP QC v 10.0, HP ALM v 11.5, Load Runner, QTP, Postman, Soap UI

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up

Office Tools: MS Office (Word, Excel, PowerPoint, Visio, Project, SharePoint)

Other Tools: AWS, Amazon EC2, Amazon S3, AWS Cloud Watch, Apache Spark ML, Salesforce, R Studio, Google Analytics, Siebel, Order and Service Management (OSM), HP-ALM, Kenan-FX, IBM-BPM 8.0, IBM-ODM

Operating System: Windows Vista, Windows 7, Windows 8, Windows 10, UNIX

Languages: SQL, Python, R, Java, HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential - DC

Sr. Business System Analyst

Roles/Responsibilities:

• Conducted Interviews, Joint Application Development (JAD) sessions and workshops to elicit requirements with various stakeholders and the Subject Matter Expert’s (SME)
• Create system requirements (SR) in Team Foundation Server (TFS) for the gathered requirements, prioritize and assign them to the development team.
• Serve as a liaison between the business teams and the internal development teams to assist or gather business requirements needed for modifications, enhancement and implementations.
• Participate in various product development ceremonies such as Daily Standup, Backlog Grooming Session, Iteration Planning and Closeout, Product Demo Sessions etc. to promote product quality, innovation, development, create and optimize customized solutions.
• Create and maintain issue logs, meeting minutes, meeting schedules, project summaries and updates.
• Create various workflows such as TO-BE and AS-IS system workflows for various product functionalities using Microsoft Visio Tool.
• Actively work with the Product Owner and implementation project manager to build various project related documents such as System Design Document, Implementation Plan and Disaster Recovery Document
• Create various UML diagrams such as Use Cases, Activity Diagrams, Sequence Diagrams and the data flow diagrams to assist the development team by utilizing gathered requirement using MS Visio capabilities
• Overseeing implementation of a new system including the data migration from the existing system and entering information into specific artifacts.
• Perform manual tests to check the availability of various services of the application and communicate the client team with the status of the application in the test environment every day.
• Run shakedown test (automated selenium scripts) in the UAT environment through eclipse tool and monitor the health/ issues in the system
• Collaborate with the testing team for any issues encountered in the shakedown testing
• Monitor and validate the defects raised by the client testing team in the IBM Jazz tool.
• Update the defect in TFS by creating a corresponding system requirement for the enhancement feature or a bug for a valid defect.
• Actively work with the internal team (Testing/development) on Defect Triage and estimate/prioritize the bugs captured.
• Communicate with the client testing team on closing the invalid defects and gathering more clarifications on various defects if needed.
• Work closely with the Client testing team in performing defect triage and providing the status (completion and resolution) for various bugs.
• Collaborate closely with developers to implement the requirements and provide necessary guidance to testers during the Quality Assurance process.
• Work with the Business team in performing UAT scenarios and guide them with the application process flows

Environment: Agile - Scrum, Windows 10, MS Office, Selenium, MS Visio, REST API’s, SOAP UI, TFS, MS Project 2016, SharePoint 2013, Web Services, XML, Eclipse, IBM Jazz, AWS, DOCS (mainframe System)

Confidential - Boston, MA

Sr. Business System Analyst

Roles/Responsibilities:

• Conducted the Document Analysis to understand the AS -IS system and Gap analysis to identify the AS-IS and TO-BE system and assisted the Product Owner to develop a robust plan through the gathered insights
• Interacted with the corporate business team, and the technical team to understand the end to end process, data security and the compliances such as Dodd Frank Act, CFPB and Bank Secrecy Act (BSA)
• Involved in conducting and documenting the Cost and Benefit analysis, Feasibility Analysis and Alternative Analysis by interacting the Stakeholders, SME’s, Financial Analysts, Project Manager and Technical Leads
• Conducted Interviews, Brainstorming Sessions, Requirement Workshops, JAD sessions to elicit the requirements with various stake holders, SME’s and then documenting those gathered requirements for further analysis
• Assisted the Product Owner to write the User Stories by using JIRA, estimating and prioritizing the stories using various techniques like Moscow, Planning Poker and helped to define the Acceptance Criteria for each user story
• Utilized the Confluence and MS Outlook for meetings and emails to organize and collaborate with the team
• Assisted the team in designing the Canonical Data Model for the system migration according to the scope
• Developed and outlined the UML diagrams such as Use Cases, Activity Diagrams, Sequence Diagrams and the data flow diagrams to assist the development team by utilizing gathered requirement using MS Visio capabilities
• Acted as a liaison between the Data Modelers, Technical Team and the Business Units to understand the data lineage and developed the Initial Data Mappings to carry out the Data migration to the AWS Environment
• Assisted the Team in the migration of the data from several sources such as Oracle Databases and the Real time streaming data to the AWS environment using the services such as Amazon EC2, Amazon S3, Amazon Kinesis
• Actively participated in extracting the data through various sources for data validation and data presentation using several queries such as select, Join, Create and Indexing for data migration into the AWS environment
• Worked with the development team to create SOAP, REST API documentation using tools like Swagger
• Assisted Team with the several amazon services such as AWS Cloud Watch, Cloud Trail to monitor and audit the alarms for the system performances and any changes in the system including the EC2, S3 and other services
• Worked with the Quality Assurance team to perform and document both manual and automation of User Acceptance Testing, Regression Testing, integration testing, performance testing, and system testing
• Developed dashboards to enable business insights, KPIs and statistical analysis using Amazon Athena and Amazon Quick Sight reviewing metrics and score cards with business to gather more insights for decision making
• Worked with the development team to deploy the Amazon EMR and utilize the Apache Spark ML to implement the data models for the further data analysis and the visualization

Environment: Agile - Scrum, Windows 10, MS Office, Selenium, Swagger, MS Visio, REST API’s, SOAP UI, JIRA 7.0, MS Project 2016, SharePoint 2013, Web Services, XML, TABLEAU 10.0, HP QC 10.0, Confluence 6.1, AWS, Amazon S3, Amazon EC2, Amazon Glue, Amazon EMR, Cloud Watch, Spark ML, Amazon IAM, Amazon Athena

Confidential - Columbus, OH

Sr. Business System Analyst

Roles/Responsibilities:

• Performed requirement walkthrough to understand and address the advantages of implementing the new system
• Assisted the Product Owner to identify the scope of the project, develop the project plan and allocate the resources accordingly by utilizing the project charter
• Analyzed the existing system by implementing the Gap Analysis and created the AS-IS & TO-BE documents to address the areas of improvement and enhancements to address the system capabilities and needs
• Performed Cost & Benefit Analysis, Feasibility Analysis to understand the net benefit and the feasibility
• Assisted the team in documenting the service transition documents such as the Service Availability Plan, Knowledge Capture Document, Disaster Recovery plan and the Business Continuity Plan
• Assisted in the implementation of the Salesforce CRM to facilitate the development of the cloud-based Retail Banking Console that would manage customer data and help bankers to recommend solutions to the customer
• Participated in various Scrum ceremonies, helped PO to review the working demo of Potentially Shippable Product Increment (PSPI) in review meeting based on the Definition of Done and Acceptance Criteria
• Actively participated in the transition process to the SFDC including the Design, Development, Planning, testing and integrating the Cloud services in SFDC for customer data management and enhancing the user experience
• Implemented the Salesforce Einstein Analytics on the customer data that would assist the bankers to identify the highest priority referrals based on the intelligent scoring
• Assisted the team to analyze the Changes in the console for different cloud such as marketing Cloud and sales Cloud by utilizing the Einstein Analytics and transformed them to the functional and business requirements in the Salesforce to help the bankers to enhance the customer experience
• Assisted the QA team to develop the test plan and test cases to perform the testing and involved in Automated User Acceptance Testing (UAT) to ensure that the business requirements were being addressed in the test
• Assisted the Quality Assurance team in performing functionality testing, reliability testing, and utility testing on the API web-services using tools Postman and Swagger
• Used JIRA and Confluence for defects tracking, organizing and collaborating teams for meetings and emails
• Assisted the Sales team to utilize the Einstein analytics capability of data science and machine learning for identifying the interests of customers and address their financial needs accordingly

Environment: Agile - Scrum, Salesforce, Einstein Analytics, Community, Salesforce App Exchange, Windows 10, MS Office, Swagger, MS Visio, SIPOC, SOAP UI, JIRA 7.0, MS Project 2016, SharePoint 2013, Web Services, XML, SOAP, JAVA, REST, TABLEAU 8.2, MS SQL Server 2012, HTML, CSS, HP QC 10.0, Confluence 5.9.5

Confidential - St. Petersburg, Florida

Business System Analyst

Roles/Responsibilities:

• Performed Document Analysis to understand the current system and conducted Gap analysis by understanding the AS-IS & TO-BE Analysis to identify the existing system and areas of improvements
• Conducted the various analysis such as Cost & Benefit Analysis, Feasibility Analysis and Interface Analysis to understand the cost effectiveness and the efficient future state
• Facilitated various interview sessions, JAD session with several stakeholders and SME’s to elicit the requirements.
• Responsible to prepare and modify various documents such as BRD, FRD and the SRS
• Developed the various UML diagrams such as Use Cases, Use Case Diagrams, Activity Diagrams and other Use Case Diagrams to understand the workflow and external systems using the MS Visio capabilities
• Assisted the team in Process modelling and Data modelling by developing Conceptual/Logical data models and database schemas to develop an efficient migration to the Teradata Enterprise Database
• Participated in various Scrum ceremonies, helped PO to review the working demo of Potentially Shippable Product Increment (PSPI) in review meeting based on the Definition of Done and Acceptance Criteria
• Helped the team in performing the integration of various OLTP systems into the analytical engine of Teradata Database by utilizing the ETL operations of Informatica Power Center
• Assisted in the data mapping activities including the source definitions, Target definitions and reviewing the business transformations according to the requirements
• Assisted the team in enhancing the Data Integrity by implementing the data normalization (validating data anomalies) and data profiling to enhance the effectiveness of data
• Assisted the QA team to design document the Test Cases, Test Plan to facilitate the various testing involved such as Integration Testing, Functional Testing and the User Acceptance Testing
• Coordinated Phased Data Migration process to handle large and complex volumes of data and address dashboard reporting capabilities for the migrated data
• Actively participated with the team in Integrating heterogenous source systems to the OLAP by using Informatica for ETL and used Tableau for reporting and visualizing the gathered data
• Supervised and worked closely with data coordinators, and other team members to provide technical support and end user training on the developed applications

Environment: Waterfall Scrum Hybrid, Windows 10, MS Office 2015 (MS Word, MS Excel, MS PowerPoint, MS Visio), MS Project 2013, JIRA 6.4, SharePoint 2013, TABLEAU 8.0, MS SQL Server 2012, HP ALM 10.0, Confluence 5.9.5, Teradata Database, Informatica PowerCenter

Confidential

Junior Business System Analyst/ Siebel Admin

Roles/Responsibilities:

• Facilitated various interview sessions, JAD session with several stakeholders and SME’s to elicit the requirements
• Worked on preparing and modifying various documents such as BRD, FRD and the SRS
• Delivered administration activities for Siebel CRM including Incremental Compile, Code deployment on Non-production environments, SRF replacement, Daily Server health checks and User account management
• Managed Order Management Testing including Siebel CRM and OSM platform for various environments such as SIT, UAT, RFS and Production environment
• Managed testing for Customer Center (including Service/Change/Incident/Problem requests) for various environments such as UAT, RFS and Production Environment
• Providing expertise in deep dive of Siebel technical issues related to current production and new enhancement development going around in the organization
• Worked closely with the project stakeholders in all the phases of the project and ensures that Siebel CRM product/application is minimally customized to make it scalable, agile, easily maintainable and upgradeable
• Team management activity, such as, task allocation, sorting out professional issues, leave plan, approvals, appraisal, BAU activities and Incident Management
• Formulated solutions and comprehensive strategic recommendations for improving the customer experience

Environment: Waterfall, Windows 10, MS Office 2015 (MS Word, MS Excel, MS PowerPoint, MS Visio), MS Project 2013, SharePoint 2013, Siebel 8.0, OSM, Oracle 11g, HP ALM 10.0, Unix

Amdocs

Sr. Engineer, Production Support Management

Roles/Responsibilities:

• Managed Infrastructure administration activities for different Kenan Environments including Database Cloning, refreshing environments, performance monitoring, space management and user management
• Worked on several activities such as CDR Re - ordering and Partition archival for managing various environments such as UAT, RFS and production
• Assisted the QA Team in executing various scripts in the SIT and UAT environments
• Actively performed application support and operational activities for different non-production Kenan environments
• Actively participated with the billing team in performing various customer billings such as Daily, Weekly, monthly and finally sending them to the printshop tool
• Worked on Release Management handling the Release policy, Release planning, Oversight on Issues, Risks, Change Requests, and Deployment for various environment

Environment: Waterfall, Windows 10, MS Office 2015 (MS Word, MS Excel, MS PowerPoint, MS Visio), Oracle 9i, HP ALM 10.0, Unix, Kenan FX, SOAP UI

Confidential

Engineer, Production Support Management

Roles/Responsibilities:

• Serviced as a Server Administrator, installed pre - production and production environment for BPM and ODM in the cluster mode
• Worked on Infrastructure administration activities such as refreshing environments, performance monitoring, space management and user management for various environments such as DEV, SIT and RFS
• Actively participated with the development team to analyze the various business rules for the different product hierarchies
• Hands on experience with license management and supported the license metric using ILMT v7.5
• Worked closely with the project stakeholders in all the phases of the project and ensures that the application is customized according to the business needs
• Performed regression testing for the Quoting application over Siebel platform
• Designed and conducted analysis for recommendations about various business insights to help decision making
• Worked on IBM - BPM v-8.0; created different sandbox for BAL service, Ajax service, web service integration

Environment: Waterfall, Windows 10, MS Office 2015 (MS Word, MS Excel, MS PowerPoint), Oracle 9i, HP ALM 10.0, Unix, IBM BPM 8.0, IBM ODM, SOAP UI