powerbi developer

Sowmya Pasala

Sr Power BI/SQL BI Developer

ad5q32@r.postjobfree.com

PH.NO: 469-***-****

Professional Summary:

A dynamic IT professional with over 9 years of extensive experience in Analysis, Design, and Development across Database and Business Intelligence domains. Proficient in Microsoft Business Intelligence (MSBI) technologies, specializing in Microsoft SQL Server, Web API, SSIS, SSRS, and SSAS. Excels in designing, deploying, and optimizing BI solutions to drive data-driven decision-making and support strategic business objectives. Skilled in Power BI Dashboard and PowerApps applications development, with expertise in SQL Server administration and performance tuning methodologies.

Technical Skills:

•Data Warehousing/BI Tools: SQL Server (SSIS, SSAS, SSRS), Power BI, Tableau, Spotfire

•RDBMS/DBMS: SQL Server, Oracle, MS Access

•Database Tools: SQL Server Management Studio, SQL Profiler, Database Tuning Advisor, Query Analyzer, DTS

•Programming Languages: C#, .NET, VBScript

•Protocols/Middleware: TCP/IP, HTTP, FTP, ODBC

•Visualization Tools: Power Pivot, ETL Tools (Talend)

Professional Experience:

AT&T, New York City, NY Oct 2022 - Present Senior Power BI/MSBI Developer

•Led the design and development of interactive Power BI dashboards and reports for diverse business units: Spearheaded the creation of dynamic and user-friendly Power BI dashboards tailored to meet the unique needs of various business units within AT&T. Collaborated closely with stakeholders to understand their requirements and translate them into actionable insights.

•Collaborated with cross-functional teams to gather requirements and translate business needs into effective data visualizations: Worked alongside cross-functional teams comprising business analysts, data engineers, and project managers to gather and analyze requirements. Ensured that the developed solutions aligned seamlessly with business objectives and user expectations.

•Designed custom data connectors and utilized Power Query for data transformation and integration: Developed custom data connectors to fetch data from disparate sources and performed data transformation using Power Query. Ensured data accuracy and consistency across the organization's reporting ecosystem.

•Developed and maintained ETL workflows, ensuring data accuracy and timeliness: Designed, implemented, and optimized ETL workflows using SQL Server Integration Services (SSIS). Ensured

that data extraction, transformation, and loading processes were executed efficiently and reliably to meet stringent business timelines.

•Provided valuable data insights to drive informed business decisions and optimize reporting solutions: Leveraged advanced analytics techniques and data visualization best practices to extract meaningful insights from complex datasets. Empowered stakeholders with actionable intelligence to drive strategic decision-making and optimize operational efficiencies.

•Automated Power Query refresh using PowerShell scripts, enhancing data integration capabilities: Implemented automation scripts using PowerShell to schedule and automate the refresh of Power BI datasets. Enhanced data integration capabilities and minimized manual intervention, ensuring seamless data updates and availability.

•Configured SQL mail agent for automatic error notifications and performed performance tuning: Configured SQL mail agent to automate error notifications and alerts for critical data integration processes. Conducted performance tuning activities to optimize query performance and enhance overall system efficiency.

Autodesk, New York City, NY July 2021 – Sep 2022 Senior Power BI/MSBI Developer

•Designed intuitive reports and dashboards using Power BI in collaboration with SMEs: Worked closely with subject matter experts (SMEs) to understand their reporting requirements and translate them into intuitive and insightful Power BI reports and dashboards. Leveraged best practices in data visualization to deliver impactful insights to end-users.

•Developed end-to-end data pipelines for efficient data extraction, transformation, and loading: Designed and implemented robust data pipelines using SQL Server Integration Services (SSIS) to extract, transform, and load data from heterogeneous sources into the data warehouse. Ensured data integrity and consistency throughout the ETL process.

•Conducted data profiling and cleansing to ensure data accuracy and consistency: Conducted comprehensive data profiling and cleansing activities to identify and rectify data quality issues. Implemented data quality checks and validation rules to maintain high standards of data accuracy and integrity.

•Integrated Web APIs to enable real-time data visualization and reporting capabilities: Integrated external Web APIs with Power BI to enable real-time data visualization and reporting capabilities. Leveraged RESTful APIs to fetch live data streams and display them in interactive Power BI dashboards.

•Implemented data quality checks and error handling mechanisms in ETL processes: Implemented robust error handling and data validation mechanisms within the ETL processes to ensure data accuracy and completeness. Monitored ETL workflows and implemented corrective actions to address data quality issues.

•Managed Power BI environment and supported application enhancements: Managed and administered the Power BI environment, including user access controls, data refresh schedules, and security configurations. Provided ongoing support and maintenance for existing Power BI applications and implemented enhancements as per user feedback.

•Configured Azure services for efficient ETL procedures and data integration: Leveraged Microsoft Azure services such as Azure Data Factory and Azure SQL Database to streamline ETL procedures and facilitate seamless data integration. Orchestrated data pipelines and workflows within the Azure environment for optimal performance and scalability.

Fidelity, Boston, MA Feb 2020 – Jul 2021 MSBI / Power BI Developer

•Prepared performance dashboards and conducted daily client presentations utilizing SSRS, SSIS, SQL, and Excel.

•Developed data capture and navigation desktop and mobile apps in Microsoft Power Apps, integrating with distribution center solutions for analytics in Power BI.

•Implemented error handling and validation mechanisms to ensure data integrity throughout the pipeline.

•Created reports in Power BI utilizing SSAS Tabular via Analysis connector.

•Developed multiple Power BI reports and dashboards, integrating Azure Data Factory for custom data pipeline activities.

•Worked on real-time data streaming using Apache Kafka or Amazon Kinesis for near real-time data ingestion.

•Automated data pipeline deployment and monitoring, ensuring continuous data availability.

Wood Forest National Bank, Woodland, Texas Oct 2018 – Dec 2019 SQL BI Developer/ Power BI

•Created SSIS packages for data validation, extraction, transformation, and loading to a centralized SQL server from diverse sources.

•Utilized DQS cleansing component and fuzzy lookup in SSIS packages for master data cleansing.

•Developed complex mappings in SSIS for data transformation and loading from various source systems.

•Upgraded data from SQL Server 2012 and SQL Server 2014 to SQL Server 2016.

•Created databases, tables, stored procedures, triggers, views, and functions using T-SQL programming.

•Developed dashboards using Pie, Bar, Funnel Charts, Maps, and KPIs using SSRS.

•Wrote advanced calculations using DAX and Power Query for Power BI dashboards.

•Configured Jira and Azure for enhanced data integration and reporting capabilities.

USAA, Atlanta, GA July 2017 – Sep 2018 SQL BI Developer/ Power BI

•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.

•Assisted team to gather and analyze data from various sources, including RESTful and SOAP-based web services, to support business decision-making.

•Learned with a team to utilize experience with SOA-based architecture to support the integration of data from RESTful and SOAP web services into the corporate data ecosystem.

•Developed dashboards using Pie, Bar, Funnel Charts, Maps, and KPIs using SSRS.

•Worked on calculations using DAX Power BI dashboards.

Genpact,India Mar 2014 – Jul 2016 SQL BI Developer

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

•Worked closely with Business Analysts to produce all required documentation.

•Worked with Product Development Team to architect Database Design and strategy.

•Worked with Business Users to architect Data Warehouse strategy based on reporting, analytical and dashboarding requirements.

•Developed database objects such as Stored Procedures, Functions, Tables, Triggers, and Indexes using T-SQL and SQL Analyzer.

•Created, insert, update, and delete triggers on some tables to capture any DML activities happening on some crucial and confidential data.

•Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

•Conducted ETL assessments and performance monitoring(tuning) to optimize data integration processes for clients while designing and developing data integration workflows using ETL tools and scripting languages (SQL).

•Developed SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.

•Involved in deploying, configuring, and managing reports using Report Manager and Report Builder.

•Ensures standards and best practices are established and met for consistent and accurate use of Tableau across the company.

•Responsible for Tableau administration, including user provisioning, server management, license administration, and version upgrades.

Sutherland, India Jun 2013 – Feb 2014 SQL BI Developer/ Power BI

•Learned to create 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.

•Collaborated with teams to implement ETL automation, ensuring timely data updates and reducing manual intervention.

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

•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.

•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 modelling by identifying the fact and dimension tables based on the user & reporting requirements.

Education:

•Bachelor of Information Technology, DRKCET, India 2013

•MS in Computer Science, New York Institute of Technology, USA 2017

Contact this candidate