Database Developer Resume
2.00/5 (Submit Your Rating)
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