Deekshitha

• Translate business logic into dashboards, charts, reports, and presentations in support of Sales & Marketing department.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate
reports. Designing Microsoft power BI dashboards and managing the power BI
gateways with a focus on usability, performance, flexibility, testability, and standardization.
• Designing OTLP, OLAP databases and creating ET L packages, tabular models,
and dashboards.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi
Services.
• Using Power BI, Power Pivot to develop data analysis prototype, and used Power
View a Power Map to visualize reports available in Web clients and mobile apps.
• Utilizing Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upperlevel
management.
• Implemented several DAX functions for various fact calculations for efficient data
visualization in Power BI.
• Designed SSAS Cube and developed MDX queries for Analysis.
• Document steps needed to migrate database objects between environments including Development, UAT, Staging and production
• Meet with business for defined requirements of the project.
• Provide production support of existing ETL process and develop cross validation
rules to ensure mapping accuracy for newly added business rules.
• Developing SQL queries or use available data profiling applications to perform data
analysis based on the business requirement and created data profiling report for data
discovery.
• Developing new data integration and support existing dataset for BI teams.
• Creating SSIS jobs and scheduled packages using SQL Server management studio
• Analysis and designing of small programs and systems to facilitate the work of the users.
• Successfully redesigned and corrected Bugs in current applications and databases.
• Implemented JIRA

Translate business logic into dashboards, charts, reports, and presentations in support of Sales & Marketing department.
Imported data from SQL Server DB and Azure SQL DB to Power BI to generate reports.
Designed Microsoft Power BI dashboards and managed Power BI gateways.
Designed OLTP and OLAP databases and created ETL packages, tabular models, and dashboards.
Installed and configured Enterprise Gateway and Personal Gateway in Power BI Services.
Used Power BI, Power Pivot, Power View, and Power Map to visualize reports available in web clients and mobile apps.
Utilized Power BI to design multiple scorecards and dashboards for different departments and upper level management.
Implemented DAX functions for fact calculations for efficient data visualization in Power BI.
Designed SSAS Cube and developed MDX queries for analysis.
Documented steps needed to migrate database objects between environments including Development, UAT, Staging and production.
Met with business for defined requirements of the project.
Provided production support of existing ETL process and developed cross validation rules to ensure mapping accuracy for newly added business rules.
Developed SQL queries and used data profiling applications to perform data analysis based on business requirements.
Created data profiling report for data discovery.
Developed new data integration and supported existing dataset for BI teams.
Created SSIS jobs and scheduled packages using SQL Server Management Studio.
Analyzed and designed small programs and systems to facilitate the work of users.
Redesigned and corrected bugs in current applications and databases.
Implemented JIRA dashboards and Confluence reports for project tracking and reporting.
Used JIRA for project planning, task tracking, and issue management.
Facilitated agile ceremonies including sprint planning, daily stand-ups, and retrospectives.
Created and maintained project backlogs, sprint boards, and release plans in JIRA.
Provided database development support.
Used Python, SQL, and relational database and data warehouse/data-lake technologies for data engineering work.
Proficient in SQL for querying and manipulating relational databases, extracting data, and performing complex data transformations.
Utilized SAS EG for data manipulation, cleaning, and analysis tasks.
Leveraged Python libraries such as Pandas and NumPy for data processing, statistical analysis, and machine learning tasks.
Developed and optimized SQL queries to extract and aggregate data from multiple tables.
Designed and executed data manipulation workflows in SAS EG for reporting and analysis.
Designed relational schemas and implemented data security.
Used SSIS for importing files and performing ETL operations.
Created and developed Power BI reports for companies hotfix pipeline.
Developed and maintained SSIS packages using C#.
Built complex packages to perform backend processing using SSIS.
Worked on SSIS script task, look up transformations, persistent lookups and data flow tasks using T-SQL and Visual Basic scripts.
Researched and resolved production related issues.
Developed and created new and existing SSRS reports.
Created reports, dashboards, stories, and visualization reports using SSRS, Power BI and Tableau.
Built data models to deliver insightful analytics.
Participated in the development and maintenance of ETL jobs and data pipelines to aggregate data from various on premise, cloud platforms and external data sources.
Developed new data marts and modified existing marts to support additional business requirements.
Worked on SQL scripts with large numbers of records in ETL flow process to import and export data.
Performed database indexing, tuning, query optimization, and performance monitoring.
Developed various SQL queries and complex stored procedures involving optimization to efficiently extract data from tables in cross servers, functions, triggers, and cursors.
Worked with AWS, Azure and Google data services.
Created Talend mappings to populate data into dimensions and fact tables.
Validated data from SQL Server to Snowflake.
Consulted on Snowflake Data Platform Solution Architecture, Design, Development and deployment.
Built solutions with no band-aid approach.
Collaborated with stakeholders to gather requirements, provide updates, and solicit feedback.
Identified opportunities for process improvement through agile retrospectives and implemented changes to enhance team efficiency and effectiveness.
Developed stored procedures and views in Snowflake for loading dimensions and facts.
Created up to date data classification and end to end data lineage using MS Purview.
Created, edited, and deleted data factories and child resources including datasets, linked services, pipelines, triggers, and integration runtimes.
Created data-driven pipelines for orchestrating data movement and transforming data at scale.
Deployed Resource Manager Templates.
Environment: MS SQL Server 2014, 2019, SSIS, SSRS, SDLC, Power BI, Snowflake, AWS, SQL Profiler, SQL Sentry Plan Explorer, AWS Services including Storage, JIRA, Confluence, Compute, IAM, Python, Redshift, Azure data fundamentals, Agile methodologies, Pentaho, GIT, AWS Glue, S3, SSAS, PowerShell Scripting.

Expertise in data cleansing using Power Query in Power BI Desktop Editor.
Worked on transformations available in Power BI query editor.
Wrote DAX expressions to create new measures and calculations per business requirements.
Used data blending, filters, actions, and hierarchies in Power BI.
Published developed dashboards and reports on Power BI Services.
Participated in the configuration of an on-premises Power BI gateway to refresh datasets.
Spearheaded the technical implementation of BI projects leveraging Power BI and ThoughtSpot.
Directed and coordinated team efforts to ensure successful project execution.
Hands-on expertise in SQL reporting, development, analytics, or BI.
Created tables, views, SQL joins and defined roles and privileges to implement business rules and control access to database.
Scheduled automatic refresh and refresh scheduling in Power BI Service.
Wrote standard and complex T-SQL queries to perform data validation and graph validation.
Wrote complex SQL queries in database Access and created various joins to fetch desired output for data analysis.
Used SQL Server, Excel, cloud, and SQL Azure as data sources for Power BI.
Created Power BI visualizations and dashboards.
Wrote DAX expressions, Power Query, and functions in Power BI.
Used DAX functions for creation of calculations and measures in tabular models.
Created reports using Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map, and KPI visualizations in Power BI.
Designed and developed complex reports such as Drill down, Drill Through, and Cross Tabbed using MS Reporting Services.
Connected various data sources in Power BI.
Created and maintained project backlogs and sprint boards in JIRA.
Collaborated with cross-functional teams to gather requirements and translate business needs into actionable insights.
Used Confluence as a central repository for project documentation.
Utilized JIRA dashboards and Confluence reports to provide project status updates and track key metrics.
Created various data modeling in Power BI and linked tables using various dimensions.
Developed and maintained multiple Power BI dashboards, reports and content packs.
Wrote calculated columns and measure queries in Power BI Desktop.
Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
Created, maintained users, roles and granted privileges.
Environment: Power BI Desktop, Power BI Service, Power BI Data Gateway, DAX, TSQL, SQL Profiler, MS Excel, Windows 10, MS SQL Server 2018, Snowflake, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Azure, Windows 2012/2018 R2 Server.

Worked on data transfer from various data sources and business systems including DB2, MS Excel, MS Access, and Flat Files to SQL Server using SSIS packages.
Created derived columns from present columns for given requirements.
Worked on SQL Server to load tables in support of de-coupled, pluggable architecture to manage data flows between service providers and LIPA.
Created SSIS packages to get data from different sources and consolidate and merge into one single source.
Created detailed design and requirements documents with logic to help team members understand the requirements and design.
Identified opportunities for process improvement through agile retrospectives and implemented changes to enhance team efficiency and effectiveness.
Provided training and support to team members on agile methodologies, JIRA, and Confluence usage.
Updated and created Knowledge Base Articles and case studies as necessary.
Assisted in the creation and improvement of Knowledge Management.
Performed database performance index tuning using Database Engine Tuning Advisor to resolve performance issues.
Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
Worked on performance monitoring of Memory, Processor, Disk I/O and fine tuning.
Worked on TQL queries.
Worked on designing normalized databases.
Worked on creating various database objects.
Performed quality testing and assurance for SQL servers.
Worked with stakeholders, developers and production teams across units to identify business needs and solution options.
Created interactive and visually appealing reports and dashboards using Power BI.
Collaborated with cross-functional teams to define quality standards and requirements for Power BI reports and dashboards.
Ensured best practice application to maintain security and integrity of data.
Monitored existing and scheduled SQL jobs.
Integrated Power BI reports and dashboards with other Microsoft Office applications.
Created and maintained data refresh schedules in Power BI Service.
Implemented row-level security and data-level security in Power BI.
Used SQL queries to extract, manipulate, and analyze data from relational databases.
Conducted data profiling and quality assessments using SQL queries to identify anomalies and inconsistencies in data sources.
Collaborated with cross-functional teams to gather requirements and translate business needs into data manipulation tasks.
Provided training and support to team members on SQL, SAS EG, and Python usage for data manipulation and analysis.
Collaborated with stakeholders to gather requirements and translate business needs into actionable insights.
Provided training and support to team members on integrating SQL, SAS EG, and Python with Power BI.
Contributed to process improvement initiatives by recommending best practices for integrating SQL, SAS EG, and Python with Power BI.
Contributed to process improvement initiatives by recommending enhancements to data manipulation workflows and best practices.
Developed and supported database architecture and development to create and enhance enterprise applications.
Designed and implemented stored procedures, views and other application database code objects.
Developed and maintained SSIS packages using C#.
Built complex packages to perform backend processing using SSIS.
Worked on SSIS script task, look up transformations, persistent lookups and data flow tasks using T-SQL and Visual Basic scripts.
Researched and resolved production related issues.
Developed and created new and existing SSRS reports.
Environment: SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SSIS, SSRS, Windows Server, UNIX, C#, OLTP, OLAP, T-SQL, SQL, SQL Profiler, Excel, Visual Studio.