PROFESSIONAL SUMMARY:

• Having 5+ 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 Stored 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 EXPERIENCE:

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 SourceSafe 6.0, Visual Studio.NET, MS Share point Portal Server2003, Crystal Reports, MS SQL 2012/2008/Reporting Services

ETL Tools: SQL Server Integration Services (SSIS)

OLAP Tools: SQL Server Analysis Services (SSAS)

Web Servers: IIS 6.0

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

Web Servers: Windows, Mac OS

PROFESSIONAL EXPERIENCE:

Confidential, West Valley, UT

SQL Developer /ETL Developer

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, Salt Lake City, UT

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 data flow 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 Administered TFS for creating new user groups.
• Administered TFS and created TFS Backup schedules.
• Strong knowledge and experience of creating SSIS packages Using Salesforce (SOQL) Data.

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

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.