Sql Server Power Bi

Kamaleshwer Peddamalka

Ph: 567-***-****

Email: ****************@*****.***

Sr. POWER BI/Azure DEVELOPER

PROFESSIONAL SUMMARY

Over 10+ years of IT experience in PowerBI/SQL Development primarily using PowerBI, SQL, PL/SQL, MS SQL, SQL*FORMS, SQL Server, Business Intelligence through SQL Server Integration, Analysis and Reporting Services (SSIS, SSAS, SSRS).

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Strong experience of developing, implementing and maintaining application systems under UNIX Operating System using SQL, PL/SQL, SQL*FORMS, SQL Server, Unix Shell Script, Oracle 10g/9i database.

Extensive experience in Design and Develop ETL Processes data from external sources like Azure blob Storage, Azure Data Lake Gen2 and ORC/Parquet/Text Files into Azure SQL Data Warehouse (Azure Synapse).

Extensive experience using Azure Key vault to Encrypt keys and Password.

Experience Building Notebook inside Azure Data Bricks using Python.

Experience creating scheduling and monitoring Spark Jobs in Azure Data Bricks.

Extensive experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services and Tableau.

Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

Set up Microsoft Flow (Power Automate) to provide auto-approval and status update features based on predefined criteria.

I have experience with Snowflake utilities snow pipes and snowsql techniques using Python.

Migrated data from on-premises SQL Database servers to Azure SQL Database servers sent by designing the Azure Data Factory Pipelines using the Azure Data Factory copy tool and Self-Hosted Runtimes.

Worked with various Azure services like Web Roles, Worker Roles, Azure Websites, Caching, SQL Azure, Net worker servicers, API Management, Active Directory (AD) services infrastructure in advocating, maintaining and monitoring and Azure Active Directory (AAD) infrastructure, incorporated with periodic auditing, troubleshooting and performance.

Created Azure Blob storage for storing ARM templates.

Worked on creating tabular models on Azure analysis services for meeting business reporting requirements.

Written Python scripting for visualization in power bi Desktop.

Worked on writing the APIs in Python.

Worked with Confidential Power BI, DAX expressions, Power View and Power Query

Worked on Continuous Integration CI/Continuous Delivery (CD) pipeline for Azure Cloud Services using CHEF.

Vast experience in extracting, transforming and loading (ETL) data from OLTP (transactional) databases and other data sources, including heterogeneous and homogeneous sources into Data Warehouse, in SSIS using various tasks and transformations.

Experience in using Unix for automation of SAS Programs

Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues including complicated joins and cursor loops, creating indexes for fast retrieval of data, creating views, indexes, triggers, cursors, stored procedures and functions.

Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.

Extensive experience using Logic Apps, Power BI Report Server in Azure Environment

Written CMDELTS commands to giver permissions, delete permissions, share report, get Workspace, Create Workspace

Good Knowledge on Python.

I have worked on migrating excel reports into power bi reports. I migrated around 200 reports and the data size is millions.

Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.

Experience in creating ETL mappings in SSIS to load data from different sources to different target databases and data analysis, data profiling, data transformation, data mapping, data cleansing and data quality.

Worked in dimensional modeling with Star & Snowflake schemas and created the Data Source Views (DSV) and SSAS Cubes using the identified Fact and Dimensional Tables.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Working knowledge in Agile/Scrum Environment and used TFS (Team Foundation Server).

Skilled in error and event handling: Implemented check points, break points, event handlers, troubleshooting, and error handling in SSIS packages to improve usability and liability.

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C, C++, C#, ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting, Python

Databases: MS SQL Server,2014/2012,2008R2,2008 Oracle 8i/9i,10g, Netezza, DB2, Azure

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Power BI, InformaticaPowerCenter9.6/9.6.1/10.0(Repository Manager, Designer, Work Flow Manager, Work Flow Monitor Visual Studio, Crystal Reports, Talend, Tableau Reporting (9.0, 9.1, 9.2,9.3,10,10.1), AZURE

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Tableau, Power Pivot, ProClarity, Microsoft Office, Excel Power Pivot, Excel Data Explorer.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

Education:

Master’s: University of Central Missouri (2015 – 2016)

Computer Science Engineering

Bachelors: Maheshwara Engineering College (2009-2013)

Computer Science Engineering

Certifications:

Microsoft Certified- PowerBI Data Analyst-Associate

Microsoft Certified- Technology Specialist- SQL Server 2008, Business Intelligence Development and Maintenance

Professional Experience:

American Airlines April 2023 - Present

Dallas/Texas

Sr. Power BI Engineer

Project: Cyber Governance

Responsibilities:

I have migrated the reports from Tableau to Power BI

I have developed Power Automate flows to pick the file from Outlook and store the file into Network shared folder.

I have implemented ETL process in Alteryx to extract data from multiple sources from CVS, EXCEL and schedule workflows in Cloud environment.

Manage end to end complex data migration, conversion and data modeling (using Alteryx) and create visualization using Power BI desktop application to develop high quality dashboard.

Extracting the data from different data sources like Archer, crowdstrike, Proofpoint, One trust API’s into Alteryx ETL tool.

Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business.

Used Power BI Power Pivot to develop data analysis prototype, and used Power View and PowerMap to visualize reports.

Created DAX calculated columns in power pivot worksheets to extract, import and join data that coming from different sources.

Use advanced Business Objects techniques to present data including contexts, drill downs, hierarchies, advances functions, predefined conditions, and prompts.

Defined data sets with joins and sub-queries for complex queries involving multiple tables in Power BI.

Created data pipelines in power bi services to publish the reports in staging like DEV, PROD, Test environments.

Worked on Administration functions including deploying code solutions PowerShell scripts.

Scheduled jobs for creating snapshot of Power BI Reports and Dashboards and troubleshooting datasets for Power BI sites.

Used Microsoft Power BI Power Query to extract data from external sources and modify data to by calculated columns as required in Excel, and created SSIS packages to load excel sheets into database.

Implemeted the Row level security to restric the users to access the reports and Data

Created the pipeline schedules within Power BI Service.

Having an experience in migrating reports from datasource SQL server into Snowflake.

Worked with different technology teams to gather the requirements and then created a functional document,

Worked on trouble shooting the power bi reports using porfermance Analyzer with in power BI desktop

Worked on Dax Studio to pull the model into it and work on different functions to run the query in Millli sec

Creating the data flows in power bi service and calling Archer API into dataflow.

Created ECRG Dashboard which is visible to Managers, VP, CFO.

Environments: Power bi Desktop, Power bi service, Snowflake, Alteryx, Excel, Power Query, Power Pivot

Fidelity Investments (DISYS/ Signature), Dallas/Texas Sep 2021 – March 2023

Sr. Power BI Engineer

Responsibilities:

Experience in designing and implementing snowflake data warehouse and data bases.

Experience with data integration, data loading and data querying within snowflake.

Familiar with snowflake feature and functionality.

Have the ability to manage and optimize snowflake performance and scalability.

Worked on snowflake’s snow pipe for Realtime data ingestion.

Also had pretty good experience in power bi admin tenant settings, capacity settings, usage metrics.

Experience in creating paginated reports in power bi service and I had experience in creating Row-level Security in power bi Desktop.

Used Databricks for encrypting data using server-side encryption.

Created data pipelines in power bi services to publish the reports in staging like DEV, PROD, Test environments.

Access permissions in each environment in power bi services for each environment

Have experience in Performance Analyzer to deep dive in slow performance of Power bi reports. We use Dax studio to modify the Dax calculation to improve report performance.

Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.

Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Expertise in Power BI, Power BI Pro, Power BI Mobile.

Implemented row-level security on data and have a complete understanding of application security layer models in Power BI.

Have experience in scheduling the task in windows scheduler.

Have worked on creating pipeline to publish the reports into power bi service using Jenkins.

Published Power BI reports from Power BI desktop to Power BI service.

Environments: Power bi Desktop, Power bi service, Snowflake, Jenkins, Excel, Power Query, Power Pivot.

Walmart/Sam’s Club, Dallas/Texas Jun 2020 – Aug 2021

Sr. Power BI Developer

Responsibilities:

Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Used Configuration Files in SSIS to ease the process of moving the packages across servers.

Expertise in DAX Queries to build Power BI calculated measures and Calculated columns.

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

Involved in the continuous enhancements and fixing of production problems.

Used MDX to interact with the back end OLAP Services

Introduced SAP HANA Hints to improve tech coding performances across various data flows.

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

Worked on excel report migrations from excel to power bi desktop.

I worked on migration of OBIEE to Power BI

Embedded Power BI Reports into our own .Net Application via REST API’s for giving better access and flexibility to the end-users.

Extensively worked on tech SAP HANA calculation views to get tech data transformations.

Worked on Performance improvement SAP HANA Views.

Implemented Copy activity, Data flow, triggers in Azure Data Factory Pipeline Activities.

Developing ETL solutions using Spark SQL in Azure Databricks for data extraction, transformation and aggregation from multiple file formats and data source for analyzing.

Developed multiple complex ETL pipelines and activities stores for full and incremental data loads into an Azure SQL DW.

Designed and Developed ETL pipelines that will read data from various sources like CRM, ADP (HR and Pay role) and JDE(Operational) and loaded into Azure SQL Data warehouse.

Experience in Integrating Power BI App with Azure Active Directory Groups and Office 365 group to implement Row level Security.

Created power automate flow to Copy files from a SharePoint folder to an Azure Blob folder.

Designed Developed various objects like External Tables (HDFS format on any Azure cloud storage), Relational Tables, Views.

Created power automate to Send a push notification when a work item is assigned in Azure DevOps.

Architect and implement ETL and data movement solutions using Azure Data Factory, SSIS create and run SSIS Package

Worked on Cloud Database Snowflake Cloud Datawarehouse and Integrated Automated generic Python framework to process XML, CSV, JASON, TSV, TXT files.

Deploying Azure Resource Manager JSON Templates from PowerShell worked on Azure suite: Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure SQL Data Warehouse, Azure Analysis Service.

I also worked to automate my data flows from Alteryx to Azure data bricks using spark and push data into Azure SQL Server.

Creating Spark clusters and configuring high concurrency clusters using Azure Data bricks to speed up the preparation of high-quality data.

Extensively used Azure Data Lake and worked with different file formats csv, parquet, delta.

Used ETL/ELT process with Azure Data Warehouse to keep data in Blob Storage with almost no limitation on data volume.

Created Dashboards to present critical company data in a single report.

Created list reports & cross tab reports using Cognos 10.1.

Also had an experience in migrating the projects from Micro Strategy, congas, OBIEE, Tableau to Power Bi reporting.

Have developed power Automate flows to trigger the data base and refresh the data in power bi desktop.

Created Power Automate flows to send emails for executives.

Connected to workday HR data to power bi to develop visualizations.

Published Power BI reports from Power BI desktop to Power BI service.

Have experience to in Self-service and Creating data flows in power bi services.

Automated POWER Query refresh using POWER shell script and windows task scheduler.

Written automated CMDELT commands to refresh the data sets in power bi service.

Written commands to give permissions to team member and if anyone leave the company or team we can retrieve the reports.

Worked on created custom visualizations using React js, node js, Angular JS for web apps.

Experience on working Alteryx tool which is used to do ETL transformations and schedule refresh in Alteryx gallery as well.

Environments: Server 2016, SSIS, SSRS, SSAS, Altrex Designer, Power Bi desktop, Power bi Services, Power bi Pro, Tableau Desktop (2020.3), Tableau Server, Excel, Power Query, Power Pivot, Python, Azure, R#

Chevron Corporation, San Roman, CA Jan 2020 – May 2020

Sr. Power BI Developer

Responsibilities:

Involved in the Requirement Analysis, Design phase and Development phase of SDLC model system.

Developed SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically.

Created SQL Server Reports using SSRS and exported them to Excel format for managers and QA team for easy validation.

Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically.

Worked with DAX/MDX queries in building expressions for various business calculations.

Worked in Creating Calculations using MDX and Supported DAX expressions which were using Pivot table reports.

Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.

Worked on CMDELTS commands.

Used Power BI Power Pivot to develop data analysis prototype and used Power View and PowerMap to visualize reports.

Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.

Created DAX calculated columns in power pivot worksheets to extract, import and join data that coming from different sources.

Created power automate flow to Copy new files to AzureBlob from a OneDrive for Business folder.

Worked on migrating reports from Excel, Tableau, Congos to power bi.

Implemented Performance Tuning and Query Optimization.

Expert in creating Complex Crystal Reports Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports.

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

Implemented Copy activity, Custom Azure Data Factory Pipeline Activities

Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.

Extract Transform and Load data from Sources Systems to Azure 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 In Azure Databricks.

Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.

Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW)

Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools.

I involved in creating ETL pipeline in and out of data warehouse using combination of python and Snowflake Snow SQL writing SQL Queries against snowflake.

Expert in creating custom visualizations and developing Power BI Dashboards into rich look.

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.

I have experience in various dashboards in Tableau server using various sources such as SAP HANA/SQL Server/Teradata/Oracle.

Created custom visuals using Python and R# which is integrated into Power BI.

Environments: Server 2016, SSIS, SSRS, SSAS, Altrex Designer, Power Bi desktop, Power bi Services, Power bi Pro, Tableau Desktop, Tableau Server, Excel, Power Query, Power Pivot, Python, R#

Johnson Controls, Inc., Florida, Boca Raton April 2019 - Jan 2020

SR. Power BI Developer

Sales Effectiveness Team

Responsibilities:

Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.

Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.

Having experience in altrex designer application to pull the data from workday.

I also worked on SharePoint to create SharePoint sites. The SharePoint sites are mainly used by our stake holder to update the data for different regions.

Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.

Worked on pulling the data from Jira using Rest Api or third-party drivers. I created visuals for my directors to measure the performance of the team.

Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business.

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

Developed, identified, designed, built, tested, optimized, and maintained a Data Warehouse and OLAP Cube using the entire Microsoft BI Stack with emphasis on, but not limited to SSIS, SSAS, and SSRS.

Create different roles for uses accessing the tabular model. Write complex DAX function to implement row level security and apply the rules for business users assigned to various roles.

Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform Drill through and drill down operations in SSRS.

Extract Transform and Load data from Sources Systems to Azure 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 In Azure Databricks.

Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards. Hands on experience on creating and deploying SSAS cubes using Star Schemas and Snowflake Schema.

Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations.

Worked on CDMELTS commands.

Used PowerQuery to acquire data and PowerBI desktop for designing rich visuals.

Good Knowledge on Python and R#.

Environments: SQL Server 2016, SSIS, SSRS, SSAS, Altrex Designer, Power Bi desktop, Power bi Services, Excel, Power Query, Power Pivot, Python, R#

Panasonic Avionics Corporation, CA Nov 2018- March 2019

Sr. Power Bi Developer

Responsibilities:

Having experience in gathering requirements from Director’s and created the functional documentation using Confluence.

Experience in maintain the reports in power bi services and sharing with another team members in the organization.

Experience in Power bi admin, like creating content packs, how many users are accessing the dashboard, how many users are using power bi Pro license.

Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.

Designed and developed Power BI dashboards, Reports and published it on Power BI sites.

Integrated Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation. Also, one must have experienced in developing custom visuals for Power BI.

Involved in migrating data from red shift to snowflake.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.

Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports

Proficient in usage of SSIS Control Flow items (For Loop, executes package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).

Worked on migrating excel reports to power bi desktop which Dataset size is around 5 million.

Experience in building SSIS packages (.dtsx) is involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

Created Write back functionality in SSAS to write the data back into the cube to make changes to the data those changes return back into the cube.

Created Internal application to access the dashboard using C#, .Net Frameworks.

Environments: MS SQLServer 2014/2012, MS SQLServer Reporting Services (SSRS), MS SQLServer Integration Services (SSIS), Power BI Desktop, Power Bi Service, Power Query, Power Pivot, TFS, Visual Studio 2015, DAX Studio, MS SQLServer Analysis Services (SSAS), T-SQL, Crystal Report, SQL Profiler, XML, Team Foundation Server (TFS) 2012, MS Excel, Excess, Windows 8.

CareMore, Cerrtios, CA Jan 2017 – Oct 18

SQLBI Developer/Power Bi Developer

Responsibilities:

Used Power BI Power Pivot to develop data analysis prototype, for advanced visualize reports.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.

Involved in gathering requirements for data deliverables to ensure an understanding of their purpose and provide a technical perspective on requirements.

Worked on Tabular Model and imported it into Power BI.

Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.

Created Bar charts and Column charts in Power BI by using SQL server as Data source.

Developed Dashboards as per business needs by using the Power BI Tool.

Automated the creation of Excel pivot tables from SAS data sets using SAS /Macro and VBA

Good knowledge on python.

Developed data model, SQL Coding, SQL Query tuning process and Schemas.

Making data visualization in a variety of ways of multiple visualizations using Power BI.

Created Package Configurations to deploy packages from development to production server.

Designed tabular, matrix reports, drilldown, drill through, Parameterized and linked reports in SQL Reporting Services (SSRS).

Defined data sets with joins and sub-queries for complex queries involving multiple tables in Power BI.

Used Power BI service Pro license to create and Publish Dashboard.

Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

Assisted with implementation/upgrade of AutoSys and JAWS, troubleshoot errors, and documentation/procedures.

Designed Cubes with Star Schema using SQL Server Analysis Services 2012 (SSAS).

Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.

Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.

Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.

Environment: MS SQLServer 2014/2012, MS SQLServer Reporting Services (SSRS), MS SQLServer Integration Services (SSIS), Power BI Desktop, SharePoint, TFS, Visual Studio 2015, DAX Studio, MS SQLServer Analysis Services (SSAS), C#.NET, T-SQL, SQL Profiler, XML, Team Foundation Server (TFS) 2012, MS Excel, Excess, Windows 8.

Sephora IT, San Francisco, CA Oct 2015 – Dec 2017

SQL BI/ Power BI developer

Responsibilities:

Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day.

Developed Power BI reports and dashboards from multiple data sources using data blending.

Optimizing the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views.

Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.

Scheduled jobs for creating snapshot of Power BI Reports and Dashboards and troubleshooting on datasets for Power BI sites.

Building the Visualizations using Power BI Desktop

Publishing the Power BI reports to the Power BI Service and pinning the Reports to the dashboard.

Creating the data models using Power BI Desktop and Power Pivot.

Creating the Report Filters using the power BI Desktop

implementing the Role Based Security in the Power BI Service

Created Power BI Visualizations and Dashboards as per the requirements.

Configured and maintained Report Manager and Report Server for SSRS.

Restricted access to users by creating security roles to access reports in Power BI.

Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

the SSIS package services to run at different intervals to fetch the data and for transferring the data into another database.

Created Package Configuration files to support the SSIS packages in different environments.

Environment: SQL Server 2012/2008R2 Enterprise Edition, .NET Framework, XML, T-SQL, SSIS, SSRS, SSAS, Visual Studio .NET IDE, Windows 2008 Advance Server, ASP, MS Excel, MS Access, Visual Studio 2008, TFS 2010, PL/SQL, Oracle Database11g, Shell Scripts, SQL*Developer, UNIX, Reports Builder

Contact this candidate