Akash Kamble Email & Phone Number

Plano, Texas, United States

• 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.

Bengaluru, Karnataka, India

• 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.

Bengaluru, Karnataka, India

• 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.

Bengaluru, Karnataka, India

• 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.