We provide IT Staff Augmentation Services!

Database Developer Resume

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

Hire Now