Data Developer

Name: Min Datta Dhungana

Phone: 571-***-****

Email: adbv1a@r.postjobfree.com

PROFESSIONAL SUMMARY:

6+ years of experience as MS SQL Developer in development of Database Design and Development in SQL Server 2016/2014/2012/2008R2/2008 system in OLTP and OLAP environment.

Highly expert in translating Business System Design document into technical design document.

Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.

In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.

Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.

Experience in scheduling SSIS packages using SQL Server Agent Active Batch.

Strong knowledge of using variables and expressions in packages.

Experience in creating the SSIS package using third party tool ZappySys.

Experience in enhancing and deploying the SSIS Packages from development server to production server.

Excellent skills in implementing ETL Packages using DTS and SSIS 2017/2012/2008R2/2008/ 2005.

Proficient in implementing all transformations available on the SSIS toolbox.

Expert in resolving the performance issue of SSIS packages.

Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).

Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.

Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2016.

Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.

Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high pressure environment.

PROFESSIONAL EXPERIENCE:

Client: The Williams Companies, Inc. Apr 2019 – Present

Tulsa, Oklahoma

SSIS/ETL Developer

Responsibilities:

●Created SSIS packages to extract the data from report URL and REST API source to the Hub and from Hub to the applicationusing third party tool called ZappySys in SSIS and alsomigrate data from different data sources to data warehouse.

●Successfully extracted transformed and load data into data warehouse.

●Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.

●Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

●Create the job and Scheduled SSIS packages for running weekly and daily feeds usingActiveBatch.

●Involved in enhancing and deploying the SSIS Packages from development server to production server.

●Established ETL design practices for optimization and performance of packages and Parameterized SSIS.

●Create low level design and ETL design doc according to requirement.

●Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.

●Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.

●Successfully tested all task in staging and stored all versions of data using GIT Hub.

●Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.

Environment: SQLServer2016, SQLServerBIDevelopment Studio (BIDS) 2016, TFS, Oracle 9i/10g, SQL Lite Speed, T-SQL, ActiveBatch, MS Access, Windows XP/2010 Server.

Client: NRL Federal Credit Union, Alexandria, VA Apr 2018 –Apr 2019

ETL Developer

Responsibilities:

●Created SSIS packages to migrate data from different data sources to data warehouse.

●Successfully extracted transformed and load data into data warehouse.

●Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.

●Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

●Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.

●Involved in enhancing and deploying the SSIS Packages from development server to production server.

●Established ETL design practices for optimization and performance of packages and Parameterized SSIS.

●Create low level design and ETL design doc according to requirement.

●Analyze existing ETL jobs and find the gaps.

●Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.

●Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.

●Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.

●Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

●Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.

Environment: SQLServer2012, SQLServerBIDevelopment Studio (BIDS) 2012, TFS, Oracle 9i/10g, SQL LiteSpeed, T-SQL, Autosys, MS Access, Windows XP/2007 Server.

Client: Quest Diagnostics, Chantilly, VA March 2017-March 2018

SQL/ETL Developer

Responsibilities:

●Installed SQL Server 2008R2 with the latest service packs.

●Migrated Database from SQL Server 2008 to 2008R2 by using side by side migration.

●Created tables, indexes and designing constraints.

●Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.

●Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

●Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.

●Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

● Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.

●Designed and wrote stored procedures, functions using T-SQL.

●Supported application written in Oracle PL/SQL and converted into T-SQL packages.

●Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

●Enhanced and deploying the SSIS Packages from development server to production server.

●Wrote stored procedures for report generation in SQL Server2008R2.

●Created Alerts for successful or unsuccessful completion of Scheduled Jobs.

●Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.

●Created T-SQL Stored procedures, Functions and Triggers.

●Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.

●Administrated the created Reports by assigning permission to the valid user for executing the reports.

●Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.

●Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.

Environment:SQL server 2008R2, SSIS, SSRS, T-SQL, SSMS, Windows XP/2007. BIDS 2008R2, Windows 2000 Advanced Server-SQL, Microsoft Share point Portal Server, VSS, SQL Diagnostic Manager

Agricultural Development Bank Ltd., Kathmandu, Nepal Jun 2014 – Jan 2017

SQL/SSIS/BI Developer

Responsibilities:

●Gathered user requirements, analyzed and designed software solution based on the requirements.

●Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

●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 Server 2008R2.

●Performed SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

●Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.

●Involved in preparing Development and Deployment guide.

●Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

●Set up Alerts for successful or unsuccessful completion of Scheduled Jobs.

●Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.

●Created stylish reports and implemented conditional formatting using SSRS 2008.

●Deployed and managed the reports in the Report Manager using SSRS 2008.

●Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

●Generated Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.

Environment:SQL Server 2008R2, BIDS 2008R2, Integration Services 2008R2, Oracle 9i, Visual SourceSafe, TSQL, Autosys, Rational Clear Case, Clear quest, MS Access, Windows XP/2003 Server.

EDUCATION & CERTIFICATION:

Master’s Degree (Economics) Graduated Year 2013

Tribhuvan University,Kathmandu, Nepal

Master’s Degree (Public Administration) Graduated Year 2007

Tribhuvan University,Kathmandu, Nepal

Bachelor’s Business Studies Graduated Year 2003

Tribhuvan University,Kathmandu, Nepal

High School Diploma Graduated Year 1999

Board of Nepal / Tribhuvan University,Kathmandu, Nepal

TOOLS AND TECHNOLOGY

RDBMS: SQL Server 2005/ 2008/2008R2/ 2012/2014/2016

Database/ETL Tools: SSIS, SSAS, SSRS

Reporting: SQL Server Reporting Services (SSRS), Report Builder

Languages: VB.NET, C#, C++, PL-SQL,T-SQL

MS-Office: Microsoft Office Tools

Operating Systems: Windows Server 2000, 2003, 2008, 2008R2, 2012

Tools: Backup Utility, Lite Speed for SQL Server, Visio

Contact this candidate