SUMMARY

• 5 years of experience in database development and IT Solutions that include experience in design, development and implementation of complex data delivery systems using MS SQL Server.
• Experience in developing the applications using T - SQL Programming (DDL, DML, and DCL).
• Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
• Complete understanding of Software Development Lifecycle and experience in validating end-to-end user scenarios for Enterprise Applications developed in SSIS/SSRS
• Experience in MS SQL Server 2008/2012/2014 with OLTP and Business Intelligence delivery using SQL Server Integration Services and SQL Server Reporting Services.
• Experience in Microsoft Visual C# in script component of SSIS
• Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Developed Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Experience in writing sub reports and parameterized Queries for generating reports in SSRS
• Expertise in using Team Foundation Server (TFS) and Sub Version (SVN) as a tool for repository of codes and version control, branching and merging into production.

TECHNICAL SKILLS

SQL Server Tools: SSMS,SSDT

Business Intelligence Tools: SQL Server Integration Services(SSIS),SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

RDBMS: MS SQL Server 2014, 2012 and 2008

Languages: SQL,T-SQL,PL/SQL,C#, C,C++,JAVA,C#,VB, ADO.NET, WPF

Operating System: Windows 7/XP, Windows Server 2008/2003

Other Tools: Visual Studio 2013/2012/2010/2008.

PROFESSIONAL EXPERIENCE

Confidential, El Monte, CA

SQL/ BI Developer

Responsibilities:

• Extensive use of SSRS for report generation, scheduling, security and maintenance.
• Used SSIS to create ETL packages to validate, extract, transform and load data warehouse databases, data mart databases
• Involved in Incremental Data Load from different sources into Main SQL database Engine with ETL Operations.
• Build different packages in SSIS using combination of multiple Dataflow Transformations.
• Created Master SSIS packages to execute set of packages that load data from various sources onto the Data Warehouse on timely manner.
• Created indexes on selected columns to speed up queries and analyses in SQL Server Management Studio
• Performance optimization of T-SQL queries.
• Creating and modifying Stored Procedures and functions.
• Creating packages for automated report delivery and multiple-format reports within a single automated mail using SSIS.
• Created Stored Procedures, Triggers, User define functions and Views in support of ETL and reporting business logic.
• Analyzed the historical data and extracted required data using both T-SQL and SSIS to support the management decisions.
• Involved in scheduling packages through SQL Server Agent and setting up shared schedules.
• Handled the reporting server and was actively involved in creation of various types of complex reports
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Involved in full life cycle of Reporting starting from the Authoring phase, the Management phase all the way to the Delivery phase
• Responsible for identifying and defining the Datasets for the report generation, writing the queries for the drill down reports, and identifying and adding the report parameters.

Environment: MS SQL Server 2014, Windows Server 2003, .net framework 4.5, SSRS, DTS, SSIS, SSAS, T-SQL, XML, MS Excel, Microsoft Visual Studio 2013, Subversion, Installshield, WIX.

Confidential

SQL Server Developer, BI Developer

Responsibilities:

• Requirement study & Analysis with Product Owner.
• Involved in Design and Requirements effort estimation.
• Preparing Requirement and Design documents.
• Maintain, update and monitor the existing database on daily basis.
• Generated reports using SQL Server Reporting Services2005/2008 from OLTP and OLAP data sources
• Designed and deployed reports with Drill-Down, Drill-Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created standard report Subscriptions and Data Driven report Subscriptions.
• Created report snapshots and cache for betterperformance.
• Created user define functions in SSRS using C# script.
• Uploaded reports on to the report manager and organized them into folders.
• Actively supported Business users for change requests and provide support to team members.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Formatted Reports using Global Variables, Expressions and Functions for the reports.
• Identified the data source and writing queries and stored procedures for datasets.
• Designed the Report templates.
• Supporting the content developer’s team issues related to database connectivity and addressing their queries related to database.
• Design & Development of SDB Migration Utility
• Unit Testing SDB migration Tool & Documentation
• Develop a tool called merged CIPS for SPRD 7.1.1. This will help SDB customers to upgrade to SPRD 7.1.1 if they so desire.
• Developed SDB installation to use the WIX installer to be in compliance with the enterprise requirements.
• Developed a tool to Transfer Commodity Codes and Piping Specs between SPRD/SDB DBs
• Actively participated in the daily standup, planning, Review meetings.

Environment: MS SQL Server 2014, Windows Server 2003, .net framework 4.5, SSRS, DTS, SSIS, SSAS, T-SQL, XML, MS Excel, Microsoft Visual Studio 2013, Subversion, Installshield, WIX.

Confidential

SQL/ BI Developer and Dot Net C# Developer

Responsibilities:

• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Created SSIS 2012 packages dynamically using SQL Server Configuration & Environmental variable.
• Worked with QA team & Business Users for the validation of the data & SSIS packages.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Transformed complex business logic into Database design and maintaining it by usingSQLobjects like Stored Procedures, User Defined Functions, and Views.
• Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.
• Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created ETL packages with different data sources (SQLServer, Flat files, Excel source files and XMLs etc.) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Experienced in creating package dynamics by using SSIS expressions and variables.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Performed Documentation for all kind of SSIS packages.
• Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, SQL task, Script task and Send Mail task etc.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and C# scripts.
• Created DTS Packages and T-SQL Stored Procedures for the ETL Process.
• Actively participated in the daily standup, planning, Review meetings.

Environment: MS SQL Server 2012,, .net framework 4.0, SSRS, SSIS, SSAS, T-SQL, XML, MS Excel, Microsoft Visual Studio 2013, TFS, Smart3D.