SUMMARY

• 7+ years of extensive experience in database activities like Data Modeling, Database Design and Development, Coding, Implementation, Maintenance and Performance Monitoring and Tuning
• Experience in Developing Spark applications using Spark - SQL in Azure Synapse Analytics for data extraction, transformation and aggregation from multiple file formats for analyzing & transforming teh data to uncover insights into teh customer usage patterns.
• Experience in Database Design and development wif Confidential Intelligence using SQL Server 2014/2016, Integration Services (SSIS), DTS Packages, SQL Server Analysis Services (SSAS), DAX, OLAP Cubes, Star Schema and Snowflake Schema.
• Proficient in Database Programming and Development using SQL Server and excellent experience in creating T-SQL (DDL, DML), Triggers, Views, User Defined Functions and Complex Stored Procedures.
• Excellent knowledge and skills in developing models, dashboards and building reports using Power BI
• Expertise in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2008 wif Import/Export data, Bulk insert and BCP.
• Experience wif Power BI Dashboards and KPI data for Metrics team and created interactive dashboards of scorecards and productivity metrics.
• Power user of Microsoft SharePoint Server and IIS web server to produce sites for file sharing, web databases and web publishing.
• Strong skills in visualization tools Power BI, Excel - formulas, Pivot Tables, Charts and DAX Commands.
• Continuously updated database structure to adhere to changing regulations and Confidential needs.
• Managed full life cycle Custom Development for several Confidential applications from inception to completion.
• Domain Knowledge of Finance, Logistics and Health insurance.
• In-depth knowledge in Object Oriented Programing Concepts and experience in JAVA and C#.

TECHNICAL SKILLS

• Azure SQL Databases
• Azure Synapse Analytics
• Azure Data Factory
• Azure Data lake
• Power BI
• DAX
• MS SQL Server 2008-2019
• Microsoft Visual Studio
• Microsoft Integration services

PROFESSIONAL EXPERIENCE

Confidential

Azure Data Engineer

Environment: Azure, Data Factory, MS SQL Server 2008-2019, SQL Server Reporting Services, T-SQL, SQL Server Integration Services, MS Excel, Power BI

Responsibilities:

• Analyze, design and build Modern data solutions using Azure PaaS service to support visualization of data. Understand current Production state of application and determine teh impact of new implementation on existing Confidential processes.
• Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure Synapse) and processing teh data in In Azure Databricks.
• Developed SSIS packages using for each loop inControl Flow to process all excel files wifin folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into teh SQL table
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse.
• Complete ad hoc report requests from Confidential stakeholders leveraging necessary BI tools
• Design, develop and support teh SQL Server 2008 R2 data warehouse by creating tables, indexes, views, indexed views, functions, triggers, stored procedures, and tuning complex T-SQL queries
• Author and publish reports in SQL Server 2008 R2 Reporting Services and Power BI services.
• Developed functional and technical documentation to assist in teh design, development and/or maintenance of deliverables
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Interacted wif end users to understand teh Confidential requirements and implemented those in teh interfaces.

Confidential

Data Analyst/SQL developer

Environment: MS SQL Server 2008/2012, SQL Server Reporting Services 2012, SQL Server Integration Services 2008/2012, MS Excel, Oracle 11g.

Responsibilities:

• Built SSIS Packages for smooth running of Interfaces necessary for teh new application.
• Developed procedures, functions and packages to implement teh system’s Confidential logic using TSQL, which supported in-house built WEB applications for HR.
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports
• Deployed database objects and SSIS packages into production.
• Worked wif cleaning of data by analyzing to successfully migrate teh existing data to new database.
• Setup Interfaces to automate and generate reports to User accessible locations on a daily basis.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked wif project manager and technical leads for resolution of technical issues.

Confidential

MS SQL SERVER Developer/MS Confidential Intelligence Developer

Environment: MS SQL Server 2008, SQL Server Reporting Services, T-SQL, SQL Server Integration Services, MS Access, MS Excel, MS share point services

Responsibilities:

• Created Star schema dimension modeling for teh data mart using Visio and created dimension and fact tables based on teh Confidential requirement.
• Gatheird report requirements and determined teh best solution to provide teh results in either a Reporting Services report, Analytical Cube or an Excel pivot table
• Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports.
• Developed SSAS Cubes for building reports using SQL Server Confidential Intelligence Development Studio to support reporting and forecasting processes
• Converted manual reports pasted together into parameter driven stored procedures to be used wif Microsoft Reporting Services 2008
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
• Configured teh report server and generated teh report models for user interactions
• Responded to ad hoc requests and special projects that require immediate attention while at teh same time maintaining deadlines on existing requests.