Sanjana Koneru
Summary
Highly skilled with nearly 5 years of experience as a Business Analyst, dedicated to improving business performance through effective data analysis. Proven track record in developing and implementing Business Intelligence (BI) solutions, ensuring alignment with organizational goals and driving data-driven decision-making across various industries, including healthcare, finance, and retail. Expertise in building data warehouses, facilitating the centralization of data from multiple sources to create a robust foundation for reporting and analysis. Experience in designing and deploying interactive dashboards using Power BI and Tableau, providing stakeholders with real-time insights into key performance indicators (KPIs) and business metrics. Experienced Data Analyst with expertise in designing and implementing efficient data models to support business intelligence, analytics, and reporting needs. Skilled in leveraging SQL, data visualization tools, and database management systems to optimize data flow and enhance decision-making. Detail-oriented and organized, demonstrated through creation of BRDs, ERDs, wireframes, and process flow diagrams using tools like Visio and Jira. Proficient in Microsoft Office Suite including Excel (Power Query, PivotTables, VBA), Word, PowerPoint, and Visio for data analysis, documentation, and process modeling. Strong understanding of Conversational IVR/IVA systems and customer service workflows through hands-on experience with Salesforce Service Cloud and user-facing business process optimization. Proven track record in designing and executing identity lifecycle processes including user provisioning, deprovisioning, and access reviews. Strong understanding of IAM governance frameworks, compliance mandates (SOX, HIPAA, GDPR), and security best practices. Proficient in role-based access control (RBAC), policy enforcement, and entitlement management within complex enterprise environments. Experienced in developing and customizing SailPoint IdentityIQ connectors, rules (BeanShell), workflows, and certification campaigns. Experience working with cloud platforms like AWS, including AWS Redshift and ETL pipelines, aligning with cloud-based Contact Center solutions like Amazon Connect. Proficient in Contact Center workflows and systems, with transferable skills from managing CRM, ERP, and WMS integrations across large-scale operations. Documented data structures and relationships, providing detailed metadata and supporting materials for stakeholders. Regularly tested and updated data models to meet dynamic project requirements and enhance data accuracy. Advanced proficiency in SQL, including complex query writing, data manipulation, and performance tuning, to extract, validate, and analyze large datasets effectively. Skilled in using Python for Exploratory Data Analysis (EDA), employing libraries such as Pandas and Matplotlib to analyze trends, visualize data, and derive actionable insights. Adept at feature engineering in Python to enhance predictive model performance, contributing to more accurate forecasts and business outcomes. Experience in automating analytical processes through scripting in Python, resulting in increased efficiency and reduced manual intervention in data processing workflows. Proficient in leading cross-functional teams, effectively collaborating with business stakeholders, data engineers, and IT professionals to gather requirements and deliver tailored BI solutions. Strong ability to transform complex datasets into clear, concise reports and visualizations, making insights accessible and actionable for decision-makers. Expertise in Salesforce Sales and Service Cloud, with hands-on experience in managing Sales Console and Service Console applications. Strong background in building complex Flows, Process Builder automations, validation rules, and approval processes to optimize business workflows. Skilled in user management, including roles, profiles, permission sets, sharing rules, and field-level security. Experience in handling large-scale data migrations using Data Loader, ensuring data integrity and accuracy. Proficient in troubleshooting and resolving production issues, providing timely support to end users, and managing incident resolution. Excellent communication skills, enabling the presentation of analytical findings and recommendations to both technical and non-technical audiences. Experienced in conducting data quality assessments and implementing data governance practices, ensuring data integrity and reliability across all reporting platforms.
Overview
6
6
years of professional experience
Work History
BUSINESS ANALYST
IAM, Sail Point, Acceptance
, MI.
11.2023 - Current
- Led the development and implementation of end-to-end BI solutions to support decision-making across business units including Sales, Finance, Marketing, and Operations
- Designed and deployed interactive dashboards using Power BI and Tableau, allowing stakeholders to access real-time data and analytics on demand
- Created data models and wrote complex SQL queries for data extraction, transformation, and validation from multiple sources including relational and NoSQL databases
- Collaborated with cross-functional teams to understand and translate business requirements into technical BI solutions, ensuring that reports and dashboards were aligned with business goals
- Strong knowledge and hands-on experience in Identity and Access Management (IAM), with a deep understanding of governance, compliance, and regulatory requirements
- Experience working with SailPoint IdentityIQ, including identity lifecycle management, access provisioning, and policy enforcement
- Expertise in user lifecycle management processes, including onboarding, offboarding, role-based access control, and segregation of duties
- Experience conducting access reviews, access certification campaigns, and role mining activities
- Defined and created Epics, Features, and User Stories in Jira, ensuring alignment with business goals and Agile best practices
- Hands-on experience with Salesforce Service Cloud, managing Sales and Service Console applications, indicates familiarity with Conversational IVR/IVA environments and customer service workflows
- Exposure to Telecom-like domains through inventory management, warehouse optimization, and integration of ERP/WMS systems, highlighting transferable domain knowledge relevant to telecom operations
- Worked on AWS-based projects, including AWS Redshift migration and ETL development, aligning with cloud-based contact center solutions like Amazon Connect
- Experience in managing data pipelines and system integration shows potential to work with Contact Center OEM products (Cisco, Amazon Connect)
- Collaborated with stakeholders to gather requirements and break down high-level initiatives into Epics and Features, providing a structured roadmap for development
- Developed detailed User Stories with acceptance criteria to ensure clarity for development and QA teams, facilitating efficient sprint execution
- Collaborated with stakeholders to gather and document detailed business requirements, ensuring alignment with agile principles and iterative delivery
- Conducted daily stand-ups, sprint planning, and retrospective meetings to facilitate smooth communication and collaboration within cross-functional teams
- Developed user stories, acceptance criteria, and backlog items in Jira to support Agile project management and ensure clarity in development tasks
- Translated complex business processes into comprehensive Business Requirements Documents (BRDs), ensuring clarity and alignment across technical and non-technical teams
- Handled incident management and resolution to ensure smooth operations of the Salesforce platform
- Monitored and resolved user-reported issues, ensuring minimal disruption to business processes
- Managed and prioritized support tickets, troubleshooting system errors, data discrepancies, and workflow issues
- Performed root cause analysis for recurring issues and implemented long-term solutions
- Ensured high system uptime by proactively identifying and resolving performance bottlenecks
- Analyzed the impact of new solutions on existing business processes and systems to ensure seamless integration and minimal disruption
- Conducted impact assessments to evaluate dependencies, risks, and potential conflicts before implementing changes
- Collaborated with business and IT teams to identify integration points and ensure smooth data flow between systems
- Conducted data analysis to identify relationships and patterns, creating efficient entity-relationship diagrams (ERDs) to support project requirements
- Spearheading change management initiatives to ensure smooth adoption of new warehouse technologies and processes
- Implementing quality assurance practices in warehouse operations to reduce errors and maintain compliance with industry standards
- Utilized Python to automate data analysis processes, reducing manual work by 50% and improving data consistency and reliability
- Monitored BI system performance, implemented performance tuning strategies, and troubleshot bottlenecks in reporting and data integration processes
- Managed ETL processes using SSIS to integrate data from various sources into the data warehouse and ensure data accuracy for reporting
- Collaborating with stakeholders to analyze and enhance warehouse operations, focusing on efficiency improvements and cost reduction
- Conducting data analysis using Excel and SQL to identify trends and optimize inventory management strategies
- Conducted structured interviews and brainstorming sessions to gather insights into business objectives, pain points, and user expectations
- Gathered and analyzed business requirements for implementing the Security Master system to centralize securities data
- Collaborated with stakeholders to establish data governance policies, ensuring accuracy and consistency of security reference data
- Defined and documented functional specifications for data ingestion, validation, enrichment, and distribution workflows
- Conducted gap analysis between existing processes and Security Master capabilities to identify areas for optimization.
BUSINESS ANALYST
IAM, RBC
, MN.
09.2022 - 08.2023
- Managed the creation and maintenance of BI tools including Power BI and Tableau for various business functions
- Developed data models, KPIs, and visualizations that provided real-time insights into key business metrics such as sales trends, customer behavior, and financial performance
- Engaged in dashboard inquiries, working with BI teams to define reporting needs and enhance data visualization using Power BI and Tableau
- Applied SAFe methodology, participating in PI (Program Increment) planning, sprint reviews, and retrospectives to drive Agile transformation
- Conducted Business Process Modeling using BPMN techniques to map and optimize workflows, ensuring efficient operations
- Wrote complex SQL queries to pull data from Oracle, MySQL, and MongoDB databases, ensuring the accuracy and completeness of the data used for reporting
- Automated repetitive tasks by creating and executing macros with VBA, improving efficiency by 40%
- Consistently created Business Requirements Documents (BRDs), user stories, wireframes, and ERDs, showcasing exceptional attention to detail and task orientation
- Conducted gap analysis, impact assessments, and data validation, reflecting strong organizational skills and thorough process evaluation
- Proficient in implementing role management and access workflows aligned with organizational policies and industry standards
- Familiar with integrating IAM solutions with enterprise applications and directories using standard protocols (LDAP, SAML, OAuth)
- Excellent interpersonal and communication skills with a strong ability to engage stakeholders, document requirements, and provide end-user training
- Skilled in collaborating with security teams and auditors to ensure compliance with SOX, HIPAA, GDPR, and other regulatory standards
- Advanced analytical capabilities demonstrated through Python-based EDA, SQL data manipulation, and the creation of predictive models and statistical analysis
- Built and maintained executive dashboards in Power BI and Tableau for real-time business insights, demonstrating data storytelling and visualization expertise
- Proficient in Microsoft Excel (Power Query, PivotTables, VBA), PowerPoint (presentations), Word (documentation), and Visio (process modeling and ERDs)
- Applied data validation techniques to maintain data integrity across large datasets
- Used advanced statistical formulas, including SUMIFS, COUNTIFS, AVERAGEIFS, for customized data aggregation and analysis
- Conducted What-If Analysis using tools like Scenario Manager and Goal Seek for strategic planning
- Designed and optimized processes for reconciliation of transactions, holdings, and NAV calculations
- Collaborated with cross-functional teams, including developers, QA, and business stakeholders, to address system challenges
- Created and maintained documentation for troubleshooting steps, known issues, and best practices
- Provided user training and support to enhance adoption and efficiency in Salesforce usage
- Conducted regular audits and health checks to maintain data integrity and compliance
- Implemented duplicate management strategies to improve data quality
- Assisted in release management, testing, and deployment of enhancements, patches, and fixes
- Assessed the compatibility of new solutions with existing infrastructure, ensuring alignment with business objectives and technical feasibility
- Mapped data flows and system interactions to understand the upstream and downstream effects of proposed solutions
- Engaged stakeholders to gather insights on process bottlenecks and inefficiencies, aligning solutions with business needs
- Facilitated requirement-gathering workshops, interviews, and brainstorming sessions to elicit critical insights and prioritize project deliverables
- Created process flow diagrams, use case scenarios, and functional specifications to support BRD development and enhance stakeholder understanding
- Ensured compliance with industry standards, such as SEC, FINRA, and GDPR, in asset management operations
- Conducted impact analysis for system changes and enhancements to ensure alignment with asset management goals
- Built filter-driven dashboards with parameters, sorting, drill-down, and drill-through functionality to provide a detailed view of performance metrics
- Leading requirement gathering sessions to identify gaps in existing warehouse processes and propose actionable solutions
- Automating inventory reporting processes, reducing manual effort and ensuring real-time updates for stakeholders
- Facilitated integration of the Security Master with downstream systems, ensuring seamless data flow and utilization
- Documented and validated key takeaways from discovery sessions, translating them into actionable requirements for development and implementation
- Supported end-to-end testing of security data, ensuring compliance with industry standards and organizational policies
- Worked closely with developers and testers to ensure business requirements were accurately translated into functional solutions
- Created process flow diagrams, wireframes, and mockups to visualize business workflows and system functionalities
- Conducted impact analysis for system changes, assessing risks and dependencies before implementation
- Provided comprehensive training and documentation to end-users, enabling efficient adoption of the Security Master system
- Monitored system performance post-implementation and worked with technical teams to address any issues or enhancements
- Coordinating with cross-functional teams to implement solutions that improve warehouse turnaround times and workflow optimization
- Utilized SQL and data modeling tools (e.g., Power BI, Tableau, Erwin, or Visio) to develop robust schemas and optimize database performance
- Created and managed data pipelines using SSIS, ensuring timely and accurate data integration from multiple data sources into the central data warehouse
- Performed performance tuning and debugging of existing reports, improving response times and user experience.
BUSINESS ANALYST
, GA.
09.2021 - 07.2022
- Designed and implemented end-to-end data models to support three major clients in the [retail, finance, and healthcare industries], improving data accuracy and scalability
- Built interactive Tableau dashboards for monitoring key performance indicators (KPIs), enabling stakeholders to make real-time data-driven decisions
- Conducted exploratory data analysis (EDA) using Python to uncover hidden patterns and insights from datasets
- Conducted testing and validation to ensure that the integrated solution meets functional, performance, and compliance requirements
- Facilitated cross-functional meetings to align stakeholders on the impact of solutions and gain approvals for deployment
- Designed and implemented end-to-end identity lifecycle processes using SailPoint IdentityIQ, covering joiner, mover, and leaver scenarios
- Customized SailPoint connectors for integration with enterprise systems like Active Directory, Workday, SAP, and Office 365
- Developed and maintained identity provisioning workflows and automated policy enforcement mechanisms to reduce manual access management
- Implemented role-based access control (RBAC), attribute-based access control (ABAC), and policy-based controls to enforce least privilege principles
- Built interactive dashboards using PivotTables, Pivot Charts, and slicers for dynamic reporting and decision-making
- Proficient in documenting IAM policies, procedures, and system architecture for internal and external audits
- Experience working in Agile/Scrum environments, contributing to sprint planning, user story creation, and iterative IAM development and delivery
- Worked with developers and architects to design scalable and flexible integration frameworks for seamless system communication
- Automated analytical processes using Python, reducing manual work by up to 50%—a valuable skill when implementing or supporting Conversational IVR/IVA systems that rely on efficiency and automation
- Performed root cause analysis and resolved production issues in Salesforce and BI systems, showcasing your ability to troubleshoot complex system interactions often found in IVR/IVA ecosystems
- Participated in Agile ceremonies (daily stand-ups, retrospectives, sprint planning) and used Jira extensively to manage epics, features, and user stories—highlighting your methodical and organized work approach
- Managed user access, roles, and profiles in Salesforce, ensuring secure, compliant data access—relevant when configuring user permissions in Contact Center platforms
- Conducted structured interviews, workshops, and brainstorming sessions to capture requirements—demonstrating user-centric thinking critical to conversational design in IVR/IVA
- Led Data Mapping efforts to align data sources, business rules, and transformation logic for seamless system integration and data integrity
- Utilized Microsoft Visio to create process flow diagrams, entity-relationship models, and system workflows for better stakeholder communication
- Performed Workflow Analysis to identify bottlenecks, optimize business processes, and recommend automation opportunities
- Conducted data cleaning and preprocessing using Excel tools like Text-to-Columns, Remove Duplicates, and Conditional Formatting, ensuring high data accuracy
- Developed and optimized SQL queries for data extraction, transformation, and reporting, reducing query execution time by 35%
- Automated repetitive ETL tasks with Python, cutting down manual data processing efforts by 40%
- Provided L1, L2, and L3 support to troubleshoot and resolve technical and functional Salesforce issues
- Managed user access, roles, profiles, and permission sets to ensure data security and compliance
- Investigated and resolved integration failures between Salesforce and external systems
- Performed data validation, cleanup, and deduplication to enhance data accuracy
- Created and optimized reports and dashboards to help stakeholders track key performance indicators
- Worked closely with end users to understand issues and provide timely solutions
- Participated in backlog grooming sessions to prioritize and refine user stories based on business value and feasibility
- Engaged in continuous feedback loops with business users to validate solutions and make iterative improvements
- Performed data analysis using SQL and Python to support decision-making and validate business hypotheses
- Validated requirements with cross-functional teams, ensuring completeness and feasibility before development and implementation phases
- Maintained version control and tracked changes in BRDs, ensuring accurate documentation throughout the project lifecycle
- Collaborated with data engineers and business teams to identify and address gaps in reporting and analysis
- Conducting end-to-end analysis of warehouse workflows to identify bottlenecks and implement process improvements
- Assisting in the migration of legacy warehouse systems to cloud-based platforms, ensuring minimal disruptions during the transition
- Conducted stakeholder interviews and workshops to understand key requirements for managing securities data
- Facilitated the implementation of data governance practices to maintain accuracy and integrity of investment data
- Provided support for fund launches, including setup of portfolios, benchmarks, and operational workflows
- Conducted UAT and training sessions to ensure seamless adoption of new asset management tools and processes
- Designed workflows for the creation, maintenance, and validation of securities within the Security Master system
- Analyzed and mapped data feeds from external sources like Bloomberg, Reuters, and other market data providers to Security Master
- Created Entity-Relationship Diagrams (ERDs) to design efficient database schemas that supported analytical needs
- Analyzed and reconciled large datasets by importing, merging, and analyzing data using Power Query
- Linked multiple datasets using Power Pivot, creating relationships and performing calculations using DAX
- Modeled complex datasets for financial forecasting and operational reporting, resulting in improved decision-making processes
- Built Excel dashboards incorporating pivot tables, charts, and macros for financial performance tracking
- Conducted A/B testing and statistical analysis to measure the effectiveness of marketing campaigns.
BUSINESS ANALYST
Standalone IT Solutions
, INDIA
02.2019 - 12.2020
- Conducted detailed analysis of business data using SQL and Python, providing actionable insights for the marketing, sales, and finance departments
- Analyzed trends in customer data and market dynamics to support strategic decision-making for product launches and marketing campaigns
- Designed and built dashboards in Tableau to visualize KPIs such as sales volume, customer acquisition costs, and lifetime value, giving stakeholders a real-time overview of business performance
- Collaborated with stakeholders to gather and translate business requirements into detailed data models
- Supported change management efforts by providing documentation, training, and stakeholder communication to ensure smooth adoption of new processes
- Collaborated with data engineers and BI teams to define reporting needs and optimize dashboards for business insights
- Built detailed process flow diagrams, use cases, and system workflows using Visio, supporting clear communication and documentation for complex system logic
- Created robust data pipelines using SSIS and performed performance tuning on ETL processes—highlighting your backend understanding necessary for data-driven IVR/IVA systems
- Integrated external data sources (like Bloomberg, Reuters) with internal systems—experience that translates well to integrating telephony systems with CRM and data platforms
- Supported end-to-end UAT and stakeholder training for large system rollouts, reflecting a structured approach to system delivery and adoption
- Played a key role in cloud migration and warehouse optimization, showcasing comfort with enterprise-scale tech environments like those running IVR/IVA and Contact Centers
- Leveraged leadership skills to facilitate cross-functional meetings, align teams on project objectives, and ensure smooth Agile execution
- Conducted Process Analysis, assessing existing workflows and proposing improvements to enhance efficiency and reduce redundancies
- Acted as a bridge between business and technical teams, ensuring clear communication, requirement alignment, and stakeholder buy-in
- Assisted in change management initiatives by providing documentation, user training, and stakeholder engagement to ensure smooth adoption of new processes
- Normalized and standardized database structures to improve data quality and minimize redundancy
- Implemented data warehouse schemas using star and snowflake models to facilitate efficient analytics and reporting
- Automated data workflows by integrating data from multiple sources into a unified model for real-time analytics
- Identifying opportunities to reduce warehouse lead times through enhanced scheduling and resource allocation
- Collaborating with IT teams to troubleshoot and resolve WMS-related technical issues promptly
- Analyzed system logs and error reports to diagnose and fix performance issues
- Coordinated with Salesforce support to resolve critical platform-related issues
- Ensured business continuity by proactively monitoring system health and performance
- Assisted in impact analysis and regression testing during new releases and system updates
- Managed configuration changes, including custom fields, validation rules, and page layouts, to meet evolving business needs
- Provided post-implementation support for new features and enhancements
- Ensured compliance with regulatory requirements such as MiFID II and SEC standards in security data management
- Automated exception handling and error reporting for incomplete or inconsistent securities data to improve operational efficiency
- Led workshops to align cross-functional teams on the implementation timeline, milestones, and key deliverables
- Defined KPIs and metrics to monitor the accuracy and timeliness of data within the Security Master repository
- Monitoring warehouse performance against service-level agreements (SLAs) and preparing monthly performance reports
- Facilitating workshops with key stakeholders to gather feedback on system improvements and operational challenges
- Designed and optimized database queries for improved performance and faster reporting
- Ensured data integrity and consistency by implementing normalization techniques and setting primary/foreign key constraints
- Streamlined workflows by integrating data from multiple sources, creating single unified models for analytics and reporting
- Assisted in the migration of on-premise databases to cloud-based solutions like Google Big Query and Azure SQL.
Education
Bachelors - information technology
JNTUH
Skills
- Power BI
- Tableau
- MicroStrategy
- Pentaho
- Advanced Charts
- Drill-Down
- Drill-Through
- Filters
- Python
- Pandas
- Jupyter
- Matplotlib
- SAFE
- SQL
- PL/SQL
- DAX
- VBA
- Oracle SQL
- MySQL
- SQL Server
- MongoDB
- NoSQL
- SSIS
- Informatica
- Talend
- API Development
- AWS
- Redshift
- S3
- Glue
- Google BigQuery
- Azure SQL
- Snowflake
- GCP
- Hadoop HDFS
- Spark
- MapReduce
- Excel
- SAS
- MATLAB
- Microsoft Visio
- Erwin Data Modeler
- Jira
- Git
Timeline
BUSINESS ANALYST
IAM, Sail Point, Acceptance
11.2023 - Current
BUSINESS ANALYST
IAM, RBC
09.2022 - 08.2023
BUSINESS ANALYST
09.2021 - 07.2022
BUSINESS ANALYST
Standalone IT Solutions
02.2019 - 12.2020
Bachelors - information technology
JNTUH
Similar Profiles
Arlene Kim-KawamotoArlene Kim-Kawamoto
Principal Broker/Owner at POSR CORP Dba Point Of Sail RealtyPrincipal Broker/Owner at POSR CORP Dba Point Of Sail Realty
Satou SagnaSatou Sagna
Assistante du département Insertion Professionnel at Institut Africain de Management (IAM) GroupeAssistante du département Insertion Professionnel at Institut Africain de Management (IAM) Groupe
Travis BialasTravis Bialas
Business Representative/Organizer at IAM District 8Business Representative/Organizer at IAM District 8
Kelly SummersKelly Summers
Developer Senior, Business Info Developer, Business Analyst II, Business Analyst I, Project Coordinator, Senior Claims Associate, Risk Management, Fraud and Abuse, Audit/Recovery Specialist, Customer Service at AnthemDeveloper Senior, Business Info Developer, Business Analyst II, Business Analyst I, Project Coordinator, Senior Claims Associate, Risk Management, Fraud and Abuse, Audit/Recovery Specialist, Customer Service at Anthem
KAMARIA BegumKAMARIA Begum
Business Analyst at Morgan StanleyBusiness Analyst at Morgan Stanley