SUMMARY

• 8+years of Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2016/ 2014/2 in Development, Test and Production Environments on various business domains like Financial, Insurance, Healthcare and Banking.
• Experienced in creating and using Stored Procedures, Views, User Defined Functions, Sub - Queries and Joins for complex queries.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance in OLTP and OLAP environments.
• Extensive Data Warehousing experience in Business Requirement Analysis, Design, Development, Testing, Implementations, Loading, Maintenance, Enhancements of Data warehouse, and ODS systems using Oracle, DB2, SQL Server, Teradata and well versed with Data Warehousing Architecture Technology, Operational Data Store, and Dimensional Data Modeling.
• Excellent Report creation skills in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports, using Report Designer as well as Report Builder in SQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS).
• UNIX shell scripting was used for scheduling batch jobs. The system was used to run batch processes and reports that utilized PL/SQL and Oracle Reports.
• Migrated Stored Procedures, tables, functions and packages from Oracle to SQL Server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Developed Drill Down, Cascading, and Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users.
• Migrated SQL server 2005 DTS to SQL Server 2008 and above into SSIS packages in coordination.
• Created Linked Servers between SQL Server 2012/2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Expertise in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experience in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Working knowledge of .Net Framework (VB.NET and C#.NET), IIS Web Server, Agile Methodology.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/2003/2000 Windows 10/7/XP/Vista, Linux.

Languages: T-SQL, PL/SQL, UNIX Shell Scripting C#.Net, VB.Net, ASP.Net, XML, HTML, Python, SAS, No SQL,Azure.

Tools: /Utilities: Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL * Plus, Toad, Ervin, COSMOS, GIT, TFS, Hive, Power BI,.

Databases: MSSQLServer 2016/ 2014/2, Oracle 10g/9i, MS Access.

Data Modeling Tools: Microsoft Visio, UML

Software: MS Office 10, Adobe Dreamweaver, Adobe Photoshop, MS Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, Tableau.

PROFESSIONAL EXPERIENCE

Confidential, Wayne, MI

Sr. SQL/BI Developer

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and SQL joins for applications.
• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012/2014/2016.
• Extracted data from various sources like SQL Server 2012/2014, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server.
• Migrated the data from SQL Server 2008 to SQL Server 2012, 2016 and ORACLE to SQL Server.
• Develop and load the data from external file systems such as MUREX, INTEX, IDEAS, YIELDBOOK and ALM etc. using SSIS Package.
• Developed/Supported Intranet-based applications for corporate-wide use extensively used T-SQL (DDL, DML), C#, ASP.NET for web services.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports using MSBI (SSRS).
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Created source, stage and archive folders as per the requirements using expressions in file system task.
• Performed different types of loads: Incremental Load, Optimized Load and Binary Load.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and 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.
• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: SQL Server 2016/ 2014/2012/2008 , DTS, SSIS, SSRS, Microsoft Visual Studio, SQL Server OLAP 2012, Team Foundation Server (TFS), T-SQL, MS Access, Windows 2008 Server.

Confidential, South SF, CA

Sr. SQL/BI Developer

Responsibilities:

• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily in SQL Server Agent.
• Created several SSIS packages to load data from different sources like Oracle, Informix to SQL server database.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Designed and created reports using SSRS, Crystal Reports with drop down menu and linked reports.
• Created email and windows share subscriptions to provide daily basis reports and managed and troubleshoot report server related issues.
• Designed and implemented Parameterized and cascading parameterized reports.

Environment: SQL Server 2014/2012/2008 Enterprise Edition, SSIS, SSRS, .NET, Erwin, T-SQL, Windows 2008/2003 Server, XML, MS Excel, MS Access, Visual Studio 2010.

Confidential, Omaha, NE

Sr. ETL Developer

Responsibilities:

• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Created Charts, graphs using SQL Server Reporting Services 2008/2008R2 (SSRS).
• Created ETL packages using Heterogeneous data sources (SQL Server, Flat Files and Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Involved in title on boarding process for newly on boarded titles of Xbox studios to allow flow of data from sourcecosmostoSQL destination.
• Developed complex stored procedures using T-SQL to generate Ad-hoc reports within SQL Server Reporting Service (SSRS).

Environment: Windows Forms, C#, Microsoft SQL Server 2012/2008R2, COSMOS,BIDS, Team Foundation Server (TFS), Windows server 2003, Internet Information Server (IIS), OLTP.

Confidential, Jersey City, NJ

Sr.SQL/SSIS Developer

Responsibilities:

• Developed variousT-SQL stored procedures triggers, views,and adding/changing tables for data load and transformation, and data extraction.
• Created Database Objects likeTables, Stored Procedures, Views, Triggers, and UDFs.
• Created complex queries involving CTE’s, Sub-queries and Joins.
• Hands on experience with epic tool.
• CreatedIndexesfor fast retrieval of the data. Involved inPerformance tuningandQuery Optimization using execution plan.
• CreatedSSISpackages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.
• DeployedSSISPackages from Dev/Staging/Production using Package Configurations

Environment: SQL Server 2005, SQL Server 2008 R2, SSIS, MS Excel, SQL Profiler, ETL, T-SQL, MS SQL Server Reporting Services.

Confidential, Carmel, IN

MSBI Developer

Responsibilities:

• Involved in Creating Database Objects like Tables, Stored Procedures, Views, Triggers, and user defined functions for this project.
• Gathered Requirements from the end user and involved in developing logical model and implementing requirements in SQL Server.
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Email Task and Data Flow Task.
• Used to design SSIS Packages to connect to hetero genius sources and pulling data from source and loading into data warehouse.
• Used different destinations like OLE DB Destination, Flat file, Excel destinations and different sources like Flat file and OLE DB Source, CSV files.
• Creation of work flows with Data flow, Execute SQL task, and Execute package tasks And Containers.
• After loading the data, I used to generate name type of reports according to the client Requirement.
• Responsible for creating reports based on the requirements using Reporting Services.
• Wrote queries for drill down reports to get the dataset required to build the report.
• Deployed generated reports onto the Report Server to access it through browser.

Environment: SQL Server 2005/2008, DTS, SSIS, SSRS, Microsoft Visual Studio 2005, SQL Server OLAP 2005, Reporting Services 2005, T-SQL, MS Access, Windows 2003 Server.

Confidential

SQL/BI Developer

Responsibilities:

• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints.
• Used DDL and DML for writing stored procedures, CTE, Temp Tables and data manipulation.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Developed complex stored procedures using T-SQL to generate Ad-hoc reports within SQL Server Reporting Service (SSRS).
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Created ETL packages using Heterogeneous data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Creating large number of stored procedures and created parameterized SSIS Packages to move data from different sources to target.
• Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Creating ad hoc queries according to business need and tuning existing queries to meet business standards.
• Involved in writing data migration scripts from old system to new system using stored procedures.

Environment: ASP.net, C#, Microsoft SQL Server 2005/2008R2, BIDS, Team Foundation Server (TFS), Windows Server 2003/2008, Internet Information Server (IIS).

Confidential

SQL Server Developer

Responsibilities:

• Used Execution Plan, SQL Server Profiler and Database Engine Tuning Advisor tools to trace the slow running stored procedures and tried to optimize the queries to improve performance.
• Created complex stored procedures, triggers, cursors, and views and other SQL joins and statements for applications.
• Developed complex T-SQL code for the application and provided ongoing technical support in the production environment.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Troubleshooting and maintaining the databases and partitioned the tables for better performance of databases.
• Creating and Rebuilding Indexes, Manage Database Security through Encryption.
• Performance monitoring/interpreting alert log and trace files.
• Export / import schema, table, full database using data pump, reorganize table space.

Environment: MSSQLServer 2008 R2, MS Windows XP, Windows Server 2008 R2, Visual Studio 2010, Query Analyzer, MS Visio Professional 2007, Excel,SQLProfiler, T-SQLC#.