Devika Reddy Email & Phone Number

Toronto, On, Ca

Presented financial data findings to senior management through clear and insightful reports and presentations.• Assisted in financial modeling and forecasting exercises to support strategic planning.• Create financial data models that integrate data from various sources and implement datatransformations using Power Query• Expert in creating Power pivots, power query, Power views and SSRS reports using tabular model(DAX), Cubes (MDX) and SQL queries.• Worked on writing DAX queries and manipulating the multidimensional data in Tabular Modelcubes.• Used SQL Server Management Studio to execute SQL queries for data analysis and debugging.• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart,Line & Clustered Column Chart, Map, Slicer...etc.) in Power BI according to the requirements.• Implement DAX functions to create custom measures and Key Performance indicators (KPIs) togenerate reports.Using Power BI Report Builder tool created paginated reports to publish to the Power BI service.• Interacted with ETL developers, Project Managers, and members of the DBA teams.• Optimized long running Stored Procedures and Queries for effective data retrieval.• Design, develop, and implement data pipelines using Azure Data Factory to move andtransform data from various sources to target destinations.• Implement data cleansing, enrichment, and validation processes within Azure Data Factorypipelines.• Developed and maintained SQL queries and scripts for financial data extraction, transformation,and loading.• Involved in Developing the Azure Databricks notebook to load the data from Databricks toazure SQL.

Toronto, Ontario, Canada

Involved in gathering, analyzing, and documenting the business requirements, functional requirements, and data specifications for reports interacted with the users to analyze the changes for improvement they need in the existing reports and developed the reports to satisfy their business needs.• Used Power BI to develop data analysis prototype and used Power View and Power Map to visualize reports.• Conducted data analysis for various reports using Python libraries: Pandas and Numpy• Designed a Power BI data model with multiple fact tables and dimensions depending on thebusiness requirements.• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL• Transformed complex business logic into Database design and maintaining it by using SQLobjects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, andTriggers as requiredDeveloped reports using Microsoft Power BI (Desktop, Service)• Created high level dashboards that enable stakeholders to focus on performance andefficiency.• Created Database Maintenance Plans for the performance of SQL Server, which coversDatabase.• Integrity Checks, update database Statistics, and Re-indexing• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL queries.• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities• Participate in integration, performance, and user acceptance testing for BI solutions.• Using python libraries for machine learning like pandas, numpy, matplotlib, sklearn, scipy to Loadthe dataset, summarizing the dataset, visualizing the dataset, evaluating some algorithms and making some predictions.

Gathering requirements from clients and internal stakeholders and plan milestones in the research, development, and implementation phases of the project lifecycle• Interact and Coordinate with Internal and External stakeholders to drive Compliance of procedures across key areas during project lifecycle.• Key player in the design and implementation and responsible for project schedules, milestones, and deliverables into the overall system• Leading demos, mentoring team members, and holding developer meetings, removing blockers, and facilitating regular technical touch-point meetings with team• Synthesized and translated business data needs into creative visualizations in Tableau and Power BI.• Designing data model and creating Datasets from scratch to aid team in data collection to be used for Tableau visuals.By using Tableau Prep Done the cleaning, shaping, and organization of data before it can beanalyzed.• Involved with Tableau Prep Builder is a tool in the Tableau product suite designed to makepreparing your data easy and intuitive.• Assign tasks, manage meetings, track progress and gave update reports to management andbusiness users.