| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Data Visualization Power Bi Sewell, NJ Data Analyst Power Bi Newark, NJ Power Bi Data Analysis Levittown, PA Power Bi Data Analysis Jersey City, NJ Data Analysis,Business Analysis,ProjectManagement,Python,SQL,Pow Lawrenceville, NJ Power Bi Data Analyst Maplewood, NJ Data Analyst Power Bi Jersey City, NJ |
|
Click here or scroll down to respond to this candidateCandidate's Name
Sr. Power BI DeveloperEMAIL AVAILABLE: EmailPHONE NUMBER AVAILABLE: MobileWith 16 years of IT experience, including 9 years as a Power BI Developer and 7 years as a UI/UX Developer, I have honed my skills across various IT sectors. I am a dedicated Data Analyst with a proven ability to identify inefficiencies and problem areas within data streams while effectively communicating project needs. My expertise includes working with multiple data sources such as Access, SQL, Power BI, Tableau, and Excel, synthesizing quantitative information, and interacting seamlessly with colleagues and clients. I have a strong track record of generating summary documents for senior management, particularly for monthly and quarterly audit and compliance reporting.PROFILE SUMMARYAround 9 years of Data Analyst experience working as a Power BI Developer.Worked in Various industries like Networking, Healthcare, Banking and Finance.Expertise in Power BI Desktop, Power BI Pro, Power BI Premium (versions 2.35, 2.79.5768.721, 2.112, 2.117.286.0).proficiency in data analysis, data modeling, data presentation, and data importation from Oracle and SQL servers into Power Bi for report generation.Created Power BI uses a variety of metrics and computed columns with DAX to provide answers to business queries.Conducted a time series analysis in Power BI using DAX expressions.Formulated complex reports using Power BI, including tabular, graphical, drill-down, and parameter-based reports as well as excel reports and graphical reports.By using Power BI to create a plethora of reports and dashboards.Good practical knowledge of groups, hierarchies, measurements, and KPIs.Proficiency in DAX (Data Analysis Expressions) function creation for Power BI dashboard reports.Designed the Power BI data visualization using pie, bar, density charts, scatter plots, maps, and cross tabs.Using Power BI Pro, create chart types such as Crosstab, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms to create solution-driven dashboards.Deployed the Power BI services and pinned visuals to make dashboards out of it.Competent business intelligence developer with a track record of addressing challenging needs and creating effective, profitable systems.Expertise in Power BI for building, Deploying and managing applications and services through a global network of Microsoft - managed data centers.Having experience in SQL server/Power BI with expertise of SQL server development, TSQL, SSIS, SSAS, SSRS)Proficient in writing complex SQL and PL/SQL queries for data extraction, manipulation, and analysis across multiple database platforms including Oracle, SQL Server, and MySQL. Experienced in optimizing query performance and ensuring data accuracy.Hands-on experience with popular BI tools such as Oracle BI, Power BI, Tableau, and QlikView for creating interactive dashboards, reports, and data visualizations. Skilled in leveraging these tools to analyze and present business insights effectively to stakeholders.Experienced in designing and developing ETL processes using tools like Oracle Data Integrator (ODI) to streamline data integration from diverse sources into centralized data warehouses. Skilled in transforming and loading large datasets while ensuring data integrity.Familiar with managing and maintaining databases across various platforms such as Oracle, SQL Server, and MySQL. Proficient in writing stored procedures, triggers, and views, along with monitoring database performance and tuning.Expertise in both relational and dimensional data modeling to support data analysis and reporting needs. Experienced in developing star and snowflake schemas for efficient query performance and managing large datasets.Strong understanding of OLAP systems for multidimensional data analysis and proficiency in data visualization techniques to present complex data in a comprehensible format using tools like Tableau, Power BI, and QlikView.Competent in complicated statistical analysis, Python programming, and SQL.Created different Power BI reports utilizing the desktop and the online service and schedule refresh.Assist end users with problems installing the Power BI desktop, installing and configuring the personal and On-Premises gateway, connecting to data sources and adding the different users.Created different visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformation inside edit query into clean-up the data.Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.Experienced in database development and release management concepts, practices and procedures along with performance tuning database code in OLTP and OLAP environments.Hands on experience working with to analyze the structured, non-structured data from various sources.Support the business users and resolved issues pertaining to all the supply chain management and distribution modules after go-live.Involved in performance tuning by checking the loads on Indexes by using SQL profiler and Tuning advisor.Experienced in client requirement analysis, physical, logical design, development, debugging, testing, deployment, support and maintenance of business applications using SQL server 2014/2012/2008/2005. SSIS and SSRS 2005/2008/2012/2014/2016.Expert in database engineer, NoSQL and relational data modeling using Microsoft SQL Server.Having good knowledge on Teradata architecture, database features and Teradata tools.Used SQL Loader to load data from legacy system (CORE) and developed PL/SQL programs to dump the data from the staging tables to the interface tables and concurrent programs to get into oracle base tables.Extensive knowledge of data warehouse methodologiesExcellent knowledge of all the phases of Software Development Life Cycle (SDLC).Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server 2014/2008/2005.Worked in Implementation life cycles of both Agile and Waterfall Methodologies.Experienced in writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as tables, views, indexes, complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs).Extensive knowledge in Tuning T-SQL queries to improve the database performance.Good Knowledge of defining, developing nd deploying Star Schema and Dimensional Data Modelling using MS SQL Server 2005 Analysis Services (SSAS) on EDW.Involved in keeping the team focused and on track and also established meeting times, places and agendas.Excellent written and verbal communication skills and ability to translate technical concepts into business language and business language into technical requirements.Involved in coordinating meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.Proficient in creating interactive and insightful dashboards using Tableau to drive data-driven decision-making.Experienced in integrating diverse data sources into Tableau, ensuring seamless data flow and accurate reporting.Skilled in utilizing Tableau for complex data analysis, including trend analysis, forecasting, and statistical analysis.Adept at developing customized reports and visualizations tailored to meet specific business needs and user requirements.Expertise in optimizing Tableau dashboards for performance and scalability, ensuring efficient data processing and visualization.Provided training and support to end-users, enhancing their ability to leverage Tableau for their analytical needs.Led Tableau implementation projects, coordinating with cross-functional teams to deliver projects on time and within scope.Strong background in designing aesthetically pleasing and user-friendly dashboards that communicate insights effectively.Having 7 years of experience in the UX/UI designer, I adept at developing creative and functional UX/UI designs, web page layouts, color schemes, and infrastructure to maintain a cohesive website consistent with clients specific requirements.Highly creative and knowledgeable graphic designer with a strong background in developing and executing visual design concepts.TECHNICAL KNOWLEDGEPower BI, Power Query, DAX power BI, Power BI Desktop, Power BI Pro, Power BIPower BI desktop/Service, SQL Server, Azure Data Lake, Azure Synapse Analytics, Azure SQL, Oracle, DB2Data analytical tools such as Power Bi, Tableau, SQL, and Python.Development Tools: SSMS, SQL, T-SQL, MS Excel,Power BI Pro, Visual Studio 2010, SQL Server Analysis Services (SSAS), Oracle Database.SQL, T-SQL, MS Excel, Service, Tableau, MS Excel, SQL Server Analysis Services (SSAS), MS Visio, SQL Server, DB2, Teradata SQL, Tableau (Desktop/Server) Teradata Administrator, Power Query.Proficient in HTML5, CSS, JavaScriptData Modeling: Power Designer, MS Visio.Databases: Teradata, MySQL, MS SQL Server, ORACLE Database, MS Access.BI/Reporting Tools: Tableau Desktop V10.x/9.x/8.x/7.x/6.x, Tableau Server V10.x/9.x/8.x/7.x/6.x, Tableau Online, Tableau reader, Tableau Public.Expertise in Microsoft office, Adobe Creative suite (Photoshop, Illustrator, InDesign, Dreamweaver, Sketch.Proficient in Microsoft word, excel, PowerPoint, access internet, quick learning ability, ability to multitask and communicate clearly and effectively, problem Solving and Customer Relations.Cross-functional Collaboration, Networking FundamentalsUser Experience Design, User Interface Design, Illustration Techniques, Typography, Color TheoryExcellent communication skills, Strong organizational skillsACADEMIC QUALIFICATIONS:YearDegreeInstitute/School2023MS Business AnalyticsUniversity of New Haven2001BFA (Bachelor of Fine Arts)JNTUCERTIFICATIONS: Microsoft Certified: Power BI Data Analyst AssociatePROFESSIONAL EXPERIENCE IN DATA ANALYSTCiti Bank, New York Jan 2023 Till DateSr. Power BI DeveloperResponsibilities:Integrated diverse financial data sources into Power BI to create a consolidated and comprehensive view of financial performance, enabling holistic analysis and reporting.Designed and developed interactive dashboards and reports highlighting key financial metrics, trends, and performance indicators, allowing stakeholders to monitor financial health at a glance.Developed and implemented Power BI dashboards to track financial KPIs and operational metrics for various business units within Citi Bank.Created robust data models and employed DAX (Data Analysis Expressions) for complex calculations, enhancing data analysis capabilities.Implement incremental load policies for large Power BI datasets.Troubleshoot Power BI visualizations performance using DAX Studio.Manage Power BI Service duties such as setting up workspaces and managing report distribution with security considerations.Create complex DAX measures to meet client needs with knowledge of iterator functions.Experience with Power BI Deployment Pipelines.Conducted in-depth financial data analysis to identify patterns, anomalies, and areas for improvement, providing actionable insights to support strategic financial decision-making.Successfully designed and implemented both Star and Snowflake schemas for data warehousing projects, ensuring optimal performance for reporting and analytics. Leveraged Star schema for simplifying complex queries in BI tools like Power BI and utilized Snowflake schema for reducing data redundancy and optimizing storage in large, multi-dimensional databases.Proficient in developing data models using Star and Snowflake schemas to meet business needs, balancing between simplicity and normalization. Enhanced query performance by carefully choosing schema types based on specific use cases, data relationships, and reporting requirements, enabling faster access to key business insights.Integrated Star and Snowflake schemas with BI tools such as Power BI and Tableau, creating intuitive, efficient reporting environments. Applied best practices in dimensional modeling, including fact and dimension tables, ensuring that the schema design supported complex analytical queries, drill-down features, and data aggregation.Set up real-time data integration and live dashboards, allowing for up-to-date tracking of financial data and performance metrics.Developed and implemented KPIs and financial scorecards, providing finance teams and leadership with clear, actionable insights into company performance against strategic goals.Collaborated closely with finance teams and stakeholders to gather reporting requirements, translating complex business needs into technical specifications, and ensuring accurate representation of financial data.Conducted meetings with stakeholders to elicit and document Citi Bank business requirements.Collaborated in cross-functional projects, integrating Power BI with other business intelligence tools and financial systems to enhance overall data analytics capabilities.Facilitated collaboration across different business units by utilizing Power BI Services shared workspaces, enabling teams to access up-to-date reports and dashboards, improving cross-functional communication and decision-making.Continuously optimized Power BI solutions to enhance performance, accuracy, and relevance. Regularly updated data models and visualizations to reflect changes in financial data, business needs, and regulatory requirements.Reviewed and optimized SQL queries and edited inner, left, and right joins in Power BI Desktop by connecting live/dynamic and static datasets.Managed the on-premises data gateway to ensure secure and efficient data refreshes from SQL Server and Oracle DB to Power BI Service, maintaining the integrity and reliability of real-time data updates.Monitored and optimized the performance of Power BI (versions 2.35, 2.79.5768.721, 2.112, 2.117.286.0) reports and dashboards on the Power BI Service, addressing issues such as slow load times by refining DAX queries and optimizing data models.Troubleshot and performed performance tuning of reports, resolving issues within Power BI Server and Reports.Provided comprehensive training and support to users, ensuring they are equipped to leverage Power BI tools effectively. Facilitated workshops and created documentation to enhance user proficiency and adoption.Ensured compliance with data privacy regulations and internal security policies, particularly in financial reporting, by implementing robust data governance practices and securing sensitive financial information.Managed Power BI Service, including workspace creation, report publishing, dataset management, and row-level security (RLS) to ensure seamless access to reports while maintaining data privacy and compliance.Leveraged Power BI Service to schedule and automate the distribution of key financial reports, reducing manual efforts and ensuring timely delivery of insights to stakeholders.Utilized best practices and standards to create entities, relationships, measures, calculation groups, field parameters, etc. that support stakeholder requirements.Ensured data accuracy and reliability within solutions through data validation and quality checks.Designed and build easily consumable, accessible, and insights-driven visualizations to end-usersTroubleshooted and resolved data issues and performance bottlenecks.Expertise in critical thinking & problem-solving skills to a range of challenging problems.Used Power BI Service to streamline the generation of compliance and audit reports, ensuring all reports adhered to regulatory standards and were readily accessible for internal and external audits.Proficient in designing hybrid cloud BI architectures, leveraging the strengths of Azure to meet specific business needs and data requirements.Ensured data security and compliance across multiple cloud environments by implementing robust data governance policies and using encryption techniques.Developed and maintained ETL processes to extract, transform, and load data from various sources into a centralized data warehouse, ensuring data integrity and consistency.Implemented and managed Azure Data Factory for ETL processes, integrating data from various sources into Power BI for real-time analytics.Designed and implemented complex data mapping strategies, transforming raw data into structured formats suitable for reporting and analysis.Utilized Azure SQL Database and Azure Synapse Analytics to handle large-scale data processing and analysis, ensuring high availability and scalability.Managed and optimized data pipelines using AWS Data Pipeline to deliver accurate and timely insights to stakeholders.Integrated Google Cloud Storage with Power BI to facilitate secure and scalable data storage solutions for large datasets.Managed and maintained SQL databases, ensuring data integrity, security, and availability for financial analysis.Wrote complex SQL queries to extract, manipulate, and analyze large datasets, supporting detailed financial reporting and analysis.Developed and managed ETL (Extract, Transform, Load) processes to integrate data from various sources into centralized databases.Implemented data quality checks and validation processes within ETL workflows to identify and rectify anomalies in source data before loading it into the data warehouse.Performed data analysis on daily, weekly, and monthly scheduled refreshes of data to ensure that the developed dashboards display accurate and up-to-date live data.Created dashboards from scratch, including drill-throughs, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, and Bullet Graphs.Involved in data profiling, data analysis, and data visualization using new tools and technologies, including SAS Visual Analytics.Developed unlinked, on-demand sub-reports and linked sub-reports using shared variables and complex reports like cross-tab, drill-down, and hierarchical reports.Validated and optimized reports before publishing to Power BI Server, ensuring accuracy and troubleshooting any issues within Power BI reports and dashboards.Skills:Business Analyst Tools, SQL, T-SQL, Power BI Desktop, Snowflake and Star schema modeling, Power Query, DAX Power BI, Power BI Pro, Power BI Service, Tableau, SQL Server Analysis Services (SSAS), MS Visio, SQL Server, DB2, Teradata SQL, JIRA, MS Excel (pivot tables, VLOOKUP's, Formulas etc.), Cloud Platforms such as Azure SQL, Azure Synapse Analytics, AWS Data Pipelines.Tata Consultancy Services, Hyderabad, India. June 2015 July 2022TCS - Project 2: Walgreens Health August 2020 July 2022Power BI DeveloperResponsibilities:Engaged with business users to understand their needs, assess the existing system, and translate business requirements into actionable data analysis and reporting solutions tailored for healthcare information consumers.Performed advanced data modeling using Power BI Desktop (Ver 2.79, 2.112) which involved cleansing, transforming, and merging data from multiple healthcare data sources to create unified models. Utilized Power Query to unpivot, pivot, and transform tables to achieve the desired data structure, ensuring accuracy and consistency.Developed complex DAX expressions to support healthcare data analysis, including functions like CALCULATE, FILTER, SUMX, AVERAGEX, DATEADD, IF, SWITCH, and RELATEDTABLE, which were instrumental in calculating patient outcomes, resource utilization, and other key healthcare metrics.Designed and created dynamic reports and visualizations using Power BI, incorporating healthcare-specific charts and graphs such as stacked bar charts, clustered bar charts, scatter plots, pie charts, donut charts, and line charts. Custom visuals were developed to meet the unique specifications of healthcare data reporting.Created and managed Dataflows in Power BI Services to streamline data integration processes. Ensured compliance with healthcare regulations, implementing Row-Level Security (RLS), restricting data sharing and publishing, and controlling access to sensitive healthcare data to maintain privacy and security standards.Applied performance tuning and query optimization techniques to enhance report efficiency and responsiveness, particularly when handling large volumes of healthcare data.Led the deployment of Power BI reports and dashboards, facilitating integration, functional, and user acceptance testing (UAT). Managed the deployment process for both web clients and mobile apps, ensuring that healthcare professionals had seamless access to critical insights.Leveraged advanced query editor features like merging and appending queries, splitting and conditional columns, transposing data, and writing M formulas to perform complex transformations on healthcare data.Played a key role in auditing and compliance, controlling access to Power BI reports and ensuring that all healthcare data visualizations adhered to stringent privacy and security protocols. Restricted export and printing options to prevent unauthorized data dissemination.Played a key role in designing Snowflake and Star schemas for the Walgreens Health Care project, transforming complex healthcare data from multiple sources into structured data models. Utilized the Snowflake schema to optimize data storage for large healthcare datasets, ensuring minimal redundancy across multiple dimensions such as patients, treatments, and locations.Implemented the Star schema in Power BI for reporting on patient outcomes and resource utilization, providing a simplified, flat structure that enhanced query performance for fast, real-time insights. This schema was leveraged to streamline the analysis of patient data, medication tracking, and clinical performance metrics, resulting in reduced query times and efficient reporting.Worked extensively with both Star and Snowflake schemas to ensure data accuracy and security while adhering to strict healthcare data privacy regulations (HIPAA). By structuring the data in Snowflake schema, the project benefited from clear separation of dimension tables, facilitating secure access control and compliance in reports and dashboards tailored for sensitive healthcare operations.Developed Key Performance Indicators (KPIs), calculated measures, and used DAX queries to create customized roles, perspectives, and partitions within the healthcare data model, aligning with specific business needs and regulatory requirements.Extracted and managed large datasets from Walgreens databases using complex SQL queries to support various analytical projects.Developed and maintained interactive Power BI dashboards to track key performance indicators (KPIs) and operational metrics across various departments.Created robust data models and utilized DAX (Data Analysis Expressions) for advanced calculations and data manipulation in Power BI.Utilized SQL to clean, transform, and prepare data for analysis, ensuring high data quality and accuracy.Optimized SQL queries and database performance, reducing query run times and improving data retrieval efficiency.Designed and ETL (Extract, Transform, Load) processes to integrate data from multiple sources into centralized databases.Extracted and managed large datasets with complex SQL queries.Cleaned and transformed data to ensure high quality and accuracy.Optimized SQL queries and database performance for efficient data retrieval.Designed and managed ETL processes to integrate data from multiple sources.Optimized ETL workflows for improved performance and reduced processing time, ensuring timely availability of data for business intelligence solutions.Automation: Automated ETL processes using tools like SQL Server Integration Services (SSIS) or Azure Data Factory, significantly enhancing efficiency and reducing manual errors.Created ad-hoc reports and queries to support business decision-making.Created ad-hoc reports and queries to support business decision-making and operational efficiency.Created interactive and visually appealing dashboards in Tableau to visualize sales, inventory, and customer data.Conducted advanced health data analytics using Tableau, including trend analysis, forecasting, and statistical analysis to support strategic initiatives.Integrated various data sources, such as internal databases and external datasets, into Tableau for comprehensive analysis.Developed tailored reports and visualizations to meet the unique needs of different business units within Walgreens.Optimized the performance of Tableau dashboards to ensure efficient data processing and quick load times.Created interactive and visually appealing dashboards in Tableau to visualize sales, inventory, and customer data.Conducted advanced analytics using Tableau, including trend analysis, forecasting, and statistical analysis to support strategic initiatives.Integrated various data sources, such as internal databases and external datasets, into Tableau for comprehensive analysis. managedDeveloped tailored reports and visualizations to meet the unique needs of different business units within Walgreens.Optimized the performance of Tableau dashboards to ensure efficient data processing and quick load times.Skills:Data Modeling and DAX, Real-time Data Analysis, Snowflake and Star schema modeling, Data Transformation, Customized Reporting, Skills, MS Visio, SQL Server, SSMS, DB2, ETL, Tableau (Desktop/Server) Power BI DAX, Teradata Administrator, Power Query.TCS - Project 1: AT&T July 2015 July 2020Power BI DeveloperResponsibilities:Engaged with clients to thoroughly understand their business requirements, translating them into precise technical specifications that aligned with the project's networking focus.Worked closely with business analysts, data engineers, and other key stakeholders to gather and define network requirements, delivering tailored Power BI solutions that met business objectives.Designed comprehensive Power BI solutions, including data models, reports, and dashboards, specifically aimed at monitoring and analyzing network performance and metrics.Gathered and integrated data from various external sources such as SQL databases, cloud services, and flat files into Power BI. Utilized Power Query for seamless data transformation and modeling, ensuring the data was ready for in-depth analysis.Implemented scalable, reliable, and secure Power BI solutions, ensuring that the final product was robust enough to handle AT&T's complex network data.Led Power BI projects from the initial requirement gathering phase through to deployment, ensuring on-time delivery and adherence to business goals and networking industry standards.Wrote complex DAX (Data Analysis Expressions) queries to create calculated columns, measures, and tables that provided deep insights into network performance and operational metrics.Enhanced report performance and efficiency by implementing best practices in data modeling, reducing data refresh times, and optimizing DAX calculations, which was critical for real-time network monitoring.Utilized Power Query in Power BI (Ver 2.35) to perform Pivot and Un-pivot operations for data cleansing and massaging, enabling accurate network data analysis.Created Power BI reports using Tabular SSAS models as source data in Power BI Desktop, and published these reports to the Power BI Service for broader organizational use. These reports provided valuable insights into network performance, outages, and key metrics.Wrote T-SQL (DDL and DML) queries, stored procedures, and handled slowly changing dimensions to maintain the history of the network data. Designed and optimized SSAS partitions to improve performance, crucial for handling large volumes of network data.Regularly optimized Power BI reports for performance, ensuring fast load times and efficient data processing, essential for real-time network monitoring.Stayed updated with the latest Power BI features and updates, applying them to enhance existing solutions, thereby improving the monitoring and analysis of network data.Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code, as well as T-SQL code from developers and QA teams, ensuring the reliability of network data reporting.Developed solution-driven views and dashboards with various chart types, including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, and Scatter Plots, to visualize network performance and trends effectively.Analyzed business requirements and designed Power BI reports, dashboards, and visualizations to meet specific client requirements in the networking domain.Developed interactive dashboards to monitor network performance, outages, key metrics, and provided actionable insights to improve network reliability and efficiency.Ensured all reports and data visualizations complied with industry regulations and internal policies, particularly focusing on data privacy and security within the network operations.Designed KPIs to measure percentage growth in various network metrics over time, implemented aggregations and pre-calculations in SSAS, and designed partitions in cubes to optimize performance.Implemented row-level security (RLS) to manage access permissions, ensuring that sensitive network data was accessible only to authorized personnel, maintaining compliance with organizational |
