| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Charlotte areaEMAIL AVAILABLEPHONE NUMBER AVAILABLEBi developer /Power bi developerProfessional Summary: Responsible for building reports in Power BI from the Scratch. Good financial and healthcare experience in previous projects creating Chart reports, Drill down and Drill through reports by passing parameters in SQL Server Reporting Services (SSRS) Cross-Report Drill through to link source and target reports to drill through the necessary information for the end user. Design, develop, and optimize data models, Created Row level security using DAX 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. Worked on all phases of data warehouse development lifecycle, from gathering requirements to design implementation, testing and support of data warehouse and data mart entities. Implemented Power BI Gateway different source to matching analysis criteria and further modeling 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. Good Knowledge and experience on Power BI Gateways (Personal and Enterprise gateways). Implemented Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements. Hand on experience in writing calculated columns and measures using DAX query language. 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. Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure. Used SQL Server Management Studio to execute SQL queries for data analysis and debugging. 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. Created logging to check the status of each pipeline and Data is moved to Azure Data Warehouse from azure storage. Skills: Tableau R Python-NumPy, Pandas ANOVAA ggplot2 Web Services (XML, SOAP, JSON, WSDL) ASP.NET Json1 Data Modeling Software Development Big data Google analytics ExcelEducation: Master of Science -North Carolina Agricultural State Technical University Bachelor of science -Addis Ababa university applied mathematics and Statistics, Minor-computer science, Professional Experience:Mede Analytics Inc, Dallas, TX Jan 2022 -Dec2023Role: BI DEVLOPER (SSIS, SSRS, SSAS)Responsibilities: Developed documentation for business requirements, functional and technical specifications, and development standards for assigned projects and applications. Designed reports utilizing custom filters and DAX expressions with excel, and written DAX Expressions, Power Query and Functions in Power pivot Created database links and accessed the data through SQL statements. Analyzed source system data to assess data quality, worked with technical and business representatives to determine strategies for handling data anomalies that are identified. Implemented data migration from Microsoft Azure cloud platform to on-premises data servers utilizing Azure cloud technology. Involved in dimensional modeling by identifying the fact and dimension tables based on user and reporting requirements and processing cubes. Import file from vendor FTP using Mede create tool and create a cube that is used for analysis, doing analysis, and creating dashboards, summary, and detail reports. Created database objects such as tables, views, stored procedures, indexes. Modified Share Ps and formulated basic coding and scripting to be utilized for reports within the organization. Used advanced Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel functions, Macros,VBA 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. Involved in generating and maintaining SQL scripts. Participated in Daily stand up Agile/Scrum meetings to discuss the enhancements to be made for the existing requirements. Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data. ConsultantYalata Technology, Nashville, Tennessee, USA Jan 2021- Dec 2021 Role: BI Developer/Data Analyst (Power BI, SSRS, SSIS Developer)Responsibilities: Used Power BI desktop to directly connect to database tables (Direct Query Mode) or import the files into Power BI(Import Mode). Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Published Power BI Desktop to the cloud. Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment. Utilized Power BI Gateway to keep the dashboards and reports up to date. Created many complex Queries and used them in Power BI Reports directly to generate reports on the fly. Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases. Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks. Checking the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment. Created logging to check the status of each pipeline and Data is moved to Azure Data Warehouse from azure storage.2 Published Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile apps. Responsible for deploying the application for the Integration, Functional and User Acceptance Testing. Adheres to department, organization and industry guidelines, standards, policies, and procedures. Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements. Responsible for complete maintenance and delivery of scheduled releases. Developed custom calculated measures using DAX in Power BI to satisfy business requirements. 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. One Main Financial, Greensboro, NC Sep 2019 - Dec 2020 Role: Power BI Developer/Data Analyst Responsibilities: Developed Power BI reports and dashboards from multiple sources using Power query, power desktop,powerbi services Explored data in a variety of ways and across multiple visualizations using power BI. Performed and worked with Calculated columns, measures by using DAX Designed attractive dashboards with visualizations such as maps, funnel chart, waterfall charts and word cloud in Power BI. Assisted in production and non-production OLAP cubes, wrote queries to produce reports using SQL server, SSAS. Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar, and density charts. Designing current databases by adding tables, relationships, creating stored procedures, views, and performance tuning of SQL queries. Created gateways in power BI. Developed SQL queries to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations. Developed complex SQL Views, Common Table Expressions, and Temporary Tables. Provided maintenance and development of bug fixes for the existing and new Power BI Reports. Involved in generating and maintaining SQL scripts. Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters. Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning. Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging. Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. Implemented code check-in/check-out and managed multiple versions of complicated code within TFS. Performed thorough unit testing on all relevant platforms to ensure proper implementation. 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.Consultant Mar 2015 Aug 2019 Client: Geico, Chevy Chase, MD Role: Business Intelligence/Data Warehouse (SSIS/SSRS/Tableau Developer, Power BI) Responsibilities: Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support. Extracted data from internal data warehouse system to SSRS. Designed reports utilizing custom filters and DAX expressions with excel, and written DAX Expressions, Power Query and Functions in Power pivot Modified SPs and formulated basic coding and scripting to be utilized for reports within the organization. Analyzed data models, data relationships and dependencies for greatest optimization. Designed and developed stored procedures, queries, and views necessary to support SSRS reports. 3 Participated in Daily stand up Agile/Scrum meetings to discuss the enhancements to be made for the existing requirements. Designed new reports and wrote technical documentation. Gathered requirements, analyzed, and visualized the data by power BI, developed and built SSRS, power BI and Tableau reports and dashboard. Developed different types of reports including Valuation reports, Client Contact Report, Accounting Statement Report, Auction report, file transfer reports by using SSRS and Tableau 9.0 and 9.3 and SQL Server 2013/2014. Created and maintained SSIS ETL packages to extract data from different systems like PostgreSQL and loaded a variety of large volume data into data warehouse from different sources like flat file, Excel file. Developed parameterized reports used for making current and future business decisions. Developed stored procedures to generate various drill-through reports, parameterized reports, tabular reports, and matrix reports using SSRS. Created reports that projected business goals for future. Used table variables and Common Table Expressions (CTEs). Worked closely with offshore team to coordinate tasks with onsite and offsite team members in finding solutions to arising problems. Identified associated store procedures and parameters used for the reports. Involved in job scheduling and alerts and provided 24x7 production support. Worked on a project to use integration services to create packages on customer information based on purchases and locations and extract data from external sources. Created SSIS package to vendors in which records were loaded daily and to other data resources such as Excel, Access, flat file, and XML to create and maintain a centralized database. Created complex stored procedures to generate reports using SSRS. Designed and built relational databases. Pulled data and dealt with heterogeneous sources and optimized data extraction and conversion process using SSIS. Migrated databases from SQL Server 2008 to SQL Server 2012. Created ad hoc reporting universes using Business Objects Universe Designer. Built and retrieved data using universes and personal data files. Created complex ad-hoc reports using the Business Objects suite applications. Installed and upgraded from SQL Server 2008 to SQL Server 2012 on various servers... Provided error handling and auditing implemented in SSIS to track down data discrepancies. Worked with SharePoint 2010 lists, using them as interface for users. Designed business intelligence dashboard using Tableau Desktop and published on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales and to track existing customer sales. Provided performance tuning of databases and helped user in efficient reporting. Developed high-level design of ETL package in MS SQL Server 2008 for integrating data from heterogeneous sources such as Excel, CSV, Oracle, flat file, and Text Format Data. Built reports using SSRS. Developed efficient reporting solutions. Set up subscriptions as needed for SSRS. Optimized SSIS packages to fine tune data loads, reduce data load time and come up with best strategies in the data load process.4 |
