SUDIP THAPA

MS SQLData Engineer

Email: ad4wym@r.postjobfree.com

Phone: 916-***-****

Professional Summary:

11+ years of progressive experience in IT industry as SQL Server/Database Administrator.

Extensive experience on SSRS, SSIS, and SSAS along with other BI technologies.

Worked in Databricks, Azure Data Lake, Azure Synapse, ADF.

Worked in Auto feed to schedule the Job for ETL running Scala and ADF pipelines.

Release BVD Data for SAP integration and the claim process generation for Rebate.

Experience in designing, creating, maintaining, and deploying form reports, tabular reports, drilldown reports, drill through reports, ad hoc reports, multicolumn reports, matrix, and charts using SSRS.

Extensive experience in Extraction, Transformation, and Loading (ETL) solutions using SQL Server Integration Services (SSIS).

Hands on experience in transformation of heterogeneous data sources into a variety of SSIS transformations like Aggregate, Derived Column, Data Conversion, Conditional Split, Multicast, Fuzzy Lookup, Union All, Merge Join, Lookup, Slowly Changing Dimension, and Pivot applying ETL concepts.

Extensively worked on error handling at various levels of SSIS packages like control flow level and data flow level. Used checkpoint files to automate the restarting process from the point of failure up to some extent.

Experience in data warehousing dimensional modeling to define dimensions and fact tables using Star schema and Snowflake schema design.

Hands on experience on projects involving Microsoft SQL Server 2000 to Microsoft SQL Server 2005/2008R2/2012upgradation and migration.

Hands on experience in T-SQL (Transact-SQL) writing/creating indexes, stored procedures, functions, views, and triggers using Microsoft SQL Server 2005/2008.

Experience in Query Optimization and Performance Tuning for T- SQL queries and SSIS package optimization.

Experience in RDBMS (relational database management systems) Concepts, Database Management Systems, Database PhysicandLogical design, Data Mapping, Table normalization, Data Modeling, CreatingER

Diagrams using tools such as MS Visio.

Hands on experience on SQL Server profiler, and Performance Monitor to solve performance issues like dead locks and long running queries.

Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor

Experience in creating Jobs, Alerts, Autosys, SQL Mail Agent and scheduling DTS and SSIS Packages.

Strong business analysis skills with a solid knowledge of agile methodology.

Good debugging and problem-solving skills with excellent understanding of system development methodologies, techniques, and tools.

Education:

Masters in science, College of Applied College, Tribhuvan University, Kathmandu, Nepal 2008

Technical Skills:

Tools:SSMS,SSIS,SSRS,VisualStudio,Autosys,TFS,MSAzure,MSOffice,MSExcel,Jira,PowerBI,Toad,ADF,Azuresynapse,AzureDatabricks, Oracle Database, Microsoft Access,Toad,MySQL,Oracle SQL Developer,SQL Lite.

Database:MSSQLServer(2005,2008R2,2012,2016,2018,2019),Oracle11g,Sybase,Netezza,MSAccess,MongoDB,CloudDB, IBM DB2, Cassandra,

Languages: T-SQL, PL SQL,PowerShell,XML, HTML, C++, VB,Python,Scala.

Certification: Power BI (DA-100), Microsoft Azure fundamentals (AZ-900), Microsoft SQL Query (70-761)

Infosys (Microsoft)FEB2021 -Current

Database Developer, Seattle

Microsoft is the largest vendor of computer software in the world. Its corporate headquarters is in Redmond, Washington.

Responsibilities:

Responsible for data onboard from SAP, CDE (Cloud Delivery Executive) using Auto feed, ADF (Azure Data Factory) pipeline.

Created multiple Store procedures, Views and other database structures as required.

Recent changes go through Dev, UAT (user acceptance testing) and production (PR process)

Created various Power BI reports for Elevate project especially for Claim, Accruals, and payment reconciliation process.

Create Various pipelines to trigger the store procedures on the daily basis.

Provided various insight on the production team for the job schedule, Performance issue and the optimization on SQL queries.

Modified various ad hoc queries to CTE and Temp tables process for optimization.

Chance to get work in thesoftware development life cycle.

Involved with the senior MS associates for various KT (knowledge transfer)sessions and the ongoing training and recent changes for the available software.

Worked to setup up the anomalies trend setup using metrics advisors in PBI (Power BI).

Involved in the Power App for the creation of the dashboard for finance and pricing project.

Supported on the Autosys projects for job scheduling and onboarding the client files.

Worked for migrating few SSIS Packages and Paginated SSRS reports.

Worked in the complex SSIS package for the multiple file load for the Rebate Data.

Environment:

PowerApps, PowerBI,MSAzureSQL,Microsoftperview,ADF,Azuredatalake,databrick,Scala,Python.

Fiserv DEC2014 -Jan2021

Dallas, TX

SQL DBA\SSIS Developer\SQL Engineer

Fiserv is a global organization highly regarded for its financial services,technology, and services.

Responsibilities:

Experience in installation, configuration, maintenance, and administration of SQL Server 2005/2008/2012.

Database administration skills including backups, restores, troubleshooting and security management for Microsoft SQL Server 2000, 2005 and 2008 R2.

Deployment of the SQL Scripts Packages Job and SSRS deployment in Different Environment (Stage, CT, and RT) as per the Instruction provided in the Test Cases.

Experience in troubleshooting SQL Database issues by using SQL Tools, execution plans, Trace, statistics, and index tuning wizard.

Creating the User Login as per the requirement and providing the role. Importing Data using SQL Wizard and SSIS packages.

Hands-on experience in managing Alerts and Jobs through SQL Server Agent

Provided database information to other system software computer operation and application teams.

Troubleshoot Database issue and as per need writing different ad-hoc queries.

Experience in deploying SSIS, SSRS, and DTS packages.

Familiar with software development life cycle.

I worked extensively in the database backup using the Lite speed server as well as in the system restoration at the time of hard drive failure.

Experience in setting up several types of replications across multiple DB servers and good understanding of the compatibility of replication type Vs SQL version.

Experience in SQL Queries and stored procedures, review, and architect SQL Code for optimized performance, suggesting efficient Indexes on tables.

Hands on experience in using version control tools, preferably Visual Source Safe 6.0 or TFS

Experience in applying patches and service packs to keep the database at the current patch.

Used SQL Server Profiler to monitor and record database activities of users and applications.

SSIS Packages creation and displaying Data using SSRS services as per requirement.

Creating Database structure as needed like (views, tables, Store procedure)

Worked on Autosys for Trigger, schedule, and automation of the job for file movement.

Environment: SQLSERVER2012/2014/2008R2/2008/2005, Windows Enterprise Server2003, IIS6.0, NETSQL Server 2012, SQL Server reporting Server, Light Speed Server, BI Xpress, SSIS.

O’Neil Data System and Digital SolutionNov2013 –Nov2014

SQL Programmer\SSIS Developer

The company is intensively involved in data-driven publishing and delivery solutions; O’Neil Data Systems offers the latest technology in multi-channel document delivery and marketing communication.

Responsibilities

Involved in creating the Job Scheduler, which runs the different Job from the SSIS packages and other programming language framework.

Creating tasks as per the requirement and implementing the different change order in production as per the business requirement.

Support data-driven products and applications such as data management systems, online authentication systems, metadata databases, warehouses and more.

Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.

Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures, and triggers.

Design and develop new Integration Services ETL packages that load data from disparate data sources into the Enterprise Integration Services Data Warehouse.

Worked in the production environment and troubleshooting the different issues while running the different Job and creating the pdf needed for the book with coordination with GMC programmer and the extreme developer.

Directly involved in the full project's development as per the business requirement for moving into production standard and successfully handed over.

Environment: SQL Server 2008R2/2008/2005, Windows Enterprise Server 2003, IIS 6.0, .NET framework, Microsoft Reporting Service (SSRS).

PROJECTS SUMMARY:

Expedia, Inc, Dallas, TXApr2013-Nov2013

MS SQL Server Database Developer/SSIS Developer

Project Description:

Expedia, Inc. is the American-based parent company to several global online travel brands including Expedia.com, Hotels.com, Hotwire.com, Egencia, Venere, Expedia Local Expert, Classic Vacations.

Responsibilities:

Involved in Installation and designing MS SQL 2000/2005/2008/2008R2, created various databases for Development and Testing Environment using SQL Server 2000/2005/2008 and managed database locations and size.

WriteT-SQL Scripts for performing all the Log shipping actions like Backup Log, Copy Log, and Apply Log and check any missing Log files and then re-copy it again to destination Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Experience in Working with High Availability techniques like Clustering (Active/Active, Active/Passive, Two/Three Node Clusters) and Replication

Configured Transactional replication for the OLTP Databases to the reporting server and scheduled monthly database refresh process of the databases from production to UAT and development servers.

Reorganized databases and sized database objects to meet standards and improve performance.

Worked on various kinds of Transformations like Import Column, Export Column, SCD and Lookup in SSIS as per the client’s Requirement.

Involved in the migration and restoration of the TB data from the staging folder into the development server.

I am skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.

Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance and disaster recovery.

Designed and developed batch scripts to automate ETL processes/data testing.

Performance tuning/optimization of databases, ETL loads and reports/queries.

Monitored and provided front-line support of daily processes and production servers.

Environment: SQL Server 2008R2/2008/2005, SQL, Windows Server 2003, Internet Information Server (IIS) 6.0/7.0, My SQL, MS-Access, LightSpeed.

Administrative Court of Pennsylvania (AOPC), Mechanicsburg, PA July2011-Mar2013

MS SQL Database Developer/SSIS Developer

Project Description:

The Commonwealth of Pennsylvania Common Pleas Case Management System (CPCMS) is a comprehensive, statewide system for criminal case management developed by the Administrative Office of Pennsylvania Courts (AOPC) under a mandate from the Pennsylvania Supreme Court.

Responsibilities:

Involved in Installation and designing MS SQL 2000/2005/2008/2008R2, created various databases for Development and Testing Environment using SQL Server 2000/2005/2008 and managed database locations and size.

Scheduled all the Log shipping Copy and Restore Jobs to copy the Backup Log files to the reporting and DR Servers and restore those log files during a particular schedule.

Designed and implemented stored procedures and triggers. And to keep track of changes to the fields of tables when changes are made.

Extensively used Joins and sub-queries for complex queries involving multiple tables from different Database

Tests the code to ensure it functions as designed as per the business requirement and the implementation of the code in production environment with Team Foundation server (TFS).

Used Event Handlers for Custom Logging using Complex store Procedures for Various Events on Warning, On Pre and Post Execution, on task Failed etc.

Involved in the consultation and coordination with the Data Hub, EAI (Enterprise Application Integration), and Presentation Tier (PT) Team for the system's performance and enhancing.

Developed the template for the database objects like Store Procedure, Views, Triggers, Metadata, CTE’s, Functions and Worktable.

Using TFS 2010, a Source Control Tool for different projects created on BIDS 2008 and check in projects into TFS.

Used SSIS features like package event handlers, property expressions, and package configurations, transactions in packages,checkpoints, and protection levels.

Created alerts and notifications for system errors, insufficient resources, SQL Server job failure and fatal database errors and ensured database security by controlling unauthorized database access. Set up transactional and snapshotreplication and DB mirroring.

Environment: SQL Server 2008R2/2008/2005, SQL, Windows Server 2003, Internet Information Server (IIS) 6.0/7.0, My SQL, MS-Access, Sybase, DB Artisan.

Young Minds Creation (P) Ltd., Nepal Jan2011-June2011

SQL Server Developer

Responsibilities:

Created database objects like tables, views, indexes etc.

Implement database standards and naming convention for the database objects.

Implemented trigger, stored procedures, and enforced business rules via checks and constraints.

Fine-tuned Stored Procedures, using Execution Plan in T-SQL for better performance.

Going through the clients' requirements and producing database design and application architecture.

Troubleshoot and minimize production down issues.

Designed new job processes, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.

Environment: MS SQL Server 2000, Windows XP, crystal reports, DTS.

Contact this candidate