SUMMARY

• Over 4+ years of experience in Data Modeling, Dimension Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2017/2016/2014/2012 for both OLTP (Batch Processing, Online Processing) & Kimball Methodology.
• Experience in various business domains like financial services, Insurance & healthcare, in high transactional and multi-server production environments.
• Strong T-SQL experience in creating database objects like tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes.
• Involved in relational data modeling (normalization, Relations) and multi-dimensional modeling using De-normalization, Fact tables, Dimension tables, Star schema for OLTP/OLAP systems.
• Involved in heavy data migration/ETL activities using BCP, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2016/2014/2012 ).
• Tuning teh performance of Stored Procedures and large T-SQL Queries using Clustered Indexes, DMV’s and efficient coding standards.
• Experience in using performance monitor/SQL Profiler to resolve Dead Locks/Long running queries thereby optimizing query execution plan.
• Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in creating packages to transfer data between ORACLE and SQL Server.
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in writing Stored Procedures in DW environment and then created packages in SSIS to load teh data into Data Warehouse. SSIS package calls these stored procedures for loading teh data.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in enhancing and deploying teh SSIS Packages from development server to production server.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.

TECHNICAL SKILLS

Programming Languages: C, C++, C#, .NET, SQL, TSQL, PL/SQL

RDBMS: MS-SQL Server 2012/2016/2017 , Oracle 11g, Microsoft Access, DB2

IDE Tools: Visual Studio.Net 2005/2008

ETL Tools: SQL Server Integration Services (SSIS) 20012/2016, DTS

OLAP Tools: SQL Server Analysis Services (SSAS) 2012/2016/2017

Reporting Tools: SQL Server Reporting Services (SSRS) 2012/2016/2017

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer.

Markup Languages: XML, HTML, DHTML

Data Modeling: ERWIN, MS Visio, Informatics

Software Testing: Manual Testing, Automation Testing(QTP, Win runner, Roadrunner)

Operating Systems: Windows 10, Windows 8 Advanced Server/Professional, Windows Server 2012, Windows NT, Windows XP Professional/Standard, Windows Vista Business/Ultimate, Windows 7 Ultimate, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

MS SQL Server\ETL Developer

Responsibilities:

• Performance tuning, and optimization of procedures and queries.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Running DBCC consistency checks, and fixing data corruption in application databases
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Designed cubes wif star schema using SQL Server Analysis Services (SSAS).
• Understanding teh OLAP processing for changing and maintaining teh Warehousing Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Created packages in SSIS wif error handling.
• Worked wif different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Has deployed packages on different servers by configuring it.
• Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
• Implemented computational sensitive queries Stored Procedures.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2012/2014 as SSIS Packages.
• Created SQL Server Profiler traces & used wif Database Tuning Advisor (DTA) for optimum performance of queries.
• Developed DTS packages to extract, transform and load into teh Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS).
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Involved in migration from SQL Server 2008 to SQL Server 2012/2014.
• Implemented Complex business logic wif User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Written DDL / DML Triggers as per company policy.
• Monitoring SQL Server logs to ensure teh backup operations, batch commands, or other scripts and processes has completed successfully.
• Rebuilding indexes on various tables.
• Developed database monitoring and tuning strategies.
• Worked wif development teams in teh design of physical databases and in modification.

Confidential, Long Beach, CA

SQL Server ETL Developer\Data Analyst

Responsibilities:

• Performed Server installation and configuration using SQL Server 2008.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views, Rules, Defaults and complex SQL statements.
• Involved in XML Development and XML File Parsing in SSIS and SSRS.
• Developed teh PL/SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Created automated stored procedures for day end operations using SQLServer agent.
• Coordinated wif front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Snapshot Replication was been used to synchronize teh data between their Different Stores.
• Scheduled Database and Transactional log backups using teh Database Maintenance Plan Wizard in SSIS.
• Involved in SQL Server Mirroring and Database optimization.
• Created and monitored database maintenance plans for checking database integrity in SSIS.
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS,SSAS.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created teh automated processes for teh activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2014 (SSAS).
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2012 Analysis Services (SSAS).
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Enhanced teh functionality in database and data ware housing concepts (OLAP, OLTP)Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2014(SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Generated Reports using Global Variables, Expressions and Functions for teh reports using SSRS 2014.
• Developed Query for generating drill down reports in SSRS 2014.Prepared AD HOC reports through report builders.
• Used DBCC commands to troubleshoot issues related to database consistency.

Confidential, Sherman oaks, CA

MS BI/SQL Developer

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, sub-queries, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules.
• Experience in creating joins for complex queries involving multiple tables.
• Implemented teh Error handling in teh Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on teh requirement.
• Involved in query optimization and tuning stored procedures for better performance.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on different kinds ofTransformations (Data Conversion, Lookup, Derived Column, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Slowly Changing Dimension, Union All etc)inSSISas per teh clients Requirement.
• Experience in providing Error handling by using Event Handler for SSIS Packages.
• Configured and maintained Report Manager and Report Server for SSRS.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2014.
• Involved in Migration of SSRS 2005 to SSRS 2014.
• Created Report Layouts and Deployed teh Reports using SSRS 2012.
• Identified and worked wif Parameters using complex expressions for parameterized reports in SSRS
• Built teh SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using dis data using SSRS.
• Generated teh weekly, monthly, and quarterly reports by using SSRS.
• Hands in improving performance of reports by caching them.
• Created data loads and Upgrade scripts for data migrations and validations.
• Studied teh existing OLTP system(s) and Created facts, dimensions and star schema representation for teh data warehouse.
• Involved SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point 2007/SharePoint Server.
• Scheduled reports to refresh and run on daily, weekly and monthly basis in teh report manager and SharePoint.