- 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.
Languages: T-SQL, PL/SQL, C#, Java, Python
RDBMS: SQL Server, Oracle, MS-Access.
Cloud: Azure/Azure Data Factory/Data Bricks/Azure Synapse
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.
Confidential, Des Moines,
Azure Data Engineer/BI Developer
- 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.
- 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.
- 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.