SUMMARY:

• 6+ years of experience in SQL and SQL - BI suite comprising of SSRS/SSIS/SSAS along with professional database design, development and maintenance of SQL SERVER 2005/2008/2012
• Handled databases running in the size of terabytes and tables with billions of rows.
• Proven ability in utilizing ETL Tools including SQL server Integration Services (SSIS)
• Proficient in using SQL Server and T-SQL and in creating Store procedures, Triggers, Tables, User defined Functions, Views, Indexes, Data dictionaries, SQL joins and Performance based query writing.
• Good knowledge of MSSQL implementing features like row and page compression techniques, data compression, Backup compression, Performance data collector, Resource governor and transparent data encryption.
• Involved in deployment of packages and created job scheduling, alert notifications for errors.
• Exposure knowledge of Informatics Migration and Upgrade.
• Experience in database Backup and Restore and Log shipping and implemented replication as High availability techniques. .
• Experience in data mirroring as data recovery solution.
• Load data into Data warehouse from heterogeneous databases like Oracle, MS Access.
• Experience in creating and scheduling complex SSIS packages for transferring data from multiple sources into SQL Server, Access and Excel by using SSIS and DTS utility of SQL Server 2000/2005/2008.
• Proficient in creating and designing report layout, sorting the data, defining sub totals using SQL Server Reporting Services (SSRS) 2008,2012.
• Experienced in generating various reports like drilldown, Sub reports, Parameterized reports using SSRS and integrated and deployed them on various web applications on to the web browsers.
• Experience in using SQL Server Analysis Services (SSAS)2008,2012 to deliver online analytical processing (OLAP) and data mining functionality and creating Cubes for the same

TECHNICAL SKILLS:

Software Languages: .NET Framework 1.1/2.0/3.0/3.5/4.0 (ASP.NET, VB.NET, Visual Basic 6.0, UML, XML

Web Development Tools and Scripting Languages: VBScript Visual Source Safe 6.0, Visual Studio.NET, MS Share point Portal Server2003, Crystal Reports, MS SQL 2012/2008/Reporting Services

Databases: MS-SQL Server 2012/ 2008/ 7.0 , Oracle 9i, MS-Access

Web Servers: IIS 6.0

Operating Systems: Windows 8, Windows 7, Windows NT4.0, Windows 2000 Server

PROFESSIONAL EXPERIENCE:

Confidential, Sean Paul, MN

MS/SQL Developer

Responsibilities:

• Creating and Modifying T-SQL Stored Procedures for validating the integrity.
• Maintained data integrity by performing validation checks.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Used SQL Profiler and Database Tuning Advisor for troubleshooting, monitoring, optimizing SQL Server and T-SQL statements from developers and testers and also created SQL scripts for tuning and scheduling.
• Involved in Error Handling using Try/catch Block.
• Migrated SQL server 2012 packages to SQL Server 2016 SSIS packages using SQL Server
• Created packages with different Control Flow options and Data Flow Transformations such as Conditional Split, Multicast, Pivot, Union All etc.
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Scheduling SSIS packages and Jobs.
• Configured Dynamic Checkpoints to allow rerunning a package from the point of failure.
• Implemented Event Handlers, Error Handling and Logging for the packages as per the requirements.
• Implemented Team Foundation Server TFS as Version Management for Microsoft Technologies 2012
• Supported and Administrated TFS for creating new user groups.
• Administered TFS and created TFS Backup schedules.
• Strong knowledge and experience of creating SSIS package Using SalesForce (SOQL) Data.

Environment: SQL Server 2012/2016, SSRS, SSIS, ETL, - TFS, SOQL, Excel, Word.

Confidential, Columbus, OH

ETL/SQL Developer

Responsibilities:

• Created T-SQL queries, stored procedures, triggers, views, Indexes, Constraints and user defined functions ( Confidential ) on various database objects to create, modify and/or maintain databases.
• Maintained Data Integrity by implementing different types of constraints on tables.
• Managed the data by altering and retrieving from a variety of sources and made them ready for statistical analysis
• Creating and Modifying T-SQL Stored Procedures for validating the integrity.
• Maintained data integrity by performing validation checks.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Used SQL Profiler and Database Tuning Advisor for troubleshooting, monitoring, optimizing SQL Server and T-SQL statements from developers and testers and also created SQL scripts for tuning and scheduling.
• Involved in Error Handling using Try/catch Block.
• Migrated SQL server 2008 R2 packages to SQL Server 2012 SSIS packages using SQL Server 2008 Upgrade Advisor.
• Created packages with different Control Flow options and Data Flow Transformations such as Conditional Split, Multicast, Pivot, Union All etc.
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Scheduling SSIS packages and Jobs.
• Configured Dynamic Checkpoints to allow rerunning a package from the point of failure.
• Implemented Event Handlers, Error Handling and Logging for the packages as per the requirements.
• Designed and Built Cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs using SQL Server Analysis Services (SSAS).
• Optimized the query performance on cube by following the recommended best practices.
• Designed and developed various Reports on SSAS Cubes as the data source.
• Documentation of all the processes involved in maintaining the database for future reference.
• Actively involved in identifying business requirements with the client
• Enhanced the logical and physical database design to fit new business requirements, and implemented new design into SQL Server 2012

Environment: MS SQL Server 2012, SQL BI Suite (SSMS, SSIS, SSRS), XML,, MS Excel, MS Access 2007 & Windows Server 2008, SQL Profiler Confidential, Austin, TX Aug 2014 - Sep 2016

SQL Developer /ETL Developer

Confidential

Responsibilities:

• Design and develop SSIS package for loading data from OLTP to ODS and finally to Data Warehouse.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Implemented replication in SQL Server for managing and scaling databases in an enterprise environment.
• Loading data in Dimension Tables in SQL Server using SSIS Packages.
• Used Bulk Copy Program and Bulk Insert to load data from different data sources to SQL Server.
• Unit testing and Integration testing for various modules.
• Created reports from Data Warehouse using SQL Server Reporting Services (SSRS).
• Created complex stored procedures to generate reports using SSRS.
• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Used ETL Transformations to copy columns and load data from data sources Oracle, DB2, Flat files to destination databases.
• Embedded reports into web pages using ASP.NET Report Viewer Web Control.
• Troubleshooting DB performance issue and implementing necessary DB changes and implemented processes to ensure Optimal Query Performance.
• Created views and indexed views to reduce database complexities for the end users.
• Run Import/Export wizard to provide Excel files to Managers for particular reports.
• Used SQL Server Analysis Services (SSAS) to design cubes for summary reports
• Created SSIS package to load data from Flat File (2GB -- 4GB) to Flat File and Flat File to SQL Server 2005/2008/2012 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.

Environment: ETL, MS SQL Server 2005/2008, T-SQL, DB, SSAS, SQL Server 2008 Integration Services (SSIS), TFS, SQL Server 2008 Reporting Services (SSRS)

Confidential, Grapevine, TX

SQL BI Developer

Responsibilities:

• Designed and created databases using normalization techniques. Implemented DDL statements
• Developed advanced queries, stored procedures, views and functions to retrieve, analyze and update data using MS SQL Server 2008 R2/2012.
• Designed, developed and implemented data import using SSIS to load data from various files into database
• Created packages and scheduled server jobs according to established business rules
• Worked on designing and coding the complete ETL process using Informatics for various transactions and loading data from different sources like Flat Files and Relational Database.
• Provided administrative functions for SQL Server such as implementing database backups, performance tuning and optimization, importing and exporting database objects. Support of high-transaction database
• Designed and implemented security by setting up users, profiles and roles and assigning system and object privileges
• Used SSRS to develop parameterized reports to group, filter and calculate results.
• Retrieved data through stored procedures and data views
• Prepared and presented status reports to Line of Businesses and Central Technology Senior Management.
• Designed reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports.
• Involved in Data migration using SQL Server Integration Services (SSIS) which helped to easily move and manipulate data from heterogeneous environment.
• Extensively used java Script for client side validations and for displaying messages.
• Extensively used LINQ and SQL queries, store procedures to generate reports and perform necessary CRUD operations.

Environment: SQL Server 2008/2012, BIDS, SSRS, SSIS, ETL, Framework 2/3/4, WCF, SQL Server Agen

Confidential, Madison, WI

MS SQL Server Developer

Responsibilities:

• Designed coding and testing of new and enhanced application components on the data warehouse and created packages using ETL tool for the users to check the codes.
• Involved in requirement gathering, analysis, design, development, change management, deployment and User Training.
• Transformed data from various data sources using OLEDB connection by creating SSIS packages and schedule them as per requirement.
• Performed (ETL) extract, transform and load data into the repository and created complex stored procedures, functions, views, indexes for the logic package.
• Data analysis and data migrations.
• Designed database schema in MySQL and associated entities. Extensive experience with SQL queries, design issues and tradeoffs.
• Updated the technical requirements documents as per given requirement and created data mapping document for data transformation.
• Involved in designing and deploying cubes in SSAS environment using snowflake and star schema designs for the operational data.
• Created SSIS packages to extract data from OLTP to OLAP systems and created alerts for successful and unsuccessful completion of scheduled jobs.
• Documented archiving and database analysis for various purposes.
• Used various SSIS tasks such as conditional split, derived column on the data retrieved, performed data validation checks during staging, and then loaded the data into the data warehouse.
• Created reports to retrieve data using stored procedures that accept parameters depending upon the client requirements.

Environment: MS SQL Server 2008R2/2012, Db2, VBA, SQL Server Reporting Services (SSRS).Business Intelligence Development Studio, SSIS, SSRS, T-SQL, MS Visual Studio 2010