PROFESSIONAL SUMMARY:

• 7+ years of experience in Database Design, Development, Implementation, and Tuning of Relational Database Systems using MS - SQL Server 2008/2008R 2/2012/2014/2016/2017 covering various domains.
• Experienced in managing SQL Server and writing T-SQL (DDL, DML and TCL) statements; and in creating and maintaining SQL Server database objects such as Tables, Views, Stored Procedures, User Defined Functions, Triggers, Indexes, and Cursors.
• Well experienced using table variables and Common Table Expressions (CTEs).
• Experienced in developing complex SQL queries, and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.
• Demonstrated experience in Extraction, Transformation and Loading (ETL) tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Data Stage, ETL package design, and RDBM systems.
• Experienced in designing SSIS packages for different Data Flow and Control Flow processes.
• Experienced in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, and Snowflake Schema.
• Well experienced in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Generated various Drill-Down Drill-Through reports, Parameterized reports, Tabular reports and Matrix reports using SQL Server Reporting Services (SSRS).
• Managing and securing reports using SSRS. Created report schedules.
• Experienced in developing Business Intelligence (BI) solutions for Decision Support Systems using SSIS, SSRS, SSAS, and Power BI.
• Experienced in Data Modeling using SSMS, Erwin, and Lucidchart.
• Skilled in working with stakeholders and end users to meet business requirements and experienced in the proper documentation of records.
• Experienced in developing and maintaining data warehouse’s functionality; and developed multi-dimensional objects and Cubes using SQL Server Analysis Services (SSAS).
• Experienced with working on Agile Projects with multiple Sprints Cycles and Scrum meetings, and on Water Fall projects with full Software (System) Development Life Cycle (SDLC).
• Strong interpersonal and communication skills; competitive analytical, logical, and problem solving skills; strong management, administrative and leadership skills; and active and self-learning abilities.
• Detail oriented, working under pr e ssure, and meeting short dea dli ne s with e x ce pti ona l p roble m solvi ng a nd de c isi on-making a na l y ti ca l skil ls a nd strong tea m wo rk spirit .

SKILL SET:

Databases: Microsoft SQL Server 2008/2008R 2/2012/2014/2016/2017/ Oracle 11g/12c, MS-Access

Languages: T-SQL, SQL, PL/SQL,.Net(C#,VB), XML

Database Tools: SQL Server Management Studio (SSMS), SQL Profiler

ETL Tools: SSIS, DTS, BCP, Import/Export Wizard

Reporting Tools: SSRS, Power BI

OLAP Tools: SSAS

Modeling Tools: Erwin, Lucidchart

Operating Systems: Windows Server XP/ 2000/2003/2008/2012

Other Tools: Microsoft Office 2003/2007/2010/2013 ; Agile Methodology

PROFESSIONAL EXPERIENCE:

Confidential, Riverside, Rhode Island

SQL Developer/ETL Developer

Responsibilities:

• Developed complex T-SQL codes to create/update database objects such as Tables, Views, Stored Procedures, User Defined Functions, Triggers, Indexes, and Cursors.
• Used Joins, Correlated and Non-Correlated Sub-Queries for complex business queries involving multiple tables & calculations from different databases.
• Experienced with Dynamic SQL, and developed procedures utilizing the functionality.
• Used SSIS to create ETL packages to Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging Database.
• Extracted data from different sources (CSV, Excel, and MSSQL and Oracle database sources) and load to Data Warehouse using SSIS complex data transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split, Lookup, Fuzzy Lookup, Slowly Changing Dimension, Derived Column, Row Count, and more) for existing/new packages.
• Developed SSIS packages using For Each Loop Container in the Control Flow elements to process all Excel files within folder; File System Task to move file into Archive after processing; and Execute SQL task to insert transaction log data into the SQL Table.
• Well experienced in using Table Variables and Common Table Expressions (CTEs).
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database using SQL Server Agent. Also, involved in deployment of SSIS Packages.
• Used advanced features of T-SQL in order to Design and Tune T-SQL to interface the database and other applications in most efficient manner.
• Generated Sub-Reports, Cross-tab, Conditional, Drill-Down reports Drill-Through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Experience on working in Agile/Scrum environments.

Environment: MS SQL Server 2012/2016, DTS, MS Access, SQL Query Analyzer, MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), TSQL, PL/SQL, SQL Profiler, Windows Server 2000/2012, Microsoft Office.

Confidential, Rockville, Maryland

SQL/SSIS/SSRS Developer

Responsibilities:

• Developed Stored Procedures and Functions used for inserting, updating, or transforming data. Also, created scripts for tuning and scheduling
• Created new tables and wrote stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Creating table indexes and constraints to ensure data integrity and enhance query processing and come up with efficient data retrieval.
• Extensively involved in created SSIS packages to migrate data from different data sources to data warehouse.
• Analysing Business Intelligence Reporting requirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas and Snowflake Schemas.
• Created SSRS Summary Reports, Sub Reports, and Drill-down Reports (on demand and periodic) by using Expressions.
• Importing Source/Target tables from the respective databases by using Execute Package Task using Control Flow Tasks in SSIS.
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequence Container, Email Task and Data Flow Tasks.
• Involved in enhancing and deploying the SSIS Packages from development server to production server.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Scheduled the ETL Package, Email, and Stored Procedures.
• Developed different reports and visualization solutions for internal and external reporting purposes.

Environment: MS SQL Server 2012/2014, MS Visual Studio 2012/2014 (SSIS/SSRS), Power BI, Microsoft Excel, Outlook, MS SQL Profiler, Windows Server 2008/2012.

Confidential .Delray Beach, Florida

SQL/BI Developer

Responsibilities:

• Involved in gathering business Requirement.
• Performed Data Modeling and developed Logical and Physical Models using Erwin and implementing them to SQL server. Designed database, tables and views structure for the application.
• Designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.
• Created/Updated Stored Procedures, Triggers, Functions, Cursor, Views, and Indexes with extensive use of T-SQL.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using SSDT.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Designed, coded and implemented ad-hoc reports using existing report models in SSRS.

Environment: MS SQL Server 2008/2012, MS Access, Oracle, MS SQL Server Integrated Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), TSQL, PL/SQL, SQL Profiler, Windows 2003/2008, Microsoft Excel.