Home

Anil Kumar - Power BI/SQL BI Developer

[email protected]

Location: Santa Monica, California, USA

Relocation: Yes

Visa: H1B

Anil Kumar : +1 205-341-1335 : [email protected] PROFESSIONAL SUMMARY: Over 8+ years of professional IT experience in Designing, Developing, Architecting and Migrating Business Intelligence solutions across multiple domains. Extensive experience in implementing Microsoft BI/Azure solutions like Power BI, Tableau, Qlik, SSRS, Informatica, OBIEE, Alteryx, Azure Analysis Services, Azure Data Factory and SQL Server. Hands-on experience in extracting the data from heterogeneous sources such as Flat Files (.csv files), Excel Files, MS SQL Server, Oracle 11g/10g, IBM DB2, FTP Server and XML Source and loading the data into target ODS, data marts and data warehouses using SSIS packages. Experience in utilizing the Power BI Import, Direct Query and Live connection methods based on the business requirements and data source types. Expert in Power BI and ability to program in DAX query language to modify data for reporting. Critically evaluates information gathered from multiple sources, reconciles conflicts, and abstracts up from low-level information in Power BI. Modify datasets using DAX query, Merge statements, Refresh Schedule, Row-level security, and Modelling within Power BI. Experience in developing custom reports and creating various types of reports like on-demand, Drill down, Drill-through, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Crosstab, graphical, and distributed Reports in multiple formats in Power BI. Experience with Microsoft Power BI DAX expressions, Power View and Power Query integrated with share point. Expertise in creating Object Level Security in cubes using the Power BI External tool Tabular Editor. Expert in implementing Row-level security (RLS) for user authentication in Power Bl. Experience in working with Larger Datasets using Power BI premium. Experience in creating DLs (Distribution Lists) and Roles (Admin, Developer and Viewer), adding the respective users to the DLs, granting the necessary privileges to the DLs, and granting and controlling access to POWER BI workspaces by adding DLs into the Workspaces as per the business requirements. Experience with Power Apps and its components Gallery, Screen, Card, Control, Property and Function the Power Fx. Experience in implementing the dashboards in iOS devices using Power Apps both in Model- Driven and Canvas Apps. Converted existing Nintex workflow and form using PowerApps and Microsoft Power Automate (Flow) to improve Business processes. Implemented PowerApps Role Based Security using SharePoint Group & Flow. Working with services, triggers, actions, conditions, parallelism, and loops - Run a flow on a schedule, calling custom business services. Extensive Tableau Experience in Enterprise Environment 10.5/10.3/10.1/9. x/8.x/7.x and design and development of Tableau visualization and dashboard solutions using Tableau Desktop. checks, and data standardization using Alteryx. Experienced in developing Alteryx predictive models for machine learning and deep learning applications. Hands-on experience in creating Denodo views, procedures, and functions to query and manipulate data from multiple sources. Good Experience with Azure Data Factory (ADF). Involved in creating Stored Procedures and Scheduling them in Azure Environment Scheduling Pipelines and monitoring the data movement from source to destinations Good knowledge of RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, and User Defined Functions. Experience in OLTP and OLAP design, development, testing, implementation, and support of enterprise data warehouse. Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables and DW concepts. Experience in T-SQL, Creating and developing new database objects like Tables, Views, and Indexes. TECHNICAL SKILLS: Reporting and BI Tools MS Power BI, Tableau, Qlik, Alteryx, SSRS, Power Apps, Power Automate, Azure Data Factory (ADF) and Azure Analysis Services (SSAS). Data Modeling and ETL Tools MS SSIS, Informatica, Erwin and Power Designer v15.0 Databases MS SQL Server 2008R2/2012/2014/2016, Oracle 11g/10g, NoSQL and Teradata Languages DAX, Power Query (M Language), SQL, Python Scheduling Tools Autosys, Control-M, TWS (Tivoli Work Scheduler) Data Virtualization Denodo Operating Systems Windows, UNIX, MS-DOS PROFESSIONAL EXPERIENCE: Kaiser Permanente Feb 2023 Till Date SOFTWARE Developer, Frisco, Texas. Responsibilities: Optimize and best possible solutions are given while creating Calculated Columns / Measures/Tables with appropriate techniques having the best performance. Dynamic Row-level security (RLS), both Static and Dynamic with hierarchies were implemented successfully on Power BI Service (Cloud). Working with data models with complex relationships in Power BI and connecting different data sources to the Power BI desktop. Solid experience on both Cloud and on-premises gateways to deploy Power BI reports and maintain normal and Row levels of Security. Creating Datasets on Power BI Service to avoid "Data Set Silos" and creating different environments for Dev/QA/Prod Swap using Deployment Pipelines. Working closely with Power BI Admin to incorporate Deployment pipelines for various environments for dev/QA / Prod on Power BI Premium capacity. Data Flows have been created with self-service Data preparation to help other BI Reports as a single source and ready to use the dataset. Data Folding and Query reduction techniques and Data Silos have been taken care of while implementing Steps with transformations on Power Query. Collaborating with business stakeholders to understand requirements and translate them into technical specifications for Power Apps and Power BI Automate. Integrating Power Apps with other Microsoft technologies, such as SharePoint and Teams, to provide seamless user experiences and streamline workflows. Designing and implementing complex Power Automate workflows and automation processes that reduced manual effort and improved data accuracy. Collaborating with stakeholders to gather requirements and translate them into technical specifications for Power Apps and Power Automate solutions. Integrating Power Apps and Power Automate with other Microsoft technologies, such as SharePoint, Dynamics 365, and Teams, to provide seamless user experiences and streamline workflows. Creating interactive dashboards and visualizations to analyze data and trends, track key performance indicators (KPIs), and identify insights using Tableau. Conducting training sessions for users to increase their Tableau skills and encourage the adoption of Tableau across the organization. Collaborating with the IT team to resolve technical issues related to Tableau Desktop. Designing and developing custom reports to meet specific business requirements using Tableau. Conducting data cleaning, preparation, and analysis to ensure data accuracy and Consistency in Tableau Desktop. Experience in creating aggregates sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters in Tableau. Designing and developing Tableau content for the Users and co-workers for a better understanding of each concept. Design, develop, and deploy Informatica ETL workflows for data integration and migration. Create and maintain mappings, transformations, and sessions using Informatica PowerCenter. Environment: MS Power BI, Alteryx, Power Apps, Power Automate, OBIEE, Tableau, ADF, Azure Analysis Services, MS SQL Server, MS Visual Studio, Jira, Denodo and Agile Methodology. Client: CIGNA March 2020- July 2021 Role: Sr. BI Developer, Hyderabad. Responsibilities: Experienced in working with DAX commands to pull up more calculated data out of the tables. Dynamic Row-level security (S) was implemented successfully on Power BI Service (Cloud) Worked with gateways to schedule the report and data using different gateways Worked with data models with complex relationships in Power Band and connected different data sources to Power Desktop. Published many reports and visualizations created for the Power service and thereby develop dashboards. Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations. Created complex Custom View using SQL Developer to create data sets for Power BI dashboards. Experienced in working with DAX commands to pull up more calculated data out of the tables. Made Power BI reports more interactive and activated by using storytelling features such as bookmarks, selection panes, and drill-through filters also created custom visualizations using "R- Programming Language". Published and maintained workspaces in Power BI Service, allotted the time refresh for the data and maintained the apps and workbooks. Used DAX functions to create measure and calculated fields to analyze data for logical visualization and used Power Queries to transform the data. Converted the Boulder Tables from Excel to Power BI with better Graphs and visualizations for the understanding and improvement of the business. Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects. Developed custom connectors and APIs to integrate third-party systems with Power Apps and Power Automate, enabling data consolidation and centralized reporting. Optimized Power Apps and Power Automate performance through code optimization, data compression, and other techniques, resulting in faster load times and improved user experiences. Created and maintained documentation of Power Apps and Power Automate solutions, including design specifications, user guides, and release notes, ensuring a smooth handover to support teams. Worked closely with IT teams to ensure proper integration and deployment of Power Apps and Power Automate solutions across the organization. Creating data models in Power BI to provide real-time insights and analytics, enabling data-driven decision-making across the organization. Involved in the ETL database, data marts, and Dimensional Model with Fact and Dimension tables. Hands-on Experience with the ETL Refresh Data Model master package using SSIS which contains a collection of several master packages running several child packages in different stages. Involved in the ETL process into a 1 package execution which is scheduled to run refresh on AutoSYS at the defined schedule to refresh the whole data model of our project. Develop and maintain data dictionaries, metadata, and data lineage information. Participate in code reviews and provide feedback to other developers. Develop and maintain database objects, including tables, views, and stored procedures. Troubleshoot and resolve issues related to data integration and data quality. Participate in code reviews and provide feedback to other developers. Develop and maintain database objects, including tables, views, and stored procedures. Develop and maintain Informatica configurations for different environments (development, testing, production). Perform performance tuning and optimization of Informatica workflows and SQL queries. Implement and maintain security controls for Informatica workflows and databases. Environment: MS Power BI, OBIEE, Informatica, Alteryx, Power Apps, Power Automate, SQL Server, SSIS, Jira and Agile Methodology. Client: United Health Group, Bangalore, India. July 2019 - Feb 2020 Role: Core Power BI/MSBI Developer Responsibilities: Created and administrated workspaces for each project on Power BI service and published the reports from Power BI Desktop to Power BI Services workspace. Utilized Power BI to create various analytical dashboards that help business users to get a quick insight into the data Installed Data Gateway and configured schedule plans for Data Refresh of Power BI reports. Implemented report integration among Power BI, Tableau, SSRS and Python reports. Implemented Tableau for visualizations and views including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc. Generated complex reports in Tableau using multiple functionalities including context filters, hierarchies, parameters, LOD Expressions, time intelligence, etc. Built interacting and storytelling dashboards in Tableau workbooks using dashboard actions Published Tableau workbook on Tableau Server and set report refresh. Good knowledge of RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, and User Defined Functions. Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS). Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables and DW concepts. Environment: MS Power BI, Tableau, Oracle 11g/12c, Microsoft SQL Server Management Studio 2012, SSRS, SSIS, HP Client, Microsoft Visio, MS Office, UNIX, Windows 10 Operating System. Client: Credit Union National Association, Hyderabad. March 2016- May 2019 Role: SSRS Developer / MSBI (SSIS SSAS Power BI) Developer Responsibilities: Developed effective and interactive dashboards using Parameters and Actions in Tableau. Strong dashboard design experience with fewer performance issues in dashboards and passionate practitioner of effective data visualization in Tableau. Used Tableau Desktop tool for building various dashboard development activities such as Dashboard layout design and development, Tableau Extracts, Tableau Actions, and Tableau Dashboards Published and shared views on the Tableau server, scheduled extract refresh and subscriptions. Colour coding, Conditional Formatting and formatting. Tableau designs, prototypes and Tableau mock-up reports and Wireframes. Created actions to navigate from one dashboard to another dashboard and created URL actions to navigate dashboards of the tableau server based on parameters. Designed the ETL database, data marts, and Dimensional Model with Fact and Dimension tables. Created T-SQL scripts (stored procedure, functions, triggers, views, tables, indexes etc.) and Oracle PL/SQL scripts, PL/SQL Packages, procedures, triggers, functions, Indexes & collections. Developed complex-level SSRS reports and managed the report server reports accordingly. Environment: MS SQL Server 2008R2 & 2012, SSRS, SSAS, SSIS 2012, Oracle 11g/10g, MS Visual Studio 2008 & 2010, POWER BI Desktop, POWER BI Service, C#, C++, VB.NET, XML, HDFS. Client: Kronos IT, Hyderabad June-2014 - Feb 2016 Role: BI Developer Responsibilities: Developing Reports as per the Mockup provided by the client. Code review of Juniors Developing Reports as per Business Requirements. Analysis of Reports and Data Validation. Solve the issue of the Report. Providing resolution to incurred issues. Testing of report functionality and preparing Unit test cases/Results. Migration document preparation. EDUCATION: Master of Computer Applications from Campbellsville University- USA in 2023. Keywords: cplusplus csharp quality analyst business intelligence active directory rlang information technology hewlett packard microsoft procedural language Colorado