Home

Aravinda Pandanaboyana - Business Analyst

[email protected]

Location: Alpharetta, Georgia, USA

Relocation: open for Relocation anyhere in USA

Visa: GC

Strategic and results-oriented business analyst with nearly 9 years of experience in software development, business analysis, and project management across the mortgage, finance, insurance, aviation, retail, and healthcare IT industries. Well-versed in SDLC methodologies and Product Lifecycle Management, including Agile and Waterfall models. A strong communicator and change agent adept at managing multiple priorities in fast-paced environments. Business Analysis: Proficient in requirements gathering, backlog grooming, process modeling, and change management to align development with business needs and enhance system usability. Scrum Practices: Experience with user stories, story slicing, backlog grooming, release planning, sprint planning, sprint review, and sprint retrospective. Project Management: Able to conduct SWOT and cost-benefit analyses. Extensive knowledge of Gantt charts, scheduling, resource planning, critical path method, risk analysis, and risk management. Process Management: Direct requirements gathering, process flow, functional process flow, process modeling, process re-engineering, and change management. Document enhancement requests with a keen awareness of developer needs and end-users and effectively engage with clients. Application Design: Facilitate application design (prototyping, screen mockups), wireframes, UI design. Possess considerable knowledge in the analysis, design, and re-engineering of system applications and business processes. Utilize structured system analysis methodologies, implementing business controls, diagramming data, and mapping processes, applying Unified Modelling Language (UML) diagrams. Data Analysis: Conduct data analysis, data mapping, logical data modeling. Created class diagrams, entity-relationship (ER) diagrams and used SQL queries to filter data within database. Testing: Oversee unit testing, end-to-end testing, system testing, regression testing, and User Acceptance Testing (UAT). AREAS OF EXPERTISE Agile Methodology Scrum Project Management Data Analysis Requirement Gathering Change Management Business Process Flow Data Mapping Documentation User Stories System Testing Sprint Planning Implementation Quality Assurance (QA) Communication UI Design UML Wireframes Data Modeling Data Visualization Software Testing Go-Live and Post Go-Live Support Deployment Support Technical Writing and Documentation Identity Life Cycle Management Process Product Lifecycle Management SKILLS Languages: C, C++, Java, SQL Software: SAP-ERP, SAP Success Factors, MS-Office, MS Access, MS-Project, Minitab System: Windows 98/2000/XP/7/8/10, Mac OS Databases: Oracle Server, MS SQL Server, Postgre SQL, MySQL Methodologies: Agile, Waterfall, RUP, Scrum, Kanban Visualization: MS Visio, Creately, Rational Rose, Zoho, Tableau, Lucid Chart, Invision, Power BI Testing: HP Quality Center (HPQC), Load Runner, JIRA, Confluence, ServiceNow, TFS Other: JIRA, Rally, Rational Clear Case, Work Brain, SharePoint, Aha, AEM, Workday, Kronos, Azure EXPERIENCE Business Analyst American Airlines | Atlanta, GA OCT 2022 Current The project involved migrating employee populations in legacy US Airways and AA systems into a single cloud-based platform. Employees were moved based on their calc groups and airport codes. Based on the new changes user stories were written to accommodate premium rates to employees. Collaborate extensively with Development and QA teams to elicit and document technical requirements for system updates, ensuring compliance with union policies regarding employee benefits, including the management of COVID Leave of Absences. Utilize various requirements elicitation techniques, including interviews, workshops, and observation, to gather comprehensive business requirements and ensure alignment with stakeholder needs. Optimize end-to-end cash management processes by integrating cash forecasting, payroll scheduling, and benefits disbursement into the migration project, ensuring alignment with financial controls and maximizing cash flow efficiency across the value chain. Develop and document comprehensive workflows utilizing Entity Relationship Diagrams (ERDs), flowcharts, and sequence diagrams to enhance the clarity of processes for both technical and business stakeholders, facilitating improved communication and understanding. Create detailed use cases to illustrate user interactions with the system and clarify functional requirements, enhancing the overall design process. Proactively address system-related issues through analytical problem-solving techniques, ensuring operational continuity and minimal disruption for end users. Plan, execute, and facilitate User Acceptance Testing (UAT) sessions to validate that the system meets business needs, ensuring stakeholder satisfaction. Work closely with UX and data teams to foster strong stakeholder relationships, ensuring alignment between design mockups, data mappings, and overall user/business requirements. Conduct in-depth data analyses leveraging SQL queries and AI-driven analytics tools to validate payroll and attendance data, demonstrating a strong proficiency in data manipulation and analysis to support accurate reporting and decision-making. Integrate AI technologies to enhance data analysis and reporting processes, enabling predictive analytics and better decision-making capabilities. Define user stories, develop test plans, and lead deployments within the Software Development Life Cycle (SDLC), adhering to agile practices for iterative development and continuous improvement. Manage change effectively by preparing communication plans and training materials to support system transitions, facilitating user adoption. Design and manage API integrations to ensure seamless compatibility between systems, focusing on effective data exchange and real-time synchronization. Document detailed technical requirements, process flows, and integration specifications to provide future reference for development and testing teams, showcasing robust technical writing skills. Utilize data modeling techniques to represent data relationships and structures, ensuring data integrity and effective usage. Leverage CRM systems such as Salesforce, Microsoft Dynamics, and HubSpot for effective management of client interactions and data analytics. Generate actionable insights from CRM and other data sources using data visualization tools such as Power BI and Tableau, empowering data-driven decision-making across the organization. Demonstrate strong stakeholder management skills by identifying key stakeholders, understanding their needs, and managing their expectations throughout the project lifecycle. Business Analyst Ategrity Specialty Insurance Company| Scottsdale, AZ Sept 2021 Sept 2022 To improve the business function and expand the business, the company needs a revamp to the website where several lines of insurance can be covered. The website would feature issuing policies, tracking claims in all 50 states in the United States for several lines of insurance. The website would provide a seamless, efficient, and user-friendly experience for the customers to file their claims and issue policies. Resolved a system flaw affecting insurance policy terms by gathering requirements, writing user stories, creating prototypes, and wireframes to redesign documents, resulting in increased revenue and agent/broker registries to 500. Developed dashboards and automated report generation with the development team, reducing manual processing time by 30%, which improved workflow efficiencies through effective data analysis. Gained experience working with Guidewire Technology to process claims, showcasing knowledge of software development lifecycle (SDLC). Tracked tickets logged through the KANBAN board and coordinated with the offshore development team to enhance stakeholder management and project management efficiency. Drafted Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Business Flow Diagrams, Activity/State Diagrams, and Sequence Diagrams to chart processes effectively, demonstrating strong process analysis skills. Collaborated with product owners to write and prioritize user stories for product backlogs and worked with the UX team to create designs and mockups, enhancing stakeholder engagement. Implemented SQL queries for quality assurance testing and report/data validation; set up definitions and processes for test phases, including Product, Integration, System, and User Acceptance Testing (UAT). Familiar with password rotations, password malfunctions, account creations, account changes, application integrations, and maintaining/creating new digital password vaults, demonstrating problem-solving skills in system security. Created user manuals and training documents for end-users and assisted in training programs, showcasing strong communication skills and technical documentation capabilities. Business Analyst BJ's Wholesale Club | Boston, MA June 2018 August 2021 This B2B e-commerce project was to upgrade B2C/B2B Ecommerce and integrate its functionalities to the Sterling Order Management System (OMS), Fulfillment and Supply Chain systems, which is using Ecommerce platform would help Vendors and Partners access areas of Product Delivery and Return, Invoicing over a secure web portal. Participated in Agile Planning Sessions, Daily Agile Scrums, Biweekly Sprint Planning, Retrospective Sessions, and Business Demonstrations to facilitate decision-making for the release of sprint outputs to production, showcasing strong Agile methodology skills. Led a team of Data Analysts and Engineers to collate, report, and interpret data, generating actionable insights and enhancing data analysis capabilities. Produced monthly reports that included key metrics, financial results, and variance reporting, as well as reconciled financial reports to ensure accuracy and transparency in financial analysis. Collaborated closely with peers and ETL Leads/Managers to perform detailed data requirements analysis, create design specifications, and maintain operational documentation, demonstrating proficiency in technical documentation and requirements gathering. Optimized SQL statements executed by ETL code to improve performance, showcasing a solid understanding of data manipulation and analysis techniques. Pre-processed data in Tableau to create on-demand visualizations by querying data from SQL Server, emphasizing skills in data visualization and reporting. Organized meetings with Subject Matter Experts (SMEs) and Data Owners to review findings and determine data cleansing processes, ensuring effective stakeholder management and communication. Worked with Content Management Systems (CMS) such as AEM to document front-end and back-end requirements and regularly update documentation, demonstrating knowledge of system integration and requirements documentation. Developed Epics and Themes for the Scrum Project as the product owner, highlighting expertise in backlog management and prioritization. Devised and prioritized the Product Backlog by conducting requirement churning sessions with Business/Product Teams, ensuring alignment with business goals and customer needs. Facilitated the creation of wireframes and the final design of the system's user interface (UI), demonstrating strong process mapping and user experience design skills. Business Analyst Humana Health | Houston, TX Jan 2017 May 2018 Implemented FHIR-based data integration at Humana Health, enhancing EHR interoperability across systems. Collaborated with cross-functional teams to design secure RESTful APIs and data workflows, ensuring compliance with healthcare standards and improving data flow efficiency. Used Agile project management to drive planning, stakeholder alignment, and sprint execution, resulting in streamlined, user-focused solutions. Developed Power BI and SAS Viya analytics to support data-driven decision-making and deliver actionable insights. Led the integration of Fast Healthcare Interoperability Resources (FHIR) for streamlined Electronic Health Record (EHR) data exchange, enhancing interoperability across healthcare systems. Developed and optimized RESTful APIs to support secure data transfer. Designed and implemented ETL processes using Informatica for FHIR data mapping and compliance with standards like US-CORE and US-CDI. Utilized SQL Server, AWS, and DB2 for managing and optimizing healthcare data workflows. Facilitated project planning, risk management, and sprint retrospectives in Agile environments, using tools like JIRA and Trello for tracking progress and prioritizing product backlogs. Developed JIRA reports to provide insights into issue resolution rates and team velocity. Authored detailed technical and functional specifications, user stories, and wireframes to guide system integration, ensuring clarity in data flow, API requirements, and security protocols. Managed collaborative documentation on Confluence and implemented Git for version control. Collaborated on implementing FINEOS Claims workflows to align healthcare claims processing with insurance industry best practices, including standardizing claims intake, assessment, and reporting. Assisted in configuring FINEOS AdminSuite to manage policy data, enabling smooth integration between policy administration and claims workflows. Defined business rules to enhance policy accuracy and improve data management practices. Developed Power BI dashboards for claims and EHR data visualization, applying DAX and KPI metrics to provide actionable insights. Created complex queries and reports using SAS Viya for data analysis and enhanced business decision-making. Conducted requirements gathering, impact analysis, and joint application design (JAD) sessions, working closely with end-users to ensure user-centric solutions. Trained stakeholders on SAS Viya tools, FINEOS AdminSuite functionalities, and FHIR integration. Business Analyst Loan Origination Bank of New York Mellon| Houston, TX Oct 2015 Dec 2016 The project involved working with numerous teams to develop an enterprise Web-based interface system supporting primarily the mortgage loan origination and processing business areas. This application allowed users to maintain and set-up account information, loan origination, and many other business areas including loan servicing. The capacity of the project was to create an integrated solution to replace the existing isolated systems. Led bi-weekly Agile ceremonies, including Sprint Planning, Daily Stand-ups, and Retrospectives, facilitating effective business requirement gathering and promoting iterative development practices. Developed Agile Functional Specification Documents (FSD) by authoring user stories and acceptance criteria that accurately captured customer requirements, expectations, and recommended technical solutions, demonstrating expertise in requirement elicitation. Actively engaged in SCRUM meetings with Subject Matter Experts (SMEs) and the Project Manager, reinforcing agile project management methodologies and fostering continuous improvement. Managed "incident/service now" tickets, utilizing ticketing systems for issue tracking and resolution, ensuring prompt service management and effective problem resolution. Contributed to the full project lifecycle by analyzing functional requirements, performing system design, supporting development efforts, conducting testing phases, and facilitating implementation activities, showcasing a robust understanding of the software development lifecycle (SDLC). Collaborated with Business Users and the Development team to configure test environments, create test data sets, and establish backend integration points, enhancing overall system testing and validation processes. Executed SQL queries to perform data validation, analyze datasets, and reconcile discrepancies between user interface outputs and database records, demonstrating advanced data analysis and manipulation skills. Identified, assessed, and mitigated potential project risks through quantitative and qualitative analysis, reinforcing the importance of risk management in project execution. Ensured compliance with banking regulations and industry standards related to mortgage origination, including adherence to the Dodd-Frank Act and RESPA guidelines, emphasizing a strong focus on regulatory compliance. Participated in User Acceptance Testing (UAT) to validate that system functionalities aligned with business requirements and user expectations, facilitating quality assurance processes. Supported change management initiatives by developing training materials, conducting end-user training sessions, and providing ongoing support to promote system adoption and minimize resistance to change. Designed and documented detailed process flows, data models, and system architecture diagrams to ensure clarity in system functionalities and enhance technical documentation standards. Identified and analyzed opportunities for process optimization within the loan origination workflow, employing methodologies such as Lean and Six Sigma for continuous improvement. Developed and implemented End-to-End value chain strategies in cash management, optimizing cash flow visibility and control across the organization by ensuring seamless integration between treasury operations, accounts receivable, accounts payable, and financial reporting. Leveraged collaboration tools like JIRA and Confluence for Agile project management, issue tracking, and documentation, enhancing team collaboration and transparency throughout the project lifecycle. EDUCATION Masters in Computer Science and Engineering the University of Texas (2014-2016) Bachelor in Technology Computer Science University of Delhi (2010 2014) Keywords: cprogramm cplusplus quality analyst artificial intelligence user interface user experience business intelligence information technology golang hewlett packard microsoft Arizona Georgia Massachusetts Texas