Power Bi Developer
Resume:
Sahithi Reddy
Sr.Power BI Developer
************.***@*****.***
PROFESSIONAL SUMMARY:
Senior Power BI Developer around 6+ years of extensive experience in business intelligence, data analysis, and visualization. Adept at leading end-to-end development of interactive dashboards and reporting solutions in diverse sectors including financial services, healthcare, and IT. Proven expertise in SQL development, data warehousing, ETL processes, and advanced analytics. Proficient in optimizing performance and implementing secure, scalable data models. Collaborative team player with a strong focus on translating complex business requirements into effective, user-friendly BI solutions.
Designed and implemented interactive Power BI dashboards and reports, enabling real-time data insights and fostering data-driven decision-making across the organization.
Managed and processed large, complex datasets with a focus on accuracy and efficiency.
Delivered end-to-end BI solutions, from data collection and transformation to visualization and reporting.
Enhanced data processing and reporting speed through strategic optimizations.
Conducted ETL operations using SSIS, integrating data from diverse sources into centralized systems.
Implemented robust security measures, including row-level security in Power BI.
Leveraged DAX and MDX to create advanced calculated measures, improving data analytics capabilities.
Optimized SQL queries, stored procedures, and overall database performance.
Applied data warehousing concepts, including star and snowflake schemas, dimensional modeling, and ETL processes, while performing data conversion, cleansing, aggregation, and transformation.
Integrated Linux systems into ETL workflows to streamline data processing.
Collaborated across teams to design and deliver BI solutions tailored to evolving business needs.
Developed efficient data models using Power BI and SQL Server for improved visualization.
Extracted and integrated data from sources like SQL Server, Oracle, and Azure into Power BI.
Published and maintained enterprise-wide Power BI dashboards for seamless accessibility.
Automated manual processes by developing a Canvas application in Power Apps.
Streamlined data refresh processes in Power BI to ensure up-to-date reporting.
Enabled report integration across Power BI, Tableau, SSRS, and Python, ensuring consistency.
Seamlessly integrated PL/SQL components into ETL solutions for enhanced data handling.
Experienced in MS Power BI Development, Power BI Admin, MS Fabric, Tableau, Power Apps, and Power Automate, MSBI Development, SQL Server Database, Azure SQL Server, Azure Blob, Azure Cosmos DB, Snowflake Database, experience in IBM Cognos, SQL Server Database, Sybase and Oracle DB.
Implemented query optimization strategies to improve data retrieval speed and reporting performance.
Engaged stakeholders for requirement gathering and delivered customized BI solutions.
Utilized Power Query to clean and transform data, ensuring integrity and accuracy.
Automated BI workflows to boost operational efficiency.
Managed reporting databases for optimal BI application performance.
Advocated for and implemented best practices in BI development and reporting processes.
Maintained and developed integrations among enterprise systems like ERP, CRM, EDI, and manufacturing control systems.
Stayed updated on emerging BI technologies and trends to enhance solutions and skills.
Developed desktop and mobile data capture and navigation apps in Microsoft Power Apps, integrated with distribution center analytics in Power BI.
TECHNICAL SKILLS:
BI Tools Power BI, Python,SSRS, Crystal Reports, Power Apps, Pivot, Power View Programming Languages DAX, MDX, SQL, T-SQL,Python
ETL Tools SSIS, Power Query
Databases SQL Server, Oracle, Cloud, Azure SQL DB
Data Modeling Star Schema
Reporting
Ad-Hoc Reporting, Drill-down, Drill-through Reports, Parameterized Reports, Linked Reports, Chart Reports, Sub Reports
Performance Optimization Performance Tuning, Query Optimization Security Row-Level Security, Security Model Implementation Other Skills
Data Warehousing, Data Cleansing, Automated Data Refresh, Dashboard Development, Report Scheduling, Data Import/Export, DataTransformation PROFESSIONAL EXPERIENCE:
Citizens Health, Colby, KS Aug 2023 – Present
Role: Senior Power BI Developer
Responsibilities:
Facilitated collaborative sessions with diverse functional teams to analyse and meticulously document intricate business requirements.
Orchestrated ETL solutions, seamlessly integrating heterogeneous systems, including Oracle, SQL Server, and flat files, into a centralized and optimized reporting database.
Oversaw the importation of data from SQL Server DB and Azure SQL DB to Power BI, enhancing the platform's capabilities for insightful report generation.
Formulated and executed DAX Queries to generate calculated columns, bolstering the analytical depth of Power BI.
Integrated Power BI REST APIs to automate report deployment and refresh cycles within CI/CD pipelines, enhancing operational efficiency.
Collaborated with business stakeholders to gather requirements, design solutions, and create insightful KPI scorecards and dashboards that drive data-driven decisions.
Integrated PL/SQL components seamlessly into the ETL solutions, ensuring efficient data processing and manipulation.
Developed scripts on Linux for data encryption/decryption as part of ETL processes and ensured secure data transfer by implementing encryption techniques within the Linux environment.
Developed Auto retrieval and insertion of NOSQL data using PyMongo and MongoDB with Python programming.
Implemented and configured Azure Blob Storage for seamless Import/Export of data to/from .CSV files.
Leveraged Power BI, Power Pivot, Power View, and Power Map to craft sophisticated data analysis prototypes and visually compelling reports.
Employed Power BI Gateways to maintain real-time data synchronization, ensuring dashboards and reports remained up to date.
Maintain and develop system integrations among enterprise front and back-end applications (ERP, CRM, EDI, Demand Planning, Manufacturing Control Systems)
Designed and executed ETL solutions encompassing data export/import, file encryption/decryption, and SFTP upload/download.
Created various SSIS packages for data movements and transformations. Worked on Python code to load data from Google buckets to big query tables, used data flow for ELT (Extract Load Transform) in Big Query.
Utilized Linux commands and scripting for file operations, including file movement, archiving, and retrieval.
Leveraged PL/SQL to import data from Oracle databases, ensuring a smooth integration process and Implemented PL/SQL scripts for data extraction and transformation from Oracle sources.
Engineered SQL objects as needed, providing robust support for evolving reporting requirements.
Handled Designing and developing the information links, Data Source, Columns, Joins, Filters and Procedures in TIBCO Spotfire.
Responsible for TIBCO Spotfire platform administration tasks, TIBCO Spotfire database administration tasks, and providing production and operational systems support to Clients and Stakeholders
Proficient in data integration and ETL using SSIS, with experience in Informatica PowerExchange for integrating data from cloud, on-premises, and legacy systems.
Skilled in using REST APIs with Python for data ingestion into BigQuery, with experience in GCP Dataproc, GCS, Cloud Functions, and BigQuery.
Experienced in designing and implementing Star and Snowflake schemas in collaboration with data architects, DBAs, and business analysts.
Actively seeking opportunities to gain hands-on experience with IDMC (Informatica) for complex mappings, sessions, and workflows.
Pursuing freelance or volunteer projects to enhance practical skills with PowerExchange and PowerCenter
Proactively working on personal projects to develop expertise in multidimensional and OLAP techniques, including building OLAP cubes and performing multidimensional analysis.
Trained and mentored junior team members on best practices and advanced techniques in using Informatica PowerCenter and PowerExchange.
Environment: Power BI, Power Pivot, Power View, Power Map, SQL Server, Azure SQL, DB, Oracle, ETL (Extract, Transform, Load), DAX (Data Analysis Expression), Azure, Blob Storage Power BI Gateways (Enterprise and Personal), SQL Server Reporting Objects, Data Modelling, SFTP (Secure File Transfer Protocol) Northwell Health, Lake Success, NY June 2022 – September 2023 Role: Power BI Developer
Responsibilities:
Designed and delivered data visualization solutions tailored to business needs, ensuring alignment with project objectives.
Applied best practices in Oracle database administration and performance optimization for efficient operations.
Translated business requirements into interactive and user-friendly dashboards for enhanced data visualization.
Managed and prepared large datasets by aggregating, organizing, and optimizing them for thorough business analysis.
Utilized DAX (Data Analysis Expressions) to create advanced calculated measures, boosting analytical capabilities.
Conducted PL/SQL performance tuning, improving query efficiency and system performance.
Created and optimized PL/SQL scripts, stored procedures, and functions for streamlined data processing and manipulation.
Implemented table partitioning and indexing strategies, achieving up to 90% performance improvement.
Developed web-based reporting applications using WebFOCUS, including scheduling reports with Report Caster and deploying them via HTML hyperlinks.
Enhanced reliability and error management through robust error handling and transaction management in PL/SQL.
Automated and scheduled reports with SSRS for timely delivery and monitoring.
Reduced report rendering time from 15 minutes to 30 seconds by optimizing stored procedures.
Administered Linux servers, ensuring stable, secure, and high-performance operations.
Upgraded and converted existing WebFOCUS reports to DataStream or DOMO reports based on evolving requirements.
Created visually appealing and insightful Power BI dashboards and published them for enterprise-wide access.
Designed SSIS packages with advanced transformations such as Derived Columns, Pivot, and Conditional Splits.
Verified daily data flow between systems like Oracle-based IFS ERP, WMS, and the Pivotal retail data system to ensure accuracy.
Extracted and cleansed data from diverse sources, including Excel, text files, MS Access, and CSV files.
Leveraged MDX for seamless interaction with OLAP services, enhancing back-end connectivity.
Performed data cleansing and transformation in Power BI using Power Query.
Conducted maintenance tasks and applied Linux server security patches to uphold system performance.
Integrated data from multiple sources, including SQL Server, Oracle, and Azure, into Power BI for analysis.
Developed complex Crystal Reports, including Ad Hoc, Frequency, and Summary Reports, with parameters, sub-reports, cross-tabs, and charts.
Maintained, enhanced, and resolved issues for both existing and new Power BI reports.
Actively contributed to production issue resolution and continuous improvements.
Optimized query performance and addressed transactional deadlocks through performance tuning and query optimization techniques.
Built a configurable Scala and Spark framework to connect to data sources like MySQL, Oracle, PostgreSQL, Salesforce, and BigQuery, loading data efficiently into BigQuery.
Collaborated on the development of a framework to generate daily ad hoc reports and data extracts from enterprise BigQuery datasets.
Demonstrated expertise in data visualization tools such as Tableau and Power BI, utilizing their OLAP capabilities.
Proficient in SQL and data manipulation languages critical for OLAP and ETL processes.
Gained significant experience with data analysis, SQL, and foundational data manipulation for Informatica workflows.
Built and optimized ETL pipelines using Informatica PowerExchange, ensuring efficient data extraction, transformation, and loading across multiple sources.
Documented ETL workflows, mappings, and processes for seamless knowledge transfer and project excellence.
Specialized in data modeling with Star and Snowflake schema designs, enabling robust data warehousing and BI solutions.
Designed ETL processes to populate Star and Snowflake schemas, ensuring consistent and reliable data integrity. Environment: Power BI, SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), Crystal Reports, SQL Server, Oracle, Data Analysis Expression (DAX), Power Query MDX (Multidimensional Expressions), Data warehousing, Excel Spreadsheets Text files, MS Access, CSV files, OLAP Services, Performance Tuning Query Optimization. Freddie Mac, Tysons VA January 2021 – Jun 2022
Role: Power BI Developer
Responsibilities:
Collaborated intensively with business users, ensuring a thorough understanding of nuanced business requirements and accommodating changes seamlessly.
Responded to specific business requests by developing visualizations using Power BI, ensuring a user-friendly and insightful representation of data.
Engineered end-to-end Power BI solutions, creating reports, visualizations, and dashboards that precisely met business requirements, subsequently publishing them for widespread enterprise access.
Leveraged the DAX programming language for measure creation, employing DAX formulas to execute accurate and meaningful calculations.
Managed table relationships in Power BI using a star schema, optimizing data connectivity and relationships for efficient reporting.
Implemented a variety of slicers in Power BI to enhance report interactivity and user experience.
Worked on diverse report types, including Yearly, Quarterly, Monthly, and Daily reports, tailoring each to the specific analytical needs of stakeholders.
Designed and deployed reports with advanced features such as Drill Down, Drill Through, drop-down menus, and parameterized and Linked reports.
Employed various transformations available in Power BI Query Editor to streamline data processing and enhance report accuracy.
Utilized Power Query in Power BI for dynamic Pivot and Un-pivot operations in the data model, ensuring robust data cleansing and massaging.
Applied a range of DAX functions for fact calculations, ensuring efficient and meaningful data visualization in Power BI.
Leveraged Azure Data Factory to extract, transform, and load (ETL) data into Power BI, improving the efficiency of the data processing pipeline.
Contributed to continuous improvement and optimization of the Power BI environment at Freddie Mac, addressing evolving business needs.
Conducted training sessions to empower end-users to leverage Power BI features and Azure-integrated functionalities effectively.
Conducted training sessions to empower end-users with effective use of Power BI features and functionalities.
Ensured compliance with security standards for Linux-based data processing.
Implemented performance tuning strategies to enhance report rendering and overall system efficiency. Environment: Power BI, DAX (Data Analysis Expression), Power Query, SQL Server, Power BI Query Editor, Data Modelling (Star Schema), Financial Services Data, Report Optimization Techniques, Azure, SQL Objects Bank of America, Charlotte, NC November 2019 – December 2020 Power BI Developer
Responsibilities:
Design, develop, and maintain Power BI reports and dashboards, translating complex datasets into intuitive visualizations.
Build and optimize data models using Power BI for efficient querying and fast report performance.
Utilize DAX and Power Query to implement complex calculations and data manipulations.
Created complex DAX calculations to support advanced analytics, such as year-over-year sales comparison, market share analysis.
Assisted in migrating SQL Reporting Services to Power Platform, creating flows on Power Automate and Power Platform.
Involved in migration of Azure SQL database based DWH to Snowflake DWH. Expertise involves writing stored procedures, functions, DML and DDL scripts.
Developed robust data models by integrating data from various sources, including SAP, Oracle, SQL Server & Snowflake database and external data such as Market research.
Manage and optimize SQL Server and Snowflake databases to support Power BI report generation and other business needs.
Automate SQL Server jobs using SQL Agent and configure alerts for job failures using Database Mail.
Develop and maintain ETL processes using SQL Integration services (SSIS) and Azure Data Factory (ADF) for data integration and transformation from various data sources to feed Power BI reports.
Perform performance tuning of SQL queries to ensure smooth Power BI report generation and seamless user experience.
Collaborate with stakeholders to gather requirements and ensure Power BI reports meet business goals.
Manage the deployment and sharing of Power BI reports through Power BI Service, configuring scheduled data refreshes. Environment:Power BI, DAX (Data Analysis Expression), Power Query, SQL Server, Power BI Query Editor, Data Modelling (Star Schema),SQL Server Reporting Services (SSRS).
Contact this candidate