Power Bi Developer

PUJITHA

BI Developer

Phone: 443-***-****

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

PROFESSIONAL SUMMARY:

Over 10+ years of IT experience in Data Visualization, Business Intelligence, Data Engineering, SQL Coding, Metadata Management, Cloud Computing, and Supply Chain Management.

Worked as a BI Data Lead Developer at Ford Motors, a leading provider of data visualizations in our team.

Converted the ETLs from Qlik Prep Flows to improve data quality and performance. Analyze data from various sources and create interactive reports and dashboards using QlikView/Qlik Sense Desktop and Server.

Comprehensive management of the Data Management Lifecycle, covering data ingestion, integration, consumption, delivery, and reporting analytics, including System-System integration.

Proficient in Big Data environments, utilizing components of the Hadoop ecosystem for processing large-scale data including structured and semi-structured data.

Designed interactive Power BI dashboards and reports, enabling data-driven decision-making for business users.

Created complex DAX calculations and custom measures to compare industry-wide benchmarks and track performance.

Designed and implemented data models using a star schema in Oracle SQL, optimized for reporting in Power BI.

Visualized key data insights using Power BI visualizations such as bar charts, scatter plots, pie charts, maps, and slicers.

Developed dashboards for data trends, market analysis, competition tracking, and customer behavior insights.

Worked on cost reduction strategies to avoid unnecessary expenses for data access from OData, Teams, etc.

I am skilled in managing QlikView /Qlik Sense server for license allocation, job scheduling and dashboard publishing using QEMC.

Ability to offer end-to-end solutions starting from requirement gathering, design, development & deployment of business intelligence applications. experienced with agile development methodology in providing quick analysis and visualizations for business users.

Worked on creating Qlik Sense dashboards using extension objects and designed reusable components for Qlik Sense / QlikView projects such as include scripts, QVDs, common data models, etc.

Gathered requirements from contact center teams and developed advanced views in Dynamics 365 to provide the daily reports to the customers.

Excellent client interaction & Good at analyzing and understanding the customer preferences

Experience using an ETL tool Qlik Sense to handle the various data feeds from the different data sources using Qlik Sense load scripts into QVDs. Profound knowledge of Data Warehouse concepts like Star schema, and Snowflake schema.

Created different data visualizations using Qlik Sense.

Domain Knowledge in the Automobile, Retail and Services Industries.

I am skilled in managing Qlik Sense server for license allocation, job scheduling and dashboard publishing using QEMC.

Proficient in developing static reports using NPrinting (Excel, HTML reports).

Connect Qlik Sense to multiple data sources including Oracle MS SQL Server, Hadoop, SQL and MS Excel.

Connect Qlik Sense to the output file from Data Wrangling tool ALTERYX.

Working with Data Scientists on Alteryx workflow with different DB connections/queries, using joins, unions, filters & formulas for the required output file and automated manual reports.

Involved in analysis, enhancement, development, and production support in different domains such as Vehicle information, Survey data, Case information, Banking

Experienced in writing functional and technical specifications.

EDUCATIONAL QUALIFICATIONS:

Bachelors in Electronics and Computer Engineer from JNTU, Kakinada, INDIA 2011

TECHNICAL SKILLS:

BIDW Solutions : Qlik Sense, QlikView, Power BI, Alteryx, Big Data, Tableau

Database Tools : Snowflake, MS SQL, My SQL, PostgreSQL, Workday, Oracle

Languages : T-SQL, PL-SQL, HTML, XML, C# Scripting

Operating Systems : Windows NT, Vista, Windows Server Editions, oracle Virtual box

Office Tools : MS Office Suite, MS Teams, Jira, SharePoint, Skype

PROFESSIONAL EXPERIENCE:

Client: FORD Motors, Dearborn, MI Aug 2018 – Till Date

Role: Sr Power BI Developer

Description: This project focuses on the management and analysis of case data, providing detailed insights into case status and classification levels. It tracks the model and year of products related to each case, as well as the case handling time across various teams. The objective is to enable higher management to efficiently monitor these metrics through a comprehensive visualization dashboard, facilitating informed decision-making and improving operational efficiency.

Responsibilities:

Worked closely with business stakeholders to understand their data requirements and deliver solutions.

Effectively follow Rally to implement Agile methodologies, track project progress, work on backlogs.

Manage the entire Business Intelligence lifecycle, encompassing requirements analysis, database architecture, ETL development, dashboard creation, and ongoing maintenance.

Design ETL framework and implement robust data solutions, including data flow diagrams, and ETL pipelines using SSIS and Alteryx.

Design scalable and secure data solutions on Azure.

Select appropriate Azure services to meet business and technical requirements.

Create data pipelines and workflows for ingestion, processing, and storage.

Develop and maintain ETL/ELT processes using Azure Data Factory and SSIS.

Integrate data from various sources, including on-premises databases, cloud services, and APIs.

Customized email notifications using Logic Apps.

Implemented Power BI Copilot to automate repetitive tasks like data cleaning, report formatting, and trend analysis, reducing manual efforts.

Implement and manage data storage solutions such as Azure Synapse, Azure SQL Database.

Extensive experience connecting Power BI with Snowflake to develop dynamic and scalable business intelligence solutions.

Enhanced Power BI performance by utilizing Direct Query and Import modes for seamless Snowflake data access.

Ensure compliance with industry regulations and internal data governance policies.

Monitor data pipelines, storage, and processing to ensure optimal performance.

Interact with business and build required dashboards using Health Risk Assessment data.

Publish the Dashboards/reports on internal Orbit server.

Provide documentation to business users and work with them to improvise any of the stories.

Work on SQL optimization to address performance issues.

Develop and deploy interactive dashboards using Power BI and Qlik Sense to provide actionable insights

Using copilot for natural language generation-built dashboards in power bi.

Oversee multiple BI projects ensuring alignment with business objectives and timely delivery.

Optimize business performance through data-driven insights, forecasting, and strategic recommendations.

Designed and implemented Row-Level Security (RLS) in Power BI to ensure data access control and tailored reporting based on user roles.

Ensure successful project execution through effective pre- and post-production management.

Provide training and support to other team members and stakeholders.

Optimized performance by migrating SSAS Tabular Models into Power BI and creating aggregated views for enhanced reporting.

Extracted data from diverse sources including Access, Excel, XML, OLE DB, and flat files to build comprehensive reports.

Designed and deployed database projects using SSDT for seamless schema management and version control.

Developed and maintained SQL Server database solutions using SSDT in Visual Studio, ensuring code consistency and deployment efficiency.

Automated database schema changes using SSDT project-based deployments, improving deployment efficiency.

Developed and maintained SQL Server stored procedures, functions, views, and triggers for ETL processes.

Designed and developed custom reports and dashboards using SSRS, enhancing data visualization for business users.

Created parameterized, drill-through, and interactive reports to provide in-depth analytics.

Integrated SSRS reports with SQL Server and external data sources, ensuring real-time data access.

Built data transformations with SSIS, including importing data from files and moving data between database platforms.

Debugged and tuned SSIS and other ETL processes to ensure accurate and efficient data movement.

Designed, implemented, maintained, and optimized MySQL databases, ensuring high availability, performance, and data integrity.

Developed DAX queries for computed columns and complex calculations within Power BI.

Published and maintained Power BI reports and dashboards for web clients and mobile apps, ensuring real-time data access through Power BI Gateways.

Successfully migrated large-scale data from on-prem SQL Server to Azure, improving accessibility and performance of data pipelines.

Automated daily data load processes in Azure SQL Database to ensure data integrity with minimal manual intervention.

Designed interactive Power BI dashboards and reports, enabling data-driven decision-making for business users.

Created complex DAX calculations and custom measures to compare industry-wide benchmarks and track performance.

Designed and implemented data models using a star schema in Oracle SQL, optimized for reporting in Power BI.

Visualized key data insights using Power BI visualizations such as bar charts, scatter plots, pie charts, maps, and slicers.

Implemented section access in the script according to user roles and developed Qlik Sense Dashboards.

Demonstrated leadership in driving projects to completion and generating regular incident management and system turnover reports.

Scheduled and managed N Printing jobs for automated report distribution and integrated report sharing via Microsoft Teams.

Ensured data security in Qlik Sense by implementing section access and hidden scripts to control data visibility.

Developed systems architecture for Qlik Sense implementation identifying the data sources and target reports.

Analyzed end user requirements and developed technical solutions.

Worked with Qlik Sense functions, objects, Set Analysis, Variables to create different kinds of charts.

Developed Qlik Sense apps, master library items and stories.

Developed and deployed Qlik Sense SaaS solutions for real-time data visualization and analysis across various business functions.

Leveraged Qlik SaaS and Qlik Insights to create scalable, cloud-based BI solutions, providing real-time data access and insights across business units.

Scheduled Weekly, Monthly and Quarterly automated jobs in NPrinting for report distribution.

Managed the security part by creating streams from the server side.

Developed executive dashboards in Qlik Sense delivered through the web, enabling them to measure the performance of the business with analytical capabilities.

Environment: Data Visualization, Power BI, Qlik sense, Tableau, Extract, Transform, Load (ETL), Reporting & Analysis, IICS, Snowflake, Informatica Cloud, Qlik Developer, Qlik Admin, REST APIs, MSBI, Qlik Sense, SQL, Qlik Nprinting, Reporting & Analysis, Snowflake, Microsoft SQL Server, MSBI, Qlik

Client: Northern Trust Company, Chicago, IL May 2015 - July 2018

Role: Tableau Developer/Power BI Developer

Description: In this project, we streamline data analysis across various services with different investment strategies and visualize performance metrics, improving decision-making and enabling real-time adjustments to ensure risk and returns are effectively balanced.

Responsibilities:

Provided ongoing support and maintenance for the dashboard in case of any data changes, system changes or

requirement changes.

Managed the projects, users, groups, permissions, and schedules for the reports in Tableau Server.

Expertise in designing visually compelling dashboards and reports using Tableau Desktop, Tableau Server, and Tableau Online.

Advanced knowledge of Level of Detail (LOD) expressions, enabling flexible aggregations and detailed analysis.

Skilled in combining data from multiple sources (e.g., SQL Server, Oracle) for holistic analysis.

Advanced knowledge of Level of Detail (LOD) expressions, enabling flexible aggregations and detailed analysis.

Expertise in optimizing Tableau dashboards by improving data extract strategies, reducing worksheet complexity, and using efficient calculations.

Designed and implemented advanced Power BI dashboards with interactive features like Page Navigation and Bookmark Navigation, improving user experience.

Developed custom DAX formulas for calculated columns and measures, enhancing report insights and analytical capabilities.

Developed and optimized SQL queries, stored procedures, and scripts for Power BI, ensuring real-time and accurate data updates.

Developed custom DAX formulas for calculated columns and measures, enhancing report insights and analytical capabilities.

Client : Vodafone, INDIA May 2011 - Nov 2013

Role: SQL Developer

Responsibilities:

Involved in the Creation of new database objects like Procedures, Functions, and Views using T-SQL in SQL Server 2005.

Involved in the Promotion of the database objects from testing stage to the developing stage in the production.

Involved in the modification of the database structures as directed by developers for different environments.

Worked on Managing user access for the customers.

Involved in the Backup and restoring of databases from various servers.

Worked on the various ETL processes which are used for the extraction of the data from the data source.

Updated the statistical information for both the old and new servers.

Assisted with various ad hoc query requests.

Provided back-end support for functional testing purposes.

Contact this candidate