Sowmya

Power BI Developer

adqhkd@r.postjobfree.com

4697313866mailto:adqhkd@r.postjobfree.com

Professional Summary

Having 8+ years of IT experience, which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server, Oracle) in production environments and providing ETL/Business Intelligence solutions using Microsoft components to various clients (SSIS, SSRS, SSAS). Informatica, Power BI & Tableau creating Design, Development, Testing, Implementation and Production/Support phases of SDLC for Data Warehouse, Client/Server, RDBMS and Web Based Application.

Conversant with all phases of the Software Development Life Cycle (SDLC) especially Agile, Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.

Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.

Highly experienced in whole cycle of DTS/SQL server integration services SSIS Packages Developing, Deploying, Scheduling, Troubleshooting and monitoring for performing Data transfers and ETL Purposes across different servers.

Developed various Python scripts to find vulnerabilities with SQL Queries by doing SQL injection, permission checks and performance analysis and developed scripts to migrate data from proprietary database to PostgreSQL.

Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.

Extensive experience and understanding of SSAS, OLAP cube and Architecture. Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports. Very good experience in writing expressions in SSRS.

Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.

Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.

Expert in designing ETL data flows using SSIS, creating mappings/workflows to extract data from SQL Server, Data Migration and Transformation from Excel using SQL Server SSIS.

Experienced in Developing the scripts which push the data from the cosmos output streams into SQL Server Databases.

Experienced in designing and building OLAP cubes, fact and dimension tables with different architecture and data sources for business intelligence and populating/maintaining data marts in SSAS.

TECHNICAL SKILLS:

Databases: SQL Server, Azure SQL, MS Access, Teradata, Oracle, DB2, PostgreSQL and MySQL.

DB Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler,

T- SQL, PL/SQL, OLAP, MOLAP, ROLAP, OLTP, DBCC.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Informatica, Power BI, Tableau.

Languages: SQL, T-SQL, PL/SQL, Dynamic SQL, HTML, C#, MDX.

Professional Experience:

Autodesk., New York City, NY Jul 2021 - Present

Sr Power BI Developer

Responsibilities:

Worked closely with various teams across the company to identify and solve business challenges.

Gathering and Analyzing requirements of clients, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.

Import data from different data sources to create Power BI reports and Dashboards.

Experience in developing Reports, Charts, Dashboards using Power BI Desktop and manage security based on requirements.

Transform, define, navigate the data from data source and performed merge and append queries using Power Query.

Implemented complex query techniques of passing multi-Valued parameters and cascading parameters in MDX.

Performed Pivoting, Unpivoting and Splitting of the columns using Power Query.

Created different chart types and drill down reports using Power Bi Desktop.

Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI

Published reports and visualizations to Power BI Service and thereby created dashboards.

Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.

Worked with both live and import data into Power BI for creating reports.

Used different type of slicers available in Power BI for creating reports.

Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.

Experienced in Data Modelling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.

Used Power BI Gateways to keep the dashboards and reports up to date.

Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub- reports per business requirements.

Experience in generating on-demand and scheduled reports for business analysis or management decision.

Used recently introduced Power BI to create self-service BI capabilities and use tabular models.

Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Shared the created workspace across the organization using Power BI Apps.

Responsible for creating Row-Level Security (RLS) based on the business requirements.

Environment: Power BI, DAX, Power BI Gateway, Power BI Apps, MDX, MS SQL Server 2016/2014/2012/2008R2, MS Excel, JSON, Windows 8/10

Fidelity., Boston, MA Feb 2020 – Jul 2021

Sr Power BI / SQL BI Developer

Responsibilities:

Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in Business intelligence studios using SSIS.

Worked on Advance performance tuning, optimizing SQL queries and building indexes.

Developed Complex SSIS Packages using Control Flow and Data Flow Tasks to load data from Various transactional sources.

Extract Transform and Load data from Sources Systems to Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks.

Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's

Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

Created the Different Kinds of SSRS Reports Like Tabular Reports, Matrix Reports Drill Down Reports, Drill Trough Reports.

Converted reports from legacy reporting to new reports using Power BI.

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Designed SSAS Cube and developed MDX queries for Analysis.

Migrated On-Premises databases to Cloud for Improving the data Integrity and maintenance cost.

Recreated all the Stored Procedures and Views, Tables for Oracle ERP Data Conversion.

Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.

Developed Dashboards in Tableau & Power BI reports and Migrated the reports from Tableau to Power Bi

Utilized Power BI to create various analytics dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports.

Implemented Power BI gateway different source to matching analytics criteria and further modeling for Power Pivot and Power View.

Created different visualization like Matrix, Table, stacked column chart, Line charts, Line and stacked column in Power BI.

Experienced in building Tabular Model Cube from Scratch in Databases with different Measures and Dimensions.

Experience in writing parameterized queries for generating stylish tabular reports Drill down, Drill Trough, Cascading, click through, matrix chart, snapshot reports.

Formatting report layout, sub reports, using Global Variables, Expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS.

Environment: MS SQL Server 2008 R2/2018, SSIS, SSAS, SSRS, Power BI, Tableau T-SQL, XML.BIML, JSON, DAX, Power Shell ISE, Web Services, C#, SSMS 18.1, TFS, Azure Dev ops, GIT, Source Tree, Visio, Python.

Wood Forest National Bank, Woodland, Texas Oct 2018 – Dec 2019

Sr. SQL BI/ Power BI Developer

Responsibilities:

Created SSIS packages to validate, extract, transform and load data to a centralized SQL server from the existing diversified data sources.

Cleansed master data using DQS cleansing component, fuzzy lookup and lookup transformations in SSIS packages.

Worked on Upgrading the Data from SQL Server 2012 and SQL Server 2014 on to SQL Server 2016.

Developed complex mappings utilizing SSIS to transform and load the data from various source systems such as SQL Server2014, Oracle, Excel and Flat files into the SQL 2016 Server target staging database.

Developed the SQL Query for the Exports and Imports.

Created Databases, Tables, Stored Procedure, Triggers, Views, Functions, Cursors, Indexes, Derived Tables and Common Table Expressions (CTEs) using Confidential -SQL programming to facilitate efficient data manipulation and data consistency.

Involved in T-SQL Troubleshooting, and Performance Tuning.

Created the SQL Jobs, Monitoring the Failed SQL Jobs.

Experience in development of Dashboards using Pie, Bar, Funnel Charts, Maps, Table visualizations and setting up KPI’s to meet the goals of the organizations.

Formatting report layout, sub reports, using Global Variables, Expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS.

Wrote Advanced Calculations using DAX and Power query to meet the requirements of the dashboards in Power BI.

Developed various reports and Dashboards of operational and research data of the organization using Tableau and Power BI.

Developed dynamic row level security with SSAS Tabular Editor to restrict data access for various users.

Created Parameterized SSRS and Power Bi Reports and PowerPivot Workbooks using data of Tabular Editor and Cube data model to prove the functionality of database.

Experience in Performance Tuning of reports within Power BI Desktop, On Premise Power BI Server, Power BI Service.

Developed Tabular, Matrix, drill down and parametrized reports with SSRS for Pricing and Forecasting Daily, monthly and quarterly reporting needs.

Experience in writing parameterized queries for generating stylish tabular reports Drill down, Drill Trough, Cascading, click through, matrix chart, snapshot reports.

Created the Data Driven Subscriptions for the reports.

Created complex Data sets in SSRS, Comparison reports between two different servers.

Performed the Unit Testing in the CERT environments.

Created the Different Kinds of SSRS Reports Like Tabular Reports, Matrix Reports Drill Down Reports, Drill Trough Reports.

Involved in Production Deployment and providing the support for the solutions.

Environment: MS SQL Server 2017/2016/2014/2012, MS SQL Server Management Studio (SSMS), MS SQL Server Integration Services (SSIS), MS SQL Server, Unix Shell script, Microsoft Azure, Web Services/API’s MS Visual Studio 2017, MS Excel, SQL Server Reporting Services (SSRS), Power BI, T-SQL, Autosys.

USAA., Atlanta, GA July 2017 – Sep 2018

SQL BI/ETL Developer

Responsibilities:

Worked in Agile methodology, participated in Sync meetings.

Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier, Lookup, Aggregate, Update Strategy and Joiner.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Implemented complex business rules in Informatica PowerCenter by creating re-usable transformations, and robust Mapplets.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.

Expert in creating Calculations (LOD, Cube Calculations, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Utilized Tableau server to publish and share the reports with the business users.

Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Worked on Upgrading the Data from SQL Server 2012 and SQL Server 2014 on to SQL Server 2016

Developed complex mappings utilizing SSIS to transform and load the data from various source systems such as SQL Server2014, Oracle, Excel and Flat files into the SQL 2016 Server target staging database.

Extract the Data from Cosmos to SQL layer, and Build SSAS Cubes.

Proficient in SQL Server Analysis Services (SSAS) to design and develop OLAP Cubes

MDX Queries using SQL Server Analysis Services

Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view.

Migrate existing data into the Power BI and create reports in Power BI preview portal utilizing the SSAS Tabular Editor.

Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business.

Used Star and snow flake schema in designing cubes for creating SSAS packages.

Experience in writing parameterized queries for generating stylish tabular reports Drill down, Drill Trough, Cascading, click through, matrix chart, snap shot reports Formatting report layout, sub reports, using Global Variables, Expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS

Deploying and scheduling reports using SSRS to generate all daily, weekly, monthly, quarterly reports including current status.

Migrated On-Premise databases to Azure Cloud Database.

Migrated data from different sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

Implemented various SSIS tasks such as conditional split, derived column for data scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

Used various transformations like Derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.

Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML, and CSV using SQL Server 2012 Reporting Services (SSRS).

Migrated all the existing Tableau and SSRS reports to Power BI

Designed and developed mappings using Source Qualifier, Expression, connected-Lookup and unconnected-Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner & Rank transformations.

Recreated packages with the new source as stored procedure to meet the requirement.

Developed dashboard reports using Reporting services, Report model and ad-hoc reporting using Report builder.

Environment: MS SQL Server 2017/2016/2014/2012, MS SQL Server Management Studio (SSMS), MS SQL Server Integration Services (SSIS), MS SQL Server, Tableau, Power BI, Unix Shell script, Microsoft Azure, MS Visual Studio 2010, MS Excel, SQL Server Reporting Services (SSRS), T-SQL, Autosys.

Genpact., India March 2014 – Jul 2016

SQL BI/ ETL Developer

Responsibilities:

Created SSIS Packages using Execute SQL Task, File System Task, Send Mail Task, for each Loop container and Sequence container.

Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server.

Created SSIS Package with various Variables, Expressions and Transformations like Conditional Split, Derived Column, Data Conversion, Lookup, Merge Join, Sort and Aggregate.

Debugged SSIS Packages using Breakpoints, Data Viewers & watch windows.

Built KPIs in tabular based on the end user requirements, worked on Performance of SSAS Tabular Editor cubes.

Involved in data migration from Excel, CSV files into SQL Server using SSIS Packages.

Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis

Implementing Industry ETL standards and best practices, performance tuning during designing the DataStage Jobs

Created/ Modified SSRS based reports based on T-SQL and Stored Procedure with Input parameters.

Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task

Worked on migrating SSIS packages from 2008 R2 to 2012

Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).

Worked on SQL scripts PLSQL, Creating Tables, Clustered/ Non-clustered Indexes Joins, to get the desired result sets from the Oracle Database as per the requirement.

Designed cubes and built Scorecards and dashboards for various levels of management.

Involved in writing MDX queries and performance optimization of the SSAS cubes. Build the dimensions, cubes with star schema and snow flake schema using SQL Server Analysis Services.

Environment: SQL Server 2005/2008/2012, SQL Server Reporting Service (SSRS), Power BI, SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), Business Intelligence Studio, PL/T-SQL, SQL Profiler, Microsoft Visio, MS Office 2003.

Sutherland., India Jun 2012 – Feb 2014

Role: SQL BI Developer

Responsibilities:

Migrated data from various sources such as flat file, Excel to SQL Server databases using SQL Server Integration Services (SSIS)

Expert in creating packages like extract, transform and load data to data warehouse by SSIS, from various sources such as flat files, OLEDB sources.

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.

Created SSIS Packages for Incremental Loading and slowly changing dimensions.

Created logging, custom logging and error handling packages.

High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).

Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.

Designed SSAS Cubes, Named Calculations for Dimensions.

Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.

Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.

Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.

Implemented Event Handlers and Error Handling in SSIS packages.

Provided organizational reporting and timely reports utilizing SSRS (SQL Server Reporting Services)

Developed complex Stored Procedures and Views to generate various Drill-through reports, Parameterized Reports and Linked Reports using SSRS.

Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.

Used different T-SQL queries such as views, triggers, user defined functions, stored procedures to retrieve data from various tables, load data

Environment: SQL Server 2005/2008/2012, SQL Server Reporting Service (SSRS), SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), Business Intelligence Studio, MS Power point, PL/T-SQL, SQL Profiler, Microsoft Visio, MS Office 2007.

Education:

Masters in Computer Science from NYIT

Bachelors in Information Technology from DRKCET

Contact this candidate