SQL/SSIS/SSRS/BI Developer

Name: Susma Gurung

Location: Pinole, CA 94564

Phone: 510-***-****

Email: ad3lqo@r.postjobfree.com

Summary:

A SQL Developer with more than 5 years of experience in Database Design, Development and implementation of Data Warehouse BI Solutions, Database Programming, Data Modeling, Testing of SQL Server 2022/2019/2017/2012

Strong Customer Centric Approach, with Process Orientation; Motivated by internal standards of performance to deliver quality results.

Extensively involved in all phases of software development life cycle (SDLC) and experience in Agile / Scrum and Project Management Methodologies.

Experienced in Analysis, Design, Implementation, Testing, and debugging new and existing client-server-based applications. Have strong experience in reverse engineering the back-end code.

Highly proficient in the use of T-SQL and PL-SQL for developing complex Stored Procedures, indexes, Tables, Views, User Defined Functions, Relational Database models, Data integrity and SQL joins.

Well - versed with database Installation, configuration, maintenance, monitoring, backups and recoveries.

Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.

Experienced in using T-SQL for developing complex Stored Procedures, Triggers, and Functions.

Extensive experience in creating Tables, Views, Indexes and SQL joins on query writing.

Created, altered, maintained system roles and permissions to users on various database objects.

Strong debugging skills and the ability to solve complex problems.

Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.

Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures.

Good knowledge of System Development Life Cycle (SDLC).

Expert in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.

Migrated Organization, Orders, Adjustments, Objectives and data in various formats like text-based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.

Skilled in using tools like Bulk Copy (BCP) and Data Transformation Services (DTS) and SSIS with MS SQL Server 2022/2019/2017/2008R2.

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

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

Proficient in working with data profiler.

Adept in defining referenced relationships and calculated members in SSAS.

Worked in developing and extending SSAS cubes, dimensions, and data source view SSAS-data mining models and deploying and processing SSAS objects.

Experienced in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services .

Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters.

Experienced in sorting the data, defining subtotals for reports and designing report layout.

Extensive knowledge on creating reports using Tablix control properties in SSRS

Ability to create table-valued functions on SSRS reporting services.

Experience in administrating the created reports and assigning permission to the valid users for executing the reports.

Expert in creating the MDX cubes and dimensions (SSAS), defining referenced relationships in SSAS, defining granularity within a measure group and drill through actions.

Involved in the SSAS storage and partitions and aggregations, Calculating queries with MDX data mining models.

Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).

Experience in designing data warehouse Data marts in Kimball Methodology.

Hands on experience with Netezza tool in data warehousing.

Expert in MS SQL Server suite of products like SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).

Experience in working with VB.Net

Good understanding of business objects web intelligence tool.

Excellent Communication, Trouble-Shooting, Team Player, Able to Work with a new and fresh perspective on work assignments, creative and quick learner of new technological developments.

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

Technical skills:

Operating Systems: Windows Server, XP/Vista/7/10, Advanced Server.

Databases: MS SQL Server 2022/2019/2017/2016, 2014, 2012, Oracle 11g, MYSQL, MS-Access.

Reporting Tools: SQL Server Reporting Services (SSRS), Power BI, Crystal Reports, Tableau.

Analytics Tools: SQL Server Analysis Services (SSAS)

ETL/Database Tools: T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS)

Web Technologies: HTML, XML, VBScript, CSS, Azure SQL Database

Other Software Tools: SQL Profiler, MS Office/Excel, MS Project, SharePoint, MS Visio, C#, Microsoft Team foundation server

Projects Summary:

Company: HCA HealthCare

Location: Irving, TX

SQL BI Developer (Feb 2022 - Present)

Technical Environment:

MSSQL Server 2022/2019, SSIS, SSRS, SSAS, TSQL, Power BI, MS Excel, MS Access, TFS, OLAP, Oracle 9i, Visual Studio 2022/2019.

Responsibilities:

Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases and into Siemens Servers using SQL Server Integration Services SSIS.

Designed ETL workflows to load data into Staging / Landing, Data Mart / Data Warehouse databases for full, incremental and remigration of data.

Proficient in Dimensional modelling, defining dimension attributes, hierarchies and different types of fact tables and measuring granularity.

Implemented ETL workflow packages using SQL Server Integration Services (SSIS) to extract, clean, transform, and load data into data warehouse.

Experienced in designing SSIS packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, flat file, OLEDB) by using multiple transformation provided by SSIS such as Data Conversion, conditional split, merge, union all etc.

Created Sub Reports and Drill down Reports as per the client requirements using SSRS

Extensively used SSIS Import/Export Wizard, for performing the ETL operations

Involved in all phases of System Development Life Cycle (SDLC)

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

Extensively designed the packages and data mapping using Data Profiling Task, Control Flow Task, Sequence Container Task, Dataflow Task, Execute SQL Task, Data Conversion Task, Derived Column Task and Script Task in SSIS Designer

Created List reports, Standardized Reports, On-Demand Reports, Cross tabs Reports, Drill-down Reports, Ad hoc Reports, Charts, Functions and Formulas using SQL Server Reporting Services (SSRS)

Configured report server in development and production and also created SQL Server Reports using SSRS from initial stage

Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions

Created Views to reduce database complexities for the end users

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 2022/2019.

Created trend charts using SQR (SSRS) and also created paretos and trend charts using visual basic.

Created Views for Dimension and Fact Tables in Staging for more flexibility.

Created Indexes on Tables to improve the performance.

Created DTS package to export and import data from SQL Server to Access, text and EXCEL files.

Performed Data Validation to ensure data integrity in source, staging, core and destination database for the Data Mart Project.

Created functions, procedures, triggers for Reporting Objects.

Created SSIS packages for importing and exporting data from Excel, Flat file, Oracle

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

Created a table to save dirty records

Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)

Debugged and optimized several complex stored procedures

Constructed cubes based on data volumes mostly adhering to Star Schema.

Used Power BI to create self-service BI capabilities and use tabular models

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

Extensively used SSIS Import/Export Wizard, for performing the ETL operations

Actively supported business users for change requests

Planned the complete Back-up of various Databases for Disaster recovery scenarios.

Identified and added the report parameters

Company: Fremont Bank

Location: Walnut Creek, CA

MS SQL Server Developer/SSIS/SSRS Developer (May 2020 - Jan 2022)

Technical Environment:

MS SQL Server 2019/2017, Windows Server 2012, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS, SQL profiler, Power BI, Performance Monitor, Query Optimizer, T-SQL, Agile, XML, ETL, Microsoft Visio 2003, MS Visual Studio 2012, Composite Studio 6.1, Oracle 11g, Team Foundation Server (TFS), Base SAS, Enterprise guide, Enterprise miner, Integrated studios.

Responsibilities:

Created complex Stored Procedures and Functions to support the front-end application.

Created database triggers to implement business requirements.

Monitored growth of database objects for capacity planning and involved in tuning the database and T-SQL queries using Explain Plan.

Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.

Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, DB2 etc. to SQL Server

Created SSIS package to load multilevel XML data into SQL SERVER database.

Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.

Designed SSIS packages to export and import data from SQL Server to MS Access, text files and Excel files.

Used SSIS transformation for Data Cleansing to remove unnecessary data.

Expertise in creating Reports, Sub Reports, drill down reports using various features like Charts, filters etc.

Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down, and Cross Tab Reports in SSRS.

Created report models for ad-hoc reports using SSRS 2017.

Designed and created Report templates, bar graphs, pie charts based on the financial data.

Generated periodic reports based on the statistical analysis of the data using SSRS 2012.

Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and also generated reports using Crystal Reports.

Building BI capabilities in an organization, with specialized capabilities including Business Intelligence (BI).

Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.

Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.

Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.

Created Power BI Dashboards (Power View, Power Query, Power Pivot, and Power Maps) and integrated them to share point.

Experienced in maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI (Power Pivot, T-SQL, Excel pivot tables).

Used DAX expressions in MS Power BI Desktop.

Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.

Used to resolve on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

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

Developed and created data dictionary, advanced queries, views, indices, and functions for databases.

Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.

Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.

Used all SAS products like Enterprise Miner, Enterprise guide, add in for Microsoft to do analysis on all the records generated.

Gathered Business Requirement specification, Table specs and functional specification documents and communicated with the marketing manager to know the type of reports to be developed.

Company: CVS Health

Location: Hacienda Heights, CA

Jr. SQL Developer (June 2018 - Apr 2020)

Technical Environment:

MS SQL Server 2012, SSIS, SSRS, SSAS, TFS, Microsoft Visual Studio 2008/2010, SQL Server Management Studio, MS Excel, T-SQL, DB2 Mainframe, MS Access, Report Builder 2.0/3.0, Windows Server 2012, Microsoft Business Intelligence Development Studio (BIDS), OLTP, OLAP, Report builder, SSAS, XML, MS-EXCEL, SQL Server Profiler

Responsibilities:

Designed and created SQL Database, tables, indexes, and views based on user requirements.

Created User Defined Functions, cursors, and Triggers.

Created & used stored procedures for database transactions in SQL Server.

Created tables, views, clustered & non-clustered index, user defined data types and functions.

Developed stored procedures and views for managing efficient data retrieval.

Wrote various Stored procedures for the purpose of application development

Developed backup & restore scripts for SQL Server as needed.

Created joins and sub-queries for complex queries involving multiple tables.

Used multiple join statements to retrieve data from multiple tables.

Used database consistency checks using DBCC utilities.

Generated Reports into Excel Spreadsheet form from SQL server6.5/7.0 using Reporting Services.

Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.

Designed the Forms & created Reports using Form Builder & Report Builder in Developer 2000.

Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.

Worked in enhancing the bug/issue tracking system used by the entire team, to produce flexible reporting with respect to the life cycle of an issue.

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Developed and maintained relational databases.

Developed Reports to generate daily, monthly, quarterly, yearly reports using Crystal Reports.

Generating ad-hoc reports using MS-Excel and Crystal Reports.

Scheduled jobs and alerted using SQL Server Agent.

Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.

Education:

Bachelor’s degree

Contact this candidate