Professional Summary

●Have more than * years of IT experience as database development, design, analysis and support various applications using MS SQL Servers 2016, 2014 and 2012 versions. Have been involved in development, unit testing, data validation and application production deployment.

●Experienced in executing activities related to end - to-end project management, including project plans and estimates, scoping, and requirements through implementation, Requirement Gathering, Requirement analysis, Application environment Setup, Preparing Test Scripts, Project Status reporting, bug fixing and deployment.

●Conversant with all phases of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development, and Implementation.

●Experienced in database modeling up to 3 NF and Dimensional modeling with Star and Snowflake schema.

●Well experienced with features and architecture of Microsoft SQL Server.

●Experience in creating and managing database objects like tables, views, stored procedures, Triggers, user defined data types and functions. Implementing SQL Server security and Object permissions.

●Developed T-SQL queries, Views, Complex Stored Procedures, User Defined Functions UDF, Database Triggers, Indexes, and various constraints.

●Implemented several Sub-Query constructs, Common Table Expressions, and different types of Joins, Rollups, Cubes, Set Operators to simplify complex queries involving multiple tables.

●Expertise working with SQL Server tools Such as Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard and SQL Server Agent.

●Experienced in ERWIN tool to model data and entities also experienced in generating mapping documents.

●Worked with new data quality services DQS in SQL 2012 as part of creating rules for data mapping and data cleansing.

●Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for performance analysis.

●Hands on experience in configuring TEMP DB with considerable MEMORY and RAID LEVELS for better performance.

●Good experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC.

●Experienced in troubleshooting SQL issues by using SQL Tools Execution plan, Trace and 3rd party tools.

●Experienced in Query Tuning by Using Execution Plan, DMVs, query analyzer and tuning advisor.

●Have experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues.

●Experienced in Data Migration by using side-by-side upgrade process Management.

●Proficient in Extract Transform Load ETL development using SQL Server Integration Services SSIS and Report development using SQL Server Reporting Services SSRS.

●Implemented Star Schema, Snowflake Schema models in Data Warehouses and Data Marts. Designed different types of Fact & Dimensions tables along with their ETL packages.

●Implemented Slowly changing dimensions up to Type 3 and developed Late Arriving dimension and fact scenarios during data load from Staging to Data Warehouse

●Experienced in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

●Well experienced in designing ETL data flows by creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server Integration Services - SSIS.

●Implemented Full load and Incremental load using merge statements and SSIS Look Up and Slowly changing dimension transforms.

●Extensively worked on Creating, Populating, and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts.

●Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management.

●Experienced in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using SQL Server 2016/2014/2012 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.

●Experienced in SQL Server Analysis Services SSAS multidimensional OLAP database development including KPIs, Data mining, working with changing dimensions.

●Worked on OLAP Data warehouse, Model, Design, and Implementation.

●Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

●Configured and administrated BPA Business Process Automation for designing ETL workflow and including multiple packages within the workflow.

●Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.

●Experienced in creating Jobs, Alerts and scheduling SSIS Packages in SQL Agent.

●Experienced in documenting all ETL projects and workflows by using Bi Documenter and also including supporting documents for troubleshoot for each project.

●Experienced in Ad-hoc reporting, parameterized, custom reporting using SSRS for daily Ad-Hoc reports.

●Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Managed security by defining roles and rights.

●Managed Production Server and Development server for SCCM Reporting.

●Good Knowledge of Web development technologies such as HTML, XML, DHTML and Visual Studio 2010 and 2013.

●Developed Test Plans, Test scripts and Executing Test Cases using HP ALM- quality center 11.

●Highly organized with the ability to manage multiple projects and meet deadlines.

●A team player with excellent interpersonal, communication and presentation skills.

Technical Skills

Relational DBMS:

MS SQL Server 2017, 2016, 2014, 2012, MS Access

Operating System:

Windows Server 2016/2012/2008/2008R2Advanced, MS Windows 2010, Unix.

SQL Server Tools:

SSMS, Profiler, Query Analyzer, Index tuning wizard, SQL Trace tools,Oracle

BI Tools:

SSIS, SSRS, SSAS, Power BI

Windows Tools:

Event Viewer, Task Manager

Programming:

T - SQL, basic idea about .NET and ASP.NET

Applications:

JIRA Ticketing System, Visual Studio, MS Office, Pointing Poker

Job Schedulers:

SQL Server Agent, Auto Sys, Control – M

Professional Experience

Company Name: Prosperity Bank

Position: SQL/SSIS/SSRS Developer

Location: Plano, TX

Year Details: Nov 2021 to Present

Responsibilities:

●Involved in Planning, Defining and Designing database based on business requirements and provided documentation.

●Interacted with Business Analyst, Subject Matter Experts and Stakeholders to understand the business needs and documented the complex business requirement into simpler one and automate the process by writing complex scripts and scheduling on the jobs.

●Involved in Change/Release Management process for deployment of change on Prod Environment and server maintenance and server patching on regular basis.

●Programmed T-SQL to create database objects such as tables, stored procedures, views, and triggers and to generate reports in SSRS.

●Developed T-SQL programs to create database, programmed queries, sub-queries, ranking functions, derived tables, common table expressions, stored procedures, views, user defined functions, constrains and database triggers using T-SQL.

●Optimized stored procedures and long running scripts using execution plan, temp tables, and code rewriting and indexing strategies to increase speed and reduce run time.

●Used Database Engine Tuning Advisor and monitoring tools for database analysis

●Built the SSIS package to load data into Staging ODS by writing optimize SQL queries for integration

●Utilized SSIS containers/transformations such as Sequence container, Foreach loop container, Look up transformations, merge joins, derived column with multiple Data flow task. To pull data sources like SQL server, Oracle, Excel, and Flat files

●Developed SSIS package to load data from different data source by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.

●Implemented various Error Handling and Event handling techniques in SSIS to ensure smooth and efficient package execution

●Deployed the run of SSIS package to the conversion server and automated the run of the packages on a weekly basis by creating and scheduling SQL server Agent jobs.

●Improved the performance of SSIS packages by enabling Parallelism in the Control and Data Flows, usage of synchronous transformations.

●Documented ETL projects and workflows by using Bi Documenter and including supporting documents for troubleshoot for each project.

●Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.

●Created data sources and data source views DSVs, named calculations and names queries calculated members, named sets, KPIs, drill through, report actions and perspectives as per the business requirement.

●Developed multiple Enterprise reports using SSRS from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and include various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports Hyperlink etc.

●Provided support for batch processing and SSIS process using job scheduler.

●Created and maintained documentation for Supported Applications

●Automated the ETL jobs using custom business logic using Power Shell scripting.

●Good working knowledge on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.

●Make recommendations based on data trends and analysis.

●Generating reports using SSRS in Visual Studio.

●Make recommendations based on data trends and analysis.

●Modified and tuned stored procedures, triggers, views, and indexes to provide best performance.

●Analysed, identified, and implemented user roles and assigned relative database access privileges

●Securing Access to Reports, Authorizing Users at the Home Level and Project Level, Managing Reporting Services Roles.

●Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using Drill-down, Drill-through And Cascading reports using SSRS.

●Leads and drives communication with users and management.

●Creates and maintains documentation related to the technical process and stakeholder usage of presentation layers.

●Trains stakeholders on complex solutions.

Environment: SQL Server 2017, 2016, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#, SQL Server Analysis Services (SSAS), Microsoft Visual studio 2010, IIS, VB.Net, Erwin, oracle.

Company Name: McKesson

Position: SQL/ETL Developer

Location: Irving, TX

Year Details: Feb 2020 - Oct 2021

Responsibilities:

●Involved in the Requirement Analysis, Design phase and Development phase of agile model system.

●Closely worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.

●Involved in design and development of Data Warehouses, Data marts and Business Intelligence reports using multi-dimensional models.

●Developed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other database objects as per the business requirements

●Assisted on the Ad hoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.

●Developed stored procedures, triggers and functions to account for some automated insertion of records in tables for wholesale lending to different merchant banks Developing Power BI report using Power Apps Entity data and other Databases.

●Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues.

●Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages.

●Developed SSIS packages to Push and Pull data using Rest APIs and other different sources and vendors.

●Built SSIS package to load data from different files and databases using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot, Slowly Changing Dimension, and other transformations from different sources.

●Used different type of Transformations for Data Conversion, Sorting, and cleaning the data from different sources into Company format.

●Created Package Configurations, Event Handlers for On Error/Warning/Task Events.

●Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.

●Troubleshooted and monitored daily execution and implementing enhancement on existing SSIS packages.

●Maintained the physical reports by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.

●Developed logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS

●Provide support to junior co-workers and work with offshore resources for knowledge share.

●Performed peer/ code review of co-worker and junior developer and make necessary revision to make sure code best practice has been followed and to eliminate errors into PROD environment.

●Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.

●Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

●Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

●Created and updated data into CRM and providing support.

●Worked on Upgrading and automating manual jobs and scripts into SSIS and scheduled in sql agent.

●Used different types of files like XML, JSON to load the data into sql database using ZappySys .

●Developing test strategies, test plans based on functional specifications, use cases, and business requirements

●Documenting and analyzing workflows & use cases, business rules, prototyping, data mapping & data modelling.

Environment: SQL Server 2016/2014 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, Power BI

Company Name: Exxon Mobil

Position: Jr. SQL Developer

Location: Brooklyn, NY

Year Details: Feb 2018 - Jan 2020

Responsibilities:

●Documenting and analyzing workflows & use cases, business rules, prototyping, data mapping & data modeling.

●Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction o 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.

●Extensively used T-SQL in constructing Stored Procedures, Common Table Expressions (CTEs), User Functions, Indexes, User Profiles, Relational Database Models, Data Dictionaries, triggers, cursors, tables, and views and other SQL joins and statements for applications.

●Developed SQL scripts to load the custom data into Development, Test and production Instances using Import/Export. Created scripts to create custom Tables and Views.

●Programmed highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used TSQL to manipulate and architect to produce results for business users.

●Defined multiple join statements to retrieve data from multiple tables.

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

●Tuned the performance of SQL queries and stored procedures using SQL Profiler. Involved in database and log backups & restoration, backup strategies, scheduling.

●Advised optimization of queries by looking at execution plan for better tuning of Database.

●Used various SSIS task such as conditional split, derived column, lookup which were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.

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

●Involved in Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

●Developed Star schema modeling in Data Warehouse and extended same in SSAS multidimensional cubes (Dimension, Hierarchies and Measure Groups).

●Developed Aggregations, partitions, and calculated members for cube as per business requirements.

●Programmed parallel period, filter, ancestors, and cross join in MDX queries.

●Scheduling and Maintaining SSIS Packages and batch jobs thru 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.

●Developed Enterprise reports using SQL Server Reporting Services SSRS and Excel pivot tables based on OLAP Multidimensional cubes which make use of multiple value section 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.

●Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).

●Raising defects where discrepancy found in the database and reporting it to the development team.

●Reported all events and requirements through established reporting mechanisms in SSRS.

●Reviewed and developed data models and database designs with development teams

Environment: SQL Server 2014/2012, Server Integration Services (SSIS), SQL Server Data Tools (SSDT), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Excel 2010.

Education

Master

Bachelor

SQL /SSIS/SSRS DEVELOPER

Name: Stuti Sapkota

Location: Farmers Branch, TX, 75234

Email: adzp6a@r.postjobfree.com

Phone No: 214-***-****

Work Authorization: Green Card Holder

Contact this candidate