SUMMARY:

• 5 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 the 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 the data into Data Warehouse. SSIS package calls these stored procedures for loading the 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 the 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.

PROFESSIONAL EXPERIENCE:

Confidential, CA

ETL Developer \Data Analyst

Responsibilities:

• Created packages in SSIS with error handling and logging.
• Created complex Stored Procedures, tables, views and other SQL joins statements for reports using T-SQL.
• Utilizing statistical techniques to interpret data, analyses results and produce comprehensive reports.
• Evaluating complex data sets in order to identify, analyses and interpret trends and patterns
• Implemented automated data processes, services and tools to support data extraction, validation and cleansing using EXCEL, SSIS and SQL Server Agent

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 and recovery.
• 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 with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Have 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 with Database Tuning Advisor (DTA) for optimum performance of queries.
• Developed DTS packages to extract, transform and load into the 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 with 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 the backup operations, batch commands, or other scripts and processes have completed successfully.
• Rebuilding indexes on various tables.
• Developed database monitoring and tuning strategies.
• Worked with development teams in the 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 the 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 with 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 the data between their Different Stores.
• Scheduled Database and Transactional log backups using the 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 the automated processes for the 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 the 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 the 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 the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on the 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 of Transformations (Data Conversion, Lookup, Derived Column, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Slowly Changing Dimension, Union All etc) in SSIS as per the 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 stylish Report Layouts and Deployed the Reports using SSRS 2012.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS
• Built the 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 this data using SSRS.
• Generated the 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 the existing OLTP system(s) and Created facts, dimensions and star schema representation for the 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 the report manager and SharePoint.

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