SUMMARY

• 9+ years of experience as SQL Developer in performing Software Analysis, design, development, support.
• Experience in Microsoft SQL 2014 Server migration from SQL Server 2010/12, Integration Service (SSIS), Analysis Services (SSAS) and Reporting Service (SSRS).
• Hands - On in High Level Design of ETL SSIS Package for integrating data from sources (Excel, CSV, flat file, Text Format Data).
• Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using Erwin
• Expert in Designing SSIS Packages to Extract, Transform and Load (ETL)/ DTS data into the data warehouse from heterogeneous databases such as Oracle, DB2, MS Access.
• Experienced in generating on-demand, parameterized, Custom Reporting, power view reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/ 2008 (SSRS)
• Expertise in C#, ASP.NET MVC, REST Web API, WCF, Entity Framework.
• Expertize in working on the projects with the global teams from the client sites i.e. Chile, UK, India
• Hands on in using SQL Server Reporting Services (SSRS), Cognos, and Tableau for implementing reports.
• Experience in using version control tools like TFS and Git Hub.
• Worked in Agile (SCRUM) Methodology Test Driven Development (TDD).
• Experienced in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2012.
• Expertise in designing and developing SQL, Oracle databases i.e. Stored Procedures, Triggers and Optimization.
• Knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes and reporting tools.
• Extensively used tools like SQL Profiler, SQL Analyzer and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Running SSIS through Batch file and exporting data from file to different tables in database.
• Proficient in using SQL Server and T-SQL and in Creating store procedure, Tables, Cursor, Views, Indexes, SQL joins and performance based query writing.
• Expert in database backup, restore, Database mirroring and log shipping and implemented replication as high availability techniques.
• Strong knowledge of Software Development Life Cycle (SDLC).
• Good team management skills and ability to work as Individual contributor or within team.
• Strong problem solving, analytical and interpersonal skills.

TECHNICAL SKILLS

Frameworks: ASP.NET MVC, VB.NET, Entity Framework, N-unit, Bootstrap, Angular.JS, CSS, HTML.

Languages: C# 2.0/4.5

Databases: SQL SERVER 2008/2015, Oracle 9i/10g, MongoDB(Learning Curve)

Development Environment: Visual Studio 2008/2015,TFS, GitHub, IIS

Protocols: Web API, SOAP, Web Services, WCF, Rest API

Reporting: SSIS, SSRS, Crystal reports, Tableau(Learning Curve)

Utilities & Tools: Rally, Splunk, Sales Force, Jeera, Serena Team Track, Source Tree, MS Visio.

PROFESSIONAL EXPERIENCE

MS SQL Developer

Confidential, Costa Mesa, CA

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Developed Complex Stored Procedures and Functions for the custom objects.
• Scheduling the SSIS Package Execution by Using the SQL Server Agent for monthly data loads.
• Imported and Extracted data from various sources such as flat file, access, SQL server and loaded those data into SQL server to build various reports.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Worked on all activities related to the development, implementation and Support of ETL processes for large-scale Data Warehouses using SQL Server SSIS
• Modified existing SSIS packages to meet changes specified by the users.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• Worked on SSIS design pattern using parent-child package structure.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues, optimizing and improving the performance of SSIS packages using performance monitoring, SSIS Logs.
• Recognized the Fact and Dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services 2008.

Confidential

Responsibilities:

• Involved in Loading Dimension with the SSIS slowly changing Dimension Wizard.
• Developed Complex Stored Procedures and Functions for the custom objects.
• Scheduling the SSIS Package Execution by Using the SQL Server Agent for monthly data loads.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• Imported and Extracted data from various sources such as flat file, access, SQL server and loaded those data into SQL server to build various reports.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Worked on all activities related to the development, implementation and Support of ETL processes for large-scale Data Warehouses using SQL Server SSIS
• Modified existing SSIS packages to meet changes specified by the users
• Set up and maintain database environments to support production, QA and development activities.
• Migrated mappings from Development to Testing and from Testing to Production
• Created various Documents such as Source-to-Target Data mapping Document, and Unit Test Cases Document.
• Modified existing reports using SQL Server Reporting Services (SSRS) as per the user requirements.
• Worked with the Mainframe and Legacy application teams to gather the requirements.
• Worked with the software teams based in Chile, Santiago on the ONS process.
• Developed the application with a minimal support by following Confidential Architectural standards in view.
• Developed Services using Windows Communication Foundation (WCF) for integration with other systems.
• Used Data Contract as the standard mechanism in the WCF for serializing .NET object types into XML.
• Automated all the reports extracting process in the new system by using custom store procedures in SQL 2014.
• Interacted with Business Users across the Confidential Batch Fulfillment and ExperianConsumer Services.
• Interacted with the other bureau’s TransUnion and Confidential on the Monitoring alerts.
• Worked in SQL server 2014 database migration from Flat files..
• Used GitHub stash repository for all the source code maintenance needs.
• Used N - unit to implement Unit, Integration and Regression Testing.

Environment: .NET Framework 4.0, Visual Studio 2015, ASP.NET, C#,SQL Server 2014/12, SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), SQL Server Analytical Services(SSAS), LINQ, GitHub, Source Tree, Rally.

Confidential, GLENDALE, CA

SQL BI Developer

Responsibilities:

• Designed and developed SSIS packages to extract source data from flat files obtained from various heterogeneous ERP databases such as Oracle, transform and load the data into SQL Server 2010 target
• Worked on various SSIS data transformations such as Aggregate Transformation, Aggregate Conditional Split, Data Conversion, Derived Column, Multi-Cast, Script Component, Fuzzy Lookup, Fuzzy Grouping and Execute SQL Task, etc.
• Created stored procedures to supports efficient data storage and manipulation.
• Developed objects (i.e. tables, views and stored procedures, functions, triggers, indexes) in SQL Server 2008 to get a better and faster performance.
• Worked on SSIS design pattern using parent-child package structure.
• Generated various reports like Tabular reports, and Drill down reports using SSRS.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues, optimizing and improving the performance of SSIS packages using performance monitoring, SSIS Logs.
• Identifying the bottlenecks, reasons of resource contention and heavy objects and preventing them from becoming the showstopper in the data-warehouse.
• Requirement gathering & designing for new initiatives/enhancement requests.
• Scheduling the SSIS Package Execution by Using the SQL Server Agent for monthly data loads
• Recognized the Fact and Dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services 2010.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2010, 2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Profiler, SQL Profiler .NET Framework 3.5, Microsoft SharePoint Server 2007, and Visual Studio 2012.

Confidential, Denver, CO

SQL Developer

Responsibilities:

• Gathered requirements from business analysts and documented them based on functional specifications.
• Integrating heterogeneous data from sources such as DB2, Oracle, MS Access, MS Excel to SQL Using SSIS
• Performed activities like analyzing and improving the databases, creation & indexing of the tables.
• Created Stored Procedures, triggers, views, tables and generated TSQL script for application
• Developed Complex Stored Procedures and Functions for the custom objects.
• Customized & optimized the existing stored procedures according to the Technical specifications and performed troubleshooting on the existing stored procedures.
• Created indexes for better performance
• Developed CARE Dash Board and Individual Reports using SQL Reporting Services (SSRS)
• Migrated CARE Web Reports to SSRS reports.
• Designed and implemented stored procedures and triggers for automating tasks.
• Performed unit testing on reports, and monitored the performance of the reports.
• Performed Optimization and Performance tuning of the Stored Procedures.
• Provided ongoing technical support in the production environment.
• Tested the data with complex queries, joins and sub queries.
• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully Extracted transformed and load data into data warehouse using SSIS.
• Modified existing SSIS packages to meet changes specified by the users
• Scheduled jobs for executing SSIS packages which were developed to update the database on Daily basis.
• Created Tabular and Matrix and Sub reports using the SQL Server Reporting Services SSRS as
• Used Team Foundation Server (TFS) for version control, source control and reporting.

Environment: SQL Server 2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Query Analyzer, MS Access, and SQL profiler

Confidential

SQL BI Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Designed the Entity Relationship (ER) models and logical data (LDM), physical data (PDM) models based upon the design documents.
• Extensively worked on full Software Development Life Cycle (SDLC) of the project from Database Design and Modeling to implementation and maintenance.
• Designed and Developed SSIS Staging Packages to Stage Source files to SQL Server Source Database
• Involved in migration projects to migrate data from Teradata to HDFS File system.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed and Developed Complex SSIS Source to Intermediate Packages to load the data into Intermediate Databases
• Developed Complex SSIS Parent-Child Packages for different Counties with Common Source to intermediate rules.
• SSIS Components used extensively in the project are Merge join, Derived Columns, Look UP, Conditional Split and Multicasting.
• Designed various packages using various task e.g. For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.
• Generated various types of daily, weekly, bi-weekly, monthly, ad-hoc, standard, dynamic reports, power view presentation, in customer level, manger level, and vendor level using Microsoft technologies like SQL Server Reporting Services (SSRS).
• Created complex Stored Procedures for validation process & for loading data from the staging area to the product database in SQL 2008.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Deployed SSIS packages from Development to Testing Servers
• Worked on all activities related to the development, implementation and Support of ETL processes for large-scale Data Warehouses using SQL Server SSIS
• Created and developed query for Tabular and Matrix Reports using SQL Server 2008 Reports Services (SSRS)
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008.
• Worked on Report generation using SQL Server Reporting Services (SSRS) that could be used to send information to Client.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Environment: Teradata, SQL Server 2005, 2008, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Profiler, Microsoft SharePoint Server 2007, and Visual Studio 2008, 2010.

Confidential

Jr SQL Developer

Responsibilities:

• Gathered requirements from business analysts and documented them based on functional specifications.
• Integrating heterogeneous data from sources such as DB2, Oracle, MS Access, MS Excel to SQL Using SSIS
• Performed activities like analyzing and improving the databases, creation & indexing of the tables.
• Created Stored Procedures, triggers, views, tables and generated TSQL script for application
• Developed Complex Stored Procedures and Functions for the custom objects.
• Customized & optimized the existing stored procedures according to the Technical specifications and performed troubleshooting on the existing stored procedures.
• Created indexes for better performance
• Developed CARE Dash Board and Individual Reports using SQL Reporting Services (SSRS)
• Migrated CARE Web Reports to SSRS reports.
• Designed and implemented stored procedures and triggers for automating tasks.
• Performed unit testing on reports, and monitored the performance of the reports.
• Performed Optimization and Performance tuning of the Stored Procedures.
• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully Extracted transformed and load data into data warehouse using SSIS.
• Modified existing SSIS packages to meet changes specified by the users
• Scheduled jobs for executing SSIS packages which were developed to update the database on Daily basis.
• Created Tabular and Matrix and Sub reports using the SQL Server Reporting Services SSRS as
• Used Team Foundation Server (TFS) for version control, source control and reporting.

Environment: SQL Server 2005, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Query Analyzer, MS Access, and SQL profiler