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 the data to uncover insights into the 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 noledge 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 noledge 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 the 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 the 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 the 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 the 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 the 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 the Confidential requirements and implemented those in the 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 the new application.
• Developed procedures, functions and packages to implement the 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 the 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 the data mart using Visio and created dimension and fact tables based on the Confidential requirement.
• Gatheird report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table
• Produced operational reports in SSRS 2008 me.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 the report server and generated the report models for user interactions
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.