Business Analyst Power Bi

Indumathi Gopala Krishna Raju Email: ad5oqa@r.postjobfree.com

Business Analyst Mobile: 954-***-****

Professional Summary:

Dynamic and results-driven Business Analyst with over 6 years of diverse experience across domains, including fuel pricing and e-commerce catalog management. Leveraging advanced analytical skills and proficiency in tools such as Advanced Excel, XL Miner, Power BI, and query language, I am dedicated to contributing significantly to the strategic goals and growth initiatives of forward-thinking organizations. With a proven track record in pricing analysis, process advisory, and catalog management, I am poised to bring a multifaceted skill set to drive data-driven decision-making and operational excellence.

Technical Skills:

Data Analysis

SQL Queries (Oracle 12c), SAP HANA

Requirement Management:

MS Office, MS Excel, Atlassian Jira, SharePoint, Agile Methodology

Data Modeling:

SQL Queries, MS Visio, Jira, advanced analytics tools (R, SAS)

BI and Reporting:

MS Excel, XL Miner, Power BI, Tableau, SAP Business Objects

Programming tools:

Python, R or SAS

Digital Marketing and Analytics:

Google Analytics

Testing Tools:

ALM Software, Version Control System (e.g.Git)

Others:

IBM Watson Studio

Education:

Masters in Business Analytics, Florida Atlantic University, Boca Raton, Florida Dec 2023

Course Work: Advanced Business Analytics, Business Innovation and Artificial Intelligence, social media and Web Analytics, Data Management and analysis with Excel

Bachelor of Business Management in Finance, Bangalore University, Karnataka, India May 2015

Awards:

Performance Excellence Award –Accenture Pvt Ltd, 2017,

Passion for Customer - Hewlett Packard Inc, 2016

Process Champion and Exceeding Everest Award -Hewlett Packard Inc, 2016

Professional Summary:

Client: Envision, Plantation, Florida Apr’ 2023- Till date

Role: Business Analyst

Responsibilities:

Collaborated with stakeholders to define detailed requirements for the HIX system, incorporating knowledge of ACA and Medicaid regulations.

Document requirements using various formats such as User Stories, Functional Specification Documents (FSD), and Business Requirement Documents (BRD) to guide the development process.

Ensured compliance with applicable laws and regulations, including HIPAA, PPACA, and Medicaid guidelines.

Conducted compliance analysis to ensure the HIX system meets regulatory standards and requirements.

Conducted market analysis to identify trends, opportunities, and challenges within the healthcare industry and the HIX market.

Performed competitor analysis to assess the strengths and weaknesses of competing products or solutions.

Organized and facilitated meetings with external clients and internal teams to gather requirements, provide updates, and address concerns.

Ensured effective communication and collaboration between stakeholders in the HIX system project.

Worked closely with the UI/UX team to translate requirements into intuitive, user-friendly designs.

Defined wireframes and visual elements that accurately reflect the functionality and user experience of the HIX system.

Provided on-site support and consultation to clients, ensuring their requirements are understood and addressed.

Client: Advance Auto Parts, Roanoke, Virginia Nov 2021 – Feb’ 2022

Role: Business Analyst

Responsibilities:

Business Requirements Analysis by conducting in-depth analysis of client business requirements, ensuring a comprehensive understanding of their needs.

Technology Architecture Design by providing expertise in designing optimal technology architectures for solutions, focusing on scalability and performance.

Hadoop Expertise by Specializing in Hadoop consulting, performing health checks, designing architectures, implementing solutions, and ensuring seamless integration.

HANA Solutions Leadership by leading initiatives related to SAP HANA solutions, including migrations, predictive analytics, HANA Live, and integration with Hadoop ecosystems.

EIM and Data Integration by overseeing Enterprise Information Management projects, including Informatica, Microsoft BI, and BOBJ Data Services for effective data integration.

EPM Implementation by Driving Enterprise Performance Management projects, covering management reporting, profitability analytics, and planning, budgeting, and forecasting solutions.

EDW Expertise in managing non-SAP data source integrations, Teradata to HANA migrations, and Business objects and Business warehouse solutions upgrades.

UX & Visualization Leadership by taking a leading role in UX and Visualization projects, including Fiori app development, Tableau integration, and mobile solutions.

Client Support and Adaptation by providing ongoing support, addressing technical issues, and adapting solutions to changing business requirements, ensuring sustained client satisfaction.

Client: ExxonMobil, Houston, Texas Nov’ 2018 – Oct’ 2021

Role: Senior Business Analyst -Vendor Management & Pricing Analyst - Master Data

Description: ExxonMobil Corporation, commonly shortened to Exxon, is an American multinational oil and gas corporation and the largest direct descendant of John D. Rockefeller's Standard Oil. The company, which took its present name in 1999 per the merger of Exxon and Mobil, is vertically integrated across the entire oil and gas industry, and within it is also a chemicals division that produces plastic, synthetic rubber, and other chemical products. ExxonMobil is headquartered near the Houston suburb of Spring, Texas, though officially incorporated in the U.S. state of New Jersey. It is the largest United States-based oil and gas-producing company. ExxonMobil is also the 8th largest company in the world by revenue and the 3rd largest in the US. The company recorded revenue of $413.68 billion by 2022. It is a product-based company.

Responsibilities:

Managed and maintained the vendor management team SharePoint site and framework tools for Payment, Loyalty, Solutions, and Operations, ensuring 100% data integrity and timely updates.

Supported Vendor Managers in ensuring vendor compliance by tracking performance against 30+ contract Service Level Agreements and terms, resulting in a 98% compliance rate.

Supervised the Contract Change Control process, resulting in accurate and timely updates to vendor contracts and improved contract compliance. Coordinated with the business to manage required financial results for stewardship and monitor spending, resulting in a 5% reduction in vendor spends.

Managed resolution of 100+ issues/reports, maintained issues log/archive, and managed the Issue/escalation management process, resulting in improved vendor performance and reduced risk.

Processed Service Request requirements promptly and accurately, improving customer satisfaction and reducing turnaround time.

Utilized ERP System, SharePoint, Excel, Access, and other systems/software to respond to customer inquiries and update vendor data accurately.

Worked on competitive pricing data to formulate profitability models and recommend pricing by researching customer and market segment pricing.

Subject Matter Expert for all North America Pricing fuels-related queries.

Led the strategic management of vendor relationships specifically within the North America Fuels Pricing Portfolio, ensuring alignment with regional business objectives.

Utilized advanced data analysis skills, including SQL queries (Oracle 12c), to conduct thorough evaluations of potential vendors for fuel pricing services.

Led complex contract negotiations with vendors, leveraging expertise in data analysis and utilizing tools like MS Excel, BI tools (Power BI, Tableau), and XL Miner to analyze pricing models and ensure cost-effectiveness.

Defined and implemented key performance indicators (KPIs) and performance metrics specific to the North America Fuels Pricing Portfolio, utilizing BI and reporting tools such as Power BI, XL Miner, and Tableau.

Utilized data modeling techniques, including SQL queries and tools like MS Visio and Atlassian Jira, to develop pricing models and conduct in-depth analysis to optimize fuel pricing strategies.

Explored innovative solutions using tools like IBM Watson Studio to enhance fuel pricing portfolio management processes and introduced advanced analytics capabilities. Collaborated closely with cross-functional teams, utilizing MS Office, Atlassian Jira, and SharePoint for effective communication and documentation. Engaged with stakeholders to understand their fuel pricing needs and ensure alignment with business goals.

Client: HP Inc. Dec’ 2016 – Oct’ 2018

Accenture Services Pvt Ltd, India

Role: Senior Business Analyst

Description: Accenture is an Irish American professional services company based in Dublin, specializing in information technology (IT) services and consulting. It is a Fortune Global 500 company; it reported revenues of $64.1 billion in 2023. Accenture's current clients include 91 of the Fortune Global 100 and more than three-quarters of the Fortune Global 500. As of 2022, Accenture is considered the largest consulting firm in the world by number of employees. The process was outsourced from HP Inc. in December 2016.

Responsibilities:

Documented the Use Cases and prepared the Use Case, Activity, Sequence diagrams, and Logical views in MS Visio, MS Office, to ensure that the development team has a clear understanding of the requirements. ·

Managed all requirements in MS Visio, making them available to the entireproject team and developed requirements traceability matrices.

Created and maintained Narrative Use Cases as well as modeled Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams with the help of MS Visio.

Collaborated with data compliance and data governance teams to maintain data models and data dictionaries, as well as define source fields and their definitions.

Support strategic product initiatives by conducting in-depth analysis and synthesizing data from multiple sources, including data warehouse, surveys, and research.

Generate and provide performance reports based on the analyzed data to inform key stakeholders about the success and challenges of ongoing product initiatives.

Develop customer insights through a thorough understanding of data, enabling the identification of patterns, trends, and opportunities that can contribute to the strategic development of the product.

Collaborate closely with the product team to translate insights into actionable strategies that drive services growth, adoption, retention, engagement, and monetization.

Conducted User Acceptance Testing (UAT) on client tools on ALM software to verify software readiness for client’s data.

Apply expertise in analytics and data mining techniques to extract meaningful information from data sets, providing valuable input for decision-making. Business Analysis Process (SDLC, documentation procedures) experience performing on team performance and user cases.

Utilize data analysis to understand how users interact with the service, going beyond the numbers to gain insights into user behaviors, preferences, and pain points.

Present data in a clear and insightful manner, using visualizations and other presentation techniques to convey complex information to both technical and non-technical stakeholders.

Synthesize data from various sources to provide a comprehensive view of user behavior and market trends, contributing to informed decision-making processes.

Contribute to the development of strategies that promote services growth, aligning insights with the overall business objectives.

Identify opportunities for improving user adoption and retention, providing recommendations and strategies for enhancing the overall user experience.

Develop insights and strategies to enhance user engagement and monetization efforts, ensuring the alignment of data-driven initiatives with business goals.

Hewlett Packard Inc, Bangalore, India Aug’ 2015- Nov’ 2016

Role: Business Analyst

Description: HP Inc. (fortune Global 500 Company) is an American multinational information technology company headquartered in Palo Alto, California, that develops personal computers (PCs), printers and related supplies, as well as 3D printing solutions. Hewlett-Packard was founded in 1939 by Bill Hewlett and David Packard. The company started off in the HP Garage in Palo Alto, California. On November 1, 2015, Hewlett-Packard was split into two companies. Its personal computer and printer businesses became HP Inc., while its enterprise business became Hewlett Packard Enterprise. The split was structured so that Hewlett-Packard changed its name to HP Inc. and spun off Hewlett Packard Enterprise as a new publicly traded company. As on 2022, the revenue for both HP Inc and HPE stands at $63 billion and $28.5 billion respectively. It is a product and service-based company. This process was outsourced to Accenture Services Pvt Ltd in December 2016.

Responsibilities:

Oversee and manage the catalog for HP products, ensuring accurate and up-to-date information is available for internal teams and external customers.

Ensure data integrity and accuracy within the product catalog, working closely with stakeholders to validate and update product information.

Identify opportunities for catalog enhancement, working with cross-functional teams to improve the structure and organization of product data.

Utilize advanced Excel for data analysis, generating reports to provide insights into catalog performance, product trends, and inventory management.

Create compelling presentations using PowerPoint to communicate catalog-related insights, changes, and strategies to various stakeholders.

Played a crucial role during the major split between HP Inc and HPE, ensuring a smooth transition of catalog information and databases.

Managed the transition of catalog data in databases during the split, ensuring data consistency and accuracy for both HP Inc and HPE.

Led the data migration efforts, facilitating the transfer of product information from shared databases to separate databases for HP Inc and HPE.

Collaborated with cross-functional teams, including IT, sales, and marketing, to understand catalog management requirements and align them with the business goals of both HP Inc and HPE.

Worked on integrating catalog management systems to accommodate the unique needs of HP Inc and HPE, ensuring a seamless flow of information.

Leveraged advanced Excel for data cleansing and transformation during the split, ensuring data consistency across catalogs.

Implemented continuous improvement initiatives for catalog management processes, utilizing tools like Excel for process optimization.

Managed the product lifecycle within the catalog, including product launches, updates, and end-of-life processes.

Collaborated with vendors to ensure timely updates and accuracy of product information in the catalog.

Maintained comprehensive documentation related to catalog management processes, changes, and best practices.

Conducted user training sessions for internal teams to ensure effective utilization of catalog management tools and systems.

Implemented quality assurance processes for catalog data, conducting regular audits to identify and rectify discrepancies.

Projects:

Data Mining & Predictive Analytics

TITLE: Implemented a robust classification model for genetic variety identification in date fruits through image analysis, utilizing K-Nearest Neighbors (KNN) classification and Classification Tree techniques.

ANALYTICAL TECHNIQUES: Employed KNN classification for similarity profiling and Classification Tree

Advance Business Analytics

TITLE: Conducted comprehensive analysis on Airbnb rental prices in London and Paris, exploring the influence of social dynamics and geographical factors.

LANGUAGES USED: ·R Programming, Python Programming

LIBRARIES: pandas, NumPy, matplotlib. pyplot, seaborn, sklearn (scikit-learn)

Visualization formats: Line plot, Scatter plot, Bar plot, Heatmap.

Contact this candidate