LiveCareer-Resume

sql data warehouse developer resume example with 8+ years of experience

Jessica Claire
  • , , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
  • :
Summary

7+ years of experience in database design and development SQL Server 2016/2014/2012/2008R2 large-scale databases. Strong experience in using Microsoft SQL Server Management Studio (SSMS), SQL Server Integration Service (SSIS), and SQL Server Reporting Service (SSRS). Technical expert with design and hands-on programming on diverse technology platforms including RDBMS, ETL (Extract, Transform, and Load) engines, BI Dashboards, and KPI Scorecards. Experience in Logical modeling using Dimensional Modeling techniques such as Star schema and Snowflake schema. Experienced working in an Agile environment with SCRUM development framework. Complete understanding of Software Development Life Cycle (SDLC) including requirement analysis, requirement gathering, design, development, imp implementation, testing, and deployment experience. IT professional with extensive work experience in developing BI/EDW Applications using Microsoft SQL Server versions 2014-2019. Experience in Designing, implementing, and maintaining Database Schema, Entity relationship diagrams, Data modeling, Constraints, Rules, Defaults, and complex T-SQL statements. Expertise in creating Tables, Views, Indexes, SQL Joins, complex Stored Procedures, User-defined Functions (UDF), and Common Table Expressions (CTEs) providing efficient data retrieval and Triggers to facilitate efficient data manipulation to maintain data consistency. Experience in Table Normalization, Query Optimization, and Performance Tuning using SQL Profiler and estimated Query plans. Integration and Migration of unstructured data from various types of sources (Excel, XML, Flat file/CSV, OLE DB, JSON) in SSIS. Good experience in creating complex SSIS ETL packages using various tasks and transformations in Control flow and Data flow. Implemented Various Error handling and Event Handling Techniques to ensure efficient package execution. Proficient in developing Dashboards including Drill through and Drill down reports using Expressions and Functions, Parameterized reports, Sub reports, Ad hoc reports, Table and Matrix reports, Interactive reports, and various Chart reports using SSRS. Deployed and configured the reports in the Report Server. Experience with Report Server and Report Manager. Experience in Microsoft Power BI Desktop to gather information from multiple sources (SQL Server, Azure SQL Database, Excel, CSV, JSON) and deliver information to the end user. Experience in building statistical KPI reporting dashboards with predictive analysis. Experienced in standard SDLC Methodology Agile/Scrum and Waterfall

Skills
  • Training & Development
  • Azure SQL
  • SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS). DBMS/RDBMS. MS-SQL Server. ORACLE. IBM DB2. T-SQL. PL/SQL. MS Access
  • Office Tools: MS Word, Excel, PowerPoint, Visio, OneNote, Microsoft Project, SharePoint portal server, Active Directory (AD)
  • METHODOLOGY: Agile, Waterfall
  • ETL: SQL Server Integration Services (SSIS). Reporting Service (SSRS)
  • Data Warehouse: Star Schema, Snowflake Schema
  • Business Intelligence: SSIS, SSAS, Power BI, SSRS, Report Manager, Report Builder Data Modeling: Microsoft Visual Studio
  • Planning & Organizing
  • Flexible Schedule
  • Critical Thinking
  • Requirements Gathering
  • Analysis and Modeling
  • Agile Methodologies
Experience
SQL / Data Warehouse Developer, 12/2021 to 11/2022
Apex SystemsSunnyvale, CA,
  • Design and develop complex ETL packages using SSIS according to the needs and requirements of the client
  • Maintained SSIS packages for production and test environment for incoming source application files
  • Deployment of SSIS packages and SQL entities in various environments through GitHub
  • Engaged in offering production support related to SSIS, SQL, and trivial Insurance Billing related issues
  • Resolving and closing all assigned Incidents on time to avoid SLA breaches
  • Troubleshoot issues related to packaging debugging, performance, and configuration
  • SQL Query Optimization and Performance Tuning, Optimizing Stored Procedures and long-running queries using indexing strategies and query-optimization techniques
  • Understand the functional side of Business requirements
  • Work with the offshore team to accomplish the development tasks if required
  • Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting
  • Experienced in creating complex SSIS packages using proper control and data flow elements with error handling
  • Provided a wide range of value-added services, including implementation and training, operational management services, health care data analysis, transaction processing, employer health centers, and third-party administrator services for employer-based health plans
  • Designed and developed SSIS packages to move data from various sources into destination flat files and databases
  • Troubleshoot previous SSIS packages to solve issues performance tuning existing scripts and processes
  • Coordinate with the QA team for testing support and get the deliverables completed on time
  • Knowledge management and sharing with the new teams on board
  • Create, troubleshoot, manage, and deploy SSRS reports
  • Create Subscriptions for customers as required
  • Designed the Entity Relationship (ER) models and logical data (LDM), and physical data (PDM) models based on the design documents
  • Extensively worked on the full Software Development Life Cycle (SDLC) of the project from Database Design and Modeling to implementation and maintenance
SQL/SSIS/ETL/ Data Warehouse Developer, 06/2018 to 12/2021
Ihs MarkitUs Remote, MN,
  • Created SSIS packages using various control flow and dataflow tasks to extract the data from multiple sources like Excel, XML, JSON, and OLTP and consolidate them into staging tables
  • Maintained SSIS packages for production and test environment for incoming source application files
  • Debugged systems and fixed program malfunctions quickly
  • Designed, Implemented, and maintained Database Schema, ER diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas
  • Implemented different Slowly Changing Dimension methodologies and Merge Statements to maintain and update data corresponding to Dimension tables in the Data warehouse
  • Generated reports, maintained dimensional as well as relational data structures and managed operational data store and data warehouse
  • Monitored SSIS package validation, error handling, optimization, and deployment
  • Scheduling Jobs and Alerting using SQL Server Agent
  • Worked on Multidimensional Modelling Development using SSDT
  • Gather requirements from business stakeholders to inform the design of database solutions
  • Develop and maintain T-SQL stored procedures
  • Performance-tune problem queries and aid analysts in optimization through techniques such as reading execution plans, adding indexes, and re-architecting poorly designed queries
  • Work directly with data analysts to assess their needs and build Data Warehousing models to service those users
  • Deliver data products using agile workflow methodologies
  • Documented data warehouse architecture to guarantee capacity met current and forecasted needs
  • Prepared functional and technical documentation data for warehouses
  • Designed, implemented, and maintained Database Schemas, Entity relationship diagrams, Data modeling, Tables, Store procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, and complex SQL statements
  • SQL Query Optimization and Performance Tuning, Optimizing Stored Procedures and long-running queries using indexing strategies and query-optimization techniques
  • Create parameterized reports, drill down, and drill through reports using SSRS
  • Held accountable for creating dashboards, Tabular, Matrix reports (crosstab or pivot), Charts, and graphs as per customer requirements using SSRS
  • Troubleshoot data integrity issues, T-SQL code defects, SSIS, and SSRS errors of varying complexity and address them as required
  • Partner with Business Analysts and Developers on an assigned line of a business project in the requirements definition and documentation of new customer reports/dashboards and oversee the maintenance and development of existing reports
  • Served as a collaborative team member within both project management and software development life cycles (SDLC) including analysis of business functions, design, development, testing, and documentation as required by end-users.
SQL/SSIS Developer, 10/2014 to 12/2017
Commercial Bank Of Ethiopia GondarCity, STATE,
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes, and Views using T-SQL in Development and Production environment for SQL Server 2000 Actively participated in a gathering of Requirements and System specifications
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins and database links and formatted the results into reports and kept logs Worked on complex T-SQL statements and implemented various codes and functions
  • Installed, authored, and managed reports using SQL Server 2005 Reporting Services Wrote Transact SQL utilities to generate table insert and update statements
  • Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions
  • Implemented new T-SQL features added in SQL Server 2005 that are Error handling through TRY-CATCH statement, Common Table Expression (CTE) Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data
  • Environment: SQL Server, T-SQL, .Net, Extensively involved in Gathering requirements by holding meetings with users
  • Constructed context diagrams and data-flow diagrams based on a description of a business process
  • Analyzing the data model and identification of heterogeneous data sources
  • Constructed an extended entity-relationship diagram based on a narrative description of a business scenario
  • Created Transformations using the SQL script to modify the data before loading it into tables
  • Migrated SQL Server 2005 databases into SQL Server 2008
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
SQL Developer, 09/2013 to 10/2014
Ethiopian Revenue & Customs AuthorityCity, STATE,
  • Revenue and Customs Authority Addis Abeba, Ethiopia
  • Used T-SQL to develop DDL, DML, and dynamic SQL daily
  • Used SSDT to develop SSIS packages
  • Maintaining code version in the repository with TFS/VSTS, TORTOISE SVN, and GIT
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with the incremental load
  • Performed T-SQL, SSIS (SSDT) Package, and Workflows performance tuning and optimization of queries for reports that take longer execution time
  • Designed complex database and data warehouse system architecture and create schemas
  • Designed components and perform complex coding/programming, debugging, and testing within a data warehouse system and documents data warehouse system
  • Reviewed data extraction, loading, cleansing, and data modeling for data warehouses
  • Developed, deployed, and monitored SSIS Packages
  • Defined unit testing and system integration best practices
  • Enhancing, developing, and deploying SSIS packages across different environments
  • Experience in agile software development paradigm (e.g., Scrum, Kanban)
  • Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard, and SQL Query Analyzer in MS SQL
  • Extracted data from heterogeneous sources (OLTP, Flat Files, Microsoft Excel) and transferred to OLAP using SQL Server Integration Services (SSIS)
  • Used SSDT to develop SSIS packages
  • Identified the data sources and created sources to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS)
  • Maintaining code version in the repository with TFS/VSTS
  • Used various transformations in the ETL packages while transferring the data from the OLTP source to the destination using SSIS 2008/2016
  • Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the data flow from one stage to other
  • Involved with the full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance
  • Deployed and managed the reports in the Report Manager using SSRS 2012
  • Wrote complex stored procedures, and views using TSQL in Management Studio.
Education and Training
Data Analytics Certification: , Expected in 07/2021 to Colaberry School of Data Analytics & Data Science - ,
GPA:
Bachelor of Art: Economics, Expected in 07/2013 to University of Gondar - Gondar,Ethiopia,
GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Colaberry School of Data Analytics & Data Science
  • University of Gondar

Job Titles Held:

  • SQL / Data Warehouse Developer
  • SQL/SSIS/ETL/ Data Warehouse Developer
  • SQL/SSIS Developer
  • SQL Developer

Degrees

  • Data Analytics Certification
  • Bachelor of Art

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: