Experience

Debian Systems Inc

• India
• IT Services and IT Consulting
• 1 - 100 Employee

• SQL BI / Power BI Developer

  • May 2020 - Present

  • Reviewed and analyzed the business environment and identified process improvements.• Participating in defining ETL strategies, preparing transformation rules and mapping data from source to target• Developed ETL process using SSIS to load data from various sources to Data warehouse and from Data warehouse to Data marts. • Deployed, automated, maintained and supported the SSIS packages. • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded into the audit table.• Created checkpoints and configuration files in SSIS packages.• Experienced in handling slowly changing dimensions in SSIS packages.• Experience in creating Pipelines in Azure Data Factory for ETL process.• Experience in developing Power BI reports by extracting data from Azure SQL Server.• Provide analytical, complex, and specialized client service analysis using Power BI dashboards.• Set up and maintained workspaces, user access on Power BI Services.• Used Power Automate to automate the Power BI Data set refresh and created flow to run the Power BI report and export data with 1 million rows to Excel / CSV. • Developed Data Flows and Shared Datasets and Paginated reports for the Power BI Dashboards. • Developed Data models for Data marts and Power BI Data source.• Developed reports using SSRS and deployed reports to Report manager. Created and managed folder structure and security on Report Manger. Created and maintained subscriptions on Report manager.• Extensively used Execution Plan, Query analyzer, and SQL Server profiler to fine tune complex stored procedures and SQL queries.• Have used Tableau Desktop to build various dashboards to track internal process. Show less

• SQL Server BI Developer

  • Feb 2017 - Apr 2020

  • Gathered requirements for reporting, Data flow (ETL) and prepared BRD and TRD.• Reviewed and analyzed the business environment and identified process improvements.• Developed SSIS package for ETL process. • Defined mapping and spec files and data flow structure for SSIS packages. • Developed, Deployed, and scheduled SSIS packages. • SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.• Experience in working with complex Datasets and connectors to pull the data for reports in Power BI• Experience in extracting data from Azure Dev Ops and Azure SQL Server for Power BI reporting. • Developed complex Power BI dashboard reports and published reports to Power BI service.• Working experience with multiple interactive visualizations in Power BI• Provide analytical, complex, and specialized client service analysis using Power BI dashboards.• Experience in developing and supporting Microsoft BI and reporting capabilities (PowerPivot, Power BI, PowerView, SQL Server Reporting Services) Experience implementing enterprise software solutions.• Developed various Table and Tablix reports with drill down, drill through and cascading parameter.functionalities using SSRS.• Deployed reports to Report manager. Created and managed folder structure and security on Report Manger.• Created and maintained subsections on Report manager.• Generated ad-hoc reports using MS Reporting services and Crystal reports.• Created and used stored procedures for database transactions in SQL Server.• Extensively used Execution Plan, Query analyzer, and SQL Server profiler to fine tune complex stored procedures and SQL queries.• Have used Tableau Desktop to build various dashboards to track internal process. Show less



Infosys

• India
• IT System Custom Software Development
• 1 - 100 Employee

• Report Developer

  • Jul 2016 - Dec 2016

  • Excellent report creation skills using Microsoft Reporting Services (SSRS). • Worked with business/functional analysts to determine reports and analytical requirements. • Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc. • Developed Use Case Documents and Technical Documentation for some reports to Hand-off to the Offshore Development Team. • Categorized reports into batch reports and on demand reports and scheduled it according to that. • Configured and maintained Report Manager and Report Server for SSRS. • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS. • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access, and CSV files to data warehouse. • Worked in Agile environment. • Developed complex queries, stored procedures, views, and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments. • Developed visualizations and Dashboards using Tableau. • Publish dashboards to Tableau Server, support, and manager user access. Show less