SQL/ETL Developer

Full Legal Name: Dikshya Neupane

Current Location: Cary, North Carolina 27511

Email ID: ad1492@r.postjobfree.com

Contact no.: 984-***-****

SUMMARY

Strong professional experience of 5+ years as SQL/SSIS Developer that includes Database Design and Development, ETL Development, Data warehouse Implementation, Report Development using SSAS, SSIS, SSRS and T-SQL.

●Strong Customer Centric Approach, with Process Orientation; Motivated by internal standards of performance to deliver quality results.

●Extensively involved in all phases of software development life cycle (SDLC) and experience in Agile / Scrum and Project Management Methodologies.

●Highly proficient in the use of T-SQL and PL/SQL for developing complex Stored Procedures, indexes, Tables, Views, User Defined Functions, Relational Database models, Data integrity and SQL joins.

●Hands-on experience in monitoring SQL Server Performance tuning in SQL Server 2014/2016 /2017 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.

●Highly experienced in Data modelling and Dimensional modelling (using Star and Snowflake schemas)

●Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.

●Experienced in creating Database Objects like Tables, Constraints (Primary key, Foreign Key, Unique, Default) Views and Indexes.

●Well versed in Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export Wizard, Triggers and Normalization.

●Performed complex queries, data scrubbing, data gathering, data consultation and data analysing on a large volume of data sets.

●Experienced in Tuning SQL queries and T-SQL queries, MDX, & improving the performance of the queries.

●Experienced in Database Administration operations like Backup, Restore and Transact- SQL (DDL, DML, DCL).

●Experienced in the development and implementation of Data Warehouse solutions: Data Warehouses and Data Marts and ETL processes and designing of Star and Snowflake data models Schema.

●Experience in Database Backup, Recovery and Disaster Recovery procedures.

●Extensive hands-on experience in Database development for both OLTP Batch Processing and Online Processing.

●Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases and into Siemens Servers using SQL Server Integration Services SSIS.

●Designed ETL workflows to load data into Staging / Landing, Data Mart / Data Warehouse databases for full, incremental and remigration of data.

●Proficient in Dimensional modelling, defining dimension attributes, hierarchies and different types of fact tables and measuring granularity.

●Implemented ETL workflow packages using SQL Server Integration Services (SSIS) to extract, clean, transform, and load data into data warehouses.

●Experienced in designing SSIS packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, flat file, OLEDB) by using multiple transformations provided by SSIS such as Data Conversion, conditional split, merge, union all etc.

●Deployed SSIS Package and SQL objects into Production and used Package configuration to export various package properties to make the package environment independent.

●Designed and developed multidimensional OLAP cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI functionality of SQL Server.

●Experienced in creating custom columns and measures using DAX, developing Page level Reports, Dashboards, dynamic Navigation bars & Stories in Power BI.

●Experienced in Enterprise Data Warehouse environments, including experience with dimension modelling and performance optimization.

●Designed, developed, and deployed reports using SQL Server Reporting Services (SSRS) reports in support of productivity enhancements.

●Developed, maintained, and supported operational reports, dashboards and scorecards using Microsoft Power BI through relational database queries.

●Articulate communicator with strong analytical and interpersonal skills, skilled at collaborating with project teams, interfacing with clients.

●A systematic, organized, hardworking and dedicated team player confident in handling multiple assignments under pressure and meeting tight deadlines.

●Experienced in Project management tools like Trello.

TECHNICAL SKILLS

OLAP/Reporting Tools

SSRS, SSAS, MDX, Power BI

Relational Databases

SQL Server database 2005/2008,2012/2014/2016/2017, Oracle 11g, SQL Server Azure, MS Access

SQL Server Tools

Microsoft Visual Studio, SQL server management studio

ETL Tools

SQL Server Integration Services (SSIS), SQL Server DTS

Data Warehousing & BI

Star Schema, Snowflake schema, Facts and Dimensions tables

Operating Systems

Windows

Development Skills

Transact SQL (T-SQL)

Other Tools

Microsoft Office, SQL, PL/SQL, T-SQL, JAVA, Batch scripting, R, Python

Languages

.Net (C#)

Domain Knowledge

Healthcare, Insurance and FinTech

PROFESSIONAL EXPERIENCE

Job Title: SQL Developer Client: WakeMed Health and Hospitals

Location: Raleigh, North Carolina Duration: February 2022 to Present

Responsibilities:

●Interact with various Business Analysts, Management, and IT Units to analyse business & functional requirements, Convert business requirements into technical use cases.

●Responsible for preparing high level and low-level design documents for change requests and bug fixes.

●Maintained business intelligence models to design, develop and generate both standard and ad-hoc reports using SSMS, SSIS, SSRS and Microsoft Excel.

●Involved with the full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.

●Worked in designing and optimizing various T-SQL database objects like tables, views, stored procedures, user defined functions, indexes, and triggers.

●Enhance existing stored procedures, views, functions, database objects to meet additional requirements of latest releases, Involved in the performance tuning of table valued functions.

●Analysed source data to determine the data model and ETL solution that will meet business requirements.

●Designed SSIS packages utilizing tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, send Mail Task, Foreach loop Container, Derived Column, Conditional Split and Derived Column.

●Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

●Implemented complex SSIS packages’ error handling and package logging that stores the logging results in SQL table and flat files on error, on warning, on task failed event types.

●Used SSIS package and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.

●Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design and other Data Warehouse concepts.

●Created Packages to group logically related column types and to transfer data.

●Involved in Dimensional modelling by identifying the fact and dimension tables and design start/snowflake schemas for the Sql Server Analysis services.

●Played a major role in production support of SSAS cube refresh, SSIS jobs.

●Worked on creating calculated measures that fits business logic, using MDX queries.

●Handling Initial and Delta loads and processing Cubes Star Schema across all environments.

●Created reports using SSRS from OLTP and OLAP data sources and deployed on a report server.

●Worked on Key performance Indicators KPIs, design o star schema and snowflake schema in Analysis Services SSAS

●While developing reports from Cubes also used the KPI's for decision making, also implemented Cube Partitions, and also debugged data connections, data sources and Data Source Views.

●Created different type of reports including Cross-tab, Drill-through, Drill-down, Sub reports and parameterized reports

●Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, XML etc.

●Created Drill Down, Drill Through and Cascaded Parameterized reports according to the customer requirement.

●Scheduled the monthly/weekly/daily reports to run automatically.

●Involved in SSIS Packages, Query verification in SSRS and Stored Procedures.

Environment: SQL Server 2017, 2016, SSIS, SSAS, SSRS, MDX, OLAP, XML, Microsoft Visual studio 2019, C#, OLAP, XML, Windows Server 2016

Database Developer Armor Texas Insurance

Fort Worth, TX February 2020 to January 2022

Responsibilities:

●Participated in Planning, Defining and Designing databases based on business requirements and provided documentation.

●Liaised with Project Managers, Business Analyst, Business Stakeholders, and other cross-functional groups to resolve business queries, defects, and mitigate escalations

●Responsible for Data Profiling to determine data integrity for transformation of Data from Source

●Programmed Queries in T-SQL, Stored Procedures and Views to store the data of clients, advisors using SQL Server, Lead Data Mapping activity extensively.

●Worked in designing and optimizing various T-SQL database objects like tables, views, stored procedures, user defined functions, indexes, and triggers.

●Worked on Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).

●Used SSIS to create ETL packages( dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases.

●Utilized Integration Services for transferring and reviewing data from heterogeneous sources like (Flat file, Excel, CSV, Oracle, MS Access).

●Designed and Developed complex SSIS packages for performing ETL process using SQL Server Integration Services.

●Monitored time taking queries with Performance Tuning to reduce the execution time and created packages in SSIS with error handling

●Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the multi-dimensional data warehouse.

●Designed dynamic visuals using Bookmarks, Slicers, custom tooltips in Power BI

●Published and Shared Power BI reports and Data models in Power BI workspaces

●Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).

●Extensively used UNIX commands for fetching and checking files.

Environment: Environment: SQL Server 2014, SSIS, SSAS, SSRS, MDX, OLAP, XML, MS PowerPoint, MS SharePoint, MS Project, MS Access, Windows Server 2012 R2 & UNIX.

SQL Server Developer E-Sewa Pvt. Ltd

Lalitpur, Nepal August 2018 to January 2020

Responsibilities:

●Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources.

●Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of various modules

●Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs

●Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions

●Tuned several slow running queries in Production. Implemented Indexes to achieve time Performance.

●Implementations of MS SQL Server Management studio to create Complex Stored Procedures and Views using T-SQL.

●Writing Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), Create and maintain Physical Structures.

●Developed Data-data packages in SSIS as part of the automating the process for billing method.

●Extracted data from various sources like SQL server, Oracle, CSV, Excel and text file from Client servers and through FTP.

●Scheduling and Maintaining SSIS Packages and batch jobs through SQL Server Agent and using Shell Scripts, VB Script and batch .bat files on a day-to-day basis

●Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.

●Worked on Transforming and Loading data using SSIS, Import/Export wizard.

●Developed Enterprise reports using SQL Server Reporting Services SSRS and Excel pivot tables based on OLAP Multidimensional cubes which make use of multiple value sections in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.

●Developed Tabular Reports, Sub-Reports, Matrix Reports, Drill Down Reports, Dashboard, Cascading, and charts using SSRS.

●Interacted with Developers in troubleshooting applications and Report Developing.

Environment: SQL Server 2012 Enterprise Edition, SQL BI Suite (SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MS Project, MS Access & Windows Server 2012, Oracle.

FULL EDUCATION DETAILS

Masters in Engineering Management, St. Cloud State University, Minnesota

CERTIFICATION

Microsoft Certified Solutions Associate (MCSA)

Contact this candidate