Home

Akash - Power Bi

[email protected]

Location: Dallas, Texas, USA

Relocation: yes

Visa: H1B

Akash Kamble _______________________________________________________________________________________ PROFESSIONAL SUMMARY: Over 7+ years of experience working on projects with extensive usage of ETL & reporting tools like Power BI, SSIS, SQL server reporting service (SSRS) in diverse roles across the organizational hierarchy. Advance data modeling using DAX, power query/edit query in Power BI desktop, and working with custom visuals. Good Experience with power automate. Coordinated and participated in weekly estimation meetings to provide high-level estimates for backlog items. Experience in configuration and maintain report manager and report server for SSRS deployed and scheduled the reports in report manager. Power BI Tools power bi desktop, power pivot, power query, power view, power map, power bi dashboard, calculated columns and calculated measures using DAX, data modelling, power apps. Expertise in creating Workflows based on Functional Specification Document. Experience in Deploying and Monitoring ETL packages in SQL Server by job scheduling the flow of packages from Development Server to Test and Production Server. Proficient in optimizing SQL queries, performance tuning using SQL Profiler as well, as understanding execution plans. Periodic reporting is done on a daily, weekly, monthly, and quarterly basis, which helps the clientby using the reporting Services (SSRS), POWER BI. Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, TreeMaps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI, and Excel to provide better data visualization. Expert in generating on-demand and scheduled reports for business analysis or management decisions using SQL Servers Reporting Services (SSRS) and POWER BI. Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map, and Heat Map. Expert on Microsoft Power BI reports dashboards and publishing to the end-users for executive-level Business Decision. Expertise in creating and maintain Workspace and Gateways. Expert on maintaining and managing POWER BI driven reports and dashboards. strong understanding of managerial and professional skill sets. Extracted data from Azure SQL Server for reporting and to facilitate sharing between multiple data systems. Experienced in ERP system such as Oracle, SQL Server, and Azure SQL Server. Extract the data from different sources and cleanse the data. Experienced with Office 365 development utilizing PowerApps, Flow, and Power BI. Good Knowledge on Robotic process automation technology. Experienced in all facets of software development life cycle (analysis, design, development, testing, and maintenance) using a waterfall methodology. TECHNICAL SKILLS: BI & Database Tools SSRS, SSIS, SSAS, Power BI, Tableau Desktop, Power BI Desktop, Power BI Services, Power BI Mobile, Databases Microsoft SQL Server 2014/2012/2008R2/2008, MySQL, Oracle, DB2, Teradata, MS Access. Script and Query Languages T-SQL, PL/SQL, C, XML, SAS, Python, Matlab Operating systems WINDOWS 7/10, LINUX, UNIX Productivity Applications Others & MS Word, MS Excel, MS Access, MS Project, Visio, SSMS, JIRA, POWER PIVOT, MS ACESS, WATERFALL METHODOLOGY, TFS, GIT, JSON PROFESSIONAL EXPERIENCE: Truist Financial, Plano, TX Oct 2021 Present Power BI Developer Responsibilities: Coordinating with business users in analyzing business requirements and translating them to technical specifications. Developed dashboards and ad-hoc reports using MS Power BI and SSRS for the senior management team for analysis. Using SSIS Package, identified the upstream and imported the required tables into the intake database, Stored Procedures are created in the staging database using the intake database tables. Good Experience with power automate. Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2016. Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services. Design data model and creating the schema on Azure SQL. Good grasp of database concepts, structures, storage theories, practices, or principles. Hands-on expertise in SQL reporting, development, analytics, or BI. Relevant experience in processing flowcharts or data flow diagrams used various sources to pull data into Power BI such as SQL Server, Dynamics CRM, Oracle, SQL Azure, etc. Created many complex Query and used them in Power BI Reports directly to generate reports on the fly. Incorporated complex business logic by writing complex SQL procedures and functions. Extracted data from Oracle, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data. Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks. Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large database sets. Checking the code into TFS (Stored Procedures, Views, Tables, Schema) for the deployment process for the production environment Published Power BI Reports in the required origination and made Power BI Dashboards available in Web clients and mobile apps. 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. Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, and Bullets using Power BI. Created KPI s, Partitions, Perspectives, and Calculated Measures, used DAX queries, and Roles. Implement the SAP Business Objects reporting requirement. 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, and Visual Level Filters in Power BI according to the requirements. Used One Drive for storing different versions of the Power BI report. Used JIRA for Version Control needs task check-ins. Excellent problem-solving approach, analytics skills, T-SQL coding commands. Responsible for complete maintenance and delivery of scheduled releases. Good knowledge of data warehouse and ETL (Extraction, Transformation, and Loading) concepts. Amazing communication skills and problem identification ability. Accenture Bangalore India Dec 2020 Oct 2021 Power BI Developer Responsibilities: Collaborated with the project team to outline project requirements in JRD meetings. Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client. Developed data reconciliation SQL queries to validate the overall data migration. Formulated DAX Expressions create Date to yearly columns and implemented partitions in Tabular Models for Power BI. Used recently introduced Power BI to create self-service BI capabilities and use tabular models. Wrote DAX expressions to create new measures, calculations per business requirements. Good Experience with power automate. Effectively used data blending, filters, actions, and hierarchies feature in Power BI. Analyzed the data using Statistical features in Power BI to develop trend analysis. Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data. Successfully integrated custom visuals based on business requirements in Power BI desktop. Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards. Created complicated reports such as parameter-based reports, graphical reports, excel reports, drill-down charts, and tabular reports using SSRS. Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, and Bullets using Power BI. Administrated and scheduled data-driven mailing subscriptions on SSRS Reporting Server. Generated and scheduled on-demand reports for business analyses and management decisions with SSRS. Accenture Bangalore India Dec 2018 Dec 2020 POWER BI Developer Responsibilities: Participated in the user requirement gathering and Design meetings. Worked closely with Business Analyst, Data Modeler, and all teams within the organization to understand business Processes. Participate in Microsoft SSIS ETL Framework to perform tasks synchronously and asynchronously. Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified. Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes. Design, develop and implement enterprise-class data warehousing solutions. Used ETL (SSIS) to develop jobs for extracting, transforming and loading data into the data warehouse. Experiences in various types of tasks like Execute SQL Task, For each Loop Container Task, Sequence Container, Data Flow Task, File System Task, Execute Package Task, Bulk Insert Task, FTP Task and Send Mail Task on control flow and data flow in SSIS and Implementing like Conditional Split, Lookup, Merge, Merge Join, Multicast, Union, Row Count, Fuzzy Grouping and Checkpoint, Transactions in SSIS. Read source data from Azure SQL DB, CSV, and SQL Server 2016. Through Power BI. Generated context filters and data source filters while handling a large volume of data. Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, and Logical, information, Text and date functions in source data. Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports. Create and customize simple data visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards. Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients. Created multiple data model and used as a common data source for the reporting purpose. Used Power BI Gateways to keep the dashboards and reports up to date. In Power BI developed reports by different time intelligence like a year to date (YTD), Month to date (MTD), same period last year. Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines. Created no of views, calculated tables, calculated columns, and measures. Hand on Experience in UNIX to write basic commands, Moving files from HDFS to local and vice versa. Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs, and charts. Accenture Bangalore India SQL Server BI Developer Nov 2015 Nov 2018 Roles and Responsibilities Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager. Created reports by retrieving the data from cube using MDX reports. Involved in creating SSIS jobs to automate the reports generation, cube refresh packages. Designed high-level ETL architecture for overall data transfer from OLTP to OLAP with the help of SSIS. Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server. Set package configuration in SSIS to redirect path from test environment to production environment. Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS. Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services. Experience in creating complex SSIS packages using proper control and data flow elements with error handling. Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS. Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various. Prepared the complete data mapping and Report Definitions for the project, which involved around 33 reports. Keywords: cprogramm business intelligence database active directory microsoft procedural language Texas