KESHAB SUBEDI

469-***-****

adwqdy@r.postjobfree.com

TECHNICAL SUMMARY

• Over 9+ years of SQL Server database and SQL Business Intelligence Development experience in different domains like secondary market, retail, finance, Healthcare etc.

• Experienced in writing T-SQL, working on SSIS, SSRS, Data Cleansing and Data Migration.

• 2 Years of experience on analyzing, designing,developing and maintaining Snaplogic pipelines to meet various data sources and targets.

• Experienced in developing Parameterized, Chart, Graph, Linked, Dashboard, Drill-down and Drill-through reports using SSRS.

• Experienced in Extracting and Transforming data SSIS in SQL Server 2008/2008R2 and SQL 2012 Data Tools and Parallel Data Warehouse (PDW/APS).

• Experienced in installation and configuration of MS SQL Server 2008 and 2008R2,20012,20016 versions

• Experienced in Error and Event Handling: Precedence Constraints, Logging.

• Hands on experience in troubleshooting database issues, debugging SQL Server stored procedure/triggers and documenting issues/resolutions of SQL Server Applications.

• Experienced in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency

• Experienced in creating users/logins and providing appropriate and required permission in SQL Server and Analytics Platform System (APS/PDW).

• Extensive experience and knowledge in T-SQL–DML, DDL, DCL, Transactions, Stored Procedures, Triggers and Functions in SQL Server 2008/2008R2/2012 and Parallel Data Warehouse (PDW/APS).

• Hands-on working experience with analyzing query plans, Code Reviews, managing indexes and locks, troubleshooting deadlocks

• Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries

• Hands on Experience in using SQL Profiler and Database Tuning Advisor for Monitoring and Tuning SQL Server Performance

• Good knowledge of System Development Life Cycle (SDLC)

• Experience in creating Jobs, Sending Alerts using DB Mail

• Experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures

• Strong inclination for finishing job within project deadline and good time management skills

• Extremely attentive, strong team player with ability to take new roles and work in high pressure environments

●Worked on AWS server for 2 years at BSA.

●Used basic C# and VB language in SSIS packages Script task.

EDUCATION/CERTIFICATIONS

• Bachelor’s Degree (Mass Communication): North Bengal University, India

• MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

TECHNICAL SKILLS

Databases

MS SQL Server 2019,2016,2012/2008R2/2008/2005/MS Access

SQL Server Tools

Management Studio, Business Intelligence Development Studio, Integration Services (SSIS), Reporting Services (SSRS), Query Analyzer, SQL Profiler, Parallel Data Warehouse (PDW/APS), AWS server.

BI and Other Tools

Visual Studio 2005/2008/2010/2012, SnapLogic (ETL)

Languages

T-SQL,VB 6.0,VB Script, HTML

Operating Systems

Windows 2010,2008/2003/2000/NT 4.0, Windows XP/VISTA/7s

PROFESSIONAL EXPERIENCE

Emids-Paramount Project, Toledo, OH 25th Jan 2021 –Current

Senior ETL Developer

Responsibilities

●Worked on analyzing, designing,developing,maintaining and deploying Snaplogic pipelines to process large amounts of Healthcare data including various Database sources (HRP,AMISYS,CACTUS application,Oracle database) and various source and target file formats.

●Crate and schedule tasks in Snaplogic task manager to run the pipelines.

●Create accounts and assign accounts to desired groups or users.

●Participate in daily standup meetings to report the progress and take on new tasks.

●Followed Paramount/Emids development and documentation procedures.

●Participated in requirement gathering from business/clients.

●Perform Stored proc optimization.

●Work with the Offshore team to figure out and resolve (ETL) job failure.

●Provide data and logic related answers to business/client.

●Modify existing SP based on the new requirement and logic change.

CareSource, Dayton, OH June 2018 –Nov 2020

SQL ETL Developer, Application Support (Communication Automation Tool)

Responsibilities

• Designed process flow documentation for different projects like prenatal packet series, Language Preference, Rx-Reminder using MS Visio 2016

• Developed dynamic ETL packages using SQL server tools(2015/2017/2019)to import and export data from different sources like SQL Database, Flat Files, Excel etc. maintaining existing ETL solutions for Communication Automation Tool(CAT) application which is cloud base (PCF- Pivotal Cloud Foundry)

• Make date available from different environments like Facts, CCA (now converted to Guiding Care) and from different vendors like mPulse, O’Neil, United Mail, Redbrick etc.

• Updated the process to dynamically filter out DoNotCall(DNC),DoNotEmail (DNE) and DoNotText (DNT) as per TCPA(Telephone Consumer Protection Act) for CAT application

• Developed effective stored procedures and used them as dataset for dynamic SSRS reports with drill down and drill through functionality adhering to CareSource standards for MCH provider report.

• Deployed SSIS and Packages and SSRS reports in central server and automated execution using SQL Agent job and Tidal.

• Used GitFlow, SVN, TeamCity and Octopus in Automating deployments of SQL Codes, SSIS packages and SSRS reports.

• Involved in team code reviews and sprint reviews.

• Heavily involved in sprint planning, capacity planning and pointing stories.

• Follow agile methodology.

• Fully involved in PCF based application (CAT) testing when it was designed and developed in the DCP framework.

Boy Scouts Of America, Irving TX March 2015 –June 2018

SQL Server Database Developer

• Perform Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources having billions of records per table of daily users’ logins and account creating process from Boy Scouts of America (BSA) sites

• Performed optimization of existing query, Stored Procedures, SSIS package and SSRS reports.

• Developed complex Stored Procedures to generate various Drill-through reports, Drill-down reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

• Immediate data extraction from various sources for mass mailing to Customers and vendors.

Environment: Microsoft SQL Server 2008 R2 Enterprise edition SP3, BIDS, SSMS, SQL (Parallel Data Warehouse (PDW), Windows Server 2008 R2, SharePoint, Team Foundation Server (TFS) 2010, Oracle, AWS (Amazon Web Services) server.

HP Enterprise Services (Healthways) July 15th – Oct 2014

SQL Server SSIS/ETL Developer (20% DBA)

Responsibilities

• Monitor existing and scheduled SQL jobs.

• Complete validation of data from source to stage and to destination once the job execution is complete.

• Fix data and re-execute the jobs individually if it fails.

• Monitor PDW processes using Admin Console

• Create a Daily, Weekly and Monthly Report to manager with complete load execution metrics.

• Identify the cause of failures of SQL jobs and report to management and respective development teams.

• Develop database objects (tables, Views and Stored Procedures) in PDW

• Create/Modify robust ETL packages to extract, transform and Load data from different source systems.

• Used SSDT transformation components like Derived Column, Conditional Split, Lookup, and Merge, Merge Join etc. to apply business rules and cleanse data.

• Create User Logins, create permissions, grant and revoke permissions to Databases and Database Objects

• Create Database roles, alter logins, unlock Logins, add user to database or database objects with specific permissions

• Identify and Optimize slow running queries and implement it

Environment: Microsoft SQL Server 2008 R2 Enterprise edition SP3, BIDS, SSMS, SQL (Parallel Data Warehouse (PDW), Windows Server 2008 R2, SharePoint, Team Foundation Server (TFS) 2010 and Oracle.

Contact this candidate