SUMMARY:

• Over 5+ years of IT experience in Analysis, Database Design, Development, Implementation, Debugging and Testing of various software applications to support ETL, Reporting and Analysis of data using MS Business Intelligence initiatives.
• Exceptional hands on experience with Microsoft SQL Server Business Intelligence suite which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) 2012, 2008 R2, 2005.
• Familiarity with Star and Snowflake schema data modeling techniques for OLAP database design.
• Proficient in database modeling for OLTP, Data Marts, Operational Data Store (ODS) and OLAP.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Involved in Designing and Building of OLAP dimensions and cubes using SSAS.
• Hands on expertise with ETL process using DTS/SSIS to load and process high volumes of data for front - end, web and reporting applications.
• Experienced in creating different types of Tabular, Matrix, Drill-Down, Cross Tab, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Proficient in Debugging, Testing, Deploying Complex Stored Procedures and different Database Objects across various SDLC environments.
• Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
• Better understanding of how to handle environmental related issues and to capture data related errors in custom logging process for SSIS/ETL Packages.
• Have hands on experience and proven track record of expertise with performance tuning.
• Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Security, User management and Performance Tuning.
• SQL Server RDBMS database development including T-SQL programming.
• Involved in entire Software Development Life Cycle (SDLC) from business analysis to final deployment and testing.
• Knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.
• Extensive work experience in writing and implementing database objects like Tables, Views, Indexes, Sequences, Synonyms and Exceptions.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Excellent problem solving skills with a strong technical background. Creative, adaptive and result-oriented professional with avidness to learn. Proficient at working as a team player with an aim of contributing towards the team's success

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, Dynamic SQL, C, C++, XML, HTML, DHTML, HTTP.

Databases: MS SQL Server Denali,2012,2008R2,2008,2005,2000, Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers)

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports.

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques.

Packages: Microsoft Office Suite 2007/2010/2012/2016

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 7/10,MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Morrisville, NC

Sr. SQL Server Developer

Responsibilities:

• Worked on a Government HealthCare Services project
• Worked as a shared resource for both Development as well as Production support based on need basis and priority of requirements.
• Worked as an ETL resource maintaining and monitoring the application workflows,dashboard integrated reports and scheduled sharepoint upload of reports.
• Worked on T-SQL programming, stored procedures and views in the processing of developing reports. Worked on SQL Server 2008 R2 and 2012 for different parts of the project.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources such as flat files, csv files, D-mart repositories.
• Used BIDS to create parameterized reports and exported reports in excel
• Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
• Involved in code review and preparing unit test cases.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Used SQL Profiler for monitoring the SQL statements and procedures.
• Discussed and gathered requirements from Product and Account team for new developments related to SSRS reports or new data loads to database through ETL processes.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2012/2008 R2/2005, IIS, SharePoint, VB.Net scripting, SSIS, SSRS, T-SQL, Visual Studio 2008/2012/2013 Indexes, .Net Framework 3.5, 4.0, backup/restore, MS Office suite 2016

Confidential, Newport Beach, CA

Oracle Database Developer

Responsibilities:

• Created PL/SQL packages, procedures, functions applying the business logic to update the database with customer applications from dealers and to decision contracts.
• Created custom triggers to automatically populate different tables.
• Created the custom tables to import the data of customers, dealers and credit bureau records.
• Deployed naming standard to the Data Model and followed company standard for Project Documentation
• Improved the performance of large queries to improve the response time of the application.
• Requirement gathering with Business partners, analysts and end users.
• Wrote two major packages to populate credit bureau tradelines and collections records of customer applications received by Dealers
• Worked on extracting data from XML and insert into respective tables
• Responsible for resolving the issues involved with the application in testing phase.
• Rewrote existing Procedures and Packages using Collections for better performance and tuned existing queries in the procedures.
• Wrote very complex queries to provide data in fewer amounts of DB calls
• Supported various data change and enhancement change requirements from dealers, by modifying respective packages and procedures.
• Involved in preparing functional document, user document, process flow diagram and flow charts.

Environment: Oracle 11g, SQL*Plus, PL/SQL, Oracle Forms, XML,SQL Developer, Serena PVCS, Win-SCP, Citrix

Confidential, San Diego, CA

SQL Server Developer

Responsibilities:

• Worked with business gathering requirements.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Deployed the created SSIS packages in Development and Testing environments.
• Created Linked Servers to retrieve data from other databases.
• Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and claim system.
• Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.
• Supported 24X7 in production issues and User’s issues on applications.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, SSIS, SSRS, T-SQL, GEM Fusion, Visual Studio 2008, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2003

Confidential, Atlanta, GA

SQL Server Developer

Responsibilities:

• Worked with business gathering requirements.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Deployed the created SSIS packages in Development and Testing environments.
• Created Linked Servers to retrieve data from other databases.
• Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
• Involved in preparing detailed technical documents.
• Involved in code review and preparing unit test cases.

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, Business Intelligent Integration Services (SSIS 2012/2008), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, ETL, Performance Point Server 2007, MS Excel.