| Candidate Information | | Title | Power Bi Data Analysis | | Target Location | US-PA-Levittown |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateObjectiveDatabase Analyst / BI Developer / Reporting EngineerAuthorized to work in the United States for any employer.Professional SkillsDomain Experience: Sales, Finance, Retail, Health Care, and Marketing.Data Modeling: Strong knowledge of SDLC with Normalization and De-normalization on OLTP and OLAP systems. Expertise in Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake Modeling, Fact & Dimensions tables for designing Data Warehouse/Data Marts. Participated in the full life cycle of development of a Teradata financial Data Warehouse.SSAS & Cube Experience: Hands-on experience in designing and managing OLAP cubes using SQL Server Analysis Services (SSAS). Proficient in creating and optimizing cubes to support complex data analysis and reporting.DAX Expertise: Skilled in writing advanced DAX calculations and measures for Power BI, including complex formulas and aggregations to enhance data analysis and visualization.Data Management: Comprehensive knowledge of data management practices including ETL processes, data integration, and data quality assurance.Data Visualization: Proficient in Power BI and Tableau for developing interactive dashboards and reports. Expertise in creating visualizations that provide clear insights and support business decisions.SQL Expertise: Strong SQL query experience in creating, testing, and maintaining Stored Procedures, Views, Indexes, User Defined Functions, Sub-Queries, CTEs, and other objects.EHR Systems: Experience with Electronic Health Record (EHR) system data extraction, designing and implementing EHR templates to capture relevant clinical data, and optimizing templates based on feedback and evolving requirements.Data Quality: Expertise in Gathering Business Requirements, Conducting QA Testing, Performing Data Quality Validation, Debugging, and Processing Documentation.Power BI: Expertise in Power BI, Power BI Pro, Power BI Mobile. Proficient in data Extraction, Transformation, and Loading using query editor, power pivot through Power BI APIs. Built normalized relational data models, created calculated columns, and measures using DAX, defined parameters, and variables to design interactive visualizations. Expertise in Power Automate and developing rich Power BI Dashboards.Tableau: Proficient in using Tableau for data visualization, including creating interactive dashboards, generating reports, and performing data analysis to uncover insights. Experience in integrating Tableau with SQL databases and other data sources to develop comprehensive visualizations.Database Migrations: Knowledge in all types of Database migrations with all versions of SQL Server. Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations.SSRS: Strong experience in developing Drill Down, Drill Through, Cascading, Parameterized, Linked, and Sub-Reports using Variables, Expressions, and Functions in SSRS. Experience in data integration solutions (SSIS). Configured and maintained Report Manager and Report Server for SSRS. Deployed and scheduled reports in Report Manager.Utilized Snowflake: data warehousing and integrated it with Power BI and Tableau for enhanced data analysis and reporting.Python: Write Python code to fetch data from an API and either save it to a CSV file or load it into a SQL database.Data Analysis Software: Proficiency in data analysis software such as SQL, Python, R, and data visualization tools like Tableau and Power BI.Regulatory Knowledge: Understanding of healthcare regulations and standards, including HIPAA and other data privacy laws.Communication & Collaboration: Excellent skills in communication & collaboration, strong analytical skills, problem-solving skills, and the ability to quickly adapt to new technologies by self-learning.Professional ExperienceBI Analyst -- Data AnalystSGS ACCUTEST Inc, Dayton, NJJul 2017 Feb 2024Published reports to Power BI Service and monitored usage/data refreshes/security access. Managed Apps workspaces. Installed and configured gateways (Personal/Enterprise) to schedule daily jobs, refresh reports/dashboards, and implemented Power BI Embedded analytics.Independently led dashboard implementation for visual best practices (color themes, visualization layout, interactivity, drill-through capabilities, filtering, etc.).Developed complex dashboards using multiple chart types (Bar/Line/Pie/Gantt charts, Scatter plots, KPI, Gauge, geographical maps, etc.) and functionalities (filters, parameters, bookmarks, slicers, etc.) in Power BI Desktop.Developed calculated columns and measures using DAX, with expertise in DAX functions such as Sumx, Calculate, All, Value, Filter, Related, Summarize, etc.Possessed strong knowledge of database management in writing SQL queries using complex joins, grouping, aggregation, subqueries, and resolving key performance issues.Accomplished work included the development and implementation of a full suite of Data Warehouse solutions: Data Warehouse and Data Marts, Cubes, Snowflake Schema, and ETL processes.Rebuilt, expanded, and migrated all legacy reports on the reporting platform. Maintained existing reports. Worked closely with clients to determine report specifications and coordinated with DBA for performance tuning, QA testing, debugging, data accuracy validation, and optimization.Excel skills with V-Lookup, H-Lookup, Macro, Index match, Pivot tables, and Pivot table charts. Created an automated dashboard with VBA in Excel.Built and managed OLAP cubes using SSAS, contributing to efficient data analysis and reporting.Utilized DAX for creating advanced calculations and measures in Power BI to support business insights.Developed and maintained SSRS reports and dashboards, integrating data from various sources.Conducted ETL processes and data migrations, ensuring data integrity and optimizing performance.Engaged in Financial Department Projects for organizations to optimize their procurement and payment processes, leading to improved financial performance and operational efficiency.Conducted data validation and quality checks to identify and resolve data discrepancies.Utilized Tableau for data visualization and reporting, creating interactive dashboards and comprehensive reports to support data-driven decision-making.Used Alteryx for data preparation, blending, and advanced analyticsProjects:Sales Performance Dashboard: Developed a Power BI dashboard to track and analyze sales performance across different regions, resulting in a 15% increase in sales efficiency. This involved integrating data from multiple sources, designing intuitive visualizations, and providing insights that helped the sales team optimize their strategies.Financial Reporting System: Implemented a Power BI system to automate financial reporting, reducing the report generation time by 50%. This project included designing ETL processes to integrate data from various financial systems, creating a data warehouse, and developing interactive dashboards for real-time financial analysis.Data AnalystTrac Intermodal, Princeton, NJAug 2014 Jun 2017Generated a variety of business reports using SSRS, configured the report server, and deployed reports on web server and SharePoint. Built reports from Analysis Services cube using MDX query designer; provided report subscription and snapshot. Conducted Data Quality Testing and Data Validation.Rebuilt, expanded, and migrated all legacy reports on the reporting platform. Maintained existing reports. Worked closely with clients to determine report specifications and coordinated with DBA for performance tuning, QA testing, debugging, data accuracy validation, and optimization.Strong SQL programming created database objects such as tables, indexes, views, constraints, temp tables, stored procedures, and user-defined functions. Wrote high-quality SQL queries to retrieve and analyze data from database tables, data marts, data warehouses, and Azure Cloud databases.Hands-on experience in Performance Tuning and Query Optimization using Execution Plan and SQL Profiler.Loaded large volumes of data from various sources to database tables using bulk insert, BCP command, T-SQL, and SSIS Package. Generated various reports using SSRS, Crystal Reports, Excel, Access, and Power BI to provide efficient solutions.Developed projects using SSAS, created data sources/data source views/cubes with measure and dimensions, configured attributes of dimension tables with hierarchy relationships; modified cubes and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions.Helped departments in fetching desired data between SQL Server database, Access database, and Excel. Successfully generated daily, weekly, monthly, yearly, and Ad-Hoc reports for different departments.Involved in reviewing business requirements and analyzing data sources from Excel/Access/SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Power BI Desktop.Migrated Excel, SSRS, and Crystal reports to Power BI.Developed and maintained databases and data collection systems to ensure data accuracy and integrity.Provided actionable insights and recommendations based on data analysis to support clinical and operational decision-making.Developed and maintained performance measurement tools and systems.Utilized Tableau for data visualization, creating interactive dashboards, and comprehensive reports to support data-driven decision-making.Projects:Customer Satisfaction Analysis: Built an SSRS dashboard to analyze customer feedback and satisfaction metrics, helping to improve service quality. This project included gathering data from customer surveys, transforming the data, and creating visualizations that provided actionable insights for the customer service team.Operational Efficiency Dashboard: Developed an SSRS dashboard to monitor and improve operational metrics, leading to a 10% increase in efficiency. This involved integrating data from various operational systems, creating measures and calculated columns, and designing interactive visualizations that highlighted key performance indicators.Reporting AnalystSystech Inc, Cranbury, NJJul 2009 Aug 2014Collaborated with business management and IT teams to define business requirements and drive new insights through data exploration.Designed and developed detailed and comprehensive reports using Crystal Reports, including parameterized reports, sub-reports, and complex formulas, to meet specific business requirements.Created and maintained documentation for reporting processes, ensuring clarity and reproducibility of reports.Provided training and support to end-users on how to interpret and utilize reports effectively.Utilized Power Query and Power View to design dashboards and scorecards, enabling effective data visualization and business insights.Utilized Microsoft Access to manage and analyze data, creating complex queries, forms, and reports for various business needs.Leveraged Excel for data analysis and reporting, using advanced functions such as V-Lookup, H-Lookup, Index Match, Macros, and PivotTables to provide detailed and actionable reports.LanguagesEnglish, ChineseEducationMaster Degree of Computer Science at UNIVERSITY OF NORTHERN VIRGINIA (09/2001-06/2005) Virginia, USABachelor of Business Administration (08/1985 - 09/1989) Beijing University, Beijing, China |
