Shikha Bhagia

Business Analyst

ad004m@r.postjobfree.com

425-***-****

PROFESSIONAL SUMMARY:

●Industry experience of 6 years as a Business Analyst with a sound understanding of High-Level Business Requirements Gathering, understanding data, proficiency in SQL and data visualization tools like Tableau and Power BI.

●Actively used Joint Application Development (JAD) and Rapid Application Development (RAD)Sessions with Business users, SMEs, and Stakeholders alike in gathering requirements and analyzing them to identify the real business need and facilitating the development of a customized solution that delivers maximum cost and usability benefit to the client and company.

●Extensive knowledge and working experience in converting business requirements into UML diagrams using Rational Rose and MS Visio and also managing and tracking those requirements.

●Extensive Experience in producing documents like Business Requirements Documents (BRD), Functional Requirement Specifications (FRS), Software Requirement Specifications (SRS), Creating requests for Proposals (RFP), and Creating Requirements Traceability Matrix (RTM).

●Experience in developing and imparting pre and post-implementation training, Conducting GAP Analysis, User Acceptance Testing (UAT), SWOT Analysis, and ROI analysis.

●Driven by Creative ideas and backed by strong Analytical and methodical problem-solving skills, identify causes and corrective actions and provide innovative solutions, building strategic partnerships with senior business leaders and getting commitments to actions from individuals at all levels.

●Experience in creating Key Performance indicators (KPI), Enterprise Risk Management, Risk Mitigation, project management methodology, and SOX controls to maintain compliance and mitigate risks and Business Continuity Planning (BCP).

●Ability to make effective decisions and meet project deliverables timely in a highly dynamic, demanding, and fast-paced environment.

●Good understanding and proficiency in deploying a wide range of projects using different SDLC models- Waterfall and AGILE-SCRUM.

●Contribution in resolving and escalating the critical issues/defects to the project team surfaced during the Testing efforts and daily business operations.

●Collaborate with key business stakeholders to identify areas of value, develop solutions, and deliver insights that reduce the overall cost of care for members and improve clinical outcomes..

●Extensive experience in Excel, Word, PowerPoint, MS Project, MS Visio, Rational Suite, and SQL.

●Highly motivated self-starter with Excellent communication, presentation, and interpersonal skills, can perform well both independently and with a team, and is always willing to work in challenging and cross-platform environments.

●Conducted end-to-end UAT for multiple software applications, ensuring product quality and alignment with business requirements.

●Collaborated with the Product Owner and Scrum team to refine and prioritize the product backlog, ensuring clear and actionable user stories.

EDUCATION DETAILS:

●Master of Science in International Business - Hult International Business School

●Master of Science in Business Analytics - Hult International Business School

PROFESSIONAL EXPERIENCE:

Kohler Co, Seattle, WA July 2022 to April 2023

Business Analyst

Responsibilities:

●Actively engaged with external stakeholders, including carriers, suppliers, and partners, to establish strong working relationships.

●Facilitated open communication channels to gather feedback, address concerns, and align program goals with external stakeholders' objectives.

●Coordinated cross-functional meetings and discussions to ensure all parties were well-informed and committed to the program's success.

●Leveraged collaborative efforts to streamline processes, resolve issues, and enhance overall program efficiency.

●Demonstrated strong interpersonal and negotiation skills in managing relationships with external partners, resulting in improved program outcomes and customer satisfaction.

●Employed advanced data analysis techniques, including SQL queries and data visualization tools such as Tableau and Power BI, to extract and process complex datasets.

●Transformed raw data into concise, visually appealing reports tailored to meet the specific needs and preferences of senior management.

●Developed intuitive dashboards and graphical representations that provided key insights into program performance, trends, and areas requiring attention.

●Ensured that data reports were not only informative but also easy to interpret, allowing management to make informed decisions quickly.

●Regularly updated and maintained these reports, adapting them to evolving business requirements and priorities, while adhering to best practices in data visualization.

●These expanded descriptions provide a more comprehensive view of your abilities in collaborating with external stakeholders and producing user-friendly data reports for management.

●Documented existing processes, identified gaps, and designed new processes to improve efficiency and alignment with desired outcomes.

●Developed process performance measures and planned the transition to new processes as necessary.

●Identify and assess the business impact of emerging trends and patterns in the data.

●Develop, maintain, and troubleshoot complex scripts and reports using SQL, Microsoft Excel, or other analytics tools.

●Assisted in writing SQL queries and identified functional issues.

●Reviewed and developed test scripts and led User Acceptance Test (UAT) plans.

●Created working procedures and user guides and acted as a liaison to vendors/IT teams.

●Demonstrated ability to work autonomously with minimal guidance, achieving project milestones on time and within budget.

●Developed processes and created user-friendly documentation, enabling end-users to effectively utilize the system and reducing onboarding time by 30%.

●Conducted end-to-end UAT for multiple software applications, ensuring product quality and alignment with business requirements, achieving an average defect detection rate of 95%.

●Ensured data accuracy and consistency by partnering with Data Science and Finance teams to identify and address data quality issues.

●Conducted succinct and impactful data analysis to optimize business performance, highlighting key growth opportunities for enhanced business outcomes.

●Proven experience in implementing B2B, B2C, and B2B2C customer experience platforms.

Environment: MS-Excel, MS-Suite, SQL, MSQL, Python, SSIS

Cam Trading Inc, Athens, GA Oct 2021 to May 2022

Business Analyst

Responsibilities:

●Proficient in digital marketing strategies and techniques to optimize online presence and engagement.

●Played a key role in assisting with the monthly billing process for advertising campaigns, ensuring accurate and timely invoicing.

●Utilized bug/project management tools like JIRA to track and prioritize tasks, resulting in a 20% increase in productivity.

●Utilized Salesforce to efficiently manage customer interactions, track leads, and streamline communication.

●Familiarity with Entitlement Management and Product Configuration, among other related areas.

●Exceptional documentation skills, including experience driving workshops and facilitating collaboration among multiple development teams.

●Lead the planning and execution of large-scale projects and the implementation of new reporting tools, ensuring that business goals are translated into actionable solutions.

●Identify and resolve data, process, and technical issues, and effectively communicate root causes to stakeholders as necessary.

●Designed and implemented the business requirement collection approach using Agile methodology based on project scope.

●Conducted meetings with key business users to gather requirements and business process information.

●Developed project plans, style sheets, and templates to estimate feasibility, cost, and time, and provide general guidelines for the project team.

●Facilitated JAD sessions with business users and development teams to drive out detailed business requirements.

●Conducted extensive data analysis using MS Excel and performed Gap analysis to identify discrepancies between business requirements and system functionality.

●Documented business requirements with wireframes and mockups, explaining business implications and impacts in detail, and stored and modified requirements in MS Word.

●Coordinated and led weekly and monthly leadership meetings, showcasing comprehensive business results, in-depth analysis, and product initiative summaries for future growth planning.

●Developed and managed dashboards and detailed scorecards, enabling transparent reporting to Executive leadership for business health assessment and strategic decision-making.

●Analyzed and prioritized user and business requirements as system requirements and planned defined system requirements.

●Worked with the business object developers to provide input for generating automated and ad-hoc Business object reports.

●Analyzed ETL jobs and mappings to document the existing business rules and transformation logic.

●Planned, reported, and provided technical mentoring to enable knowledge transfer/communication between management and junior staff.

●Utilized forecasting techniques, developed interactive dashboards, and reported on sales trends to accurately predict and increase daily sales by 25% through the use of MS Excel.

●Managed online orders and actively promoted app-based sales through daily use of the Ziizii app.

●Efficiently handled inventory, storage, returns, and purchase orders, and provided support to the CEO in the creation of monthly budget plans.

●Performed data extraction, cleaning, analysis, and completion of missing data to accurately forecast taxes, considering historical data, using My-SQL.

●Used SSIS to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.

Dedicated Developer, Alpharetta, GA July 2021 to Oct 2021

Business Analyst

Responsibilities:

●Excellent verbal and written communication skills, with a focus on interpersonal effectiveness.

●Detail-oriented and well-organized, ensuring meticulous attention to project requirements.

●Track record of working with large-scale customer experience platforms.

●Assist in the development of CRM applications like GHL and Ontraport.

●Assist in the development of the corporate website from a customer perspective.

●Conduct business process analysis and design for the sales and marketing business areas leading design discussions with senior management.

●Develop and maintain configuration and functional design documentation.

●Develop test cases, execute testing, and coordinate testing with a business representative.

●Ability to perform all tasks within the software development lifecycle at a senior level, including the ability to lead design discussions and workshops with business area management and document business processes.

●Lead and coordinate Issue Management events from identification through resolution.

●Help to develop and implement processes and methodologies.

●Works with Marketing and IT teams to develop complex queries and reporting to assess the viability of marketing programs using SAS base code, SAS Business Intelligence, SAS Marketing Automation, SQL, and Other reporting tools.

●Led training sessions on the Order Management System platform and backend, equipping users with the knowledge to maximize system capabilities.

●Excelled in communication and collaboration, fostering positive relationships with cross-functional teams and stakeholders.

●Acquired experience or knowledge of the Google Ad Manager Ad Server, enhancing understanding of advertising operations and system integration.

●Led UAT defect triage meetings, providing clear communication and updates to stakeholders on testing progress and issue resolutions, resulting in a 20% reduction in defect turnaround time.

●Coordinated UAT activities, including test environment setup, test data creation, and test execution timelines, to meet project deadlines, achieving a 95% on-time delivery rate.

●Conducted UAT training sessions for end-users, facilitating smooth adoption of new software and ensuring user satisfaction, resulting in a 90% user acceptance rate.

●Facilitated effective communication and transparency within the Scrum team, fostering collaboration and knowledge sharing among team members, resulting in a 15% improvement in team communication and collaboration.

●Utilized Scrum artifacts, such as burn-down charts and task boards, to track project progress and identify areas for improvement, achieving a 90% accuracy in tracking and forecasting sprint progress.

Environment: Access 2000/2002/ 2003. SQL, Windows XP Professional, Excel, Access, Excel 2002/2004. MS Visio, Visual Basic, SQL.

Diversity Dashboard, Watertown MA Jul 2019 to July 2021

Business Analyst

Responsibilities:

●Leveraged Tableau to visualize and analyze marketing performance data, enabling data-driven decision-making.

●Demonstrated competence in Oracle for data management and analysis, contributing to informed marketing strategies.

●Effectively utilized Order Management Systems (OMS) to coordinate and streamline campaign logistics.

●Managed and optimized Google AdWords campaigns to enhance online visibility and drive targeted traffic.

●Collaborated with cross-functional teams to ensure seamless integration of marketing efforts within the Salesforce ecosystem.

●Created detailed reports using Tableau to present campaign performance metrics, allowing for actionable insights.

●Proficiently used Oracle to extract, transform, and load marketing data, facilitating accurate analysis.

●Coordinated with internal stakeholders to ensure accurate data input and synchronization between Salesforce and Oracle systems.

●Successfully implemented Google AdWords campaigns, resulting in increased click-through rates and conversions.

●Collected and documented business processes as well as business rules and performed GAP analysis.

●Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level.

●Created various Business Documents such as BRD and SRS to record Functional, Non-Functional, and Technical Requirements

●Developed workflow and screen mock-ups.

●Interfaced with business users extensively to prepare and update requirements.

●Performed data analysis and the mapping of the attributes between the source system and the target system.

●Ensured all artifacts complied with corporate SDLC Policies and guidelines.

●Proficient in Microsoft Excel, with a demonstrated ability to utilize advanced features for data analysis and reporting.

●Familiarity with Salesforce, contributing to a holistic understanding of CRM systems and their integration with OMS platforms.

●Demonstrated proactive problem-solving abilities, resulting in the identification and implementation of process improvements that increased efficiency by 23%.

●Assisted in resolving impediments and removing obstacles that hindered the team's progress, ensuring smooth sprint execution, resulting in a 95% reduction in critical impediments.

●Demonstrated a strong understanding of Agile principles and Scrum framework, adapting quickly to changing project requirements and delivering results in a fast-paced environment, achieving a 90% adherence to Agile practices and values.

Environments: Waterfall, MS Visual Studio, SQL, SSIS

Orion Excellence – India. Mar 2017 - Jul 2019

Business Analyst

Responsibilities:

●Utilized critical thinking skills to analyze complex business processes, identify challenges, and suggest effective solutions for optimization.

●Crafted interactive Tableau dashboards that facilitated dynamic data exploration and analysis.

●Designed dashboards to provide clear snapshots of key performance indicators.

●Integrated live data connections into Tableau for real-time monitoring of critical metrics.

●Automated data refreshes and updates in Tableau to ensure access to the most current information.

●Contributed to a data-driven culture, making complex data easily understandable for stakeholders.

●Acted as the primary information liaison to the business, providing timely and accurate responses to inquiries and serving as the first point of contact.

●Established and maintained trust with internal and external stakeholders by effectively addressing concerns and advocating for their needs, fostering long-term relationships.

●Conducted comprehensive investigations to establish facts, reach conclusions, and summarize findings, enabling data-driven decision-making processes.

●Structure Curriculums, and daily lessons by documenting requirements, and addressing concerns from parents that increased customer satisfaction.

●Project Schedules using (MS Project), resource planning, budgeting, Quality metrics, and change control.

●Responsible for providing leadership, coaching, and guidance on a continuous basis to project team members in the areas of the project lifecycle. Operating procedures, processes, and practices.

●Developed, implemented, and maintained financial models and analytics tools for OTC Derivatives.

●Responsible for collecting, prioritizing, and negotiating all in-scope business requirements and assisting the Project Manager with managing scope creep

●Managed less experienced BAs, and assisted with building requirements management process, knowledge base, and templates

●Ability to perform detailed analysis to ensure all aspects of the business requirement are understood.

●Able to formalize business requirements, ready for two-way communication business communication, b technical communications

●Capable of assisting with the management of all non-technical aspects of the new requirements

●Responsible for the creation of risk management plans to identify, analyze, monitor, and respond to risks associated with the project to ensure the ability to achieve expected outcomes, on time and on budget.

●Launched and outperformed seasonal marketing campaigns, and events that resulted in brand awareness going up 4 times within a year and revenue growth by 5times over 4 years

●Diversify the hiring process, and led training programs for teachers to improve employee retention rate removing the cost of hiring.

●Facilitated effective communication and transparency within the Scrum team, fostering collaboration and knowledge sharing among team members, resulting in a 15% improvement in team communication and collaboration.

●Utilized Scrum artifacts, such as burn-down charts and task boards, to track project progress and identify areas for improvement, achieving a 90% accuracy in tracking and forecasting sprint progress.

●Assisted in resolving impediments and removing obstacles that hindered the team's progress, ensuring smooth sprint execution.

●Demonstrated a strong understanding of Agile principles and Scrum framework, adapting quickly to changing project requirements and delivering results in a fast-paced environment.

Environment: Program and project Management, Risk identification, Team Collaboration, and Leadership, SDLC, Vendor Management.

Contact this candidate