SQL SERVER SSIS DEVELOPER

Full Legal Name: Jyotsna Pathak

Current Location: Columbus, Ohio 43235

Email ID: ad15sf@r.postjobfree.com

Contact no.: 1-614-***-****

Work Authorization: Permanent Resident (Green Card holder)

SUMMARY

Versatile SQL Server Developer with more than 5 years of experience using Microsoft SQL server 2016 in Healthcare, Banking and Finance, E-Commerce domains. Specialized in Database Design and Development, ETL Development, and Report Development using SSAS, SSIS, SSRS, and T-SQL.

●Experience working in all phases of Software Development Life Cycle (SDLC) from analysis, estimate, design, coding, unit testing, system testing and user acceptance testing.

●Experience working in an Agile and Waterfall development environment for different projects.

●Created and used Functions, Indexes, cursor, Table Partitioning, Collections, REFCURSOR, Views, materialized views, indexes, Packages, Exception handling, Dynamic SQL and Triggers, Stored Procedures in T-SQL.

●Experienced in ETL processes, data extraction, transformation, and loading using tools like BCP utility, DTS, and SSIS.

●Wrote Unix Shell Scripts for scheduling jobs and executing shell objects.

●Experience in DBA activity, SQL performance tuning using explain plan, query Optimizer and Cost - Based Optimization (CBO).

●Expert in creating documentation for unit testing and requirement gathering.

●Worked on AUTOSYS scheduler to monitor and run the ETL jobs.

●Worked for report creation in PDF and Excel reporting using XML reporting tool for Oracle Database data.

●SQL Server 2012 OLAP database development including KPIs, Data mining, working with slow changing dimensions

●Experience in Importing/Exporting Data from various data sources like Excel and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.

●Maintaining all the documentation related to developed objects which involve a code review checklist, technical specification, unit test document, FD (functional design) checklist.

●Experience in evaluating and performance testing the database applications. Implemented indexes on tables for better performances on data retrieval from oracle.

●Knowledge of optimization tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

●Good understanding of the Oracle database, related utilities, and tools.

●Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.

●Good team player with excellent communication, analytical, written and presentation skills with strong aptitude towards learning new technologies.

EDUCATION AND CERTIFICATION:

Bachelor Degree, Bharati Vidyapeeth University, Pune, India, 2018

Microsoft Certified Solutions Expert (MCSE)

TECHNICAL SKILLS

●Industry/Domain experience: Healthcare, Banking and Finance, E-Commerce

●Operating Systems: Windows, Linux, Unix

●Programming Languages: SQL, Python

●ETL Tools: DTS, SQL Server Integration Services (SSIS)

●Database Tools: MS SQL Server Query Analyzer, SQL Profiler, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)

●Reporting Tools: SSRS, Power BI, Tableau

●Development Skills: Transact SQL (T-SQL)

●Databases: MS SQL Server, MS Access, Oracle

●Data Modeling: Erwin, SQL Server Management Studio (SSMS)

PROFESSIONAL EXPERIENCE:

SQL Developer - University Hospitals

Shaker Height, Ohio - (December 2022 to Present)

Responsibilities:

●Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development, and testing using AGILE methodology (SCRUM).

●Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.

●Experience in migrating databases from SQL Server 2008 to SQL Server 2012.

●Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)

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

●Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.

●Involved in Extraction, Transformation and Loading (ETL) process and used Informatica Power Center tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager and Workflow Monitor

●Designed Data Mapping documents, DDL scripts, and Data Dictionary and Metadata of the models and maintained them.

●Maintained SQL scripts, indexes, complex queries for data analysis and extraction.

●Used .NET provider Data Reader Source Task to Read from RDBMS sources.

●Involved extensively in Functional Testing, System Testing, Integration Testing and Regression Testing and Content Testing, both manually as well as using automated testing tools including Quality Center, QTP, SAP TAO and Load Runner.

●Wrote UNIX Shell scripts for Informatica ETL Tool.

●Worked in ASP.NET Web forms, State management and Caching feature.

●Developed some codes to work on Visual Studio 2008 and Team foundation server (TFS) also used the same code in SSRS to generate Reports.

●Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from a huge dataset using SQL Server Analysis Services (SSAS).

●Used the complex SQL queries in Oracle and Teradata in the Data Warehousing environment.

●Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.

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

●Worked with the Version control Systems like Team Foundation Server (TFS), Visual Source Safe (VSS).

●Involved in developing database objects such as procedures, triggers, constraints, indexes, and views. Used T-SQL to build dynamic stored procedures.

●Involved in Development of data access, business and Application layer using ASP.NET.

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

●Generated ad-hoc reports using MS Reporting services and Crystal reports.

●Worked on Erwin Data Model Tool and good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.

●Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multidimensional reports in SSRS. Provided Ad-hoc queries and Reports for Company Wide users pulling data from multi-terabyte data warehousing systems.

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

Environment: Windows, SQL Server 2017/ 2019/ 2021, Teradata, SSAS, SQL Integration Services (SSIS), SQL Reporting (SSRS), GIT, Visual Studio 2019/2022, Team foundation Server, Tableau, VB.NET, DTS Package, Crystal Reports and Erwin.

SQL ETL Developer - Capital Merchant Banking and Finance Ltd.

Kathmandu, Nepal- (October 2020 - November 2022)

Responsibilities:

●Attended the daily scrum calls to discuss about the each PBI business requirements, progress updates of the sprint.

●Worked on Agile Methodologies with daily scrum meetings and shares.

●Created efficient Stored Procs, UDFs, and Views having complex queries to enforce the business rules to load the valid data in the destination tables.

●Redesigned the existing stored procedures code by using merge statements, temp tables, table variables, CTE and exists clause to improve the performance of the stored procedures.

●Worked on the development of the database objects such as tables, constraints, indexes, views, table functions, scalar function, and referential integrity as per the requirement and business rules.

●Have in depth knowledge about indexes clustered index, non-clustered index, column store index, filtered, covering index.

●Upgraded MS SQL Server 2008 R2 database to MS SQL Server 2012, by using Detach/Attach, backup & Recovery.

●Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers.

●Developed ETL packages using SSIS/Informatica Power Designer for various customers to fetch data from different EDW sources.

●Loaded (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2 and SQL server.

●Developed SSIS packages for file transfer from one location to the other using FTP tasks.

●Worked on UNIX shell scripting in automation of ETL Jobs.

●Created the logs from the UNIX shell scripts for auditing the automated Workflow process.

●Performed migration of data from different databases like MS Access, MS Excel to SQL server.

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

●Used Team Foundation Server (TFS) for source version control on a shared team environment.

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

●Worked on Ad hoc Reports by writing Complex SQL using TOAD and SQL Developer.

●Enhanced the existing ECA (Error Correction Application) application based on the client requirements.

●Performed Documentation for all kinds of reports, DTS and SSIS packages.

●Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.

Environment: SQL server, Visual Studio Management Studio, OLAP, OLTP, SSIS, SSRS, T-SQL, JIRA, Python, MS Excel, DB2, GIT and Access.

Junior SQL Developer - Daraz

Kathmandu, Nepal - (November 2018 – September 2020)

Responsibilities:

●Involved in project meetings to walk through and review the functional and technical specifications with clients.

●Delegated Project based tasks to the offshore team. Communicated with the team about the project and business requirements.

●Deployed SSRS reports and data sources from SQL server data Tools to SSRS reporting server.

●Created Normalized database structure, database objects such as views table and stored procedure and designing of SSIS packages for extraction and transformation (data manipulation logic) of data from FTP folder based on the tickets from select staffing end user.

●Used ETL SSIS to develop jobs for extracting, cleaning, transforming, and loading data into data warehouses.

●Developed different SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).

●Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.

●Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel.

●Created different reports like tabular, matrix, ad-hoc, drill down and drill through reports using SSRS.

●While developing SSIS package extensively used executables such as for each loop, Sequence container, for loop, DFT (along with many transformations in DFT), execute SQL task, bulk insert task, FTP task, file system task, execute process task, execute package task, send mail task, script task.

●Eliminated duplicate data from staging tables and loaded the distinct data to PROD tables by creating stored proc for each staging table.

●Used big logics to develop stored procedures to align with the business rules and data requirement specially to load the data from staging tables to PROD tables.

●Used merge statements for DML operation in Stored procedures.

●Extensively used sub queries, correlated queries, temp tables, CTE, table variables in stored procedures.

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

●Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cubes.

●Created and Deployed Ad-hoc and Customized Reports to satisfy business needs using SSRS.

●Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.

●Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging areas and finally transfer into data marts.

●Managed all the published reports using the report manager. Controlling the user permissions to access the reports at site level, folder level and report level access.

●Used Lookup transformation and merge join to update the existing data with new data if it was not matched and loaded new data which did not exist in the PROD table.

●Extensively used event handlers, lookup, merge join, script component, union all, data conversion, derived column, conditional split, multicast, merge, sort, aggregate, row count, row sample for applying the business rules in SSIS packages.

●Handled error and given the production support for data issues related to SSIS packages and Stored procedures.

Environment: SQL Server, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#, SQL Server Analysis Services (SSAS), Microsoft Visual studio 2010, VB.Net, Python, T-SQL, Erwin, MS Excel, XML, SQL Profiler and Oracle.

Contact this candidate