PROFESSIONAL SUMMARY:

• 5+ years of progressive work experience as an IT professional with a wide range of experience in Database Development and BI Development
• In depth knowledge of Software Development Life Cycle (SDLC), database design and Normalizations
• Proficient at T - SQL programming (DDL, DML, and DCL)
• Skill in creating SQL Server database objects such as tables, stored procedures, joins, triggers, indexes, user-defined functions, views, and cursors
• Experience in the Extracting, Transforming and Loading (ETL) of data using SQL Server Integration Services (SSIS)
• Experience in designing SSIS packages for different Data Flow and Control Flow processes
• Experience in developing Business Intelligence (BI) solutions for Decision Support Systems (DSS) using SSRS and Tableau
• Experience in the design and implementation of Normalization and De-Normalization techniques for both OLTP and OLAP systems
• Strong knowledge of Relational and Multidimensional Modeling concept
• Design and develop data visualizations, graphical dashboards and reports using Tableau desktop
• Maintain connection between Tableau Desktop and data sources such as Excel, Flat file, RDBMS and Azure using data blending/join table
• Experience in Scheduling Incremental Refresh for periodic dashboard reports on Tableau Server
• Experience in moving data from various sources to data lake and Azure SQL Databases using Azure Data Factory (ADF)
• Experience in the proper documentation of records
• Excellent communication skill, self-motivated, quick learner, determined to learn new technologies and strong team player with excellent interpersonal skills.

SKILL:

Query Languages: PL/SQL, T-SQL

Web Technologies: HTML, CSS

Cloud Technologies: Microsoft Azure

Programming Languages: C#, ASP. NET

RDBMS: SQL Server 2012/2014/2017

Tools: and Utilities: SQL Server Management Studio, Microsoft Office Suite, Visual Studio, Notepad

BI tools: MS BI, Power BI, Tableau Desktop

Data modeling tools: Vertabelo, Erwin

Source Control: TFS, Git

PROFESSIONAL EXPERIENCE:

Database Developer

Confidential

Responsibilities:

• Perform Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost
• Assist on Developing physical model using Vertabelo and implementing them to SQL server
• Create and Modify existing Stored Procedure and View using SSMS depending on Business requirements
• Develop complex SQL queries involving Join, Subqueries, CTE and Cursors
• Create pipelines to load Data from Blob to SQL Database on Azure
• Migrate jobs on premise to Microsoft Azure using Azure Data Factory (ADF)
• Use Azure Data Factory (ADF) mapping data flow to transform data against on-prem SQL Server only against data that has changed using the delta data loading pattern
• Modify already existing SSRS reports according to Business User’s request
• Use various transformations in the ETL packages while transferring the data from different sources to destination using SSIS
• Create logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS
• Ensure proper implementation of Event Handlers, Loggings, Checkpoints, Transactions, and package configurations
• Schedule SQL Server jobs to load data periodically using SQL Server Agent

BI Developer

Confidential, Bethesda, MD

Responsibilities:

• Analyze business requirements and attending periodic meetings for changes in requirements and documents
• Create and test dashboards and ensure it meets the business requirements
• Create database objects like tables, views, indexes and triggers in MS SQL Server that support relational and dimensional database models
• Develop script for data manipulation and ensuring data integrity
• Develop complex SQL queries, and perform optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor
• Involve in requirement gathering, logical and physical data modeling using Lucid Chart
• Develop fact and dimension tables, configuring ETL work flows to populate fact and dimension tables, and develop Cubes and reports for analysis
• Develop and automate SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources like Flat file, MS Excel, CSV, MS Access to SQL Server
• Create calculated fields and parameters along with appropriate filters and plotted measures on respective graphs with base data
• Connect tables from a single data source using Join
• Develop several Visualizations using Scatter plots, Gantts, symbol maps, Histograms, Dual-axes, Heat maps, Text Tables and Highlight Tables graphs

ETL developer

Confidential, Deerfield, IL

Responsibilities:

• Performed data extraction to and from various sources like SQL Server, Oracle, MySQL, MS excel and CSV from Client servers
• Created Stored Procedures, User Defined Functions, indexes, Views, Tables, Constraints, Triggers and writing complex queries using Joins, Aggregate Functions, Sub-queries, Derived tables and CTE
• Analyzed the Sources, Targets, Transforming the data, and Mapping the data and loaded the data into Targets using SSIS
• Created SSIS (ETL) packages involving Control Flow, Containers, Data Flow Tasks and Email alerts
• Worked on SSIS logging, Error Handling and Package configurations
• Created Data-driven Packages in SSIS as part of automating processes including variety of transformations
• Load data into dimensions and fact tables using slowly changing dimension using SSIS package
• Involved in performing Audits and recovery operations of SSAS objects
• Created Parameter, Cascading, Drill-down, Drill-through, Sub-Reports, gauge and Matrix reports using MS SSRS

BI Developer

Confidential

Responsibilities:

• Ensured project requirements and delivery with active interactions with end users
• Planned and designed data collection and survey tools and perform data analysis
• Created and tuned database objects such as tables, stored procedures, triggers, views, indexes and joins in MS SQL server to support relational and dimensional databases
• Created ad-hoc reports and complex enterprise reports such as drilldown, drill through, parameterized and cascading reports using SQL Server Reporting Services
• Designed and created report templates, plots, bar graphs and pie charts; and scheduled periodical reports to run automatically
• Extracted, interpreted, and analyzed data to transform raw data into meaningful and actionable information
• Leveraged SQL Queries to analyze large volume of data and wrote T-SQL scripts to manipulate data for ETL purpose
• Developed Interactive Dashboards using Tableau Desktop presented to applicable internal stakeholders
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the change of data accurately
• Applied different types of objects like Sets, Groups, Parameters, Filter, Advanced Calculated Fields and Filtering for developing visualizations