Azure Data Engineer/BI Developer Resume Des Moines, - Hire IT People

PROFESSIONAL SUMMARY:

5+ years of experience in design, development & analysis of SQL Server and Business Intelligence tools - SSIS, SSRS wif expertise on ETL process.
1+ experience in Azure cloud eco-system
Experience wif Azure Data Factory, Azure Data Bricks, Azure Synapse as we are in teh process of going to Azure Cloud
Expert in SSIS Control Flow Tasks (For loop, for each loop, Execute SQL task) and Data Flow Tasks such using transformation (Conditional Split, Data Conversion, Loop up, Derived Column, Merge, Union all, Merge join).
Experience in creating Logging, Error handling by using Event Handler, and Custom Logging for SSIS packages.
Experience in creating Drill Down and Drill Through, Ad Hoc, Parameterized reports, Sub-reports, Snapshots, designing report layout using SQL SSRS.
Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions and others.
Experience in creating and designing Data warehousing, Data Modeling using both Star Schema Modeling, Snow-Flake Modeling
Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, C#, Java, Python

RDBMS: SQL Server, Oracle, MS-Access.

Cloud: Azure/Azure Data Factory/Data Bricks/Azure Synapse

Web Technologies: HTML, XML, JavaScript

Version Control: TFS

SQL Server Tools: SQL Server Management Studio, Business Intelligence Development Studio, SSIS, SSAS, SSRS

Data Modeling Tool: Erwin, MS Office Visio

Operating System: Windows Server, Linux, Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines,

Azure Data Engineer/BI Developer

Responsibilities

Analyzed existing databases, tables and other objects to prepare to migrate to Azure Synapse.
Compared Snowflake on Azure vs Azure Synapse.
Worked on on-prem Datawarehouse migration to Azure Synapse using polybase and ADF.
Analyzed Azure Data Factory and Azure Data Bricks to build new ETL process in Azure.
Analyzed database tables and denormalized to create Operational Data Store (ODS) to improve query performance.
Created user defined functions and stored procedures to meet teh requirement.
Worked wif developers, DBAs, and systems support personnel in elevating and automating successful code to production.
Created SSIS Packages using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for teh reports and to export data into Excel, csv, and Text file to data warehouse.
Developed SQL Queries and SSIS Packages to fetch data from different tables to databases using joins and deployed them creating jobs for efficient running of teh packages.
Created/Updated Views, Stored Procedure, Triggers, User Defined Functions and Scripts using T-SQL.
Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.

Confidential

SQL/BI Developer

Responsibilities:

Gatheird requirement and designed technical document to implement application.
Work on creating microservices based on java
Designed and developed data model in SQL Server using Visio.
Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Cursors.
Designed high level SSIS architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse.
Created database maintenance planner for teh performance of SQL Server, which covers Database integrity checks and re-indexing.
Deployed teh packages on staging and production.

Confidential, Texas

SQL/BI Developer

Responsibilities:

Experienced working wif agile methodology and provided daily communications, Scrum notes, Sprint Reviews Reports, Project Retrospectives.
Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement teh business logic and created clustered and non-clustered indexes.
Added few columns and tables to Enterprise data warehouse dat were present in a DataMart but were missing in teh EDW.
Rewritten teh stored procedures for teh ETL processes where monthly billing data is sent to teh client.
Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing teh packages in both environments: Development and Production Developed reports against Data Warehouse Schemas like Star Schema and Snow-Flake Schema.
Developed SSRS reports such as Matrix, table, chart using complex SQL queries and stored procedures.
Performed development and maintenance including creating free-form SQL reports specifically for reporting via SSRS.
Provided feedback and technical guidance to Project Managers on issues of critical importance to achieving business objectives.