Sai Kumar Pakalapati

• Demonstrated a high level of initiative and creativity while tackling difficult tasks.
• Proven ability to learn quickly and adapt to new situations.
• Used strong analytical and problem-solving skills to develop effective solutions for challenging situations.
• Identified issues, analyzed information and provided solutions to problems.
• Power BI - Development of new dashboards to automatize manual work currently in place
• Snowflake - Proposals to move existing legacy data to Snowflake based architecture and thereby integrating the data into Power BI visualizations.

I have been privileged to work on multiple BI and Analytics projects catering to various esteemed organizations in different Industries. Apart from the below listed projects I have also been part of bidding for new projrcts and creating POCs to demonstarte the required capabilites when required.

Project: BARACUDA(BMW)

Duration: May 2022 - Dec 2022

Aim of the project is to develop an end-to-end system to extract, transform and visualize data related to electricvehicles thereby evaluating their individual health. All the ETL related development has been done on AWS and the front end has been developed on multiple technologies such as Tableau and QuickSight.

• Created proofs of concept for innovative new solutions.
• Creation of glue, Athena and Lambda (Python based )jobs to extract and process the data from various sources inclding S3 buckets from other accounts.
• Overall Ownership of setting up an QuickSight account within the AWS account and developing appealing dashboards based on the transformed data in S3 buckets.

Project:FINDWH(IKEA)

Duration: Jan 2021 - Apr 2022

The Project is meant to develop a full proof system for Finance department within Ikea ecosystem worlwide to validate and finalize their data sind Oracle, Qlik and PowerBI.

• Creating proofs of concept to migrate existing Qlik dashboards to Power BI using Power BI desktop.
• Connecting Power BI to various Back end systems.
• Extracting and shaping data based on next development needs.
• Creating data models to be used either as self service or as developed Reports.
• Extensive usage of DAX to calculate new fields having performance of the expressions as highest priority while maintaining data quality.
• Appealing Visualisations created after discussions with the business users.
• Estimated work hours and tracked progress using agile methodology.
• Documented software development methodologies in technical manuals to be used by IT personnel in future projects.

Project: CONDIS(BMW)

Duration: Apr 2019 - Dec 2021

The aim of the project is to have a front-end system with multiple back-end systems to track the movement of newly produced vehicles from the point of leaving various BMW production plants till they reache the respective dealers located all over the world using various technologies such as Splunk, Hadoop, QlikSense and AWS

• Designing end to end Qlik architecture for efficient functioning of the dashboards.
• Lead a team of Qlik developers responsible to develop various dashboards based on business needs.
• Developed Incremental load for data being fetched from back-end.
• Training business users on effective usage of the dashboards.
• Very acquaint with Agile methodology and have been involved in all meeting such as Grooming, Retro,hand-over etc.,

Single point of contact within the organization for all Business Intelligence - Qlik View related queries and new requests.

• Extensively developed and maintained three dashboards catering to different set of business users.
• Thorough testing of dashboards to ensure data quality before roll-out.
• Organizing workshops to train Sales representatives and management group on the usage of Qlik dashboards.

Database developer involved in large projects responsible for all database related activities

• Gained extensive experience on Microsoft SQL Server specially on SSIS and SSRS implementations.
• Developed first POC within the business unit for SSRS automated reports along with Email based scheduled delivery to business users.
• Development of SAP BO Webx and Crystal Reports based on SAP BW data.
• Successfully developed and implemented Qlik sense dashboards as POC for business to understand the benefits of moving to New BI from traditional BI systems.