Home

MODASSAR KHAN - Business Analyst

[email protected]

Location: Monmouth Junction, New Jersey, USA

Relocation: yes

Visa: H1B

MD MODASSAR KHAN SR. BUSINESS SYSTEM ANALYST M: + 319-346-3651 Email: [email protected] Experience Summary About More than 8+ years of professional experience a Business Analyst, I have diversified expertise across Health Sector, Banking, and finance domain. My experience encompasses both Waterfall and Agile methodologies, and as a certified Scrum Master, I've applied frameworks like SCRUM, SAFE, and Kanban, ensuring the successful delivery of high-quality software solutions. My collaborative and analytical approach positions me as a reliable team player in achieving business objectives. Professional Summary 8+ years of project management experience in the implementation of the Software Development Life Cycle (SDLC) and using various methodologies and frameworks like Agile-Scrum, SAFe, and Waterfall. Accomplished IT professional with a strong background in software quality assurance and project management. Specialized expertise in leveraging tools such as HP Application ALM for efficient and effective application lifecycle management. Extensive work experience and proven knowledge in healthcare, finance, banking and Retail domain Proven professional experience utilizing Atlassian Jira for managing user stories. Excellent computer skills, including Microsoft Word, Visio, PowerPoint, and Excel Proficient in requirement gathering process using different Elicitation Techniques such as Interviews, Document Analysis, Brainstorming Sessions, and JAD Sessions In-depth understanding and experience in conducting different analyses such as GAP Analysis, Impact Analysis, and Root Cause Analysis to frame a business strategy Expertized in creating and analysing Business Requirement Documents (BRD), Functional Requirement Documents (FRD), and Requirement Traceability Matrix (RTM). Well-versed in Word, PowerPoint and Excel, writing Zure d queries Experience in end to end data mapping and ETL Efficient creating wireframes and/or mock-ups in accordance with UX best practices Developed UML diagrams such as Activity flow diagram, Sequence diagram Conducted due diligence for Change Requests and implemented the change requests Proficient in project management tools such as Jira//Confluence to document user stories, tasks, & acceptance criteria and for status reporting and planning. Worked with SOA architecture and Micro-Service architecture and implemented successfully in projects Experience in API documentation using Swagger and API testing using Postman Experience in working closely with PM, PO, System Architect and cross-functional teams and involved in writing Client-side validations, Transformation rules, Database validations, and Server-side validations and collaborated with the development team in integrating interactive UI pages Facilitated the User Acceptance Testing (UAT) session before every release by inviting the right stakeholders to work on developed software to check its capability Proficient experience in both manual and automated testing, and compliance. performed UAT (User Acceptance Testing), unit testing, regression testing, and integration testing Engaged in all scrum ceremonies such as Backlog Grooming, Sprint Planning, Daily Scrum, Sprint Review, and Sprint Retrospective. Design and integrate dashboard using power BI Proactively updated Team progress to the Product Owner using Key Performance Indicators (KPIs) integrated into JIRA and Rally such as Burn-up Chart, Burn-Down Chart, Cumulative Flow diagram, and Velocity Chart Generated User Stories using INVEST criteria and acceptance criteria in GHERKIN format Possess excellent verbal and written communication skills with strong interpersonal and ethical abilities in handling teams, Executed PI Planning Sessions and Prioritize PI Objectives along with Product Owner. Methodologies Agile, Waterfall and Hybrid Framework SAFe, Scrum, BI Tools Tableau, Crystal Report, Power B1 ETL Tools Informatica, Modeling Tools MS Visio, Lucid Charts Documentation Tools MS Office Suite, Share Points, Swagger, MS Excel Project Management Tools JIRA, MS SharePoint, Confluence, Azure DevOps Testing Tools Swagger, SoapUI, Selenium, Postman Web Technologies XML, HTML & CSS, SOAP, REST, Web Services Databases SQL server, ORACLE, MS Access, IBM DB2, NoSQL Design Tools MS Visio, Balsamiq, Sketch, Professional Experience: Client: Aetna CVS Health Location: Hartfort, CT Role: Sr. Business Analyst Duration: 2021- Till Date Project: Claim Denial Analysis Aetna CVS Health, headquartered in Hartford, CT, is a prominent player in the health sector. I actively contributed to the analysis and resolution of claim denials, collaborating with cross-functional teams to optimize processes and ensure efficient healthcare claims management. Roles and Responsibilities Played a key role in improving the claims processing efficiency, resulting in reduction in claim denials. Prepared Project Documentation like Business Requirement Documents (BRD), Functional Requirement Documents (FRD), System Requirement Specification (SRS), Release Notes, and minutes of meetings (MOM) utilizing MS Word and confluence Elicited Business Requirements by conducting detailed Interviews, Document Analysis with Business Users, Stakeholders, and Subject Matter Experts (SMEs) Leverage HP Quality Center/ALM for test planning, test case design, execution, and defect tracking. Develop complex SQL queries for reporting, data extraction, and data manipulation Collaborate with cross-functional teams to ensure accurate and clear documentation of QA processes. Utilized Atlassian Jira boards to organize tasks, prioritize user stories, and facilitate seamless collaboration, ensuring effective project management and progress tracking. Gathered requirements for Change Request and evaluated it with the Impact Analysis Worked in EDI transaction 837 P.I to identify key data set elements for designated record set. Interacted with claim Payment and Enrolment, hence analysing an documenting related business process. Develop and implement privacy policies and procedures to ensure compliance with HIPAA regulations. Assisted in gathering the business requirements, ETL Analysis, ETL Test and design of jobs and logic for the data warehouse project Set up and manage Azure DevOps projects, repositories, and boards. Design and implement CI/CD pipelines using Azure DevOps. Set up monitoring tools and dashboards to track pipeline performance and deployment metrics. Apply Agile principles to manage and prioritize work, participate in sprint planning, and ensure timely delivery of Java Full Stack features and improvements. Serve as the point of contact for individuals seeking information about their privacy rights under HIPAA Involved in the development and implementation of Middleware services for the claim process, with a focus on RESTful APIs and JSON payloads. Facilitate change management processes related to the introduction of new technologies or updates to the Java Full Stack solution. Communicate changes to stakeholders effectively Involved in Extracting, Transforming, and Loading ETL of data to target warehouse data base Created design, and carry out test strategies for subsystems or applications. Facilitated frequent meetings with the management team to prioritise the gap list and performed Gap Analysis based on expected process and current process. Performed root cause analysis for production and reporting issue encountered with EDI transactions and also performed risk analysis Attended the Triage calls to identify the defects to using HP Quality Center and proposed the resolution and fixed the defect using mapping document. Implemented Unified Modelling Language (UML) to prepare Activity diagram, Use Case diagram, Data Flow diagram, Sequence diagram. written complex SQL Queries involving Joins and Subqueries Experience with data transformation from OLTP to OLAP using the transformation rules in Informatica Facilitated User Acceptance Testing (UAT) and guided business users by providing a manual guide to validate the requirements. Design, develop, and maintain SQL databases to support business applications. Designed Test Plans, Test Strategies, and Test Cases for User Acceptance testing (UAT) with the help of the QA team Provide detailed reports on testing outcomes, including identified discrepancies and suggested improvements. Actively participated in Backlog Grooming and Sprint Review sessions to ensure that the Definition of Ready (DoR) and Definition of Done (DoD) criteria are met for each user story Participated in the Sprint Review session with the scrum team to ensure that the system functionality is fulfilled by delivering the Minimum Viable Product (MVP) confirmed by the product owner and stakeholders. Client: Walgreens Location: Deerfield, IL Role: Business Analyst Duration: Sept 2018- Dec 2020 Project: Enhancement of Customer Relationship Management Walgreens, based in Deerfield, IL, is a leading pharmacy retail and healthcare service provider. I played a pivotal role in enhancing Customer Relationship Management processes, working closely with Walgreens to gather requirements, design solutions, and improve overall customer satisfaction. Roles and Responsibilities Experienced at RCA on cases, issues, and problems and making sure the solution is delivered within the predetermined SLAs and deadlines Collaborate with business stakeholders to understand their requirements and translate them into technical specifications for Java Full Stack development. Identified a stakeholders to ensure a smoother change process and to clarify roles and responsibilities in the cross-functional project environment. Worked with the project manager and Delivery Team on the Product Roadmap (User Story Mapping) and Release Planning. Write and optimize SQL queries to extract, transform, and analyze data. Lead Backlog Refinement Session, collaborated with the business team in prioritizing and grooming product backlogs and helped in prioritizing and estimating the user stories using and Planning Poker techniques. Write complex SQL queries to retrieve and manipulate data as per business needs. Verify data totals by rigorously testing reports against various data sources, both online and offline. Performed due diligence in writing user stories in accordance to INVEST Criteria and convert the business requirements into technical specifications and prepared the Systems Requirement Document (SRD) with the technical team in the JAD session. Analyzed and updated the User Stories, Tasks, and Burn Up/Burn down charts to track the progress of the team in JIRA. Leverage expertise in Java Full Stack development to guide technical teams in implementing robust and scalable solutions. Create prototypes and wireframes to visualize and communicate the user interface and overall user experience of the Java Full Stack solution, ensuring alignment with business expectations. Utilize advanced Excel functions for data manipulation and analysis, writing intricate formulas to extract meaningful insights. Worked with SOA architecture and Micro Service Architecture and implemented API integration successfully in projects. Performed various analyses like GAP Analysis, Impact Analysis, Root Cause Analysis, and Cost- Benefit Analysis to validate the feasibility of decisions and strategies and analyzed if the action plans meet the business requirements. Collaborate with DevOps teams to integrate Java Full Stack solutions into continuous integration/continuous deployment (CI/CD) pipelines, ensuring seamless and efficient deployment processes. Assisted in designing orchestrations, creating transactions, and integrating web services and APIs into the Orchestration implementation and performed Data Mapping for creating the orchestration process to generate reports. Prepared Data Mapping to identify and standardize data from the OLTP to OLAP database during Extract Transform Load (ETL) process using Informatica Power Center for better assisting in creating API and Webservices for interaction between systems. Validated the API request and response payloads and assisted developers in API documentation using the Postman and swagger. Utilize SQL queries to extract, transform, and analyze data from various sources. Involved in Daily scrum meetings, Sprint planning, Sprint review and Sprint retrospective, and aided in maintaining artifacts such as Product Backlog, Sprint Backlog and managed to resolve Dependencies and Impediments in every scrum ceremony. Actively engaged business users in the Sprint Review and demonstrated Potentially Shippable Product Increment (PSPI) to validate on agreed requirements as per the defined Definition of Done (DoD) created by myself and business stakeholders. Designed the Test Plan, Test Cases and Test Scenarios for validating Web Services and APIs based on the defined user stories and acceptance criteria and facilitated smoke testing, functional testing, integration testing and regression testing. Strong experience in conducting User Acceptance Testing (UAT) with complete guidance and update release note & runbook for each release as well as reviewing Test Procedures and Creating Test Cases. Facilitated Triage calls to identify defects by performing Root Cause analysis and mitigated it along with the development and testing team. Actively involved in setting up the Orchestration Process within the applications using RESTful Webservices/APIs. Testing ETL process that use flat files, as source and generate flat files in UNIX environments using UNIX command Facilitated System Demo to Inspect and Adapt Minimum Viable Products (MVP), also engaged in Innovation and Planning Workshops, PI Planning, PO Council Meetings and Release Management Meetings. Client: HSBC Bank Location: Arlington, IL Role: Business Analyst Duration: May 2015 - Aug 2018 Project: Loan Origination HSBC Bank, located in Arlington Heights, IL, is a globally recognized banking institution. During my tenure I managed end-to-end processes for loan origination, ensuring compliance with regulatory standards and leveraging analytical skills for continuous improvement in the banking sector. Roles and Responsibilities Managed the end-to-end process of loan origination, ensuring compliance with regulatory requirements and optimizing workflow efficiency. Conducted in-depth business process analysis, identifying security requirements and gaps in existing systems. Analyse financial performance and variances against budgets and forecasts. Worked closely with stakeholders to gather and document security-related business requirements for technology enhancements. Lead the development and enhancement of financial reports and dashboards. Collaborate with UX/UI designers to ensure a seamless and user-friendly digital banking experience. Facilitated communication between technical and non-technical stakeholders, ensuring a comprehensive understanding of security project objectives. Utilize data analytics tools to extract insights from financial data. Collaborate with IT teams to configure and customize ERP systems to meet business needs. Utilized comprehensive third-party software solutions, including but not limited to Metasploit for penetration testing, and Darktrace for continuous monitoring. This helped identify and address potential security threats. Evaluate and recommend technology solutions for mortgage origination, underwriting, servicing, and other related processes. Fostered collaboration among project teams and motivated team members to achieve team and organizational goals. Participate in testing and quality assurance activities for core banking system enhancements. Collaborate with business users to understand data requirements and provide SQL-based solutions. Identified, and guided teams through areas for improvement, including process, development practices, and internal and external impediments. Provide support for ad-hoc data analysis requests using SQL. Client: HDFC Location: New Delhi Role: Business Analyst Duration: 2013 2014 Project: Mobile Banking Enhancements Enhance the mobile banking application to provide users optimizing the user intuitive and user-friendly experience for account setup, fund transfers, and other key banking functionalities. Roles and Responsibilities Act as a bridge between technical and non-technical stakeholders, facilitating effective communication and understanding throughout the project. Elicit and document detailed requirements for the enhanced mobile banking application, ensuring alignment with business objectives and customer needs. Collaborate with internal stakeholders, including project managers, developers, and designers, to communicate requirements and facilitate a shared understanding. Create comprehensive use cases that outline the end-to-end functionality of the mobile application, considering various user scenarios. Ensure the security and efficiency of payment processing systems. Conduct risk assessments related to financial operations and implement risk mitigation strategies. Analyse existing mobile banking processes to identify areas for improvement and optimization in account setup, fund transfers, and related activities. Contribute to the development and maintenance of financial planning and budgeting systems. Define UAT criteria and collaborate with QA teams to ensure that testing aligns with business requirements and user expectations. Collaborate with finance teams to ensure accurate financial forecasting. Work with data teams to map data requirements for new features, ensuring seamless integration with backend systems. Collaborate with UX/UI designers to ensure that the user interface aligns with customer expectations and usability standards Work with Soft Skills Stakeholder Collaboration: Adaptive with cross-functional teams Communication: Strong verbal and written communication skills to effectively interact with stakeholders. Problem-Solving: Skilled in identifying and resolving issues or conflicts that may arise during the procurement process. Attention to Detail: Strong attention to detail when preparing documentation and ensuring accuracy in all aspects of the process. Certifications Certified scrum master SMAC PMP Certification CBAP Tableau Data Analyst Education Bachelor : BBA- Amity University, India Master : MSc. Information Technology, USA Keywords: continuous integration continuous deployment quality analyst user interface user experience business intelligence active directory information technology hewlett packard purchase order microsoft Connecticut Illinois Maryland