Rakshand Topucharla
Westborough,MA
Summary
Results-driven Business Analyst with a proven track record at CIBC, leveraging SQL and Python to enhance data quality and automate reporting processes. Skilled in Power BI and cross-functional collaboration, I delivered actionable insights that improved operational efficiency by 20%, driving strategic decision-making and optimizing resource utilization.
Overview
5
5
years of professional experience
Work History
Business Analyst
CIBC
Remote , USA
08.2024 - Current
- Data Preparation: Used SQL and Python for data extraction, cleaning, and transformation from multiple sources, ensuring high data quality. Employed various techniques to handle missing data, outliers, and inconsistencies, making datasets ready for analysis.
- Predictive Modeling and Machine Learning: Applied machine learning algorithms such as logistic regression and decision trees to forecast project outcomes. Developed a model to predict resource allocation for community-driven initiatives, achieving a 20% improvement in operational efficiency.
- Data Visualization and Reporting: Designed interactive Power BI dashboards to visualize social impact metrics. Created drill-down reports that enabled stakeholders to explore detailed metrics and compare various scenarios, contributing to data-driven decision-making.
- Automation and Efficiency: Automated routine data reporting using Python scripts, reducing manual work by 30%. This allowed more time for strategic analysis and insights generation, streamlining data flow between departments.
- Impactful Insights and Recommendations: Delivered comprehensive reports that provided actionable insights for enhancing project execution. Recommendations led to a 15% increase in resource utilization efficiency, significantly benefiting the target communities.
Business Analyst
Credit Acceptance
Southfield, MI
05.2023 - 08.2024
- Business Problem Identification: Collaborated with cross-functional teams to identify core business challenges. Translated complex business problems into specific data analysis questions, ensuring alignment between data outputs and business goals.
- Exploratory Data Analysis (EDA): Utilized Python for extensive data exploration. Applied statistical techniques to examine the distribution of key variables, detecting patterns and anomalies. Cleaned and transformed data to ensure its readiness for analysis.
- Model Development and Testing: Built and tested machine learning models (such as random forests and SVMs) to predict equipment performance. Implemented models that reduced information delays and improved data processing times, leading to better operational decision-making.
- Data Cleansing and Quality Assurance: Developed procedures for cleaning raw datasets, addressing issues like multi collinearity and autocorrelation. Improved data accuracy by implementing robust data validation checks, enhancing reliability for further analysis.
- Advanced Reporting: Created detailed Power BI visualizations that allowed stakeholders to easily interpret complex data. Presented insights to senior management through data storytelling, ensuring that findings were clear and actionable.
- Project Optimization: Identified inefficiencies in data processing workflows and recommended process improvements. Implemented automated routines that reduced delays in data reporting and boosted overall system performance by 25%.
Business Analyst
Virtusa
Hyderabad, Telangana
05.2021 - 12.2022
- Market Experiment Analysis: Analyzed data from over 1,000 marketing experiments to identify key trends and insights. Utilized SQL to query and clean large datasets, ensuring data integrity before further analysis.
- Data Quality and Governance: Conducted comprehensive data cleaning on over 5 million customer records, resolving issues like missing data, duplicate entries, and inconsistencies. Established data governance frameworks to ensure ongoing data integrity, resulting in a 15% improvement in data accuracy.
- Predictive Modeling for Sales and Marketing: Developed predictive models using Python and machine learning algorithms to forecast customer behavior. These models helped optimize marketing strategies and increased campaign success rates by 20%.
- Data Preparation and Standardization: Prepared and standardized marketing data for analysis by applying normalization and scaling techniques. Processed over 10,000 data points to ensure accurate and efficient analysis, improving the accuracy of business forecasts.
- Business Reporting: Created custom Power BI dashboards that provided real-time insights into marketing performance. These dashboards allowed stakeholders to track KPIs, monitor campaign performance, and identify areas for improvement.
- Cross-functional Collaboration: Engaged with marketing, finance, and operations teams to provide data-driven solutions that aligned with business objectives. Contributed to a 30% reduction in operational costs by implementing data-driven process improvements.
Junior Business Analyst
Blue Dart
Chennai, TN
05.2020 - 05.2021
- Historical Data Analysis: Led the analysis of 8 years of historical business data using MySQL. Provided detailed insights into customer trends, contributing to long-term strategic planning for business growth.
- Data Integrity Improvements: Implemented data cleaning and transformation processes using Python to improve data quality. Enhanced data accuracy by 15%, reducing the likelihood of errors in business reporting.
- Marketing Strategy Development: Worked with the marketing team to analyze customer behavior and inform strategy. Developed insights that contributed to a 32% increase in sales through targeted marketing efforts.
- Process Optimization: Identified inefficiencies in existing business processes and worked with cross-functional teams to develop optimization strategies. Reduced manual efforts by automating data extraction and reporting processes, saving 10% of total man-hours monthly.
- Reporting and Stakeholder Communication: Developed detailed reports using Excel and Power BI, delivering key insights to senior leadership. Presented data-driven recommendations that directly influenced marketing and sales strategies.
Education
Master of Science - Masters in Information Studies
Trine University
Angola, IN05-2025
Bachelor of Science - Computer Science
SRM University
Chennai, India05-2022
Skills
- Business Intelligence: PowerBI, Tableau, QlikView, Apache Superset, Oracle forms and reports, Azure Cloud, IBM Cognos, salesforce, Looker
- Languages: Oracle SQL, SQL-queries, PL/SQL
- Other ETL/Reporting Tools: SSIS, SSAS, Microsoft Azure ML, SQL Server Reporting Services (SSRS), Crystal Reports
- Databases: Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008, DB2, MySQL, Snowflake, Amazon Redshift
- Operating Systems: Windows 98/XP/7/10, 11 Unix, Linux
- Tools: Toad, SQL Plus, SQL Developer, SQL Server Management Studio, MySQL Workbench, SAS/ES, Anaconda, Oracle, SQL Server, Azure, ETL, Postman
- Applications: Advanced MS Excel, MS Visio, MS Access, Adobe, JIRA, Atlassian, Bitbucket, ServiceNow
- Keycloak, NiFi, Alteryx
Timeline
Business Analyst
CIBC
08.2024 - Current
Business Analyst
Credit Acceptance
05.2023 - 08.2024
Business Analyst
Virtusa
05.2021 - 12.2022
Junior Business Analyst
Blue Dart
05.2020 - 05.2021
Master of Science - Masters in Information Studies
Trine University
Bachelor of Science - Computer Science
SRM University
Similar Profiles
Marzia AliMarzia Ali
Mortgage Specialist at CIBCMortgage Specialist at CIBC
Nena BrownNena Brown
Sr. Manager, Talent Acquisition Strategy & Program at CIBCSr. Manager, Talent Acquisition Strategy & Program at CIBC
Jenniffer RodriguezJenniffer Rodriguez
Customer Service Representative at CIBCCustomer Service Representative at CIBC
Amina Mohammed IkafAmina Mohammed Ikaf
Case Manager – Client Care at CIBCCase Manager – Client Care at CIBC
PRINCE ANTWIPRINCE ANTWI
User Services Technician at Hologic Inc.User Services Technician at Hologic Inc.