| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLEArea of ExpertiseMicrosoft PowerBI professional with 12 years of IT experience and strong background in Report development (PowerBI Desktop), Data modelling, Power Query, Administration (Both service level and tenant level) with proficiency in writing complex DAX functions and maintaining Tenant level security and workspaces in Supply chain management, Telecom, Healthcare/Insurance, Manufacturing, Retail, Pharmaceutical and Software industries.MSBI (SSIS-ETL, SSRS and SSAS) professional with strong knowledge in creating SSIS packages and creating schematic layer SSAs tables. Expertise in creating crystal clear reports (SSRS and paginated reports)Expertise in Data extraction, Transformation and loading ETL using various tools such as MS SQL server installation services (SSIS).Involved in creating databases objects like Tables, Views, Procedures, Triggers and functions using T-SQL to provide definition, Structure and to maintain data efficiently.Expertise on Power BI View Tool. Created reports using the Power BI ToolExperience in building Data flows and Deployment pipelines and integration different data flows into single entity and creating paginated report by using paginated report builder.Installed On premise data gateway (Enterprise level- On servers), Trouble shooting, checking the gateway logs and scheduled daily data refresh in POWER BI. Creating gateway clusters and assigning data sources to clusters.Created Roles and implemented Row level security for user Authentication in POWER BI Created calculated measures in tabular model using DAX Queries according to end user requests and reporting needs.Created Tabular Models using DAX queries in analysis services and deployed it.Verified and validated and thoroughly tested data and functional requirements in all environments.Maintaining. Pbix version control with share point and expert in using the DAX studio, ALM tool kit, Tabular editor and DAX helpPerformed peer code review, proactively addressed the code comments adhering to the agreed standards and requirements.Creating paginated reports with Power bi report builder and publishing to online service.Prepared user manual and Trained End Users on developed Power BI Applications.Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.Technical Skills:Reporting ToolPower BI Desktop, SQL Server Reporting Services, Power BI Admin level. Paginated reported builder (Power BI), DAX studio, Tabular editor and ALMOLAPSQL Server Analysis Services, SSIS packagesOperating SystemsWindows Enterprise 2003/2000, Windows Server 2016, 2008 R2, Windows Server 2012.ApplicationsErwin 3.5/4.1/7, Visual Studio 6.0/.NET/2005,2008/2010/2012Education:Masters in Information Technology, Southern New Hampshire University-Manchester -New Hampshire.Certifications:Microsoft Certified Power BI developer (DA-100)https://www.youracclaim.com/badges/8ec1f764-a40e-4ebe-ab1c-0206e60a1080/public_urlAbbVie -Mattawa-North Chicago (AbbVie and Allergan) Nov 2022 to CurrentRole: Sr. PowerBI Architect / Power BI / Fabric Capacity Admin/ power platform AdministratorResponsibilitiesDesigned and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.Experienced in managing workspaces (Classic and premium workspaces (V1 and V2), users, licenses and data access, users, licenses and data accessExperience in Implementing Power Bi tenant level data governance policies and capacity planning.Created data pipelines using ADF and synapse analytics.Experience in analyzing health of the power bi tenant by using premium metrics app and expert in audit and analyzing logs through rest API.Expert in configuring the different data source connectors (Oracle, SAP HANA, Post Gers SQL, SQL server, Amazon connector and Simba ODBC drivers.Expertise in debugging the performance of reports on various layers (data source, data set level, report level, Capacity level and network related issues. Designing dataflows and deployment pipelines (For deployment activities to various environments)Enabled fabric workloads and created data pipelines for ETL and Migrated Data flow gen1 to Gen2.Maintain different levels of Data Security in Power Bl while granting access to data and assigning Row Level Security (RLS) when needed.Performing upgrades on the gateways installed on remote servers. Responsible for managing service accounts for creating gateway connections on servers.Expertise in configuring the data gateways on remote servers for enterprise data gateways (On premises data gateways) and providing access to users for scheduling the refreshes/perform load balancing on gateway servers.Worked as a Power Bi admin (Tenant admin on P2 capacity) and responsible for installation of external tools (ALM tool kit, DAX studio and Tabular editor.Configure Capacity settings to assign users as Capacity Admins per capacity during initial setup of the capacity and later via User Permissions within the Premium settings.Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.Configure and maintain Premium capacity planning, updating, troubleshooting, access management and performance management.Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.Configure Tenant settings to give control over the PBI features such as (workspace settings, Export and sharing settings, Publish to web, Developer settings and configure other settings in admin portal)Created Paginated reports by using Power BI paginated report builder and published to Power Bi service. Created deployment pipelines and data flows. Responsible for version control as well.Retail Business services (Ahold and Delhaize group) JAN 2016 to NOV 2022Role: Sr. Power Bi Admin/Sr. Power BI Developer.Responsibilities:Collaborated with senior management, subject matter experts, and IT teams to define business requirements.Transformed business requirements into functional and nonfunctional requirements.Created complex stored procedures to perform various tasks including, but not limited to index maintenance, data profiling, metadata searches, and loading of the data mart.Created perpetual inventory reports for packaging (CPG) products for Shop and Stop / Food Lion retail companies.Working as Power Bi Developer for Upstream Reliability Operations Analytics team under data architects and data scientists where my roles is to create a large data warehouse environment, Feature Set tables, pulling and pushing data from different sources like SAP HANA, Ariba, Azure SQLDesigned, developed, and tested the ETL strategy to populate data from multiple source systems.Implemented SSIS packages to perform ETL data messaging operations (data profiling, cleansing, and verification).Loading data from Salesforce and SAP HANA, Azure Sql server tables into SQL DWDesigned incremental loads to populate the data mart with checksum and timestamp techniques.Created master-child packages to consolidate data from data sources into SQL server with execute package tasks, enabling modular programming.Implemented package configurations on development, test, and production environments utilizing parameters.Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.Strong understanding of Data Modeling in data warehouse environment such as star schema and snowflake schema.Created SSAS cubes with KPIs and aggregation for the front-end analysis team.Utilized multi-dimensional and tabular model in analysis services to pull and generate reports directly from in-memory from back-end relational data sources.Designed SSRS reports for in depth business analyses.Designed expressions to calculate, group, filter, parameterize, and format report contents.Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.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.Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.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.Provisioned VMs with SQL Server on cloud utilizing Microsoft Azure and setting up communication with the help of endpoints.Migrated enterprise database to Microsoft Azure with Redgate and azure data factory.Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure.Perform thorough unit testing on all relevant platforms to ensure proper implementation.Using Team foundation server (TFS) for managing source code changes.Involving in developing test cases for Unit Testing.Customizing data sources using Query Editor to cleanse and manipulates data in columns.Creating calculated columns using DAX functions to perform business logic in the reports.Created various visualizations like waterfall, funnel, matrix visualization, scatter plots, combo charts, gauges, cards and KPI.Developing dashboards by connecting to On Premises data models in Power bi Desktop based on measure and dimensions.Publish on Power BI services and schedule automated refresh of reports and create and share dashboards based on reports in power bi desktop.Created gateways to pull data from on premise data source into power bi cloud services.Creating user profiles and security groups to access power bi reports.Creating Dimensional modeling for SSAS cubes using Tabular model.Developing DAX queries by connecting to SSAS tabular models and created live query connection for advanced visualization and report tabular model.Developing reports and dashboards in Power BI using Power BI Stack of Power Pivot, Power View, and Power Map.Developing reports Using Power BI Desktop and Publish on to Power BI ServicesEnvironment: SQL Server 2012, SharePoint, Power BI, Tableau, TFS, DTA, SQL Profiler, MS Azure, Data Factory, Visual Studio, C#.Donegal Insurance, PA Dec 2014-Nov 2015BI Developer/AdminActively involved in gathering requirements from end users, involved in modifying various technical & functional specification Designed, developed and tested solutions for business user specified requirements to achieve desired business results.Participated in the daily standup with business teams to resolve the business issues and Data challenges.Hands-on experience in the design, development of end user applications for the data presentation and analytics, including scorecards, dashboards, reports, monitors, and graphic presentation (Information Visualization &Analysis) using POWER BI.Create reports in Power BI Desktop and Service utilizing the connectors and content packExpertise in creating different organization content pack, and service paExpertise in creating reports from importing, Direct Query and Live data from several data sources.Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time Column, etc.Expertise in creating DAX queries.Created different reports in Power BI Desktop and publish to Power BI online.Expertise in scheduling refresh and troubleshooting refresh issues.Expertise in installing, maintaining and troubleshooting the Personal and On-Premises Gateway.Install, configure and maintain Power BI Report Server for a client/server environment on Windows Expertise in creating different dashboards and reports.Import data from different data source to create Power BI reports and dashboards.Created calculated measures in tabular model using DAX Queries according to end user requests and reporting needs.Created Tabular Models using DAX queries in analysis services and deployed it.Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps, Pareto charts according to deliverable specifications.Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.Extracted information from different data sources like Oracle, SQL Server, MS Access and flat files.Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.Environment: Power BI, MS SQL Server, SSRS, SSIS, SQL Server Management Studio (SSMS), Tableau9.0, Toad, Star Team, Okta, Business Objects, SQL, PL/SQL, MS Project, Cisco Jabber, MS Office Suite (Word, Excel, PowerPoint)Ventois Inc-Shrewsbury-MA Jan2014- Nov2014SAS consultant (Data Migration)Responsibilities:Experience in developing Macros using SAS procedures.Generated reports using PROC REPORT, DATA _NULL_ and PROC TABULATE for customized report writing.Experience with PROC SQL, PROC DATASETS, PROC FORMAT, PROC PRINT, PROC APPEND, PROC TABULATE, PROC GPLOT, PROC GCHART, PROC COMPARE, PROC IMPORT, PROC EXPORT.Experience with PROC TRANSPOSE, SAS/STAT procedures such as PROC FREQ, PROC MEANS.Experience in PROC SQL joins and PROC SQL set operators to combine tables horizontally and vertically.Used company standard macros.Play a key role in developing, debugging, and validating the project-specific SAS programs to generate derived SAS datasets, summary tables, and data listings in accordance with departmental standards.Render support in generating analysis data sets and creating specified structure of TLFs through creating Macros and macro variables using %LET, CALL SYMPUT, and DATA _NULL_.Generate analysis datasets based on the Data Definition Tables (DDT) and in accordance to the CDISC standard. Used SDTM model (3.1.1)/ ADAM for domain creation and CDISC compliant analysis datasets.Utilize Proc CDISC for verifying compliance of datasets with CDISC standards and electronic submissions.Used SAS ODS to report outputs in different formats like RTF, PDF, and HTML.Validated analysis data sets and SAS outputs with other programmers outputs and mockups in SAP using PROC COMPARE, PROC CONTENTS and PROC FREQ. Created formats for the coded data and used PROC SQL for data validation.SAS macros were successfully used to create new programs and modified existing SAS programs to make them portable as well as for consistency of results.Documented, summarized and recorded data as per standard operating procedures (SOPs) and FDA regulations.Majorly worked with the data management team and was involved in handling documentation and submission processes (under managers assistance).Strong in UNIX and used all UNIX commands to manage SASprograms check-in/check-out, moving codes, build release scripts, data file movement And Good Understanding of data modelling.SAS statistical programmer- JAN-2011 TO Dec-2013GSK Pharmaceuticals-London-UKResponsibilities:Developed many reports, listings based on SOP, using various Procedures in Base SAS and SAS/Stat.Active participation in meetings related to IVRS and help other developers understand the process, functions and implementation in the study.Wrote macros to streamline the process of development of programs with respect to study related parameters.Produced many AD-HOC reports, as imposed by Statisticians to satisfy and verify many of data and SOP issues.Implemented many flags to denote various Adverse events based on the requirements and as directed by statisticians.Provided assistance to CDM group to validate Data.Produced many crucial reports including AE, SAE, SF-36, KCCQ.Authored many macros that were used extensively in all study related programs, to perform specific functions.Intensive participation in submission of reports and requests to satisfy queries as imposed by various governing agencies including EMEA, FDA.Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools-SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL.Acted as medium between the Statistical Department and CDM in reporting andProduced quality customized reports by using PROC TABULATE, REPORT, SUMMARY and provided descriptive statistics using PROC Means, Frequency, Univariate.Used Output Delivery System (ODS) to create a vast variety of reports both in RTF and HTML format. |
