Deekshitha Reddy S
BI Developer
Email ID: **********.****@*****.***
Sample Work: Sample Work.docx
Contact: 872-***-****
EXECUTIVE SUMMARY:
An experienced and highly motivated IT professional with around 9+ years of experience in analysis, Data Governance, design, development, testing, managing and support of Business Intelligence products and services in Microsoft Power BI, Tableau, Cognos, SQL, Data warehousing and ETL.
Experience in complete Software Development Life Cycle (SDLC), Agile & waterfall methodology, using Jira software more over maintaining the BRD-Business Required Document and FRD-Functional required documents.
Thorough knowledge of ETL tools such as SSIS, Alteryx, Informatica, Talend, AWS Glue, Azure Data Factory.
Expertise in using ETL tools for data integration, Data transformation, Dimensions changing over time by creating packages, control flow, data flow.
Proficient in managing databases, data warehouses, Cloud Databases like MY SQL, Oracle, SQL Server, Teradata, Azure, AWS.
Good knowledge of Data warehousing, OLAP, Dimensional Data Modeling like Star Schema Modeling, Snow – Flake Modeling for Fact and Dimensions Tables using Analysis Services.
Performed A/B testing for making better decisions between two variables, optimizing performance, Reducing risk.
Good knowledge of database programming and standard languages like SQL, T-SQL, Alteryx Formula Language, PL-SQL, Python, R.
Create Temp Tables, Views, Functions, Stored Procedures in SQL Server also can write queries for data Analysis by using where clause, having, group by, join functions, Window Functions.
Proficient in MSBI tools, SQL Server Integration services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS).
Conducted the A/B testing for making better decisions between two variables, optimizing performance, Reducing risk.
Skilled in using Business Intelligence tools such as Power BI, Tableau, MS Dynamics, OBIEE, Cognos for data visualization, Reporting, Analysis.
Expertise in Power BI Tools such as power BI desktop, power BI services, power apps, Power automate, power on, power pivot, power query.
Created many reports using charts, Visualization, DAX functions, M code, new measures, new columns, filters for insightful and interactive visualizations on power BI Desktop.
Good at creating calculated fields, Bins, Groups, sets for easy and meaningful reports on Tableau desktop and schedules the reports for refreshments and publishes them to Tableau server.
Experience in scheduling refreshments for data sets, reports and publishing them to servers in a secure way by giving access to subscribed users.
Good knowledge of Data Marts, Data warehousing, Data lakes, Operational Data Store (ODS), OLAP, and Data Modelling like Dimensional Data Modelling, Star Schema Modelling, Snow-Flake Modelling, and FACT and Dimensions Tables.
TECHNICAL SKILLS:
Databases : MY SQL, SQL server, Oracle, Sales force, Teradata, DB2, Postgres.
Cloud databases : Azure, AWS, Service now, GCP, Snowflake.
ETL Tools : SSIS, Informatica, Talend, Azure, AWS, snowflake Migration. .
BI Tools : Power BI, Tableau, Cognos, Excel, SSRS, Spotfire, OBIEE.
Power Platform : Power BI Desktop, services, Power on, Microsoft Fabric, Copilot, Automate, Power BI embedded, Apps,
Languages : SQL, DAX, T-SQL, PL-SQL, Python, R.
Methodologies : Waterfall, Agile, Jira software, Azure DevOps, Sales force, SharePoint, SDLC.
CI/CD : Azure.
UI/UX : Axure.
Data Modeling : Star Schema, Snowflake Schema, Logical & Physical, Dimensional Modelling.
WORK HISTORY:
Northern Trust, Chicago, IL Nov 2024 – Till Date
Power BI Developer
Followed the Agile principles, attended stand-up meetings, sprint reviews, retrospectives and worked on Azure DevOps to monitor the tasks, user stories.
Worked on Azure Devops to create features, User stories by myself for daily calls, Retrospective calls.
Worked with Snowflake to Analyze, Validate, manipulate data simultaneously written queries.
creating sophisticated Power BI solutions that extract useful insights from a variety of datasets by leveraging intricate data models, DAX expressions, and unique visualizations.
Worked on views according to the requirements to generate the reports for fast, accurate results.
Working on Git hub to raise the PR for data migration after creating views from one environment to another environment.
Managed parameters in power query for source connection, reduce the latency of refreshments, data transformations.
Implemented advanced expressions and calculated fields in Report Builder for dynamic content customization.
Generated HTTP API’s for Power automate flows using HTTP request action to collaborate workflow with airflow for automatic email setup.
Connected API with power BI for reports generation as a POC.
Used Copilot as a POC to automate data insights extraction and narrative generation, improving dashboard interactivity and user understanding.
Collaborated with Copilot to suggest optimal visualizations and KPIs from complex datasets, reducing manual effort and boosting development efficiency.
Enhance data collecting and reporting systems using SharePoint and the Microsoft Office 365 Power Platform, which includes Power Apps, Power Automate (Flow), and Power BI.
worked with different types of filters like report level, Visual Level and Page Level filters.
Creating different chart types including KPI’s, Custom Visuals, Column charts, Pie Charts, Bar Charts, Funnel charts and Waterfall charts as per the data type.
In charge of handling all aspects of Power BI service administration, including creating, monitoring, and troubleshooting data sources, managing users, workspaces, and gateways.
Designed DAX measures to create custom aggregations for KPIs and metrics not readily available in source data.
Designed and implemented complex DAX calculations, including time intelligence functions, dynamic measures, and calculated columns, to deliver actionable insights.
Worked on both Import, direct query mode for data extraction from Snowflake.
Deployed the workbooks, dashboards to Power BI services, worked on scheduling while publishing them to services.
Worked on Power automate, created workflows to send automatic emails for the reports.
Environment: Azure DevOps, One Drive, SharePoint, Power BI (Desktop, Services), Power BI Report Builder, Power Query, DAX, gateways, SQL, Power automate, Microsoft Copilot, API, GitHub, Snowflake, Excel.
Fannie Mae, Plano, Texas Oct 2023– Oct 2024
Power BI Developer
•Attended the Sprint backlog Planning, Daily Scrums to elicit the requirements. Sprint Reviews, and Retrospective Meetings to get the reviews, feed backs for the done tasks.
•Functioned actively with Jira tool to monitor & get the updates of tasks.
•Developed and maintained the Power BI reports, dashboards based on yearly, monthly, weekly data to support financial reporting, Analysis, decision making processes.
•Designed Daily Customers, Department based Reports or Dashboards using Power BI to build robust applications to provide insights on Sales key metrics such as Turnover, Gross Sales Volume, and Trade Terms, along with the product and customer details their daily trends, and so on.
•Worked on SharePoint for Document management such as storing, organizing, managing, Collaboration with team, sharing feedback, Version control.
•Performed ETL process and loaded humongous amounts of data from source systems to Target systems.
•Excellent understanding of Data modeling using the concepts like Star-schema, and Snowflake schema using fact and dimension tables.
•Performed Debugging, Optimizing the Dashboards / Reports, and Performance Tuning of Dashboards / Reports Power BI and report tuning techniques in Power BI to meet client requirements and followed best test approaches like UAT before delivering the output.
•Developed Stored Procedures, Functions, Triggers to reduce the query run time and increase the performance tuning.
•Created schedule refreshments in Power BI service to reduce the manual efforts and if needed did manual refreshments as well for weekly, monthly dashboards.
•Wrote many DAX functions for accurate and meaningful visualizations, insightful data reports.
• worked on all power BI components such as Power Query, Pivot, View.
•Created automating repetitive tasks such as file management, data extraction, data synchronization using Power Automate.
•Created the Power BI Embedded interactive reports to integrate the reports with applications.
•Developed various solution-driven views and dashboards by developing different chart types including KPIs, Custom Visuals, Column charts, Pie Charts, Bar Charts, Funnel charts, and Waterfall charts.
•Created static and dynamic row level security for the data security, also performed the incremental refreshment to avoid the latency in data refreshment.
•Created, Stored, Managed, analyzed data in Azure Synapse, ADL, Azure SQL data warehouse, worked with Azure data-bricks, Azure Data Factory data integration.
•Developed and deployed predictive models for customer behavior and sales forecasting using Python (scikit-learn, statsmodels) to drive data-informed business strategies.
•Worked on python programming language for data validation and data analysis. Used many python libraries like NumPy, Matplotlib, pandas, seaborn.
•Created reports using REST API’s using import mode for better performance.
•Working on developing dashboards, performance optimization, and various ad-hoc change requests as per the client’s requirement to provide insights on the most granular level and make the applications user-friendly and System Integration Test (SIT) to maintain data accuracy.
Environment: Azure, AWS, Share Point, SQL Server 2016, SSIS, Power BI (Desktop, Service), Power BI report builder, Power BI Embedded, Power Automate, Power APPS, MS Dynamics, Jira, Python, Agile Methodology, Excel, DAX, SQL, T-SQL, REST API, SQL Server Data Tools (SSDT).
Centerlight Health, New York Feb 2023 – Sep 2023
BI Developer
Responsibilities:
•Business analysis, Database focusing on Requirement Analysis, Development, Testing, Administration, and Implementation of BI Solutions in Health care, working closely with Business Analysts, End users to glean the requirements.
•Covering all phases of SDLC (System Development Life Cycle) including business requirements analysis, design, development and implementation, Testing, ongoing support, Maintenance.
•worked closely with different members for seamless output as well as helped the team specifically for Agile process flow in JIRA to move tasks from one activity to another.
•Involved in the gathering of user requirements, Developed reports using Microsoft Power BI (Desktop and Service).
•Imported data from amazon redshift ODBC driver to Power BI to generate reports.
•Responsible for creating the metrics tree and populating the Fact and Dimension tables that helps to transform/load data.
•Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements.
•Worked with Drill Down, Drill through, table and matrix visuals, and worked with different level of filters like report level, Visual Level and Page Level filters.
•Created filters, slicers, calculated measures, and calculated columns for preparing reports in Power BI.
•Extracted data from different relational databases and data warehouses like SQL Server, Azure Data Lake Gen2 and Azure Analysis Services (AAS) using Power BI.
•Involved in designing and developing reports in SQL Server Reporting Services (SSRS).
•Good in report developing, testing, deploying reporting solutions, scheduling the reports in Power BI Service and managing the application’s users, groups, and integrations with active directory.
•Data Visualizations Design & Implementation, Reports and Dashboards Design & Development, Universe Design & Development, Performance Management, Installation, Configuration &Maintenance of Reporting Environments, Data Modelling and Business Analysis.
•Experience in training end users/vendors through Application/Tool.
•Designed and developed interactive reports and dashboards using Cognos Report Studio as POC.
•Built and maintained metadata models in Cognos Framework Manager, including star and snowflake schema structures.
•Connected Cognos to diverse data sources such as Oracle, SQL Server, and DB2 using dynamic query mode.
•Self-motivated team player with good communication, Analytical, Problem Solving and Interpersonal skills to communicate effectively at all levels of the development process and Flexibility to adapt changing priorities and meet deadlines as per the schedules and solve client/customer related technical issues.
Environment: Azure, SQL Server 2016, SSIS, Power BI (Desktop, Service), Power BI report builder, Cognos, MS Dynamics, Jira, Python, Agile Methodology, Excel, SQL, T-SQL.
DSQ Software, India Jan-2019 to Jun-2021
BI Developer
Responsibilities:
•Amalgamated with other teams to glean the end user requirements and maintaining, following the business documents using Jira tool.
•SQL Query Optimization and Performance Tuning, Optimizing Stored Procedures and long-running queries using indexing strategies and query optimization techniques.
•Used SSIS packages to validate, extract, transform, and load data to data warehouse databases.
•Conducted meetings with business users for requirement gathering, understanding getting new inputs, and generating POCs, reports, and dashboards based upon the requirement.
•Worked on managing ETL processes by pulling large volumes of data from source to Tableau to develop reports.
•Troubleshooting within SQL codes, SSIS Packages, and SSRS as required. Work as a collaborative team member using software development life cycles (SDLC) including analysis of business functions, design, development, testing, and documentation as required by end-users.
•Conducted the Data migration, Advanced Analysis, Workflow for data, Data processing with the help of Alteryx along with SSIS.
•Generated reports on Alteryx as a POC.
•Managed the BRD, FRD documents and good at converting the Business Documents to Technical.
•Enhancing and deploying the SSIS packages from the development server to the production server and scheduled jobs for executing the stored SSIS packages which were developed to update the database on a daily/Weekly/Monthly basis.
•Worked with AWS Glue for ETL solutions using SQL Extracted, Transformed, loaded humongous amount of data.
•Stored and analyzed the data using the AWS storage accounts such as S3, Redshift.
•Wrote many algorithms for the automation like Data Transfer, Integration, setting up and running the pipelines, automatic messages, Detect the errors and many.
•Worked on both Live and Extract data based on the data size and source.
•Created interactive visualizations using the slicers, filters and showed accurate value visualizations, insightful, better, interactive visualizations by writing LOD’s.
•Deployed the reports, dashboards to Tableau services as well as responsible to give access to the end users.
•Building content packs/ apps workspaces to share datasets, reports, and dashboards to various departments in the company to distribute only data required by each department.
•Supported previous projects and worked on defects and change enhancements, migrating one BI tool reports to Tableau.
•Used many visuals, charts, filters as per the prerequisite such as Line charts, Scatter plot, Histogram, Pie chart, Area maps, Tree map to find the Trends, Analysis, and prediction.
•Fabricated Groups, Bins, Measures, Parameters to easily handle the humongous quantum of data.
•Scheduled the Weekly, Monthly reports to deploy on Tableau server.
Environment: Tableau (Desktop, Services), Excel, AWS (S3, Redshift), AWS Glue, SQL Server 2016, Alteryx, ETL, SSIS, T-SQL, SQL, Server Data Tools (SSDT), Jira.
Techno LINQ, Bangalore Nov-2017 to Dec -2018
Jr. ETL Developer
Responsibilities:
Worked on Informatica Power Centre tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
Responsible to gather data and load data from source systems (Flat files, cloud databases) to targeted system (Oracle data base).
Applied many transformations like Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing, data type changing, column changing, for loops and optimizing the mappings.
Parsed high-level design specifications to simple ETL coding and mapping standards.
Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
Developed complex mappings using corresponding Sources, Targets, and Transformations like update strategy, lookup.
Maintained stored definitions, transformation rules, and target definitions using Informatica Repository Manager.
Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer, and scheduling of the workflow.
Created slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
To reduce the Data load, Data Transfer latency effectively performed initial, incremental, batch load mechanisms.
Used highly complex PL/SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used PL/SQL to manipulate and architect to produce results for users.
Performed Informatica code migration from development / production and fixed and solved mapping and workflow problems.
Environment: Informatica Power Centre 9.1, Workflow Manager, Workflow Monitor, PL/SQL, SQL, Oracle 11g/10g, Teradata, Sales force, MicroStrategy.
BOJJA It Solutions, Hyderabad June-2014 to Oct -2017
Jr. BI Developer
Responsibilities:
Managed enterprise services by diagnosing root causes of incidences, determined time of detection, diagnosed, and resolved by analyzing data.
Worked with various data sources such as Oracle, SQL Server, and flat file sources.
Created, maintained & scheduled various reports in SSRS such as Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
Involved in connecting multiple data sources in Power BI to implement working reports.
Involved in developing reports and dashboards visualization.
Involved in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis using Power BI desktop.
Involved in creating multiple kinds of Power BI Reports and Dashboards.
Created and deployed Matrix, Grid, Chart, and Gauge Reports utilizing SSRS. Created parameters for SSRS reports as well as drill-down and interactive sorting capability.
Implemented subscriptions and snapshots in the SSRS Report Manager.
Researched problems thoroughly to diagnose the root cause by pulling data from multiple Sources, Developed Reports and dashboards using Power BI.
Involved in creating Score Cards, Metrics, Power View/MAP and Pivot Tables using Office.
Involved in creating multiple kinds of Report in Power BI and presented them using Story Points.
Created SSIS package to pull all events and programs data from database server and SharePoint lists.
Assisting users in creating and modifying worksheets and data visualization dashboards.
Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
Environment: Microsoft SQL server 2012, SQL, T-SQL, Power BI desktop, Power BI services.