Name: Swathi Shivayogi Boosnur Email: adx179@r.postjobfree.com

Mobile: 952-***-****

CAREER OBJECTIVE:

To secure a challenging position in a reputable organization to expand my learning’s, knowledge, and skills

SUMMARY:

6 years of hands-on experience of working with Power BI, Tableau, SQL script, SSIS, R Programming and Azure fundamental

Created customized report in Power BI and Tableau for Business Intelligence

Design and implement data models, perform statistical analysis and create Predictive Analysis Models

Implemented complex reports and dashboards with large data sets

Implemented drilldown charts, hierarchical reports, drill through reports, parameterized reports, informative reports, trend indicators.

Ability to learn, explore and implement new technologies.

Experienced in Sales and Production domain and Banking Domain Created dashboards, KPIs, scorecards and reports.

Coordinated with Quality Assurance associates to ensure all deliverables are accurate and of the highest quality.

Guided interns and juniors analysts by sharing expertise, providing feedback and helping them enhance their analytic skills. Also lead analytical projects, coordinating with cross- functional teams.

Involving in continuous improvement by seeking opportunities to improve data analysis processes, enhance data quality and identify innovative analytical techniques or tools that can drive efficiency and better outcomes

Experience in working with team environment as well as individual contribution

TECHNICAL SKILLS:

Business Intelligence Tools: Power BI, Tableau

Modeling tools: Star Schema, Snowflake schema

Programming Languages: R Programming, Visual studio 2018, Python, Jupyter Notebook, Py Spark

ETL Tool: Alteryx

Microsoft Power Platform: Power Apps, Power Automate

Data Science: Data Analysis, Azure Data Bricks

Database: SQL Server 2018, SSIS

Code repository: TFS and Knowledge on GIT hub repository

Cloud Technologies: Microsoft Azure.

Platforms: Windows.

EDUCATIONAL QUALIFICATION:

Bachelor of Engineering from Visvesvaraya Technological University, Belgaum, Karnataka India

PROJECT:

Employer CIBC Bank, Chicago, USA (Full Time position)

Project Credit Risk Management

Experience Mar 2022 – till date

Role Sr. Data Analyst

Roles and Responsibilities:

Worked with business teams to gather their reporting needs and develop interactive reports and effective visuals in Power BI and provide end-to-end solutions in Power BI.

Worked on assessing and managing various risks in the banking sector, such as credit risk, market risk and operational risk. This includes developing risk models, performing stress tests and providing risk mitigation strategies.

Prepared and reviewed dashboard specifications and design documents Perform source data analysis, data discovery and data profiling.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Generated context filters and data source filters while handling huge volume of data.

Created repeatable processes for data extraction, classification, enhancement, and analysis activities in Tableau.

Developed and maintained Tableau dashboards, and schedule, distribute, and run reports.

Customized the tooltips and labels, to user understandable format, the numerical measure was changed to its appropriate formats like representing the revenue, expense and margins as currency values.

Successfully implemented Dynamic Row level and Static row Level security across different Line of Business on Power Bi service and Desktop.

Built dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integrations.

Conducted performance tuning to ensure that dashboards function within acceptable parameters.

Created automated cloud flows in Power Automate to capture the responses with attachments into a SharePoint list from MS Forms.

Created an app to ease the process of intake form for the reports in Power Apps.

Ensuring that data analysis and reporting adhere to regulatory requirements and compliance standards specific to banking industry.

Collaborate with domain experts to understand business problems and develop data driven solutions

Documenting the work, including methodologies, code, queries and findings, to maintain a record of the project and facilitate knowledge sharing within the team.

Coordinated with Quality Assurance associates to ensure all deliverables are accurate and of the highest quality.

Guided interns and juniors analysts by sharing expertise, providing feedback and helping them enhance their analytic skills. Also lead analytical projects, coordinating with cross- functional teams.

Involving in continuous improvement by seeking opportunities to improve data analysis processes, enhance data quality and identify innovative analytical techniques or tools that can drive efficiency and better outcomes.

Environment: SQL Server 2018, Power BI, Tableau, MS-Excel, SharePoint, Microsoft office, Alteryx, Power Automate, Power Apps, Star Schema modeling, Python( Jupyter notebook), Py Spark, Azure Data Bricks.

Employer Techno Pack

Project Techno Sales and manufacturing Reporting

Experience Sep 2017 – July 2021

Role Power BI Developer

Technology/Software Power BI, MS SQL server (On-premise and azure) and JIRA

Profile This project is intended to cater the data analytical need for the company Sales.

Based on Requirement need to create Data model and create various charts and Dashboards using Power BI for Machine analysis.

In this project we were dealing with company sales for their Clients. I was mainly involved in processing the raw data from different sources and developing a customized visual representation of data by using Power BI and adhoc reports

Responsibilities:

Developed visual reports, dashboards and KPI scorecards using Power BI desktop.

Created reports by connecting to various data sources, importing data and transforming data for Business Intelligence.

Develop and present data in Dashboard to Client

Excellent in analytical thinking for translating data into informative visuals and reports.

Able to implement row level security on data and have an understanding of application security layer models in Power BI.

Proficient in making DAX queries in Power BI desktop.

Expertise in using advance level calculations on the data set.

Responsible for design methodology and project documentation.

Able to develop tabular and multidimensional models that are compatible with warehouse standards.

PERSONAL DETAILS:

Type of Visa : H4 EAD

Sponsorship Required : No

Eligible to work for

Any Employer in US : Yes

Notice Period : 15 days

Current Location : Indianapolis, Indiana, USA

Contact this candidate