• Leading the Data BI Team.• Estimate and prioritization of tasks.• Design and develop Power BI reports and Paginated reports.• Create and maintain stored procedures, SQL Server jobs and SSIS ETL packages.• Work on development and support tasks

• Lead team of 4 Power BI developers.• Requirement understanding and creating BRD document.• Bring data from multiple data sources like Oracle fusion tables, Oracle Business Intelligence Cloud Connector Public View Objects, Share Point Lists, Share Point Excel files, Azure Analysis Services, Power BI datasets.• Develop and support various reports for procurement and finance teams.• Worked on Azure synapse views, queries, and procedures.• Used Azure Synapse pipelines and Azure data bricks hive_metastore along with python to load data from Oracle BICC PVOs to Azure Synapse.• Brought down refresh time of reports by 60% by redesigning the data model and improvised views.• Use Service now for creating story, assign tasks in the agile board and work on incidents as per SLAs.• Use git-hub for versioning pipeline codes from working branch to main branch and deployment.• Created complex DAX measures and Time Intelligence measures for report KPIs.• Created Microsoft tickets and worked closely for issues related to Azure run books, Gateways and SSAS cubes, usage reports.

• Discuss business requirement with users, consult and propose design.• Worked on optimizing existing reports.• Created SSIS packages to bring data from complex excel files into SQL Server tables and build Power BI Reports.• Worked on creating customized themes to implement standard formats across the report.• Created power bi standard template for all reports.• Extensible worked on remodeling the existing reports to optimize performance.• Worked on creating complex measures and columns.

• Meet business users to understand business objectives and discuss requirements.• Imported different data from SQL Server database, Share Point and Excel file to generate reports.• Data massaging, cleansing, transformed data by utilizing Power Query and M Queries such as unpivot columns, replace values, duplicate, reference.• Optimized data modelling, used cross filtering, joins, merge & append.• Utilized parameters, slicers, filters, matrix, tables, custom visuals to build various inventory, container scan and finance accrual deferral reports.• Design and run unit test cases, publish reports to power bi app, configure data gateways, schedule refresh.• Migrated Qlik View Finance and Operations reports into Power BI.

• Responsible for analysis, architecture, design, and development of data warehouse and business intelligence solutions• Participated in designing architecture of SSIS (ETL) process to pull out policy, billing data from VMS system to daily, monthly OLAP (Star Schema, Snow Flake Schema) data mart and feed downstream reporting.• Designed and created complex SSIS packages dynamically using BIML scripts for performing ETL operations from different source systems.• Created audit tables to maintain all logs and error information.• Deployed the SSIS Packages to different environments and created jobs for efficient running of the packages.• Extensible used T-SQL scripts, dynamic SQL, complex stored procedures, functions, cursors and indexes.• Worked on Exception Handling with @@error and with Try/catch and resolving locking/deadlocks.• Responsible for proposing and implementing solutions to new or change in business use case.• Worked on Reconciliation and Validation script to ensure data integrity.• Responsible for monitoring database performance and proactively worked on any issues.• Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.• Created complex visualizations& KPI scorecards using Power BI desktop and published to Power BI service.• Expertise in writing complex DAX functions in Power BI and Power Pivot. • Created Workspaces and content packs for business users to view the developed reports.• Created stored procedures and SQL queries to pull data into power pivot model. • Configured Gateways and Scheduled refreshes in power bi service.• Check in source code into GitHub for version controlling.• Coordinate with Release Management Team for migrate code to QA, UAT, TRG and Production based on migration date and releases. • Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.

• Involved in complete SDLC life cycle. • Extract, Transform and Load source data into respective target tables to build the required data marts. • Understand user requirements and Data Model defined and developed by the business analysts and data architects. • Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards. • Implemented different types of constraints on tables. • Designed and applied entity and attributes description and definition for the models. • Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases. • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.• Responsible for gathering business requirements to create business user reports. • Developed optimal stored procedures and queries to create data sets for reports. • Created various Power BI Dashboard and reports using Desktop and deployed it to the Server.• Helping users to identify the possible matrices for the Power BI reporting and other analytics decisive reporting.• Configured Power BI Gateway for the dashboards and other Ad hoc reporting needs.• Managed security by defining roles and rights.• Good Experience on Power Query, Power pivot and DAX functions.• Responsible for scheduling the subscription reports.• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports. • Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.

• Designed and created complex SSIS packages for performing ETL operations from different source systems.• Extensively used transformations, control flow tasks, containers and event handlers.• Great Expertise in creating and managing Check Points, Package Configurations, Logging, System and User-defined Variables for SSIS Packages• Deployed the SSIS Packages to different environments and created jobs for efficient running of the packages.• Responsible for designing the SSAS cubes, dimensions, fact tables and measures.• Designed, developed Sub-reports, Drill-Down, Drill - Through and Parameterized reports using SSRS from both OLTP and OLAP databases.

• Deputed to client location for SAP implementation.• Requirements gathering and technical documentation.• Proactively giving business solution to client.• Design & develop universe, webi reports and dashboard using BEx queries.• Unit testing.

• Involved in collecting requirements.• Designed, developed and tested universes for supporting ad hoc queries and canned reports according to the business requirements.• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.• Designed, developed Universes and webi Reports.• Involved in Modifying and Performance tuning of the Existing Reports.• Mentor subordinates.• Team building activities.

• Developed ETL jobs like data transformation using Microsoft SQL Server Integration services.• Created SSIS packages, staged data from different data sources into a SQL Server Database using SQL Server Integration Services.• Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications.• Performance Tuning and Maintenance plan for consistency checks, backup/restore and Rebuild Indexes.• Wrote stored procedures using T-SQL and implemented them.

• Experience in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.• Performed daily tasks including backup and restore by using SQL server 2005/2008 tools.• Responsible for implementing different disaster recovery technologies like Replication, Log Shipping• Responsible for job monitoring activities, analyze and evaluate the causes for the job failures.

• Accept, assign incidents and update or reply users with relevant technical solutions/codes within SLA• Creating reports that included database connectivity, universe designing, creating formulas, parameters, formatting, sub reports, charts etc.• Integrating these built reports into applications so that information needed for reports at runtime is hard coded (the logon information, parameters etc.)• Involved in testing different RTM versions of Business Objects XI and Crystal Reports XI. • After the development phase, we assist customers in deployment of application.