T-SQL, SQL, SSIS, SSRS, ETL

Professional Summary:

Over *+ Years of extensive IT experience in design, development and analysis of Microsoft SQL Server 2005/2008/2008R2/2012/2014/2016 and successfully worked as a SQL Server Business Intelligence tools (BIDS) developer with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) implementing technical skills along with interpersonal skills as per business needs.

Hands on experience in all phases of SDLC (Software Development Life Cycle) involving Requirement analysis, Software design, development, implementation, testing and maintenance.

Experienced in extracting, transforming and loading the data using SSIS in SQL Server 2005/2008/R2and Data Transformation Services in SQL Server 2000.

Expertise in Relational and Dimensional Data Modeling, RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Warehouses. Experience in design and implementation of On-Line Transaction Processing (OLTP) and On-Line Analytical Processing (OLAP).

Expert in using Complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables, Views, Indexes and T-SQL queries (DDL and DML).

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key& Foreign Key Constraints.

Experienced in SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services).

Experienced in implementing ETL – Extract Transform and Load Packages using Data Transformation Services (DTS) and SSIS (SQL Server Integration Services) 2005/ 2008/2008R2.

Strong experience in developing SSRS Reports, Developed Standard Reports, Sub Reports, Cross Tab Reports, Drill down Reports, Drill through Reports, Used various Charts and graphs like Bar Chart, Line graphs, Pie Charts.

Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.

Worked on Power BI and prepared dashboards using Tableau to make it more attractive.

Extensively involved in T-SQL performance tuning to enhance the performance of the complex queries for Reports, Packages and other business logic.

Skilled in Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS object

Experience in creating complex SSAS cubes with multiple fact measures groups, KPIs, dimensions.

Technical Skills:

Databases: SQL Server 2008/2012/2014/2016, MS Access 2000, MS Excel, Oracle 9i/10g,

Mainframes, DB2, Teradata (V2R12).

Programming Languages: T-SQL, PL/SQL, Teradata SQL, C, C#, XML, ASP.Net, HTML, Python.

Operating Systems: Windows 2003/XP/NT/Vista/2008/2010, Windows 2000 Advanced Server, Windows 2003 Enterprise Server.

IDE & BI Tools: SQL Server BI Development Studio (BIDS), SharePoint, Power BI, MS Visual Studio

2013/2010/2008 Power Pivot.

Process/Methodologies: Scrum, Agile methodologies.

Version Control: Team Foundation Server (TFS), GitHub.

ETL Tools: SSIS, DTS.

Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose.

Packages: Microsoft Office 2016/2014 /2010/2007/2003.

Professional Experience:

Home Away, Inc., Austin, TX Sep-2015 - Till Date SQL Server/SSIS/SSRS Developer

Description:

Home Away, Inc. is a vacation rental marketplace. The company offers the most comprehensive selection of rentals for families and groups. The project goal was to map OLTP and OLAP servers in transferring huge data by overcoming threshold limits involved in building delay packages to backfill data.

Responsibilities:

Migrated DTS packages from SQL Server 2014 to SQL Server 2016 as SSIS Packages.

Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column

Created SSIS Packages to integrate data coming from Text files and Excel files.

Created SSIS packages to validate, extract, transform and load data to data warehouse databases.

Wrote stored procedures and User Defined Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.

Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.

Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables

Deploying the Packages and Reports on to the server.

Created Partition table for very large database for good performance.

Involved in the post deployment maintenance of canned reports and cubes.

Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.

Worked on JIRA Ticketing System

Used GitHub For Code repository and Code Reviews.

Document new SSIS packages

Worked on DATAMEER in Pulling data from Hadoop and do some analytics

Building Data sources for tableau reports based on Requirement

Had good Experience in Agile methodologic

Worked on Enhancement of ETL Framework

Environment: SQL Server 2008R2 & 2014 Enterprise Edition, SQL, T-SQL, MS Access, SSIS, SSRS Business Intelligence Development Studio (BIDS), MS Office 2007, Visual Studio 2008 & 2013.

Protech Associates Inc., Columbia, MD Sep-2014 –Jun-2015 MS SQL/BI Developer

Description:

Protech develops and delivers software business solutions for member-based organizations, commonly referred to as association management software systems or AMS systems. The company was founded in 1984 based on a passion for helping associations and nonprofits shape and manage the complete membership experience.

Responsibilities:

Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.

Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.

Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.

Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.

Wrote stored procedures and User Defined Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.

Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.

Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Worked on Power BI and prepared dashboards using Tableau to make it more attractive.

Created different Power Pivot reports as per the client requirement.

Experience in creating Multidimensional cubes using SSAS and designing DW schemas.

Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).

Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.

Worked on Filtered Views, views and Base table integration between different Source systems.

Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.

Verified business requirements and functional specifications.

Environment: Windows 2003 Advanced Server, MS SQL Server 2012/2008/2008R2, TSQL, Visual Studio 20013/2010 SSAS, SSIS, SSRS.

Universal American, Houston, TX. June 2013-Aug 2014

SQL Server BI Developer

Description:

Universal American Corporation (UA) is insurance, Finance and administrative services company that specializes in offering products to the senior and self-employed markets. UA Corp has targeted the senior market in particular because it is the fastest growing demographic segment in the country. UA contracts with the federal government to offer Medicare Advantages with Prescription Drug Plans.

Responsibilities:

Involved in Installation and Configuration of MS SQL Server 2008R2.

Created Views to maintain security of customer data.

Created Indexes to get the high-level performance.

Performed ETL operations to support incremental, historical data loads and transformations using SSIS.

Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.

Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, complex joins, column conversions, 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 data from Excel Spreadsheets, Text file, MS Access and CSV files.

Developed and Scheduled SSIS Packages for loading Facts and Dimensions.

Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs.

Used Data Diffractor tool to normalize semi-structured Spreadsheets, fed it into the SSIS pipeline in the form of normalized output of factual data and contextual metadata.

Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.

Performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.

Environment: MS SQL Server 2008/2008R2, TFS, Query Analyzer, Windows 2003, SSIS, SSRS, SSAS, Excel, Visual Studio 2010.

Health Science Community Center, Morgantown, WV. Sep 2011 - May 2013 SQL Server BI Developer

Description:

HSC improve the health and well-being of West Virginians and society at large. Conducting vital research that advances scientific knowledge, pharmacy practice, and economic development and providing direct supportive services to patients, the community, and the profession.

Responsibilities:

Used various transformation components in the data flow task to implement business logic.

Configured SSIS packages using Package configuration wizard to allow package run on different environments.

Migrated data using ETL Tool in SSIS.

Deployed SSIS packages and Reports to Production Servers.

Conversion of DTS packages SQL Server 2000 into SSIS packages SQL Server 2005.

Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.

Created ETL package for data conversion using various transformations tasks.

Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.

Created datasets for reports using T-SQL and stored procedures

Experience in Data Analysis, Normalization, Data warehousing, Data Cleansing, Data Modeling, Data Mapping, Erwin 3.0 in OLTP & OLAP environments

Experience in building star schema and snowflake schema depending on the business data requirement. Rebuilding Indexes and Tables as part of performance tuning exercise.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Created complex variables, multiple breaks, sorts in the reports.

Created Tabular and Matrix reports using SSRS.

Environment: SQL Server 2000/2008 Enterprise Edition, SSIS, SSRS, ASP.NET, ADO.NET, Erwin, XML, T-SQL, SQL Server 2005/2008R2, T -SQL, MS Excel, MS Access.

State Bank of India, Hyderabad, India Jan 2009 –June 2011 SQL Developer

Description:

State Bank of India is the nation’s largest and oldest bank. State Bank of India (SBI) has more than 80 offices in nearly 35 other countries, including multiple locations in the US, Canada and Nigeria. Customer-centric database was built to analyze transactions across finance, marketing, Risk, collections and customer relations were developed.

Responsibilities:

Setting up new MS SQL Server instances and databases.

Going through the clients' requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.

Capacity planning of MS SQL Servers. Implemented and maintained database security.

Managing logins, roles, assigning rights and permissions. Created views to implement security.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.

Troubleshoot and minimize production down issues.

Have written several stored procedures and Triggers as per the client requirements.

Running DBCC consistency checks, and fixing data corruption in application databases.

Designed new job process, new database maintenance plans and DTS packages.

Created scheduled maintenances and backup procedures to the database as a disaster recovery method.

Data conversions and data loads from various databases and file structures.

Monitor failed and long running MS SQL Server jobs.

Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2008, Transact-SQL, Enterprise Manager, Query Analyzer, DTS Designer, SQL Profiler, Index Tuning Wizard and MS-ACCESS 2000.

Contact this candidate