SUMMARY

• Over 7+ years of experience in the field of Microsoft BI stack, T - SQL, SSIS, SSAS Tabular models, SSRS, Power BI.
• In-depth experience of Transact-SQL (DDL, DML), Normalization and Denormalization techniques on the database tables.
• Expert in Data visualization and Data analyzation using Power BI.
• Good Sort of Experience in configuring and creating SSIS solutions for high-performance Data Integration, Data Migration, and Business Intelligence.
• Experience in data analysis, design, and development of databases for business applications in client/server and data warehouse environments in SQL
• Extensive knowledge of Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
• Strong knowledge of Amazon Cloud Web Services (AWS), S3, Athena, Data Lake and AWS Glue.
• Proficient in designing data sources, data source views, dimensions, defining d Relationships, Creating Hierarchies in SSAS.
• Experience working with a wide range of data sources, such as MySQL, Redshift, Snowflake, and Big Query.
• Experienced in data cleaning and wrangling, data analysis, machine learning, and predictive modelling
• Expertise in Azure cloud data migration from various sources.
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment.
• Worked on Data Lake Analytics (Azure Data bricks) to transform the data as needed to build the tabular model in Azure Analysis Services and automated the refresh of tabular models using Azure Runbooks, Azure automation account and Azure Functions.
• Expertise in Performance tuning, deploying, and processing SSAS cubes.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Worked on Data Factory to load data from Data Lake to Azure SQL Data warehouse.
• Developing ETL packages using SSIS to extract and load from Source into Azure SQL Server.
• Experience in building pipelines, datasets and creating connections, triggers in Azure SQL Data warehouse.
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS
• Good experience in creating multiple kinds of Power BI Reports and Dashboards.
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP and OLAP.
• Experience in designing data sources, data source views, dimensions, user-defined hierarchies, and cubes using SSAS.
• Developed Scorecards/Reports for the system using Crystal Reports, SSRS.
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• In corporate critical thinking skills and judgment in the analysis process to determine the best course of action for each inquiry/problem.

TECHNICAL SKILLS:

• Microsoft SQL Server
• MS Access
• Teradata
• Confidential SQL
• AWS
• SQL Server Azure
• Business Intelligence Visual Studio
• SQL Server Integration Services (SSIS)
• Informatica
• PowerPivot
• SQL Server Reporting Services (SSRS)
• Power BI
• Tableau
• SQL Server Analysis (SSAS)
• OLAP tools
• Power BI
• Azure Data Factory
• Azure Data Bricks
• Azure Data Analytics
• Azure Synapse
• Talend
• Composite
• Tableau
• Adobe Analytics
• Version control system (SVN
• TFS
• GitHub
• DevOps)
• ServiceNow
• SharePoint
• TeamCity
• Octopus
• Tidal
• Jira
• Agile and Waterfall Methodologies

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Business Intelligence Developer

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Modifying the existing measures to improve performance.
• Created Power BI reports using sources like Excel, SQL server, Datawarehouse, Dataflow, SAP, Snowflakes, AWS, Confidential, Synapse, CSV, SharePoint.
• Utilized Python scripts to connect with PowerBI and generate visuals such as graphs, charts, and tables.
• Gather business requirements and build Power BI reports based on the requirements.
• Publishing Power BI Reports from Power BI Desktop to Power BI Service.
• Applied SAS Macros and SQL to generate reports for various departments.
• Use Azure Data bricks to create notebooks in SQL / Python language to fetch parquet files from the azure data lake and create SQL server views as required.
• I did work on setting up Power BI Gateway and maintaining it for On Prem connectivity.
• Developed and maintained reports and dashboard using Snowflake data warehouse, Tableau, and Power BI.
• Developed custom Python scripts to embed into PowerBI to automate data manipulation and analysis
• Experience creating, modifying, and troubleshooting data pipelines and data models within Looker.
• Comprehensive knowledge of SQL and experience using Look ML to develop Looker models.
• Made changes to the existing Power BI Dashboard regularly per Business requests. Transformed and combined the data using Query Editor in the Power BI and Published Power BI Desktop reports created in Report view to the Power BI Service.
• Good hands in creating multiple kinds of Power BI Reports, Dashboards, and Visualizations.
• Experienced in using the R statistical language for data analysis and visualization.
• Experienced in using Hadoop and Apache Spark for large scale data analysis
• Developed custom Python scripts to build complex queries and data transformations
• Maintained Snowflake warehouse configurations and parameters.
• Experience creating and maintaining dashboards, exploring data, and creating reports in Looker.
• Utilized Power BI (Power View) to create analytical dashboards that depict critical KPIs such as legal case matters, billing hours, and case proceedings, along with slicers and dicers enabling end-user to make filters.
• Built custom components to visualize tabular, graphical, and chart-based data using ReactJS.
• Created SSIS packages to load the Data from the different source systems and load them into SQL Server tables.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Works closely with BI Analysts to understand customer needs, analyze business and functional requirements, and translate these requirements into robust, scalable, operable solutions.
• Developed and implemented data models and data warehouses using Snowflake.
• Maintained and improved existing ReactJS components, ensuring scalability and performance.
• Troubleshooting reports issues, ETL job failures, and optimizing query performances.
• Lift and shift existing SSIS packages into Azure Data factory and schedule to run using the IR in the Azure services.
• Using Copy activity in the Azure Data Factory to load the data into the SQL Server tables from different source systems.
• Developed and maintained data migration processes using SharePoint and AWS, streamlining the data migration process.
• Wrote DAX Expressions, Power Query, Functions in Power BI.
• Created Multiple Azure Logic apps to do API Calls and load the responses into the Azure data lake store and use Azure data factory to parse the XML or JSON to load the cleansed data into SQL server tables.
• Use Azure Data Lake analytics to run USQL scripts and schedule them to run using the Azure Data factory.
• Use Azure Data bricks to run python scripts to parse the data from XML files and load the transformed file into ADLS.
• Conducted database management, performance measurement, and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.
• Deployed reports and created report schedules and subscriptions. Managing and securing reports using SSRS.
• Experience with creating SSAS in creating cubes, data source views, named queries, dimensions, and deploying analysis services projects.

SQL BI ENGINEER

Responsibilities:

• Performed Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Confidential, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge, and union all.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.
• Worked on ETL(DataStage) jobs from Source to Target with VBA and SQL programming.
• Experienced working in cloud-based data warehousing, ADF, Spark, Google cloud and AWS.
• Experienced in creating and automating the SSAS cube partitions using PowerShell scripting.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
• Migrated existing self-service reports and Ad hoc reports to Power BI.
• Involved in creating Named Queries in Data Source View, creating new Dimensions, Modifying Dimensions to add new Hierarchies, and other stuff in SSAS.
• Experience in deploying SQL Databases in AZURE.
• Design and Develop ETL SSIS packages for loading data from Azure data warehouse to SQL Server data mart.
• Used various sources to pull data into Power BI such as SQL Server, Confidential, SQL Azure etc.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Wrote MDX queries and expressions for use in Front End BI Applications and created SSRS reports.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in SSRS.
• Involved in Installation, Configuration and Deployment of Reports using SSRS.
• Experience in migrating on premises Tableau server to cloud (AWS).
• Generated reports using the Reporting Services analyzed using Server analysis (SSAS).
• Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Expertise in Power BI Pro, Power BI Service, and Power BI Mobile.
• Efficient in in corporation of various data sources such as Confidential, MS SQL Server, and DB2, Sybase, XML and Flat files into the staging area.

Confidential

SQL Server/BI Analyst

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, involved in Design, Development, and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes).
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications.
• Connected to the AWS Redshift and Snowflake directly from Tableau to access cloud data warehouse and quickly perform visual analysis
• 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 SSIS packages to automate the ETL process included meta data on record count, file size and run time.
• Wrote and edited SQL Queries for database testing and report verification.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server 2008r2/2012
• Analysis Services (SSAS).
• Knowledge in creating KPI’s, Perspectives, Partitions using SSAS.
• Created Power view reports using the Tabular SSAS models in Excel.
• Developed SQL Server reports (SSRS) on daily performance of databases using SQL Server Reporting Services.
• Worked on client requirements and wrote Complex SQL Queries to generate Reports.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Tuned and Optimized SQL Queries using Execution Plan and SQL Profiler.
• Environment: Windows Server, SQL Server 2010, SSIS, SSRS-2008, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler, MS Excel.

Confidential

BI Engineer

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, involved in Design, Development, and testing of the system.
• Developed Up-selling and Cross-selling reports using DAX functions.
• Migrated Crystal Reports to Power BI from Scratch.
• Creating Row level security with power bi and integration with the power bi service portal.
• Debugged T-SQL queries for performance tuning. Ensured the ETL process was completed within the deadline and investigated various stages and reasons for delays.
• Implemented the core business process using T-SQL, Stored Procedures, and Functions
• Scheduled the SSIS packages to run as jobs periodically according to the requirement using SQL Server Agent
• Designed the ETL process based on the schemas (snowflake and star schema) for extraction and transformation of data from the source database and loading onto the target database
• Developed profit analysis reports and dashboards by products and customers.
• Experienced in AWS, GITHUB, Python (airflow and glue).
• Worked on all types of transformations available in the Power bi query editor.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Extensively developed SSAS Cubes, Partitions, Aggregations, KPIs, and Browser perspectives. Expert in creating Star schema cubes using SSAS
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage explorer.
• Created and Managed OLAP Cubes using SSAS.
• Developed custom-calculated measures using DAX in Power BI to satisfy business requirements.
• Developed analysis reports and visualization using DAX functions like table, aggregation, and iteration functions.
• Created reports using time intelligence calculations and functions.
• Imported Data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Worked on all kinds of reports, such as Yearly, Quarterly, Monthly, and Daily.
• Executed dashboard setups and data manipulation using DAX.