PROFESSIONAL SUMMARY:

• Senior Data Engineer with more 7 years of experience in the full data delivery pipeline, which includes database design, data collection, ETL processing, data cleansing, report delivery, and data analysis. A highly motivated, well - organized, productive team member with excellent analytical mind, able to quickly acclimatize to the given role and deliver results. Wide working experience in various enterprise domains such as financial, banking, insurance, healthcare and consulting.
• Solid Involvement in Microsoft Commerce Insights (MSBI), ETL Information Stockroom, OLTP & OLAP utilizing SQL Server Integration Administrations (SSIS) and Sky blue Information Manufacturing plant V2 (ADF2), Announcing (SSRS/Power BI), Investigation Administrations (SSAS) and MS SQL Server ( ).
• Broad information and Involvement in managing with Social Database Administration Frameworks counting Normalization, Clustering, T-SQL, Put away Methods, Limitations, Questioning, Joins, Keys, Records, Information Import/Export, Triggers and Cursors and different SQL server objects like patterns, tables, Client Characterized Information Sorts, Lists, Ordered Sees, Capacities, CTE (common table expression), Table Factors and Put away Methods.
• Hands-on experience with Azure Data Factory V2, Data Flows, Azure Data Lake, Azure Synapse, Azure Analysis Services, Snowflake and other cloud tools.
• Created physical information models, made DDL (Information Definition Dialect) scripts and DML (Information Control dialect) scripts to control the SQL Database.
• Good understanding of migration of on-premise SQL Server schemas to the cloud on Azure SQL Server DB and Azure VM and development and maintenance of databases across both on-premise and cloud deployments.
• Mastery in Extricating, Change and Stacking (ETL) utilizing different apparatuses like export/import information and SQL Server Integration administrations. Made, Created, Tried and Sent Bundles into generation servers by making bundle configurations.
• Master in consolidating Information from different complex Information sources, Populating Measurement and Truth tables in Information stockrooms, Cleaning and Standardizing the information stacked into OLTP and OLAP databases utilizing SSIS. Great understanding of Normalization/De-normalization and database plan technique. Encounter in making ETL handle, Information warehousing, Operations Information Store concepts, information marts and OLAP advances, Counting Star and Snowflake schema.
• Capable in creating PBIX records in both Control BI Desktop and Control BI Administrations stages and in uploading them into Report Server and Cloud Administrations with appropriate push level security settings.
• Seasoned in building Tabular models within Power BI Desktop and writing complex DAX queries to create measures and calculated columns.
• Skilled in Analyses Service, particularly in building Tabular models on top of DW/DM/DB, and writing complex DAX and MDX queries against the models.
• Experience in creating Report models for Ad-hoc reports, Drill Down, Drill Through, Parameterized, Cascading, Conditional, Table (List), Matrix (Crosstab), Charts, Sub-Reports, Indicators, Bar Graphs & Line Graphs, Dashboards, Ad-hoc reports using SSRS.
• Expert in Perfor mance Tuning of Complex T-SQL codes, SSIS packages, Power BI/SSRS reports.
• Experience pushing and pulling data from Azure blob. Experience in developing and deploying backend services to Azure clouds.
• Solid understanding in maintenance and administration of SSIS by creating SQL Agent Jobs, Alerts, Mail Notifications, and schedule DTS/SSIS Packages by SQL Agent, Windows Scheduler and others.

TECHNICAL SKILLS:

Advanced: T-SQL codingData analysisDebugging/Troubleshooting

ETL implementation: Data warehousingPerformance tuning

Cloud technologies: Agile methodologyBusiness analysis

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Senior BI Developer

Responsibilities:

• Interacted with business users and team leads for better understanding of business specifications and requirements, identifying data sources and Development strategies.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports
• Excellent knowledge in Azure SQL stack architecture (SQL Server, Synapse and Azure Data factory). Configured Azure platform for data pipelines, ADF, Azure Blob Storage and data lakes. Build workflows to automate data flow using ADF.
• Actively participated in migration of on-premise SQL Server schemas to cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments.
• Worked on various DAX expressions in Power Pivot based on the business requirement.
• Used Power BI to implement a semantic model to simplify the analysis of business data and relationships by loading relevant data from Azure Synapse data warehouse.
• Migrated on-premise SQL server schemas to the cloud on Azure SQL Server and maintained databases across both on-premise and cloud deployments.
• Developed filters, reports, dashboards and also created chart types, visualizations and complex calculations to manipulate the data in Power BI.
• Built efficient ETL packages, using both SSIS and ADF2 pipelines for processing Fact and Dimension tables with complex transforms and SCD type 1/ type 2 changes. Build workflows to automate data flow using Python and ADF2.
• Use the Azure Data Factory pipeline to pull data from various semi-structured data sources, both on-premises and in the cloud. Data captured from a file-based location, including CSV or JSON files.
• Developed many Power BI reports using Power BI Desktop and Power BI Service such as Performance Reports, Profit Reports, Sales Per City / State Report, Score Card Summary, Annual Expenses Report, Cost Comparison Reports and etc.
• Created various types of reports such as sub reports, Tablix and Matrix using SQL Server Reporting Services and created Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created reports on both cascading and standard parameters.
• Designed reports on account information, research reports using ad-hoc reporting to be used by clients and advisors.
• Used Power Query to acquire data, developed calculated columns and measures using DAX in Power BI desktop for designing rich visuals using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map.
• Shared with user groups, scheduled and maintained the Power BI and SSRS reports published to the Report Server and Power BI Service.
• Created complex stored procedures, triggers, functions (UDF), indexes, tables, views and other T-SQL code and SQL joins for SSIS packages and SSRS reports.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created linked, drill through, drill down, cashed, snapshot and sub reports using Report Server Project & Report Model Template in SSRS and was responsible for deploying them.

Confidential, Houston, TX

Senior BI Developer

Responsibilities:

• Attended daily scrum meetings, discussed new requested features/user-stories/tasks with Business Analysts and updated the status of tasks assigned on Agile Platform.
• Built efficient ETL packages, using both SSIS and Azure Data Factory ADF2 pipelines for processing Fact and Dimension tables with complex transforms and SCD type 1/ type 2 changes.
• Created complex stored procedures, triggers, functions (UDF), indexes, tables, views to support the project.
• Created and maintained complex T-SQL queries, Stored Procedures and Views using SQL commands such as Lead, Lag, CTEs, Recursive CTEs, Bulk Insert and Merge.
• Created SQL Server jobs and scheduled them to load data over nightly using SQL server Agent.
• Created reports using Power BI Desktop and deployed to Power BI Service to share with end users via Workspaces and Apps which implemented Row Level Security and User Group management.
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures. Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Designed Power BI reports on account information, research reports using ad-hoc reporting to be used by clients and advisors. Created reports on both cascading and standard parameters.
• Built reports for different domains such as Finance, Accounting, Management, and other client teams.
• Designed, developed, maintained and delivered additional new Power BI Dashboards and Reports with complex DAX query measures/columns, drill down/drill through/hyperlink options, dynamic slicing/dicing features.
• Applied Row-Level-Securities in all Power BI Reports, scheduled and monitored data source refreshes accordingly, and created measures and calculated column into reports using DAX expressions
• Did various performance tuning techniques by using parameterized queries, Indexing, SQL server profiler, query optimization, IO stats, database engine tuning advisor, execution plans etc.
• Staged data from various sources for future use in building warehouse Dims and Facts.

Confidential

SQL Developer

Responsibilities:

• Worked independently and as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Project includes analysis of complex business requirements, creating and modifying complex stored procedures also worked on performance tuning.
• Largely used T-SQL in supporting Finance Team and constructing User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Created complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Created the optimal logics to load the data that business rules were based on flat file names or ragged hierarchy.
• Design, develop, and support complex integration processes (including interfaces) using SQL Server technology, stored procedures and SQL program code.
• Involved in organizing conceptual data model, logical data model, physical data model, data mapping and data normalization.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Did various complex Stored Procedures/execute task, wrote C# hard codes in script task for ETLs, updated/maintained the ETL packages with high performance.
• Created stored procedure using nodes method to load XML file data into SQL server tables. Experienced solving issues raised by QA, UA for database.
• Created interactive, accurate, insightful, and well-organized Power BI reports/dashboards to support businesses in their data driven strategic planning.
• Developed filters, reports, dashboards and also created chart types, visualizations and complex calculations to manipulate the data in Power BI.
• Developed slowly changing dimension SCD-Type 0, 1, 2 in SSIS to update the old data in dimension tables when the new source data is loaded. Also automated the process by deploying the packages into SQL server and creating jobs in SQL Server Agent.
• Worked directly with Solution Analysts and Technical Architects to translate business requirements into conceptual and logical data models.
• Created packages using SSIS to extract the data from different flat files (.txt, .csv, .xlsx) and loaded to tables in SQL Server.
• To Import and Export Data across various files and databases created ETL packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column and etc.
• Participate in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Converted old ETL packages to the new version (did optimization by applying more stored procedures instead of using control flow tasks).
• Used various formatting techniques like interactive sorting, grouping to create user friendly reports.