Power Bi Sql Server,Python,Data analytics,AI/ML,SSRS,SSIS

Bhagya Putam

Email: *********@*****.***

Phone: 916-***-****

PROFESSIONAL SUMMARY

●8+ years of hands-on experience in the field of Business Intelligence, with expertise in designing, developing, and implementing BI solutions across multiple industries.

●Strong proficiency in SQL programming, with a solid foundation in creating complex stored procedures, user-defined functions, SQL joins, and optimizing data queries to ensure seamless data manipulation and integrity.

●Proficient in MSBI tools, specifically SQL Server Integration Services (SSIS) for ETL processes, SQL Server Reporting Services (SSRS) for reporting solutions, and Power BI for interactive data visualizations. Extensive experience in designing and building dashboards, reports, and data models.

●Deep expertise in Power BI: Designed and developed interactive and advanced Power BI reports and dashboards, leveraging DAX functions and Power Query transformations to deliver actionable insights tailored to business needs. Proficient in designing a variety of visualizations, including slicers, heat maps, scatter plots, and more.

●Advanced experience in creating SSRS reports: Including parameter-based reports, drill-down reports, matrix reports, and graphical reports. Hands-on experience in managing report security and accessibility in multi-user environments.

●Strong background in data analysis, data cleansing, and data verification. Skilled in transforming complex datasets into meaningful insights using SQL queries, visualizations, and statistical techniques.

●Effective in collaborating with stakeholders at all levels: Proactively engaged in requirement gathering, process design, and solution delivery with both business and technical teams, ensuring alignment with organizational goals.

●Comprehensive knowledge of SDLC methodologies: Comfortable working in both Agile and Waterfall frameworks, ensuring timely and efficient project delivery. Demonstrates flexibility and strong communication skills when working in dynamic, fast-paced environments.

●Strong experience with Excel including pivot tables, VLOOKUP, and other advanced features to support data analysis and reporting needs.

●Excellent problem-solving abilities, with a keen eye for identifying trends and patterns within large datasets, and the ability to transform findings into strategic recommendations that drive business decisions.

●Effective trainer and mentor: Led training sessions for team members and other stakeholders, improving their understanding and utilization of BI tools, reports, and best practices.

●Proactive team player with excellent interpersonal skills, capable of managing projects independently or within a team setting, maintaining a focus on high-quality deliverables and continuous improvement.

TECHNICAL SKILLS

●Operating Systems: Microsoft Windows, Linux

●Business Intelligence Tools: Microsoft BI (SSIS, SSRS), Power BI, Tableau, Self-service BI (Power Pivot, Power View, Power Map, Power Query), Power BI Report Builder

●ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

●Databases: MS SQL Server, Oracle DB2, MS Access

●SQL Server Tools: SQL Server Management Studio (SSMS), T-SQL, SQL Agent, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

●Data Modeling Tools: Microsoft PowerPoint, Microsoft Project / Office

●Languages: C, Python, TSQL, Visual Basic

●Other Tools: Excel Pivot Tables, VLOOKUP, Google Spreadsheets, QuickBooks

EDUCATION

●Masters in Commerce, Osmania University

●Post Graduate Diploma in Data Science and Business Analytics, Texas McCombs School of Business (GPA 3.7)

●Diploma in Computer Applications

●Currently enrolled in Post Graduate program in Artificial Intelligence and Machine Learning, Texas McCombs School of Business.

PROFESSIONAL EXPERIENCE

Health Axis, Tampa, FL

Senior Business Intelligence Analyst

March 2022 - December 2023

●Designed and developed a wide array of reports and interactive dashboards in SSRS and Power BI, including a Claims Time Service Dashboard, reducing manual processing time by over 50%.

●Led the business requirements gathering process, closely collaborating with stakeholders to translate business needs into technical specifications.

●Automated existing CMS reports, such as ODAG, by transitioning them to Power BI, improving reporting efficiency and accuracy.

●Developed complex SQL queries to retrieve the data.

●Created ad-hoc reporting solutions using SSRS and Excel to support various business functions.

●Developed and optimized complex DAX queries for creating actionable insights through Power BI dashboards.

●Evaluated and debugged existing BI programs, ensuring data integrity and resolving performance issues.

●Worked with cross-functional teams, including DBAs, architects, and business users, to drive the BI development lifecycle from requirements to deployment.

●Trained junior analysts and other team members on BI processes, helping to establish best practices across the team.

●Collaborated with data management teams to clean, validate, and prepare datasets for BI solutions.

Members Choice Credit Union, Houston, TX

Senior Business Intelligence Analyst

September 2018 - July 2020

●Designed and developed complex SSRS reports for various departments, including Finance, Operations, and Marketing.

●Lead data analysis and preparation processes to support credit card operations, performing extensive exploratory data analysis (EDA) to derive business insights.

●Designed and developed the end-to-end process from retrieving the data from the SQL server to the day-to-day reporting of the credit card operations by creating the daily, weekly and monthly reports which reduced the manual reporting time by 20%.

●Developed complex SQL queries in the data retrieval process from SQL Server.

●Implemented SSIS ETL solutions for seamless data integration into the organization’s data warehouse.

●Developed customized reports for SAP database systems, creating automated SSIS packages for daily, weekly, and monthly data loads.

●Worked with SQL Server Job Agent to schedule and monitor the execution of SSIS packages, ensuring smooth data processing operations.

●Assisted the Accounting department by delivering month-end reports and balancing financial accounts using SSRS and Excel.

●Participated in SDLC meetings with business analysts, data architects, and other stakeholders to ensure project success and timely delivery.

●Actively engaged with cross-functional teams to gather data requirements and create technical design documents for BI solutions.

Maddisoft, Houston, TX

Business Analyst

January 2018 - August 2018

●Developed Power BI models to support reporting and employee headcount analysis, incorporating DAX functions to enhance data-driven insights.

●Designed and implemented automatic data refresh schedules within Power BI Service, ensuring timely and accurate data for decision-making.

●Gathered and documented business requirements from stakeholders, ensuring alignment with functional and technical needs.

●Built process maps to outline current and future business processes, providing clear visual representations for stakeholders.

●Reported on identified risks and worked to mitigate them, providing actionable recommendations for business improvements.

VLK Solutions, Houston, TX

Business Intelligence Analyst

September 2014 - September 2017

●Created multiple reports in SSRS and Excel, supporting key business functions and decision-making.

●Utilized Power BI visuals to create interactive dashboards and data visualizations that effectively communicated business insights.

●Performed account reconciliation and provided valuable insights through detailed financial reports.

●Managed customer accounts, created invoices, and processed payments, ensuring accuracy and timeliness.

●Utilized QuickBooks for data input and financial reporting, supporting business operations.

Academic Course Projects for Data Science and Business Analytics

University of Texas (Feb 2021 - September 2021)

●Axis Health Insurance: Statistical analysis and visualization to assess customer health data for determining insurance charges. Skills: Hypothesis Testing, Data Visualization, Statistical Inference.

●All Life Bank Customer Segmentation: Used K-Means and Hierarchical Clustering to segment customers for targeted marketing strategies. Skills: EDA, KMeans Clustering, Hierarchical Clustering.

●Travel Package Purchase Prediction: Built predictive models to identify potential customers for a new travel package. Skills: EDA, Random Forest, AdaBoost, Gradient Boosting, Hyperparameter Tuning.

●All Life Bank Personal Loan Campaign Modelling: Created models to predict potential loan customers, applying Logistic Regression and AUC-ROC analysis. Skills: Logistic Regression, Decision Trees, AUC-ROC Curve.

●Cars4U Pricing Model: Developed a pricing model for used cars using Linear Regression to assist business strategy. Skills: EDA, Linear Regression, Business Insights.

●Cardio Fitness Product Analysis: Analyzed cardio fitness product data to evaluate product effectiveness. Skills: Python, EDA, Regression Analysis.

*** References Available Upon Request ***

Contact this candidate