| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Writer, Proofreader, Editor Granite Falls, NC Power BI developer, SQL developer Charlotte, NC Power Bi Data Warehouse Matthews, NC Power Bi Data Engineer Charlotte, NC Data Analyst Power Bi Charlotte, NC Supply Chain Power Bi Concord, NC Power Bi, Excel, Salesforce, Microsoft Office Charlotte, NC |
|
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE)SUMMARY:Expertise in Power BI, Power BI Pro, Power BI Mobile.Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.Expert in creating and developing Power BI Dashboards into rich look and tested Power BI reports of Database and verified it with the source data.Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.Proficient in Data Warehouse concepts, OLTP, OLAP, Star Schema, Snowflake Schema, Fact and Dimension tables.Good Knowledge and experience on Power BI Gateways (Personal and Enterprise gateways).Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH, SQL, Physical, logical database design, and Performance tuning.Used SQL Server Management Studio to execute SQL queries for data analysis and debugging.Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing, and maintenance) using Waterfall and Agile methodologies.Experienced in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts, and numerous stored procedures consumed at various stages of migration/cleansing process, reports, or data validation.Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.Experienced in Error handling and Debugging coding issues and troubleshoot production problems.Experienced in publishing Power BI Desktop reports created in Report view to the Power BI service.Used Power Query to acquire data and Power BI desktop for designing rich visuals.Skilled in design of logical and physical data modelling using Erwin data modelling tool.EXPERIENCE:09/19 to ONEMAIN FINANCIAL GROUP LLCNC12/21 Sr. Power BI DeveloperUsed Power BI desktop to directly connect to database tables (Direct Query Mode) or import the files into Power BI (Import Mode).Developed documentation for business requirements, functional and technical specifications, and development standards for assigned projects and applications.Used Power BI to extract data from different sources such as SQL Server, Excel, CSV files, load cleaned the data and loaded it into the Power BI canvas for visualization and analysis.Designed reports utilizing custom filters and DAX expressions with Power BI, and written DAX Expressions, Power Query and Functions in Power BI.Created database links and accessed the data through SQL statements.Analysed source system data to assess data quality, worked with technical and business representatives to determine strategies for handling data anomalies that are identified.Carried out administrative tasks on DOMO like adding/maintaining users and groups, scheduling reports, setting up presentations directly on Microsoft Excel and PowerPoint using DOMO plugins.Implemented data migration from Microsoft Azure cloud platform to on-premises data servers utilizing Azure cloud technology.Created hierarchies in Power BI to help end users make accurate decisions based on the visualizations.Created custom KPI scorecards to help end users visualize metrics according to their preference.Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.Worked using Column profiling to optimize columns and remove redundancies and errors from individual columns.Developed complex SQL Views, Common Table Expressions, and Temporary Tables.Responsible for building reports in Power BI from the Scratch.Creating Row level securities and integrating with Power BI service portal.Used Cross-Report Drill through to link source and target reports to drill through the necessary information for the end user.Created and developed star and snowflake schema.Involved in generating and maintaining SQL scripts.Participated in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.Implemented Power BI Gateway different source to matching analysis criteria and further modelling for Power Pivot and Power View.Utilized Query Editor to clean and format data and eliminate redundant information and append and merge tables from various data sources.on an intranet site using SharePoint Server.Used Power BI Desktop to connect various data sources and worked with different visualizations and created dashboards.Designed rich dashboards with power BI and prepared user stories to create compelling dashboards to deliver actionable insights.Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.Involved in database development using stored procedures, triggers, views, and cursors.Wrote DAX Expressions, Power Query, Functions in power bi.Conversant with all phases of Software Development Life Cycle (SDLC).Wrote Teradata scripts for data manipulation, data inserting millions of records into tables.Used various Data Visualizations with Power BI and published reports to Power BI Services.Monitored performance and optimized SQL queries for maximum efficiency.Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages using VBScript.Created automation script to Scale up/down the Data Warehouse.Using a Query Editor in Power BI performed certain operations like fetching data from different file.Merge Queries and Append Queries, remove columns and split columns, choosing required columns in the data.Created dimensions by defining Parent-Child relationships, using different dimension types.Involved in planning, defining, and designing star/snowflake diagrams using Erwin on business requirement and provided documentation.EDUCATION:Master of ScienceNorth Carolina Agricultural State Technical University,2019.Minor-Computer ScienceAddis Ababa University Applied Mathematics and Statics, 2005.SKILLS:TableauRPython-NumPy, PandasMSPBIANOVAAGggplot2Web Services (XML, SOAP, JSON, WSDL)ASP.NETScrumJsonJavaScriptData ModellingSoftware DevelopmentNode.js |
