Business Analyst Process
Resume:
Vanaja Dunna
*************@*****.***
Sr. Business Analyst
PROFESSIONAL SUMMARY:
Over 10 years of experience as an IT Business Analyst, specializing in business process analysis, requirements management, and the implementation of ERP systems, including JD Edwards and financial applications.
Expertise in gathering, documenting, and analyzing business requirements for commercial lending, focusing on risk rating and banking domain, and translating them into functional and technical specifications.
Proven track record in managing the entire software development lifecycle (SDLC) from requirements gathering to functional design, testing, and user acceptance testing (UAT), ensuring successful project delivery.
Proficient in creating EPICs, Features, and User Stories to document requirements, ensuring clear communication between business stakeholders and technical teams.
Extensive experience in collaborating with product owners, business users, and cross-functional teams to understand and prioritize requirements, driving results through teamwork and consensus.
Skilled in supporting the implementation of projects, process improvements, and system enhancements in the banking and finance domain.
Adept at identifying business needs, conducting gap analysis, and proposing solutions that enhance system functionality, streamline processes, and improve financial reporting.
Strong problem-solving and analytical abilities, with the capacity to define issues clearly and devise innovative solutions in a fast-paced, high-demand environment.
Committed to continuous learning, staying updated on emerging technologies, banking trends, and regulatory requirements to ensure the business remains competitive and compliant.
Excellent written and verbal communication skills, ensuring that requirements are documented thoroughly and communicated clearly to both business stakeholders and technical teams.
TECHNICAL SKILLS:
Business Analysis & Requirements Management: Requirement Gathering, Functional & Technical Specifications, Business Process Analysis, Use Case Development, Change Management, Test Plan Creation, UAT Management, JIRA, Azure DevOps, EPICs, Features, User Stories.
ERP & Finance Applications: JD Edwards, ERP Implementation, Finance Systems Integration, Business Rules in ERP, Financial Reporting, Accounting Systems, Commercial Lending, Risk Rating Models.
ITSM & Service Management: ITIL, Service Desk Management, ITSM Process Definition, Incident Management, Change Management, Problem Management.
Data Analysis & Reporting: SQL, Microsoft Excel, Power BI, Tableau, QlikView, Data Models, Data Maps, Reporting, Business Intelligence.
Testing & QA: Test Strategy, Test Plans, Test Case Development, Cross-functional Testing, UAT, Test Automation Tools (TestComplete).
Project Management & Collaboration Tools: JIRA, Confluence, SharePoint, Microsoft Teams, Project Server, Trello, Microsoft Project.
Process Modeling & Documentation Tools: Microsoft Visio, Lucidchart, BPMN, Wireframing, Prototyping Tools.
Software Development Methodologies: Agile, Scrum, Waterfall, SDLC, Application Lifecycle Management (ALM), Continuous Integration/Continuous Deployment (CI/CD).
Cisco Partner Ecosystem Tools: Proficient in using PXP and Commerce tools for partner engagement and operations.
Data Analysis & Reporting: Expertise in analyzing datasets, preparing actionable reports, and delivering insights to stakeholders.
Partner Program Management: Strong understanding of partner rebates, certifications, and recurring revenue metrics.
PROFESSIONAL EXPERIENCE:
Client: GEICO, Chevy Chase, MD
Role: Sr. Business Analyst Nov 2022 to Present
Acted as the lead IT Business Analyst for multiple projects in the commercial lending domain, with a focus on risk rating and banking functionality, gathering business requirements and creating detailed documentation to guide development efforts.
Collaborated with product owners, business stakeholders, and cross-functional teams to understand and gather complex business requirements, ensuring alignment with business objectives and technical feasibility.
Managed the creation and maintenance of functional and technical specifications, including EPICs, Features, and User Stories, to ensure clear, structured communication across all teams.
Coordinated closely with business stakeholders to assess and document business needs related to commercial lending, specifically risk rating processes and banking compliance, translating these into actionable technical requirements.
Led the development of comprehensive test plans and test cases, collaborating with SMEs to perform cross-functional testing and ensure solutions met business requirements and regulatory standards.
Supported the execution of user acceptance testing (UAT) by collaborating with end-users to define scenarios, track issues, and ensure resolution, while maintaining detailed UAT documentation for future reference.
Worked with internal and external technical teams to integrate JD Edwards with other banking systems, enhancing business processes, and improving financial reporting capabilities.
Managed process improvements across commercial lending systems, leading efforts to streamline loan origination and risk rating processes through system enhancements and optimization initiatives.
Facilitated workshops and meetings to gather requirements, refine processes, and drive change in alignment with Agile methodologies, ensuring timely delivery of high-priority features.
Assisted in managing the implementation of new features and enhancements, working with cross-functional teams to address issues, resolve blockers, and ensure smooth deployments.
Provided ongoing production support, ensuring continuous improvement and resolution of post-deployment issues through effective collaboration with technical and business teams.
Played a pivotal role in managing project documentation, ensuring proper traceability and compliance with banking regulations and internal policies.
Actively participated in sprint planning and backlog grooming sessions, ensuring the team’s focus aligned with business priorities and deadlines.
Developed and maintained dashboards and reporting tools using Power BI to enable informed decision-making by senior management and business stakeholders.
Led user training sessions, ensuring stakeholders were proficient in new system functionalities and reporting tools like Power BI and Excel.
ENVIRONMENT:
SQL, Excel, Power BI, JIRA, Azure DevOps, Microsoft Visio, BPMN tools, Confluence, SharePoint, Microsoft Teams, GIT, Lucidchart, Azure, Git, Power Platform, Tableau, QlikView, PowerPoint, Microsoft Project, Trello, Team Foundation Server, WebEx.
Client: HCSC, Chicago, IL
Role: Business Analyst Dec 2021 to Jun 2022
Roles & Responsibilities:
Conducted comprehensive competitive analysis and monitored market trends using SQL and Power BI, enhancing strategic planning and decision-making processes.
Developed strategic business plans utilizing the SWOT analysis framework, employing Excel to analyze strengths, weaknesses, opportunities, and threats.
Analyzed business problems and documented processes to develop requirements, user stories, and acceptance criteria for software development projects.
Managed project timelines and resource allocation with Gantt charts, effectively coordinating tasks through Trello for project tracking.
Conducted regular sprint reviews and retrospectives using Azure DevOps, fostering a culture of continuous improvement and team accountability.
Developed detailed release notes and documentation within Azure DevOps to communicate changes and enhancements to stakeholders effectively.
Engaged in iterative development cycles, delivering incremental improvements and regularly releasing working software to gather user feedback.
Facilitated user acceptance testing (UAT) sessions with business stakeholders, gathering feedback and ensuring the solution meets user requirements and expectations.
Developed complex SQL queries and reports using Oracle SQL and PL/SQL to support business intelligence initiatives, providing actionable insights to stakeholders.
Created detailed reports and presentations summarizing market risk findings, providing actionable recommendations for risk mitigation strategies.
Administered JIRA projects, configuring workflows, issue types, and custom fields to align with team processes and project requirements.
Created and managed user stories, tasks, and bugs within JIRA, ensuring clear documentation of work items and tracking of progress.
Fostered a culture of continuous improvement by conducting sprint retrospectives, identifying areas for enhancement, and implementing actionable changes in subsequent sprints.
Developed and maintained system documentation to ensure compliance with project requirements and facilitate stakeholder understanding.
Monitored and analyzed project metrics using Azure DevOps analytics tools to identify trends and areas for improvement, driving data-informed decision-making.
Provided ongoing support and troubleshooting for ERP users, addressing issues and implementing enhancements based on feedback.
Monitored ongoing market developments and communicated relevant insights to stakeholders, ensuring they remain informed about emerging risks.
Assisted in change management initiatives to ensure smooth transitions during ERP upgrades and process changes.
Created performance metrics dashboards in Power BI, integrating data from SQL Server to monitor and report project success.
Developed user training materials and conducted workshops on system functionalities, empowering users to leverage the systems effectively.
Emphasized the importance of automated testing and continuous integration within the Agile framework, enhancing code quality and deployment speed.
Conducted detailed business analysis to inform strategic decisions, optimizing service delivery and overall performance.
Environment: SQL, Power BI, Excel, Gantt charts, Trello, Webex, Oracle SQL, PL/SQL, R, Python, Agile, Git, Confluence, D3.js, MATLAB, Apache Spark.
Client: Lowe's, Mooresville, NC. Feb 2020 to Nov 2021 Role: Business Intelligence Analyst
Roles & Responsibilities:
Developed SQL-based reports to meet specific business requirements, utilizing Power BI for dynamic visualization.
Managed ETL processes and data integration using Informatica, facilitating efficient data movement and transformation.
Created predictive analysis models to forecast business trends, employing R for statistical modeling and analysis.
Collaborated with business stakeholders to define project objectives, aligning them with business requirements using Excel.
Ensured adherence to Agile best practices and principles, promoting an Agile mindset across the team and organization.
Collaborated with cross-functional teams and stakeholders to identify and implement data-driven solutions, enhancing partner ecosystem efficiency.
Utilized Cisco tools, including PXP and Commerce tools, to manage partner engagements, streamline processes, and support certification workflows.
Conducted detailed data analysis and prepared comprehensive reports to monitor partner rebates and recurring revenue metrics, ensuring actionable insights.
Resolved partner queries promptly, maintaining compliance with SLA requirements and driving partner satisfaction.
Implemented strategies to optimize partner certifications and rebate structures, aligning with organizational goals.
Thrived in a fast-paced environment, ensuring seamless collaboration and timely project delivery across diverse business units.
Led business analysis efforts for the implementation of JD Edwards ERP systems, working closely with finance teams to automate and improve financial reporting and accounting functions.
Conducted detailed business process analysis to identify system requirements, creating process flows and wireframes to support system design and implementation.
Partnered with business units to define functional specifications, converting high-level business requirements into actionable user stories and acceptance criteria.
Facilitated UAT sessions, collaborating with business stakeholders to ensure that newly implemented ERP functionalities met business requirements and compliance standards.
Developed project-related documentation including system requirements, test plans, training manuals, and post-implementation support documents.
Managed testing across cross-functional teams to ensure successful integration and deployment of JD Edwards ERP with minimal disruption to financial operations.
Leveraged ITIL best practices to manage incident, change, and problem management processes within the scope of IT service management (ITSM).
Tracked and monitored project milestones using tools like JIRA, ensuring that timelines and deliverables were met while maintaining transparency and stakeholder communication.Coordinated with technical teams to ensure accurate data reporting, leveraging SQL Server for backend support.
Enhanced data reporting processes to support business objectives, integrating Informatica and SQL Server for seamless data flow.
Supported business objectives alignment using SAP for enterprise resource planning and data management.
Utilized Azure Data Warehousing solutions to manage large datasets, optimizing data storage and access.
Implemented Azure Blob Storage for scalable cloud storage solutions, enhancing data accessibility and security.
Monitored and analyzed digital media performance metrics using R, providing insights into content effectiveness and audience engagement.
Managed version control and workflow coordination using GIT, ensuring consistency and collaboration across project phases.
Delivered training sessions on new data tools and platforms using Webex, enhancing team capabilities and project outcomes.
Environment: Power BI, Informatica, R, Excel, SQL Server, SAP, Azure Data Warehousing, Azure Blob Storage, SharePoint, Azure Analytics, JIRA, R, GIT, Webex.
Client: Metalyst Forgings Limited, India Jul 2017 to Oct 2019 Role: Business Analyst
Roles& Responsibilities:
Analyzed data trends to provide deep insights into business performance, employing SQL for effective data querying.
Developed business dashboards using Tableau, visualizing key performance indicators to inform strategic decisions.
Conducted requirement meetings to gather crucial project specifications, utilizing collaborative tools like Microsoft Excel.
Collaborated with team members to ensure accuracy and completeness of documentation, using SharePoint for centralized access.
Implemented predictive modeling using MATLAB and SAS to accurately forecast business trends and outcomes.
Developed strategic business recommendations based on comprehensive data analysis, employing Python for statistical insights.
Employed D3.js to create complex data visualizations for stakeholder presentations, enhancing data communication.
Worked closely with IT teams to configure and customize CTRM systems, adapting them to meet evolving business needs and market conditions.
Monitored and analyzed scheduling systems to ensure compliance with North American ISO market requirements, facilitating accurate bidding and auction processes.
Assisted in the implementation of Straight Through Processing (STP) solutions within scheduling systems to optimize transaction handling and improve operational workflows.
Created and maintained comprehensive documentation of RDBMS structures, processes, and standards to support knowledge sharing and project continuity.
Developed stored procedures and triggers within the RDBMS to automate data processing tasks and enforce business rules effectively.
Managed project documentation and coordinated requirement gathering efforts using Confluence for collaboration and version control.
Supported collaborative teamwork to align project objectives with business goals, using Agile methodologies for project management.
Utilized Python to perform statistical analysis, enriching data insights and supporting business decision- making processes.
Applied SAS for advanced statistical analyses, identifying patterns and trends that influenced business strategies.
Created interactive and informative dashboards using Tableau, providing stakeholders with real-time business insights.
Facilitated data-driven discussions and decision-making processes during requirement meetings using SQL insights.
Ensured data integrity and accuracy in all reports and analyses, utilizing robust validation techniques in MATLAB.
Coordinated with cross-functional teams to align data analysis efforts with overall business strategies using JIRA for task management.
Led the development of data infrastructure improvements, leveraging Python scripting to automate data processes.
Enhanced data visualization capabilities using D3.js, providing detailed and engaging presentations to stakeholders.
Managed version control and documentation using GIT, ensuring reliability and consistency across data projects.
Environment: SQL, Tableau, Microsoft Excel, SharePoint, MATLAB, SAS, Python, D3.js, Confluence, Agile methodologies, JIRA, GIT.
Client: Xebia IT Architects India Pvt Ltd, India Mar 2015 to Jun 2017 Role: Data analyst
Roles & Responsibilities:
Managed PostgreSQL databases to support robust data analysis and reporting initiatives, enhancing data accessibility and integrity.
Utilized Microsoft Excel and QlikView for effective dashboarding and data visualization, facilitating data- driven decision-making.
Employed Apache Hadoop for big data processing, improving data handling capabilities for large-scale analytics projects.
Created detailed reports to inform strategic decision-making and operational improvements, using SQL for data querying.
Provided training and support to team members on RDBMS best practices, fostering a culture of continuous learning and improvement.
Implemented ETL processes using Informatica to streamline data integration and improve data quality.
Developed comprehensive documentation to support analytics implementations, using Confluence for knowledge sharing.
Collaborated with cross-functional teams to ensure successful execution of trades, settlements, and invoicing processes within CTRM and scheduling systems.
Developed and maintained documentation for CTRM and scheduling processes, ensuring clarity and consistency in operations across teams.
Utilized GIT for version control in analytics projects, ensuring data consistency and project continuity.
Analyzed large datasets to derive actionable business insights, leveraging the processing power of Apache Spark.
Supported project implementation phases with detailed documentation and reports, using Microsoft Excel for data compilation.
Created powerful business intelligence solutions using Power BI, integrating diverse data sources for comprehensive analysis.Ensured high data quality and integrity in analytical reports, employing rigorous validation techniques in PostgreSQL.
Leveraged QlikView for interactive data visualizations, enhancing user experience and data interpretability.
Coordinated with technical and business teams to ensure seamless integration of new analytics solutions.
Maintained and updated ETL processes as per business requirements, using Informatica for efficient data transformations.
Managed data security and compliance protocols, ensuring the protection of sensitive information during data processing.
Environment: PostgreSQL, Microsoft Excel, QlikView, Apache Hadoop, SQL, Informatica, Confluence, Git, Apache Spark, Power BI.
Contact this candidate