Power Bi Developer
Resume:
TRISHIKA BOYANAPALLY
Sr. Power BI Developer
***************@*****.***
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Professional Summary:
Around 8 years of IT experience which includes analysis, design, development, implementation, deployment and maintenance of Business Intelligence, Data Warehouses and Data Mining applications in Financial, Healthcare, ecommerce and Manufacturing industries.
Proficient in Microsoft BI tools, adept at leveraging Power BI to design and develop dynamic reports and dashboards by blending data from multiple sources, ensuring actionable insights for informed decision-making.
Highly proficient in Microsoft BI tools such as SSIS, SSRS, and SSAS, with comprehensive expertise in T-SQL across various SQL Server versions 2005/2008R2/2012/2014/2016.
Experienced in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
Skilled in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 2021,2020,2019,2018,10/9.x/8.x/7.x.
Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012.
Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
Experience in developing and debugging Stored Procedures and Triggers.
Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
Used tools like MS SQL Profiler, Index Tuning Wizard, Pervasive and Windows performance for monitoring and tuning SQL Server performance.
Excellent hands-on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.
Extensive knowledge in by using Row Transformations, Block and Unblock Transformations for Performance Tuning in SSIS packages.
Experience in working with different type Dirty Data from Different sources.
Hands on experience working with Logging, Error handling using Event Handlers pre and post for SSIS Packages.
Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union.
Experience in working with Data Cleansing technique in ETL procedures.
Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.
Worked with Microsoft Power BI, DAX expressions, Power View and Power Query integrated with share point.
Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi- dimensional expression (MDX), Perspectives and Roles.
Hands-on experience in creating groups and measures, KPIs.
Worked on building Tabular Model Cube from Scratch in Databases with different Measures and Dimensions.
Experience in performance tuning, processing and deploying the cubes.
High knowledge in cube partitioning for better database performance.
Strong communication and collaboration skills, with a track record of delivering high-quality solutions on time and within budget.
Technical Skills:
RDBMS/DBMS: MS SQL Server 2016/2014/2012/2008R2/2008/2005/2000, MySQL, Oracle 11g/10g/9i/8i, and MS Access 2003/2000/97
Database Technologies/Tools: SQL Server Enterprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio
Databases: Azure SQL Database, Azure data warehouse, Azure Data azure data factory,
Azure Data Synch, MS SQL Server 2008 R2, 2012, 2014,2016, MySQL and Oracle12c.
Azure Cloud: Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service (AAS), Azure Blob Storage. Cache using Pipeline and SSIS, Data Migration Service (DMS), Azure SQL Data.
Reporting Tools: Power BI, SQL Server Reporting Services, Crystal Reports, Excel.
Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7
Programming Languages: T-SQL, PL/SQL, HTML, CSS, Python, Windows Scripts
Design Technologies/Tools: Erwin, MS Visio, Rational Rose
Data Warehouse / Business Intelligence: Tools SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2016/2014/2013/2010/2008, SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell
Certifications
MS 70-778 – Analyzing and visualizing Data with Power BI
PL-300 - Microsoft Power BI Data Analyst
PL-400 - Microsoft Power Platform App Maker
Organizational Experience
Power BI Engineer Peraton San Diego, CA Aug 2020 – Present
Key Result Areas:
Responsible for creating reports such as Cascading, Drill down/Drill through Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
Worked extensively on Data visualization and Data analyzation using Power BI.
Implemented advanced DAX (Data Analysis Expressions) calculations to derive complex business metrics and KPIs, facilitating data-driven decision-making.
Implemented ETL processes using Power Query Editor to integrate data from multiple sources, ensuring data consistency and accuracy in visualizations.
Automated report generation and distribution using Power BI Service and SharePoint, improving accessibility and timely dissemination of business insights.
Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
Developing the reports using Power BI, Power Pivot and SSRS.
Implementing Drill Through & Hyperlinks in Power BI report.
Implemented time intelligence functions in DAX (e.g., TOTALYTD, SAMEPERIODLASTYEAR) to analyze trends, seasonality, and year-over-year performance in reports and dashboards.
Created parameterized DAX queries in Power BI to enable dynamic filtering and user-driven analysis, enhancing interactivity and usability of reports.
Implemented drill-through functionality in Power BI reports for deeper analysis of KPI performance, allowing users to investigate contributing factors and root causes.
Developed and maintained multiple Power BI dashboards/reports and content packs.
Implemented security measures and adhered to compliance standards (such as GDPR, HIPAA) when configuring Power BI Gateways, ensuring data privacy and regulatory compliance
Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
Configured dynamic thresholds for KPIs in Power BI based on historical data and business rules, enabling real-time monitoring and proactive decision-making.
Responsible for workspace access. Added end users as viewers, contributor, member and Admins on non-production and production workspaces.
Created premium capacity metrics for studying the usage of workspaces and reports for business purpose.
Upgraded On-prem gateway servers in a quarterly fashion. Backup up all the gateway versions to revert in failure of gateway upgrade.
Worked as Power BI Admin to apply report level and workspace level security.
Written Power Shell script to backup all production reports weekly.
Maintained all reports source code on Azure Repo to monitor changes.
Used Excel, SQL, Azure DevOps, CSV and Power BI Data as data sources.
Embedded Power BI reports on SharePoint. Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to Power BI reports.
Writing MDX queries to get the data from a tabular model.
Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance. Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database.
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.
Designed and Developed ETL Frame that extract, transform, Audit and load data in Azure SQL Datawarehouse.
Performed database backup and deployment to the production server.
Extensively involved in Designing and Developing 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).
Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
Configured production and non-production datasets on Gateway clusters and Power BI Online.
Involved in unit testing against the developed packages and reports.
Designed and developed the dashboards, Scorecards and KPI’s in the Power BI.
Experience in developing the Calculated columns and Measure in the Data Analysis Expressions (DAX).
Implemented scheduled data refreshes with on-premises data gateways as per the business requirement.
Implemented Direct Query, Imports Data and Live Connection modes.
The apps and workspace and share across the organization and individuals based on the requirement.
Creating and maintaining the app’s content.
Creating and maintain the Power BI Content packages.
Generating the Web links or Embedded Code for publish to web or website or portals.
Design and develop the RLS (Row -Level-Security).
Written rdl reports using Power BI Report Builder and deployed to Power BI Online. Also, maintained the source code and report structure on Azure DevOps.
Tools & Environment: MS SQL Server 2012/2014, Management Studio (SSMS), ETL, Integration Services (SSIS) 2012, Power BI, Power BI (Pro), Power BI Service.
Power BI Engineer Cigna Bloomfield CT Oct 2021 – Jul 2022
Key Result Areas:
Extensively involved in Development, Implementation and Reporting in MS SQL Server 2016/2014/2012/2008 R2/2008 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
Proficient in Creating, Configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Engine Tuning advisor.
Involved in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
Responsible for creating reports such as Cascading, Drill down/Drill through Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
Involved in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
Worked extensively on Data visualization and Data analyzation using Power BI.
Designing and Developing the Dashboard Reports in Power BI using DAX.
Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
Developing the reports using Power BI, Power Pivot and SSRS.
Implementing Drill Through & Hyperlinks in Power BI report.
Developed and maintained multiple Power BI dashboards/reports and content packs.
Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models.
Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
Responsible for identifying, designing and implementing processes related to predictive / analytical modeling, data mining and complex data sets using statistical and text mining using python scripts.
Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
Installed On premise data gateway and scheduled daily data refresh in Power BI.
Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
Wrote and modified various Stored Procedures used in the application using T-SQL.
Extensive experience in different type of reports including Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
Performed DAX (Data Analysis Expressions) & MDX functions for the creation of calculations an measures in the Tabular Mode & multi-dimensional Cubes.
Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports.
Writing MDX queries to get the data from a tabular model.
Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance. Create Parameterized SSRS Reports and PowerPivot Workbooks
using data of Tabular model and Cube data model to prove the functionality of database.
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.
Designed and Developed ETL Frame that extract, transform, Audit and load data in Azure SQL Datawarehouse.
Performed database backup and deployment to the production server.
Extensively involved in Designing and Developing 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).
Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
Created SSIS packages using .NET and C# as a custom code in Script task.
Involved in unit testing against the developed packages and reports.
Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and
quarterly Reports including current status.
Tools & Environment: MS SQL Server 2012/2014, Management Studio (SSMS), ETL, Integration Services (SSIS) 2012, Power BI, Power BI (Pro), Power BI Service.
SQL/Power BI Developer Children Hospital of Philadelphia (CHOP) Dec 2020 – Sep 2021
Key Result Areas:
Involved in planning, defining, and designing data based on business requirements and provided documentation
Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
Developed SQL scripts for defining stored procedures to implement complex business logic.
Implemented error handling techniques in procedures and ad-hoc SQL queries to handle runtime errors.
Improved latency of SQL queries by adapting best approaches available including indexing strategies.
Created SSIS packages to extract data from OLTP and transformed into OLAP systems and scheduled jobs to call the packages and stored procedures
Used SSIS and TSQL stored Procedures to transfer data from source to staging area and finally load.
Creating SQL jobs for scheduling SSIS packages and configured alerting mechanisms.
Developed calculated columns and table calculations in Power BI using DAX expression.
Performed daily calculations for data set using DAX expressions to as required for the dashboard.
Involved in developing power BI data model using DAX expressions to build calculated columns and calculated measures.
Responsible for changing the data visualizations in Power BI reports and dashboards on client requests.
Designed dashboards utilizing Power BI with rich visuals such as charts, slicers, gauges, funnel, word cloud.
Generated dashboards in Power BI Desktop and Power BI Service using super-fast slice and dice and modern data visualization features.
Shared Power BI reports and dashboards to various user's groups using app workspace.
Created multiple Power BI reports utilizing different visuals such as bars, lines, pies, cards for providing insights into Provider data.
Designed several KPIs for Power BI reports to manage performance and monitor inconsistencies in services.
Developed dashboards on Power BI service and implemented timely refreshments to reflect changes of data from OLTP.
Tools & Environment: SQL Server 2012, Erwin, SSDT, SSIS, SSAS, DAX, SSRS, Power BI, Power BI Desktop, T-SQL, Erwin, MS Excel, TFS, DTA
Database/Reports Developer Stanley Black & Decker, Towson MD Sep 2019 – Nov 2020
Key Result Areas:
Interacted with business analysts and data modeling team to understand requirements and existing tables, relationships, and database constraints.
Interpreted data files and record layouts to map fields between multiple systems and database tables
Verified data for missing values and incorrect data and then cleaned and structured the data based on the format required.
Cleaned and analyzed data from multiple sources to identify trends and patterns configure changes
Created views, triggers, and UDFs to maintain referential integrity and integrated exception handling.
Generated server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
Developed tested SSIS packages for data cleansing using look up and fuzzy transformations.
Performed data profiling and data quality checks on source data and created data mapping document
Created SSIS packages to extract data from sources to load into DataMart by transforming the data to match the convention of snowflake schema.
Led the development of Datawarehouse along with analysis of existing data mart for budget and health services department.
Involved in creating complex measures including ranking, KPIs, aggregation by DAX in SSAS cubes.
Created calculated columns and measures in Power BI & Excel depending on requirements using DAX.
Created Power BI reports to analyze data in the data warehouse which has inter dependencies between various data marts.
Guide team on Power BI Desktop, Power BI Service and Dimensional modeling using TFS.
Tools & Environment: SQL Server 2012, T-SQL, SSIS, SSAS, DAX, SSMS, SSDT, SQL Profiler, Erwin, DTA, TFS
SQL/BI Developer Prolifics Corporation Ltd. India Jan 2016 – July 2018
Key Result Areas:
Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).
Actively participate in the Design, Build, Test and Deploy phases of Siebel UCM implementations for Oracle customers.
Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes, if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.
Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs.
Wrote and modified various Stored Procedures used in the application using T-SQL.
Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.
Responsible for creating partition function and schema for the table partitioning.
Involved in creating counter logs and trace logs for advanced performance analysis and data logging over a period.
Created SSIS 2012 Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
Created various jobs using SQL Server Agent.
Used SQL Server Profiler to trace the slow running queries and the server activity.
Tools & Environment: SQL Server 2008 R2, T-SQL, SSMS, BIDS, SSIS, SSAS, SSRS, SQL Profiler, DTA, TFS
Education
Master’s in Computer Science from University of Illinois at Springfield, Springfield- 2019
Bachelor’s in Information Technology from Jawaharlal Nehru Technological University, Hyderabad- 2016
Contact this candidate