Swarna Raju Kuttolla
Lead BI specialist
Hyderabad
Summary
With over 13 years of experience, I bring extensive expertise in SAP BO, Power BI, Tableau, SAP BODS, SNOWFLAKE, and Oracle. Specializing in retail and banking domains, I have excelled in BI tool installation, configuration, and maintenance, with a focus on SAP BO, Power BI report server, and Tableau. I have led Power BI development projects, built data models, and created visualization reports using Oracle, Snowflake, and SharePoint as data sources. Proficient in DAX and M Code/Query, I have hands-on experience in installation and administration of SAP BODS (ETL). I also have experience in overseeing data ingestion through SNOWFLAKE (ELT) utilizing the COPY command and Pipelines, python framework. I have a proven track record in team leadership, capacity management, and service level maintenance, supported by relevant certifications.
Achievements:
- Provided exceptional technical support to end-users, maintaining a satisfaction rating of over 90-95% in customer surveys.
- Implemented automation solutions for routine administrative tasks on all the BI tools, reducing manual effort by 50% and enhanced security model by implementing role-based access controls, reducing unauthorized access incidents by 30%.
- Designed and executed Disaster Recovery protocols, ensuring continuous data protection and system resilience with zero data loss.
- Engineered complex data models within Power BI to accommodate Snowflake's schema-on-read architecture, enabling flexible and scalable reporting solutions.
- Utilized Snowflake's advanced features such as materialized views and clustering to improve query performance and reduce report latency in Power BI.
- Integrated Power BI with Snowflake, optimizing data retrieval and processing to ensure fast and efficient reporting across large datasets.
- Implemented Snowflake's SnowSQL connector for seamless data connectivity and query execution within Power BI, enhancing data accessibility and usability.
- Received positive feedback from stakeholders on the accuracy, reliability, and timeliness of Power BI reports connected to Snowflake, contributing to improved decision-making and business outcomes.
Overview
13
13
years of professional experience
5
5
years of post-secondary education
3
3
Certifications
3
3
Languages
Work History
Senior System Administrator
Credit Suisse (Switzerland Bank)
Pune
06.2021 - 03.2024
- Managed team of 6 individuals and provided technical oversight for SAP BO, Power BI, and Tableau administration.
- Manage and administer SAP BO, Power BI and Tableau platform, including user access, permissions, and licenses.
- Implement security measures, including role-based access controls, row-level security, and data encryption, to protect sensitive information.
- Establish governance policies and procedures to ensure compliance with regulatory requirements and organizational standards.
- Provide technical support and troubleshooting assistance to Power BI users, resolving issues related to data connectivity, report design, and performance.
- Creation of KB articles to educate users on best practices, and troubleshooting procedures for known issues.
- Integrated Snowflake with Power BI to establish for Power BI, providing actionable insights and visualizations to support decision-making processes.
- Create Power BI data models that establish connections with range of data sources, including Oracle, SharePoint, and Snowflake.
- Developed engaging visualization reports in Power BI, featuring key performance indicators (KPIs) and interactive bookmarks.
- Load data from Amazon S3 into Snowflake tables utilizing COPY command and Snowpipes.
- Utilizing snowflake views for power BI reporting.
- JIRA and Odyssey tools are being used to track all activities and documentation.
ERP Functional Analyst
DXC Technology (Formerly Known As Hewlett Packard)
Hyderabad
11.2010 - 06.2021
- Implemented, upgraded, and configured SAP BO platforms (3.1/4.0/4.1/4.2) for leading retail and financial sectors, optimizing operational efficiency.
- Integrated SAP BO with BW, Oracle, SQL Server, and other data sources, ensuring seamless connectivity and accessibility.
- Implemented Disaster Recovery protocols for SAP BO, ensuring 99.9% continuous data protection and system availability.
- Configured SAP BO with Win AD and LDAP authentication systems, strengthening system security and user access control.
- Troubleshooting scheduling and publication issues, ensuring uninterrupted operation of SAP BO environment.
- Designed and enforced advanced security measures for SAP BO, heightening data protection and access control.
- Fixing vulnerabilities (Web inspect, VA scan) on SAP BO servers
Administered BODS 4.2 SP14 patch 500 installation and performed critical administrative activities, enhancing server configuration. - Established SAP BW connection with SAP BODS using RFC connection, facilitating efficient data interaction.
- Managed BODS repositories and user security, ensuring robust data integrity and access control measures.
- Scheduled and managed batch jobs, streamlining data processing operations.
- Conducted smooth migration/transport of objects across environments, ensuring seamless deployment and system continuity.
- Troubleshot load-related and RFC issues, ensuring consistent data availability and reliability.
- Designed and constructed data models and tables within Power BI, improving operational efficiency.
- Utilized Power BI's Query Editor to optimize ETL processes for reporting datasets.
- Optimized SQL queries and created indexes for improved performance.
- Developed calculated columns and measures using DAX for advanced data analysis.
- Managed Tableau Server environment, ensuring reliability, performance, and security.
- Administered user access, permissions, and licensing in Tableau Server.
Monitored Tableau Server performance and provided technical support to users.
Education
Bachelor of Technology - Information Technology
Jawaharlal Nehru Technology University
Hyderabad 06.2001 - 12.2005
Skills
SAP BO, Power BI and Tableau Administration
undefinedCertification
Application Associate - SAP Business Objects Business Intelligence platform 4.0
Biography
I've worked with various technologies for the last 13+ years, with a focus on SAP BO, Power BI, Tableau, SAP BODS, SNOWFLAKE, and Oracle. I have worked on a few well-known projects for the retail and banking/financial industries. I have extensive experience installing and configuring BI tools. I am also proficient in using BI virtualization to create reports. Experience in data warehouse tools like BODS and SNOWFLAKE. I have experience in leading the team and handling capacity management roles and service level manager role. "Application Associate, SAP Business Objects Business Intelligence Platform 4.0" and "SAP Certified Application Associate, SAP Analytics Cloud" are the certifications I've received.
Industry Experience
- Retail - 9 years
- Finance/Banking - 4+ years
Personal Information
Total Experience: 13+ Years
Timeline
Senior System Administrator
Credit Suisse (Switzerland Bank)
06.2021 - 03.2024
ERP Functional Analyst
DXC Technology (Formerly Known As Hewlett Packard)
11.2010 - 06.2021
Bachelor of Technology - Information Technology
Jawaharlal Nehru Technology University
06.2001 - 12.2005
Similar Profiles
Ekaterina LapshinaEkaterina Lapshina
Senior Trade Finance Officer at Credit Suisse (Switzerland) LtdSenior Trade Finance Officer at Credit Suisse (Switzerland) Ltd
Helene OttenHelene Otten
Assistant Vice President Product Control at Credit Suisse BankAssistant Vice President Product Control at Credit Suisse Bank
Suraj SinghSuraj Singh
Team Lead (VP) : Prime Services IT Operations at Credit Suisse Corporate And Investment BankTeam Lead (VP) : Prime Services IT Operations at Credit Suisse Corporate And Investment Bank
Abhiram BarikAbhiram Barik
Architect at ZscalerArchitect at Zscaler
Sridhar BikkinaSridhar Bikkina
Senior Analyst -Dynatrace Administrator at StateStreet (HCL-Lead Engineer)Senior Analyst -Dynatrace Administrator at StateStreet (HCL-Lead Engineer)