SUMMARY

• Over 8 years of IT working experience in SQL Server database developing and implementing using SQL Server 2014/2012/2008 R2/2008/2005, Microsoft SQL Server integration services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS) and MDX for data warehouse and data mart solutions in Financial, Retail, Healthcare, and Insurance.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS) and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
• Experience in working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experience in using Performance Monitor, SQL Profiler and Database Tuning Advisor to solve Dead Locks / long running queries.
• Expertise in Developing and Tuning T - SQL, PL/SQL Complex Queries, Stored Procedures, UDF’S, triggers, views, Indexed views, and error handling using Try-Catch blocks.
• Created and supported daily/weekly/monthly jobs using SQL Agent and Control-M.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server using multiple control flow and Dataflow Tasks.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Created many complex SSIS packages with transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Data Conversion, Fuzzy Lookup, For Loop, For Each Loop, Slowly Changing Dimension etc.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Strong Experience in creating different formats of reports for internal and external reporting purposes including Ad Hoc, parameterized reports, Linked reports, Snapshots, Tabular, Matrix, Drill Down, Drill Through using SQL SSRS.
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using MDX in SSAS.
• Experience in Dimensional Modeling, ER Modeling, FACT and Dimensional Tables and Operational Data Store (ODS).
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS
• Experience on Tableau Reports, dashboards, scorecards and strong background in SQL stored procedure development and triggers.
• Expertise in Relational Database Management Systems, including Normalization and De-Normalization techniques, Constraints, Querying, Joins, Keys, Functions, Data Import/Export, cursors.
• Experience in making sure that storage, archiving, back-up and recovery procedures are working correctly.
• Proficient with creating Use Cases, Sequence Diagrams, Component Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Expertise in problem-solving of application issues and production errors, including high level critical production issues that require immediate attention.
• Ability to handle multiple tasks and assignments concurrently in cross-functional teams and a self-motivated flexible team player with excellent communication skills, analytical skills and total commitment to the organization goals.

TECHNICAL SKILLS

Operating System: Windows XP/VISTA/7/8/10, IOS, Unix

Programming Languages: T-SQL, SQL, C, PL SQL, ASP.NET, JAVA,C#

Web Technologies: HTML, XML, WCF.

RDBMS: MS SQLServer2012/2008R 2/2008/2005/2000 , Oracle Database 11g/10g/9i.

BI Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Performance Point Server 2007, Tableau Desktop 8.3, Tableau Server 8.3.

Data Modeling Tools: Visual Studio 2005/2008/20012/2015 , MS-Visio, Erwin 7.2/4.5, Metadata Manager, Informatica tool.

Database Query Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Query Analyzer, SQL Profiler.

PROFESSIONAL EXPERIENCE

Confidential, Oakland, CA

SQL/SSIS Developer

Environment: MS SQL Server 2012/2014, Visual Studio 2012/2013, MS SQL Server Data Tools (2012), Microsoft Access, Microsoft Visio, MS Office 2010

Responsibilities:

• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
• Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL Server Agent.
• Creating large number of stored procedures and created parameterized SSIS Packages to move data from different sources to target. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Good Expertise in using Source Control Tools such as Team Foundation Server (TFS) and maintain a Repository of the T-SQL, SSIS developments.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• Created ad hoc queries according to business need and tuning existing queries to meet business standards.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS. Configured and maintained Report Manager and Report Server for SSRS.

Confidential, Mattawan, MI

SQL server/SSRS Developer

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS), Visual Studio 2013, Windows XP, T-SQL.

Responsibilities:

• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
• Created SSIS packages for Uploading of different formats of files (Excel, Access, DBF) and databases (SQL server, Flat files) into the SQL Server database using SQL Server Integration Services (SSIS).
• Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
• Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Optimized and Aggregated cubes with 40% performance for better performance.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Used subqueries, joins, CTE's and analytical functions for data retrieval for reporting needs.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Involved in Performance Tuning of queries by interpreting execution plan and SQL profiler.
• Created Clustered and Non-Clustered Indexes on tables to improve performance of reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012.
• Created many Ad-Hoc Reports, Summary Reports, Tabular Reports, Matrix Reports using SSRS.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Created Parameterized reports and Linked reports and possess thorough knowledge of report serving architecture using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analysts and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.

Confidential, San Antonio, TX

SSIS Developer

Environment: Windows 2007, MS SQL Server 2008/2008R2, MS Office, Microsoft Visual Studio, Database Engine Tuning Advisor, SQL Server Management Studio 2010, SSIS, SSRS, MS-Access, Intelligence Development Studio, SQL Server Data Tools.

Responsibilities:

• Create various database objects and implement referential integrity constraints for enforcing data integrity and business rules.
• Developed SSIS packages for migrating data from staging area of SQL Server 2008R2 to SQL Server 2012.
• Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Automated execution process, scheduling, deploying of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and FTP.
• SQL Server installation and administration on SQL 2008 for development and test server, 2008 R2 for UAT and production server and 2012 for report server.
• Developed T-SQL queries, scripts and stored procedures used for extracting, validating, transforming and loading data provided by clients.
• Respond to ad-hoc requests from Business Analyst and Project Managers by providing accurate data/reports in a timely manner.
• Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.
• Installed and administered Microsoft SQL Server Integration Services and SQL Server Reporting Services.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS various features like multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion etc.
• Created SSRS reports using complex SQL Queries/Stored Procedures which have sub-reports, Drill-Down reports and charts.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules as per the Client requirements.

Confidential

MS SQL Developer

Environment: Visual Studio 2005/2008, SQL Server 2008/2005 Enterprise Edition, SharePoint Server, Microsoft Business intelligence development studio(MSBI) SSIS, SSRS, SSAS, OLAP, Crystal reports 10, Oracle, Share Point Services, VB.net, and Windows Server 2003.

Responsibilities:

• Extensively involved in understanding the requirement provided by the client and analyzing the functional specification and discussing issues with business analysts.
• Working knowledge of various kinds of records (patient records, insurance data, lab records, medical records, Medicare records, Medic Aid records), and implementing rules using HIP AA constrains.
• Worked on writing T-SQL code for complex stored procedures to extract all the claims data based on the diagnosis code, member eligibility for plans.
• Also created claims detail report as a part of Medicare PQRI program to support any queries received from providers needing further explanation on bonus checks for customer service department.
• Created reports with Drop Down menus and multi-select variables as parameters which are passed to stored procedure to populate the report accordingly.
• Worked with SSIS for creating ETL jobs in migration of data from one database to other.
• Created different SSIS Packages for performing various automated tasks using controls and components elements of SSIS Package.
• Experience in Scheduling the SSIS packages for automatic process of extract transform and load (ETL).
• Worked on performance issues of the T-SQL queries and stored procedures which were early executing for more than 1 hour.
• Designed and optimized various T-SQL database objects like tables (schemas), views, stored procedures, User Defined functions (UDF), indexes and triggers using Management Studio and SQLProfiler.
• Responsible for Unit testing of the reports before moving them for validation by the Business Analysts.
• Responsible for cleansing up database for maintenance work.

Confidential

SQL/Business Intelligence Consultant

Environment: MS SQL Server 7.0/2000, T-SQL, Query Analyzer, SQL Profiler, Enterprise Manager, Windows Server 2000.

Responsibilities:

• Installed & Configured SQL Server 2000 for Development Purpose
• Migrated certain packages from SQL server 7.0 to SQL server 2000.
• Created DTS packages to transfer the data from Oracle to SQL Server 2000
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Converted various SQL statements into Stored Procedures thereby reducing the Number of database accesses.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Created Indexes, Constraints and Rules on database objects.
• Created and modified Clustered and Non-Clustered Indexes to optimize the queries using Index Tuning Wizard.
• Designed and developed MS SQL Server Stored Procedures using T-SQL statements from scratch.
• Developed Triggers on Views to populate base tables.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Create stored procedures and user defines functions to supports efficient data storage and manipulation.
• Handling database objects with Enterprise Manager.
• Provided Technical Documentation for future enhancements.