Rajarshi Boggarapu
Dallas,TX
Summary
Dynamic and results-oriented Business Analyst with extensive experience in utilizing SQL, Python, and business intelligence tools to derive actionable insights, streamline workflows, and implement impactful solutions within the finance and IT sectors. Proficient in developing interactive dashboards and visualizations using Tableau, Power BI, and Excel to facilitate data-driven decision-making. Well-versed in Software Development Life Cycle (SDLC), Agile, and Waterfall methodologies, with a solid foundation in ETL processes, data modeling, and comprehensive requirement documentation (BRD, FRD, SRS). Experienced in leveraging tools such as JIRA, Salesforce, AWS, and MuleSoft to ensure seamless integration and successful project execution. Skilled in conducting cost/benefit and risk analyses, as well as process redesign initiatives, to enhance operational efficiency and drive positive business outcomes.
Overview
4
4
years of professional experience
Work History
Business Analyst
Freddie Mac
01.2024 - Current
- Collaborated with stakeholders at Freddie Mac to gather and document business requirements, effectively translating them into actionable deliverables for development teams
- Designed and implemented dashboards and visualizations using Tableau and SQL, providing transparency and real-time tracking of financial KPIs and product performance within the organization
- Enhanced Freddie Mac's CRM systems by integrating third-party applications, enabling real-time insights for sales and customer service teams to improve operational efficiency
- Conducted rigorous testing on over 50 programs and databases, identifying and rectifying errors, which resulted in a 30% reduction in system downtime and significantly improved overall performance
- Successfully modified and optimized more than 10 existing databases and database management systems at Freddie Mac, leading to a 25% increase in data retrieval speed and enhanced user satisfaction
Business Analyst
Hellinex Cloud
01.2021 - 07.2022
- Led a team of 5 programmers and analysts in implementing database changes, improving project efficiency by 20% and ensuring adherence to quality standards
- Developed interactive dashboards using Power BI and Tableau to showcase financial performance metrics and operational insights
- Authored logical and physical database descriptions for 15+ databases, enhancing data organization and reducing retrieval time by
- Conducted advanced SQL data validation to ensure report accuracy and created documentation for ETL processes to facilitate team communication
- Authored detailed documentation for ETL processes, data mappings, and workflows to maintain clear communication across teams
- Managed financial datasets in SQL Server, optimizing query performance and reducing report generation times, while implementing a standardized process for database modifications that cut modification time by 35%
- Utilized Python for data cleaning and preprocessing, improving data accuracy, and identified over 200 errors in database systems, leading to a 50% decrease in user-reported issues.
Education
Master - Business Analytics
The University of Texas
May 2024
Bachelors - Business Administration
Vellore Institute of Technology
May 2022
New Models of Business in Society - undefined
Skills
- SKILLS SET
- Methodologies:
- SDLC, Agile, Scrum, Waterfall
- Documentation: BRD, FRD, SRS, Process Flow Diagrams
- Business Intelligence Tools: Tableau, Power BI, Qlik, SSRS, Excel
- Databases & Programming: SQL (MySQL, SQL Server, PostgreSQL), Python (Pandas, NumPy, Matplotlib), R
- Cloud & Integration Tools: AWS (S3, EC2, RDS), Azure, MuleSoft, Alteryx, Postman
- Analysis Techniques: Cost/Benefit Analysis, GAP Analysis, Impact Analysis, Risk Analysis, SWOT Analysis
- Project Management Tools: JIRA, Azure DevOps, MS SharePoint, MS Project
- Version Control: Git, GitHub, GitLab
- Other Tools:
- Salesforce, Oracle ERP, SAP, Figma, Jupyter, Notebook
Timeline
Business Analyst
Freddie Mac
01.2024 - Current
Business Analyst
Hellinex Cloud
01.2021 - 07.2022
Master - Business Analytics
The University of Texas
Bachelors - Business Administration
Vellore Institute of Technology
New Models of Business in Society - undefined
Similar Profiles
Aarthi MurugesanAarthi Murugesan
Product Manager at FREDDIE MACProduct Manager at FREDDIE MAC
Jarred FaustJarred Faust
Investments & Capital Markets Operations Associate at Freddie MacInvestments & Capital Markets Operations Associate at Freddie Mac
Mahendra ChoudharyMahendra Choudhary
Product Owner at Freddie MacProduct Owner at Freddie Mac
Durga Priya VanamDurga Priya Vanam
Big Data Engineer at Freddie MacBig Data Engineer at Freddie Mac
Toni YoungbloodToni Youngblood
Licensed Realtor at DFW Britestar Realty PLLCLicensed Realtor at DFW Britestar Realty PLLC