Summary
Overview
Work History
Education
Skills
Certification
Contactnumbers
Timeline
Hi, I’m

Rahul Akula

Business Systems Analyst III
Ellicott City,MD
Rahul Akula

Summary

I am Rahul Akula, a results-driven Business Systems Analyst III with over 5+ years of experience, including 3+ years in India and 2+ years in the USA. I specialize in project management, data analysis, workflow optimization, and cross-functional collaboration across diverse industries and technical environments.

Proficient in leveraging advanced Excel functions, including data analysis, pivot tables, and VBA macros, to drive operational efficiency and decision-making. Expertise in creating interactive data visualizations using Power BI to present complex data patterns, trends, and insights to stakeholders. Skilled in data cleansing, transformation, and shaping using Power Query Editor, ensuring data accuracy and consistency for effective visualizations and KPI metrics.

With a proven track record of assisting in data migration projects, I ensure accurate data transfer while maintaining data integrity using Excel and SQL. Adept at leading cross-functional teams to develop comprehensive process maps for complex business operations, ensuring alignment with organizational goals and stakeholder expectations.

Dedicated to continuous improvement, I excel in identifying and implementing enhancements to operational workflows. Proficient in utilizing advanced project management methodologies and tools, I collaborate with vendors and stakeholders to streamline operations and drive efficiency gains. My ability to analyze complex systems and deliver tailored solutions enables me to thrive in dynamic, fast-paced environments. Open to leveraging my skills and experience for impactful opportunities, particularly in India.

Overview

6
years of professional experience
4
Certification
2

Masters

Work History

Exelon Corporation

Business System Analyst III
07.2024 - Current

Job overview

  • Utilized Jira for project management by tracking tasks, managing backlogs, and collaborating with cross-functional Agile teams
  • Collaborated with diverse teams and business stakeholders to spearhead the implementation of Dynamics 365 Finance, focusing on key financial modules and dashboards
  • Delivered ongoing system support and configurations to ensure optimal performance for business units utilizing D365 Finance
  • Designed and developed dynamic financial dashboards in Power BI and Tableau, delivering actionable insights to stakeholders across business units
  • Automated manual processes using tools like Power BI and Advanced Excel, improving efficiency and accuracy
  • Analyzed complex datasets using SQL and created reports to support strategic decision-making
  • Managed document repositories and workflows in SharePoint, ensuring efficient document sharing and version control
  • Led governance and review meetings with vendors and stakeholders to provide project status updates, track deliverables, and align on strategic goals
  • Automated manual Excel processes by transitioning to Power BI, increasing efficiency and reducing errors across workflows
  • Managed and migrated large enterprise financial data (ENP) into Power BI, leveraging it for advanced dashboard creation and analytics
  • Utilized Agile methodologies to drive project delivery, collaborating with cross-functional teams via tools like Jira and Confluence
  • Managed project status updates and reporting, integrating data from platforms like SharePoint and Office365
  • Developed and optimized SQL queries and scripts for data extraction, transformation, and reporting, ensuring accuracy and efficiency across projects
  • Administered and managed SQL Server databases, ensuring high availability and performance for enterprise applications
  • Provided in-depth financial analysis and reports to support strategic planning and project execution
  • Expertly utilized tools like QlikView, Tableau, Power BI, and Advanced Excel for data visualization and business intelligence
  • Collaborated using platforms such as ServiceNow, Microsoft Teams, and SharePoint to manage workflows and enhance productivity
  • Integrated Dynamics 365 with Power BI and other enterprise systems, enabling seamless data flow and comprehensive reporting for informed decision-making
  • Ensured data integrity and reporting accuracy by standardizing processes and implementing governance frameworks in collaboration with stakeholders
  • Environment: SQL, Jira, Power BI, Python, QlikView, Tableau, SQL Server, Service Now, Informatica IDQ, Microsoft Teams, Office365, Advanced Excel, MS Visio, SharePoint, Dynamics 365, Agile, SQL Assistant
  • Interacted with internal customers to understand business needs and translate into requirements and project scope.
  • Gathered, reviewed and reported on findings.
  • Identified needed business improvements and determined appropriate systems required to implement solutions.
  • Assessed business requirements to create focused solutions.
  • Created and maintained standard operating procedures governing system functions and features.

Inovalon Solutions

Business Systems Analyst
02.2024 - 07.2024

Job overview

  • Participated in collaborative brainstorming sessions with diverse stakeholders and business teams to comprehend business requirements
  • Analyzed business requirements and facilitated their elicitation, ensuring alignment with system specifications throughout the development cycle; assisted developers in understanding and implementing requirements
  • Proficient in advanced Excel functions such as data analysis, pivot tables, and VBA macros; created interactive data visualizations using Power BI to elucidate complex data patterns, trends, and insights for stakeholders
  • Skilled in utilizing XML to facilitate structured data exchange, storage, and configuration management, promoting seamless data portability and system interoperability across platforms
  • Engaged in requirements workshops, Joint Application Development (JAD) sessions, and story grooming sessions
  • Authored user stories within Agile projects, prioritizing and refining them while evaluating the impact of scope changes
  • Prepared Business Requirements Documents (BRDs) and obtained approvals from relevant stakeholders; developed Functional Specifications based on BRD-derived functional requirements
  • Elicited, documented, managed and validated business, functional and non-functional requirements throughout entire scope of SDLC lifecycle via waterfall and agile methodologies
  • Performed daily integration and ETL tasks by extracting, transforming and loading data to and from different RDBMS
  • Extensively worked with ad hoc querying/reporting, data analysis and RDBMS
  • Conducted data cleansing, transformation, and shaping using Power Query Editor in Power BI to ensure data accuracy and consistency for visualization and KPI metrics
  • Coordinated with development and testing teams to provide detailed requirement understanding
  • Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing
  • Worked with Quality Control Teams to develop Test Plan and Test Cases
  • Collaborated with cross-functional teams, including IT and marketing, to gather feedback and integrate insights into data analysis and visualization processes
  • Managed data, including confidential records, billing information, and large sets of data, ensuring accuracy, security, and compliance with regulations
  • Served as the IT liaison for projects, facilitating communication between business teams and IT stakeholders
  • Led cross-functional teams in developing comprehensive process maps for complex business operations, ensuring alignment with organizational objectives and stakeholder requirements
  • Environment: SQL, Python, Jira, Confluence, QlikView, Tableau, Oracle, SQL Server, Informatica IDQ, AWS, Amazon EC2, Office365, Advanced Excel, MS Visio, SharePoint, Agile, SQL Assistant
  • Identified needed business improvements and determined appropriate systems required to implement solutions.
  • Collected, defined and analyzed business requirements.
  • Troubleshot incidents reported by end-users to schedule system changes and identify permanent solutions.
  • Offered input for complex documents to support client-ready final versions.
  • Created and maintained standard operating procedures governing system functions and features.

Johnson & Johnson

Senior Business Analyst
02.2023 - 02.2024

Job overview

  • Company Overview: (remote)
  • Collaborated with cross-functional teams to analyze complex revenue issues and implement improvement initiatives aligned with departmental metrics
  • Assessed risks associated with disputes and revenue reconciliation, devising strategies to mitigate them, while remaining adaptable to evolving scenarios
  • Demonstrated strong proficiency in Microsoft Office applications, particularly Excel, Word, PowerPoint, and Power BI
  • Applied finance knowledge and Information Systems expertise to areas including disputes, accounts receivable, deduction management, collections, and supply chain
  • Acted as a subject matter expert in resolving revenue disputes for key accounts, managing the entire resolution process from research to adjustment
  • Possessed regulatory awareness, including familiarity with SOX, GCC, and/or GMP requirements
  • 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)
  • Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis
  • Led revenue-related project initiatives, focusing on addressing root causes of disputes and providing insights to support decision-making
  • Presented data and reports to key stakeholders, tracking dispute resolution progress
  • Provided guidance and escalation support for complex issues, expediting resolution processes
  • Assisted management with analysis and reporting for proactive customer account management, engaging both internal and external partners
  • Utilized Process Excellence tools for root cause analysis and process optimization, leveraging knowledge of Salesforce.com, and Microsoft Excel
  • Demonstrated familiarity with data visualization tools such as Power BI or Tableau
  • Ensured accurate documentation of dispute resolution processes, maintaining compliance with regulations and company policies
  • Supported internal and external audits, including SOX, ensuring documentation accuracy and compliance
  • Orchestrated cross-functional meetings to elicit requirements and guide process mapping exercises, culminating in optimized workflows and heightened operational efficacy
  • Worked independently to prepare User stories, Use cases based on project stakeholders and user requirements using Jira while consistently communicating with QA & IT developer
  • (remote)
  • Environment: Jira, Confluence, Salesforce.com, Oracle, SQL Server, Informatica, LEAN, SOX, GCC, Office365, MS Visio, SharePoint, Agile, SQL Assistant
  • Supported leadership team with reporting, analysis, and business presentations to inform divisional strategies.
  • Interacted with internal customers to understand business needs and translate into requirements and project scope.
  • Assisted with creating data cubes and OLAP models to improve data analysis.
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Developed data mining algorithms to identify and classify patterns in data.

Kotak Banking and Insurance

Business Analyst
06.2018 - 07.2021

Job overview

  • Company Overview: India
  • Gather technical requirements by coordinating with IS team and translating them to system requirements, reviewed change with Product Owner and stakeholders
  • Responsible for identifying vendors which offer property specific data such as year built, location, building type, construction type, material and geolocation and delivered data insights using QlikView
  • Collaborate with stakeholders, Cost-to-Serve (CTS) and Project Management to draft Project scope for Analytics solutions
  • Design and implement data visualization techniques in Excel to effectively communicate data findings to non-technical stakeholders
  • Assisted in data migration projects, ensuring accurate data transfer and maintaining data integrity through proficient use of Excel and SQL
  • Reviews of Visual Basic code to identify bugs, inefficiencies, and adherence to coding standards, ensuring high-quality and reliable software solutions for banking systems
  • Act as a liaison between the business stakeholders and technology teams, translating regulatory requirements into functional specifications for the development of AML/KYC/FINCEN-related software applications or enhancements
  • Assist in the development and implementation of automated systems and technologies to enhance the efficiency and CDD (Customer Due Diligence) and EDD (Enhanced Due Diligence) processes within the bank
  • Building scope and PaaS solution requirements for big data analytics using unstructured data, documented system requirements for Reporting changes and merge, deliver new feature enhancements to enterprise Reports
  • Lead the data analysis of property specific attributes from these vendors and qualify them for a proof of concept, identify gaps on Prospect 360 database such as Fill Rate, Hit Rate, etc
  • Collaborating with law enforcement agencies, internal stakeholders, and external partners to mitigate fraud risks
  • Use Informatica Mapping Designer to evaluate reusable mappings, created tasks for data synchronization and built reusable mappings with parameterized values to generate reports
  • Ensuring compliance with applicable laws, regulations, and industry standards related to fraud prevention and anti-money laundering (AML)
  • Responsible and resolved technical issues in the implementation of APIs, used Postman and Splunk to read errors in API response, validate credentials, version and app credentials to authenticate
  • Chaired various meetings, trained testers of another team on various data transformation documents
  • Analyze data related to the banking processes to identify trends, patterns, and areas for improvement
  • Data-driven insights can be valuable in decision-making
  • Assumed ownership and accountability for the assigned deliverables through all the phases of SDLC
  • India
  • Environment: Jira, Confluence, QlikView, Oracle, SQL Server, Informatica IDQ, AWS, Tableau, Amazon EC2, Office365, MS Visio, SharePoint, Agile, SQL Assistant
  • Interacted with internal customers to understand business needs and translate into requirements and project scope.
  • Developed and maintained data warehouses and data marts to support business operations.
  • Updated and developed scripts and queries to extract and analyze data from multiple sources.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Utilized data visualization techniques to present and explain complex data sets.
  • Implemented business intelligence solutions to increase operational efficiency.

Education

Gannon University
Erie, Pennsylvania

Master's Degree from Business Analytics
12-2022

University Overview

Chaitanya Bharati Institute of Technology
Hyderabad, India

MBA from Finance and HR
05-2018

University Overview

St Mary Centenary College
Hyderabad, India

Bachelor's Degree from Computer Science
05-2016

University Overview

Skills

  • Agile expertise
  • Requirements gathering
  • Data Migration
  • Project Management
  • Large Data sets
  • MS Excel
  • MS Office
  • Power BI
  • Tableau
  • Process Mapping
  • Revenue/Expense Analysis
  • Dynamics 365
  • ServiceNow
  • System Analysis
  • Workflows
  • XML
  • SQL
  • Python
  • Enterprise resource planning
  • Workflow design
  • IT strategy development
  • User acceptance testing
  • Software testing
  • Technical tool development
  • Stakeholder management

Certification

  • Salesforce Certified Administrator, 11/22
  • Salesforce Certified Platform Developer I, 11/22
  • Microsoft Certified: Azure Database Administrator Associate, 09/24
  • Microsoft Certified: Power BI Data Analyst Associate, 09/24

Contactnumbers

Contactnumbers
+91 9701411234, +1 (385) 358 6120

Timeline

Business System Analyst III
Exelon Corporation
07.2024 - Current
Business Systems Analyst
Inovalon Solutions
02.2024 - 07.2024
Senior Business Analyst
Johnson & Johnson
02.2023 - 02.2024
Business Analyst
Kotak Banking and Insurance
06.2018 - 07.2021
  • Salesforce Certified Administrator, 11/22
  • Salesforce Certified Platform Developer I, 11/22
  • Microsoft Certified: Azure Database Administrator Associate, 09/24
  • Microsoft Certified: Power BI Data Analyst Associate, 09/24
Gannon University
Master's Degree from Business Analytics
Chaitanya Bharati Institute of Technology
MBA from Finance and HR
St Mary Centenary College
Bachelor's Degree from Computer Science
Rahul AkulaBusiness Systems Analyst III