Rakesh Gurram Email & Phone Number

United States

Jefferson City, Missouri, United States

I’ve significantly optimized data pipelines and ETL processes by refining file formats and code, leading to enhanced efficiency and performance. My experience includes extracting, transforming, and loading data from diverse sources into Power BI, and developing robust data models with Azure services like Azure Analysis Services and Azure Synapse Analytics. I’ve utilized SQL and Python extensively for data accuracy and integrity, and leveraged Salesforce CRM data to improve marketing strategies and sales performance.I’ve designed and maintained Azure-based data warehouses for both structured and unstructured data, and applied advanced statistical techniques and machine learning algorithms in Jupyter Notebook for improved business forecasting. My expertise extends to managing Hadoop clusters, developing Python scripts and data analysis workflows, and crafting compelling dashboards and reports with tools like Power BI, Sisense BloX, and ElastiCube to support data-driven decision-making.In addition, I’ve developed complex SQL queries and stored procedures for MySQL, PostgreSQL, and Oracle databases, and utilized SAS for data manipulation and reporting. I’ve automated data tasks, transitioned processes for more frequent updates, and provided training on Power BI. My collaborative approach involves working with cross-functional teams, integrating Python solutions, managing projects with JIRA, and ensuring seamless execution of ETL processes through detailed BRDs and ER diagrams.

San Francisco, California, United States

I have extensive experience in data engineering and analysis, where I have significantly improved performance and data integrity across various platforms. I implemented data transformations during loading and redesigned views in Snowflake, conducted rigorous unit tests for accuracy between Redshift and Snowflake, and utilized Python and SQL to manage data from sources like Amazon S3, SQL Server, and Salesforce. My role involved designing and executing hypothesis and A/B tests using Google Analytics and SQL, which provided actionable insights for data-driven decision-making. Additionally, I was responsible for optimizing AWS costs through cost-effective solutions, leveraging tools such as AWS Cost Explorer, and maintained interactive dashboards in Power BI to deliver intuitive, data-driven insights to stakeholders.In collaboration with cross-functional teams, I designed and implemented scalable data models and warehouse solutions using MySQL, enhanced Hadoop cluster performance through configuration adjustments, and documented analysis procedures in Jupyter Notebook for transparency. My responsibilities also included comprehensive data backup and disaster recovery strategies on AWS, employing services like Amazon S3, AWS Backup, and AWS Disaster Recovery to ensure business continuity.Furthermore, I conducted detailed data analysis using statistical tools such as R, IBM SPSS, and SAS to uncover trends and build predictive models. I took charge of monitoring AWS infrastructure performance with CloudWatch, CloudTrail, and AWS Config, and maintained Power BI reports to ensure their accuracy. My role involved documenting project details using Confluence, managing project status updates, conducting training sessions on Power BI, and mentoring junior Python developers. I streamlined issue tracking with JIRA, maintained regular communication with stakeholders, and actively sought their input to ensure project success.

Mumbai, Maharashtra, India

In my recent role, I specialized in optimizing database performance and streamlining data management. I implemented advanced data partitioning strategies in PostgreSQL to enhance query efficiency and handle extensive datasets. My work also involved creating and managing data transformation pipelines with Azure Databricks and Azure Synapse Analytics, which facilitated the cleaning, preprocessing, and enrichment of raw data. Additionally, I worked with database administrators to monitor Oracle database performance and supported transitions to Teradata, ensuring seamless ETL processes.I played a significant role in integrating analytical tools and handling various data sources. I collaborated with statisticians and data scientists to deploy advanced analytics models in SAS and developed predictive models and conducted data mining in IBM SPSS. I also managed code versioning by integrating Jupyter Notebook with Git and created customized reports and dashboards in Google Analytics. My responsibilities included preparing and cleaning data with IBM SPSS Data Preparation and developing data models using Azure SQL Database and Azure Analysis Services for comprehensive reporting and analysis.Furthermore, I engaged with Marketing and Operations teams to define and align data requirements with business objectives. I produced actionable reports and visualizations using Python, SQL, and Tableau, and managed Tableau user access and permissions while providing training to end-users. My role also included setting up monitoring and alerting systems with Azure Monitor and Azure Log Analytics to preemptively address issues and overseeing QA processes to ensure data integrity and successful project outcomes.

Mumbai, Maharashtra, India

In my role, I have leveraged Tableau to generate insightful dashboards and reports, providing policyholder analytics to stakeholders and facilitating informed decision-making. I also documented my Python codebase meticulously, enhancing knowledge sharing and ensuring maintainability. My expertise extends to executing data transformation and cleansing processes using AWS Glue and AWS DataBrew, which ensures data quality and consistency for downstream analytics.Additionally, I have created complex Excel models and spreadsheets for data analysis and visualization, collaborating with business stakeholders to interpret findings from IBM SPSS analyses. My work includes conducting exploratory data analysis (EDA) and visualizations with Pandas, NumPy, and Matplotlib in Jupyter Notebook, and performing both descriptive and inferential statistical analyses using IBM SPSS Statistics on large datasets.Furthermore, I have implemented automated backup and disaster recovery solutions with AWS Backup and AWS Disaster Recovery, ensuring data integrity and availability. I’ve configured Google Analytics to track and analyze website traffic and user behavior, validated SAS programs for regulatory compliance, and developed and maintained AWS data pipelines. My role also involves supporting data migration test plans, ensuring data accuracy and adherence to acceptance criteria.