SUMMARY:

• SQL, T - SQL, Data Warehousing (DW), SSRS, ETL, SSIS, SSRS, Business Intelligence (BI), DAX Studio
• Azure ADF, Azure Bricks, Azure Data Lake, Azure Blob storage, Azure Synapse, Azure stream Analytics ( using IoT device/IoT hub/, Azure Active Directory & Access Management, Azure Logic App, Azure data studio, power BI, DOMO, Athena AWS, Snowflakes, slack, okta
• Basic knowledge on scrum board Jira, Confluence, smart sheet, ECM, excel, word, AIMS (advanced Insurance management software)
• Conducting research, gathering and analyzing the structure, data modeling, evaluate and suggest methods to improve practices and processes to make more effective business decisions & identifies new opportunities for business to capitalize on technology
• On power BI perform configuring gateway, schedule & refresh, power Automate, refresh data, Share, subscribe, export on PPT, PDF,PBX etc

TECHNICAL SKILLS:

SQL Server Tools: SSIS, SSRS, SSAS, SQL Server Management Studio, SQL Server Business Intelligence StudioAzure, Azure data Factory (ADF), Azure data studio (ADS), Knowledge and good understanding of Azure Synapse and Azure Data Explorer

Reporting Tools: Power BI, SSRS (SQL Server Reporting Services), Tableau, DOMO, Tableau

ETL Tools: SSIS (SQL Server Integration Services)

Operating System: Windows 10, 8.1/ 8/7/Vista/XP/ NT/2000, DOS, Windows Server 2003/2007, T-SQL, MS SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Visual Studio 2016, OLAP.

WORK EXPERIENCE:

Data Analyst

Confidential

Responsibilities:

• Developing ETL/ ELT operation. Extract, Load and Transform data from AWS Athena and snowflakes.
• On Bases of departments business requirement, write frequent snowflakes queries and pull the query results.
• Perform data cleaning, modeling, and transformation on snowflake and Excel. design graphic reporting and data Visualization on BI tool, DOMO
• Communicate the results on project management software, Confluence and Jira

MSBI Analyst

Confidential

Responsibilities:

• Developing, maintaining new, and existing MSBI solution (On premises and cloud) using ADF (Azure data Factory) such as transformation and data movement (Migrating and converting the source data from different sources to Azure storage i.e., blob storage, file, table queen, Azure Lake and Azure bricks etc.
• Experienced knowledge in Azure portal architecture and its cloud components and storage accounts (Blob storage, Azure data lake, ADF data factory, Azure data explorer, Azure database...), configuring ADF, linked service, data sets, data flow, pipeline, copying, monitor, Trigger, storage, validation, Debagging, data flow transformation I.e. (lookup, conditional split, Derived column, delete, Aggregate, surrogate key, Parameterization, Azure query, etc.
• Experience on Azure data studio, Azure data explorer, and do query.
• Experience on creation of Azure subscription, Azure active directory, security, Access control (IAM), key vault, Logic App
• Get data from different sources and convert those raw data into meaningful insights through interactive and easy-to-understand dashboards and reports.
• Building Analysis Services reporting models, Developing visual reports, dashboards and KPI scorecards
• Connecting to data sources, importing data and transforming data for Business Intelligence. translating data into informative visuals and reports, responsible for design methodology and project documentation and design methodology and project documentation
• Able to implement row level security.
• Responsible for design methodology and project documentation. develop tabular and multidimensional models that are compatible with warehouse standards.
• Developing, publishing and scheduling Power BI reports as per the business requirements. understand the business requirements and develop data models accordingly by taking care of the resources.
• Crafting and executing queries upon request for data and import to power BI query.
• Experience in Workspace, Reports, Gateway, Apps Create and manage reports in Microsoft Power BI experience in writing DAX formulae, data formatting on Power BI
• Define data model, data cleaning, transformation, merge, split, custom, calculated column, append, KPI, Filter, hierarchies and drill-down, row level security, install gateway, and create Dashboards, customize visualization.

Confidential, San Ramon, CA

MSBI Analyst SQL BI Developer/Admin

Responsibilities:

• Access control and security, grant access, deny & monitor SQL server activity
• Import and Export data to SQL server.
• Developing and Designing database tables and structures, constraints, etc.
• Creating views, functions and stored procedures, view, temporary table
• Writing optimized SQL queries for integration with other applications.
• Creating database triggers for use in automation.
• Maintaining data quality and overseeing database security.
• Create an ETL design/Framework and implementation checks in SSIS packages and Perform ETL, extract, transform and load data operation.
• Conducting preliminary testing of the warehousing environment before data is extracted.
• Design and develop the complex ETL packages using Full/Incremental Load strategy.
• Troubleshoot issues related to package debugging, performance, configuration and migration.
• Create Triggers, Indexes, Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to databases.
• Set up database maintenance plans, back-up & recovery strategies, and procedures.
• Managed database backup and disaster recovery and Restore database from backup and implemented Point-In-Time Recovery solutions.
• Write standard T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Created New Reports by using SSRS & created SSRS Reports.
• Migrated Multiple SQL Servers and databases from (On-Premises) and SQL Database servers to Azure Cloud Created Tabular Models using DAX queries in analysis services and deployed it.
• Develop and maintain multiple Power BI dashboards/reports and content packs to share Power BI objects, such as reports, datasets, or dashboards with individuals within your organization. on the Power BI website
• Responsible for building Power BI Dashboards using Tabular and Multidimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Create data integration and Analytics, Azure Data Lake Storage, Azure Data Factory, Azure SQL databases and Azure SQL Data Warehouse for providing analytics and reports for improving marketing strategies.
• Create monthly, weekly and daily reporting dashboards on marketing-generated leads. Make recommendations to adjust tactics for future campaigns to meet lead and pipeline development goals.
• Establish and report on KPIs across all online and offline marketing channels.
• Imported data into Azure Analysis Server from Data Lake and SQL DB for data modeling purposes and to generate reports using Power BI.
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.

Confidential, Houston, TX

MSBI Analyst ETL developer

Responsibilities:

• Do all SQL developer tasks, such as designing, developing and maintaining SQL databases as well as designing applications that interface with SQL databases. They are also often responsible for analyzing a company or organization’s data management and input needs and help design systems that organize, store and access that data for them. Also creating, developing and maintaining SQL databases to ensure its performance and stability. This includes creating database tables, structures, schemas, insert, delete, update, data, create stored procedure, view, function, index, join, group by, where clause, order by, Sum, Aggregate, Min, Max, Average, Trigger, etc.
• Extract, transform, load (ETL) developers are responsible for extracting and copying business data and loading it into a data warehousing environment that they have designed.
• Designed and implemented BI Strategy for new Reporting Environment.
• Designed SSIS Packages to extract, transform, load (ETL) existing data into SQL Server from different environments.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Involved in troubleshooting of performance issues which were associated with Tableau reports.
• Used Microsoft Power BI to create interactive reports and Dashboards.
• Perform Data visualization and Data analyzation using Power BI.
• Installed On premise data gateway and scheduled daily data refresh in Power BI.
• Developed dashboard reports using Reporting Services, Report Model using Report Builder.
• Created/modified SQL Joins, subqueries, and other T-SQL implement business rules.

Confidential

MSBI Analyst SQL developer

Responsibilities:

• Implement database triggers, functions, stored procedures, and packages.
• Create new stored procedures and analyze and modify existing stored procedures.
• Produce effective database development including design, stored procedures, triggers, and functions.
• Develop custom database objects, stored procedures, functions with T-SQL
• Extract, transform, load (ETL) developers are responsible for extracting and copying business data and loading it into a data warehousing environment that they have designed.
• Created Database Objects- Tables, Indexes, Views, User defined functions, Triggers, Stored Procedures, Constraints and Roles.
• Write T-SQL scripts to generate object definition to sync databases.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP database to staging area finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column lookup that were used for Data Scrubbing, data validation checks during staging, before loading the data into the Data Warehouse.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Data Flow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Data warehouses can also use real-time data feeds for reports that use the most current, integrated information.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in SSRS and deploying SSRS reports. report creation skills using Microsoft Reporting Services (SSRS).
• Create and edit alerts on Reports, as per User request.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.

Branch Manager Business Intelligence Analyst

Confidential

Responsibilities:

• UW, handle claims, prepare budgets and set business targets.
• Set marketing strategy and expand sales.
• Designing, developing, and maintaining SQL databases and Creating database tables, structures, schemas and dictionaries
• Creating database tables, structures, schemas and dictionaries and Ensuring database performance and stability creating database tables, structures, schemas, insert, delete, update, data, create stored procedure, view, function, index, join, group by, where clause, order by, Sum, Aggregate, Min, Max, Average, Trigger, etc.
• Data entry, cost benefit analysis and compile summary report
• Analyse cost.