| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Power Bi Sql Server Dunwoody, GA SAS Programmer, Power Bi, SQL, Python, Pharmacy Technician Alpharetta, GA Power Bi & Sql Server Cumming, GA Sql Server Power Bi Snellville, GA Data Analyst Power Bi Atlanta, GA Power Bi Business Intelligence Atlanta, GA Data Engineer Power Bi Marietta, GA |
|
Click here or scroll down to respond to this candidateCandidate's Name
Power BI DeveloperEmail: EMAIL AVAILABLE Mobile: PHONE NUMBER AVAILABLEPROFESSIONAL SUMMARY:Over 7+ years of experience working on Power BI development, SQL server integration services, SQL server reporting services, SQL server Analysis Services, and TSQL Development.Specialized in transforming data into user friendly visualizations to give business users a complete view of their business using Power BI.Created different Power BI reports using the desktop and the online service and schedule refresh.Experience in installing and configuring the personal and on premises gateway, connecting to different data sources and as well as adding different users.Created different visualization in the report using custom visuals like Bar charts, Line charts, Cards, Slicers, Pie Charts, Donut Charts etc. Used different transformations to clean up the data.Experience in developing Power BI reports and Dashboards from multiple data sources.Experience in monitoring Premium Capacity, updating, troubleshooting, access management and performance management.Extensive knowledge on Premium Capacity Metrics and Power BI Capacity Load Assessment tool.Configured Tenant settings to give control over the PBI features.Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date, and time column.Expertise in deploying Power Bi datasets using ALM Toolkit.Experience with Dimensional Modeling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, drill down and drill across approach.Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.Experience in writing complex SQL queries involving multiple tables inner and outer joins.Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.Experience in Creating Tables, Views, Triggers, Stored Procedures, Power BI User Defined Functions, and other T- SQL statements for various applications.Worked Extensively on ETL process using SSIS package.Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2016/2014/2012/2008.Experienced in client requirement Analysis, Physical, Logical design, development, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications.Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts.Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.EDUCATION :Masters in Computer Science, University of Alabama at BirminghamGPA 3.7 Jan 2020 - May 2021Bachelors in Electronics and Telecommunication, Mumbai UniversityGPA 3.3 Aug 2011 July 2015CERTIFICATION:Microsoft Certified: Power BI Data AnalystTECHNICAL SKILLSLanguagesJAVA, C++, T-SQL, SQL, PLSQLDatabaseMS-SQL, Oracle, PostgreSQLWeb TechnologiesJSP, Servlets, JavaScript, HTML, XMLDeveloper ToolsPower BI, Tableau, Hive, ALM Toolkit, Capacity Load Testing tool, DAX Studio, Tabular Editor, MS OfficeOther ToolsJIRA, GIT, SVN, Putty, WinSCP, Target ProcessClient: Central Dynamics (Cendyn), GA May 23 PresentRole: Senior BI ConsultantResponsibilities:Interacted with client daily for any requirements, progress, and deliverables.Coordinated with client to identify new requirements, analyze strategies and reporting mechanisms and maintained associated documents.Assist in report generation to internal and external customers for decision making.Involved in migrating Power BI reports connected with one data source to another data source.Help with data management, modeling and integration tasks in data warehouse systems, and reporting platform administration tasks.Manage reporting schemas, provide help, and quickly resolve any problems that may arise. Implementing BI Solutions to achieve data reporting and analysis goals.Extensive use of performance analyzer to check the performance of the report and time computing for DAX queries.Refreshing report using XMLA endpoints.Deployed existing incremental refresh configured datasets using ALM Toolkit.Used Premium Capacity Metrics and Power BI Capacity Load Assessment tool for premium capacity maintenance.Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date, and time column.Expertise in combining data using power query.Created report for users in different departments in organization using SSRS and Power Bi.Troubleshoot and support reports in power bi workspaces whenever there are issues in production.Helped in creating BI Standards to achieve company objectives.Suggestions for improvements and changes to improve the BI Process.Maintain documents for all BI Processes.Environment: SQL Server, Power BI Desktop, Power BI Service, DAX Studio, ALM toolkit, Power BI Capacity Load Assessment tool, Tabular Editor, Azure Data Lake, Azure ADO.Client: Reply Sep 21 Mar 23Role: BI EngineerResponsibilities:Interacted with business resources daily for analyze business processes, requirements progress and deliverables.Coordinated with stakeholders to identify new requirements, analysis strategies and reporting mechanisms and maintained associated documents.Assist in report generation to internal and external customers for decision making.Involved in migrating existing Cognos reports to Power BI reports.Coordinating with IT teams to build data warehousing systems for BI, reporting and analytics.Assist in data administration, modelling and integration activities in data warehouse systems, and administration activities in reporting platform.Oversee Reporting Schemas and supported and solved issues any found in timely manner.Implementing BI Solutions to achieve data reporting and analysis goals.Supported the development of BI Standards to meet the business goals.Recommended enhancements and modifications to optimize BI Process.Leaded meetings related to BI Operations such as addressing BI questions and issues related to Cognos as well as Power BI, resolving problems and closing tickets in timely manner.Coordinated and helped other teams to support and fix issues dealing with their Power BI reports.Created Workspace and Apps in Power Bi Service and giving access to end users to Apps.Developed interactive visuals, KPI scoreboards using Power BI desktop application.Developed complex DAX Queries to generate computed columns.Created rich Power BI visualizations, DAX Queries, and work with power query for data integration and transformation as per the business requirement.Developed Power Bi reports and dashboards using Companys standard defined visuals using Nummero toolkit.Experience in separating report from dataset and using Power BI Dataset as live connection.Extensive use of performance analyzer to check the performance of the report and time computing for DAX queries.Experience in refreshing report using XMLA endpoints.Deployed existing incremental refresh configured datasets using ALM Toolkit.Used Premium Capacity Metrics and Power BI Capacity Load Assessment tool for premium capacity maintenance.Configured Tenant settings to give control over the PBI features.Implemented Row Level Security (RLS) on datasets and reports in Power BI.Created several user groups and roles and provided RLS to them.Skillful in using Power BI features such as bookmarks, selection pane, drill down drill throughs.Created Power BI apps and integrated with Power Bi reports and Dashboards.Created reports from import, direct query from several data sources.Developed reports and dashboards from multiple data sources such as on premises and cloud using Power Bi Desktop.Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date, and time column.Expertise in combining data using power query.Utilized Power BI Gateway to keep the dashboards and reports up to date.Developed and published reports and dashboards using Power BI.Installed and configured Enterprise Gateway and Personal Gateway in Power BI Services.Skillful in Fact/Dimension data warehouse design model, including Star, Galaxy, and Snowflake Schema.Created report for users in different departments in organization using SSRS and Power Bi.Coordinated with Data Engineer to optimize the database by creating various clustered, non-clustered indexes and indexed views.Involved in creating daily, weekly, monthly, subscription reports for the analysis of managers & end-users using SSRS.Troubleshoot and support reports in power bi workspaces whenever there are issues in production.Maintained documents for all BI Processes.Environment: SQL Server 2012/2008R2/2008/2005, Power BI Desktop, Power BI Service, Cognos, DAX Studio, ALM toolkit, Power BI Capacity Load Assessment tool, SQL Reporting Services (SSRS), SharePoint, SourceTree, Target Process.Client: Kimball Midwest, OH. Jan 20 Aug 21Role: SQL Developer InternResponsibilities:Interacted with business resources daily for analyze business processes, requirements progress and deliverables.Gathered business requirements, working in conjunction with the data warehouse architect on the development of logical data models.Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for data cleaning.Utilized Power BI Gateway to refresh the dashboards and reports timely manner.Configuring Power BI Gateway for SSAS live connection.Developed complex DAX Queries to generate computed columns.Developed and published reports and dashboards using Power BI.Developed various dashboards by developing various chart types including pie charts, bar charts, tree maps, scatterplots, line charts, area charts, circle views, Sankey charts in Power BiInstalled and configured Enterprise Gateway and Personal Gateway in Power BI Services.Worked with table and matrix visuals, worked with different level of filters like visual level, report level and page level filters.Created Complex Views and complex functions to expose the column as per the client requirement.Implemented DB maintenance plans by appropriately re-indexing the indexes to resolve fragmentation. Analyzed and addressed DB performance issues to resolve the blocking, deadlocks and optimized the performance.Environment: SQL Server 2012/2008R2/2008/2005, T-SQL, Power Bi, DAX Studio, Visual Studio 2012/2010,BI Xpress, SharePoint, Project Server, C#, VB, HTML, Team Foundation Server (TFS), Service Now.Client: CTS, India Dec 17 May 19Role: SQL Server BI DeveloperResponsibilities:Successful migration of the data from 2005 SQL database to SQL 2008, 2012 database by converting and re-writing DTS packages and updating them to SSIS packages.Enhanced the logical and physical database design to fit new business requirements, and implemented new design into SQL Server 2008Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration Services (SSIS) on different Data Sources.Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.Implementation of Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.Created Stored Procedures, Triggers and User Defined Functions to support the front-end application.Created Triggers (Instead of and After) for Auditing Purpose.Optimized the database by creating various clustered, non-clustered indexes and indexed views.Created Jobs using sql server agent to automatically run the stored procedures in scheduled time.Worked on de-bugging package execution using break points in control flow and data viewer in data flow.Worked on importing and exporting data from MS-Access Database and XML to SQL Server Database.Developed, created and implemented complex ETL strategy to grab the data from OLTP, perform various transformations and dump the incremental data into Data Mart.Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.Optimized ETL packages using various SSIS features at Control Flow and Data Flow level.Designed, deployed and maintained various SSRS Reports in SQL Server 2008 and 2012.Used Dynamic SQL extensively in T-SQL increasing usability of code and also used dynamic query to create parameterized, cascading parameterized reports, drill down, drill through and Tab reports.Generated daily, weekly, monthly, subscription reports for the analysis of managers & end-users using SSRS.Optimized packages minimizing use blocking transformations, adjusting buffer size, parallel executing packages in control flow, and using proper event handing, loggings and check points.Used XML as SQL server package configuration in deploying packages to production environment.Involved in De-Normalization of existing tables for faster query retrieval.Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.Experience in Using and maintaining the Visual Source Safe for version control.Created Complex Views and complex functions to expose the columns as per the client requirement.Scheduled and monitored various jobs like package execution and cube processing using the SQL Server Agent.Automate the backup and the recovery strategies for the Production environments.Implemented DB maintenance plans by appropriately re-indexing the indexes to resolve fragmentation.Analyzed and addressed DB performance issues to resolve the blocking, deadlocks and optimized the performance.Environment: SQL Server 2008R2/2008/2005, T-SQL, SQL Integration Services(SSIS), SQLReporting (SSRS), SSAS, Business Intelligence Studio, Visual Studio 2008, Erwi4.0, SharePoint,MOSS2007, C#, HTML, Visual Source Safe (VSS),Client: SunraySys Solutions Pvt Ltd - India Feb 16 Nov 17Role: MSBI DeveloperResponsibilities:Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needsWorked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSISInstalled, configured and maintained SQL Server Integration Services (SSIS).Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.Experience with the Share point 2007 to upload the SSIS packages in to Web portal.Participated in requirement gathering, cube design, application design, SSAS development, training operational users.Implemented SQL Server OLAP services (SSAS) for building the data cubes.Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.Developed reports using SSRS and published as PDF, Excel, and CSV formats.Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.Designing and building data load procedures using MS SQL Server.Designed and implemented Stored Procedures and Triggers for automating tasks.Configured product meta-data tables to support client data reporting needs.Incremental and full database recovery with experience of complex recovery scenarios.Performance: Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queriesEnvironment: SQL Server 2005/2008, MS Analysis Service SSAS Developer 2008, MS Project, MS Access 2000 & Windows 2K platform. |
