SUMMARY

• 5+ years of experience in design, development & analysis of SQL Server and Business Intelligence tools - SSIS, SSRS with expertise on ETL process.
• 1+ experience in Azure cloud eco-system
• Experience with Azure Data Factory, Azure Data Bricks, Azure Synapse as we are in the 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, Iowa

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 the requirement.
• Worked with 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 the 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 the 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:

• Gathered 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 the source server to the Enterprise Services Warehouse.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Deployed the packages on staging and production.

Confidential

SQL/BI Developer

Responsibilities:

• Experienced working with 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 the business logic and created clustered and non-clustered indexes.
• Added few columns and tables to Enterprise data warehouse that were present in a DataMart but were missing in the EDW.
• Rewritten the stored procedures for the ETL processes where monthly billing data is sent to the client.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the 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.