SUMMARY

• Over 8 years of strong experience in the Database Design, development and deployment of large - scale enterprise applications.
• Extensive experience and in depth working knowledge in various SQL Server tools and IDE to work with Database, reporting and business intelligence based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio and Query Analyzer.
• Extensive experience in using Microsoft BI studio products like SSIS, SSRS, SSAS for implementation of ETL methodology in data extraction, transformation and loading.
• Experience in OLTP, OLAP, Slowly Changing Dimensions (SCD), Data Cleansing and Data Migration.
• Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous and homogenous sources (Excel, CSV, Oracle, SQL Server, flat file, Text Format Data) by using extensive data transformations.
• Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using Integration Service (SSIS), BULK INSERT, DTS Import/Export utility, and Bulk Copy Program (BCP).
• Good Knowledge and understanding of data warehousingtechniques and standards.
• Experience in Data modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging.
• Experience in handling Transactions in SSIS packages for data consistency.
• Excellent knowledge in RDBMS concepts and constructs along with Object creation such as Database, Tables, Normalization, User Defined Functions, Stored Procedures, Views, Cursors and Triggers.
• Hands on Experience in writing complex stored procedures, Indexed Views and also creating and Updating tables for Data consistency and Data manipulation by executing DBCC commands.
• Expertise in Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins, temporary tables, table variables, common table expressions (CTE)
• Experience in creating SSIS packages, DTS Migration and Metadata Management. Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Automated manual process with SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Experience in designing report layouts and developing Custom Reports and different types of Tabular/Matrix/Adhoc/Sub/drill down/drill through Reports and Charts in multiple formats using SSRS 2008/2005.
• Hands on experience in creating several reports such as drill down reports, parameterized reports, linked reports, and sub-reports, Matrix Reports, Charts using SQL Server Reporting Services.
• Extensively worked in creating Report subscriptions for data driven reports by using Report Manager.
• Used Report Manager to manage report security by assigning roles, permissions and to create report schedules.
• Experience with Ad-Hoc reporting using Report Builder in SSRS for daily reports.
• Experience in optimizing long running queries for SSIS packages and report performance.
• Worked on analyzing and performance tuning queries by looking at Query Statistics and Execution plans.
• Extensively worked with SQL Server Agent Job and Cisco Enterprise schedulers for scheduling SSIS Package jobs and jobs written in console applications in .NET.
• Experience in Designing, Developing and Maintaining applications using Visual Studio .NET, ASP.NET, C#, VB.NET, ADO.NET.
• Extensive experience in Visual Source Safe (VSS), Subversion (SVN) and Team Foundation Server (TFS 2008/12) version control systems.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2012, 2008, 2005, 2000, DB2, Azure SQL, Oracle 9i/10g/11g

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development, Studio, Visual Studio, Configuration Manager, SQL Server Profiler SQLQuery Analyzer, SQL Refractor, SQL Server Agent.

BI/ETL Tools: SQL Server Analysis Services, Business Intelligence Development Studio, Tableau

Reporting Tools: Microsoft SQL Server Reporting Services, Crystal reports, Cognos

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook.

Database Technologies: T-SQL, PL/SQL, XML, DTS, OLTP, BCP, SSIS, and OLAP

Operating Systems: Windows XP/2008/2012, UNIX, Windows 9x

Programming Languages: T-SQL, PL/SQL, HTML, Visual Studio, VB and C#. Net

PROFESSIONAL EXPERIENCE

Confidential, Somerset NJ

SQL Server BI Developer

Responsibilities:

• Involved in gathering business requirements, documenting and translating into high performing Business Intelligence processes.
• Extensively involved in creating system requirement specifications (SRS), Data mapping documents for extracting transforming and loading data from heterogeneous sources to SQL Server 2012.
• Worked with loading data from heterogeneous sources like Delimited and fixed width Flat Files feeds, Oracle, SQL server, MS-Excel, XML files using SSIS.
• Extensively worked with DTS Package Error Handling using SSIS Event Handlers at package and task level.
• Implemented Package level Logging in SQL Server, Flat File logs.
• Extensively worked with Data transformations such as Data Conversion, Derived columns, Union, Merge, conditional split, Multicasting, Cache Transform, Lookup, Fuzzy Lookup, OLEDBCommand etc.
• Implemented Master Child Package model using Execute Package task and passing parameters to the child package from parent package. Also used Execute Process Task to invoke executable.
• Extensively used File System Task for File Movements and SMTP Task for sending emails,
• Extensively worked with FTP Task for uploading and downloading files for processing.
• Worked with Web Service Task to invoke Web methods (operations) and captured results in Package variables to use in XML Source and XPATH Query operations to retrieve relevant data.
• Worked with Script task and Script Component using C#. NET for making restful web service calls and other custom operations based on requirements.
• Migrated SSIS Packages in SQL Server 2008R2 Package Deployment Model to Project Deployment Model in SQL Server 2012.
• Worked with Project Deployment Model and configuring the Environment, Environment variables, deploying projects to Integration services catalog, mapping environment variables to project parameters.
• Data migration Bulk copy program (BCP Utility) to Import and Export data from Text to SQL Server 2012 using Batch Files and Automated it using SQL Agent.
• Implemented Database SQL Server Agent Jobs Migration from SQL Server 2008 R2 to SQL Server 2012 using SSIS Packages.
• Worked with Migrating DB Objects, Reorganization and rebuilding Indexes using SSIS Tasks.
• Created database objects such as Tables, User Defined Functions, Stored Procedures, Views, Cursors and Triggers, Clustered and Non Clustered Indexes.
• Extensively used Common Table expressions for hierarchical data and complex stored procedures.
• Worked with Complex T-SQL queries, Sub queries, co-related sub queries and joins to fetch the data as per the functional requirements.
• Extensively used T-SQL Ranking functions such as Dense Rank, Rank, and Row Number functions.
• Worked with Execution Plans in SQL Server for performance tuning and implementing necessary indexes based on the cost of the operations.
• Created SQL Server Agent Jobs for scheduled execution of SSIS packages and custom console applications
• Designed and developed complex custom reports using SSRS.
• Worked with ASP.NET Web applications using C#. NET, ADO.NET Dataset, Data table, to connect to SQL Server and Oracle using Oracle Client.
• Worked with Report Viewer to render SSRS Report on ASP.NET Web Portals.
• Extensively created reports using Tabular and matrix layouts involving hierarchical Drill - Down reports, drill through reports.
• Extensively worked with Conditional Formatting of SSRS Report elements, using expressions.
• Extensively worked with Row Grouping and Column Grouping for aggregations in hierarchical data reports using Drill downs in SSRS.
• Created dashboards using benchmarked data to provide an analytical snapshot of point in time data.
• Extensively used Shared Data Sources, Data sets in the reports and involved in deploying the Reports using Report Manager.
• Extensively worked with SSRS Report Subscriptions to emails, Network share drives on a scheduled basis.
• Used Report Code to write custom VB.Net Methods to use in report expressions.
• Extensively worked with Data Driven Subscriptions based on query for SSRS Subscriptions.
• Worked with SSRS Reporting web service for custom applications and console applications.
• Involved in Tableau reporting tool for creating reports for enhanced visualizations.
• Involved in designing Dashboards using Tableau reporting platform for high performance and best visualizations for business scenarios.
• Used TFS (Team foundation server) source control tool as version control for check-in/check-out process.

Environment: Windows XP, Microsoft SQL Server 2005/2008/2008 R2/2012, Crystal Reports XI, SQL Enterprise Manager, Oracle 11g, VB.Net, C#. Net, SQL Server Reporting 2008 R2 / 2012, Microsoft Excel, Tableau, Team Foundation Server (TFS) 2008, and SSRS 2005/2008/2012 , SSIS/DTS, SSAS 2000/2005/2008 , .NET Framework 3.5/4.0

Confidential, Woodbridge, NJ

SQL BI / ETL Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Created complex Stored procedures, User Defined Functions (UDF), Indexes, Views, Tables and, created Referential Integrities using Primary keys and foreign keys.
• Created Unique and Check Constraints for data consistency.
• Extensively worked with T-SQL using temporary tables, table Variables, complex joins, Pivots and created complex scripts.
• Worked with complex T-SQL Scripts for DML Operations such as Data insertion, deletion and updates for Referential tables.
• Worked SQL Server Agent Jobs for scheduling jobs related to .Net applications and SSIS Packages.
• Used Database Mail for sending emails through Stored procedures.
• Invoked Command Shell in Stored procedures to make calls to the custom applications.
• Used CLR Stored procedures for making complex operations.
• Worked with Common Table Expressions, Co-related Sub queries, Sub Queries.
• Extensively used Error Handling using TRY CATCH blocks and raising Error using RAISERROR.
• Created multiple enterprise reports from SQL Server Database (OLTP) including various reporting features such as groups, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2005/2008/2008 R2) like standard parameter reports, cascading parameter reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created visualization reports and Dashboards for business analysis using Charts such as Pie chart, bar chart etc. in SSRS.
• Designed and developed Complex reports using Crystal Reports XI.
• Used SSRS Reporting web service to dynamically generate reports passing parameters.
• Configured SSRS reports for snapshot and cache settings for increasing report performance.
• Worked with ASP.NET MVC applications in implementing business tier functionality components.
• Worked with ADO.NET, Dataset, Data Table, Data Relations, and LINQ to make ORM queries on Enumerable classes.
• Worked with SMTP Clients in .Net applications to send emails, File I/O Operations in C#. NET.
• Used SSRS Report Viewer and Crystal Report Viewer to render SSRS report and Crystal reports respectively.
• Experience with writing T-SQL, PL/SQL code and working on Dashboard and crystal reports.
• Implemented ETL process using SSIS in aggregating data from disparate sources such as DB2, SQL Server and File Feeds as per the business requirements and loaded in to SQL Server.
• Created SSIS package that involves looping feeds using For Loop container and implemented parallel executions using multiple Sequence containers and Precedence constraints.
• Implemented Type 2 Slowly Changing Dimension (SCD) for loading all the historical transactions.
• Used many data flow transformations such as Import column, Export column, Lookup, fuzzy lookup, cache transformations etc.,
• Used SSIS task events and event handlers to implement pre conditions and Error Handling in DTS Packages.
• Implemented Logging mechanism in packages for various events like pre-execute, post-execute and captured data in SQL Server.
• Deployed SSIS packages in file system and automated the jobs using DTEXEC command line utility to run the packages through CISCO Enterprise Job scheduler (TES).
• Created Package configurations to configure package settings to migrate the packages to QA, UAT and PROD Environment.
• Created console applications using C#. NET and ADO.NET to implement business requirements.

Environment: SQL Server 2005/2008/2008 R2 Enterprise Edition, SSIS, T-SQL, SSRS, Crystal Reports XI, SSAS, Windows Server 2008, C#. Net 3.5, ASP.Net 3.5, DB2, Oracle 10g, DB2, Visual Basic 6, Cisco Tidal Enterprise Scheduler, .NET Framework 3.5.

Confidential, MN

SSRS/SSIS Developer

Responsibilities:

• Actively participated in gathering Business requirements to implement functional and technical specifications
• Created design documents and technical flow documents for the SSIS and created SSRS report specifications
• Worked on data cleansing, data Extraction, Transformation and Loading design, development, source to target mappings, data warehouse transformations, performance tuning, testing and documentation
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files and other OLE DB Sources) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Worked with Various control flow tasks such as Sequence containers, for loop container, Execute SQL Task, Dataflow task, SMTP Task, FTP Task, File System Task, WMI Event Watcher, Web Service Task, Script task for implementing custom functionality using C#. NET and VB.NET.
• Implemented Parent - Child package model using Execute Package Task.
• Worked with slow performing SSIS Packages to performance tune using various techniques such as parallel processing (Parallelism) using Sequence Containers when applicable
• Fine-tuned performance of the SSIS Packages by removing blocking or synchronous transformations (such as SORT, PIVOT), avoiding OLTP database table locking by multiple containers, avoiding Implicit data type conversions.
• Improved SSIS Package performance by controlling Rows per Batch and Maximum Insert Commit Size to control the Temp database usage and DB Transaction log.
• Used Package level MaxConcurrentExecutable for concurrent executions to control the threads on the SSIS Task based on the server specification limitations and configured Engine threads in dataflow task.
• Monitoring execution plans to enhance the performance of the queries, stored procedures.
• Worked with Type 1, Type 2 and Type 3 slowly changing dimensions (SCD) for maintaining historical data.
• Used SQL Server Profiler to trace the parameters and troubleshoot the issues in Stored procedure invocations.
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Developed Scheduled Jobs to automate the packages.
• Implemented Event Handlers and Error Handling in SSIS packages and generated email alerts to the respective user groups.
• Involved in creation of dimensions using Star, Snow Flake schemas.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• WroteMDXqueries and expressions for use in Front End BI Applications
• Created SSRS reports and Data access from MDX, OLAP and Cubes
• Built SSRS reports from various heterogeneous sources like SQL Server, Oracle.
• Created ad-hoc queries from DB2 database for custom reporting needs.
• Created Drill Down, Drill through, linked and sub reports using SSRS 2008R2.
• Created reports from various migrated data sources into simple dashboards for easy reviewing.
• Built parameterized reports involving cascading parameters that are rendered in .NET web applications using Report Viewers
• Worked with ASMX web services in .NET to make web service calls.
• Worked with middle tier of .NET applications to build business functionality in web services and ASP.NET web applications.
• Worked with Windows forms in .Net to implement user screens and functionality using VB.NET

Environment: SQL Server 2005/2008R2 Enterprise Edition, SSIS, T-SQL, SSRS 2008, Dashboards, SSAS, Windows Server 2003, C#, ASP.Net, Oracle 10g, Visual Basic 6, ASP.Net 3.5, C#. 3.5, .Net Framework 3.5/4.0.

Confidential, State of MI, Lansing, MI

SQL Server Developer/ BI Developer

Responsibilities:

• Migrated legacy reports built in COGNOS 8 BI platform to SSRS reporting platform in 2008 R2.
• Converted legacy reports developed in crystal reports to SSRS 2008 R2.
• Created drill down, drill through, sub and linked reports using MS SSRS 2008 R2 as well as managed the subscription of the reports.
• Created many user-friendly reports for visualization of data and improving business decisions using cascading parameters and SSRS charts like bar, pie, line, column, Area etc.
• Deployed SSRS RDL files into report manager and managed report security by granting privileges to the report
• Created Report models for business users to design Ad-hoc reports using report models.
• Created snapshots for reports and improving performance of reports using cache mechanism.
• Involved in Relational and Dimensional Data Modeling Techniques to design data models using Erwin tool.
• Created Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions to implement the business logic.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Worked with PL/SQL in Oracle 10g database version, developed custom oracle packages involving stored procedures, functions, custom data types, record types, custom object types.
• Created Release scripts and rollback scripts by creating master scripts for DBA to run. Implemented spooling to capture the execution log of these scripts.
• Designed and developed DTS packages for transferring data from flat files and Access files.
• Created many SSIS Packages based on business requirements using Control flow tasks and Data flow transformations.
• Involved in converting SQL Server 2000 DTS packages to SQL Server 2008 R2 SSIS packages.
• Automated many manual operations using SSIS as a platform and deploying packages in File System and scheduling using SQL Server Agent Job.
• Involved in building cubes and dimensions using SSAS.
• Worked with Linked servers in SQL Server and Database Links in Oracle.
• Worked with SQL Profiler, SQL Analyzer, and SQL Enterprise Manager for performance tuning and debugging the stored procedures
• Worked ASP.Net Web forms in 2.0 Framework using C#. Net, built Front-end screens, user components such as user controls, custom controls.
• Worked with ADO.Net for database connectivity using Data Readers, Data Adapter, Data Tables, and Data sets.
• Created SOAP Based web services and consumed services to implement business functionality as per the requirements.
• Worked with Testing Team and Business users and assisted in testing the functional and business testing.
• Created unit test cases for module testing and also tested the end-to-end business functionality.

Environment: T-SQL, PL/SQL, SQL Server 2000/2005/2008 R2, COGNOS 8 BI, Windows 2003 Server, Query Analyzer, MS Access, Flat files, Oracle10g, DTS, OLAP Services, Erwin Data Modeler, ASP.NET 2.0 .Net Framework 2.0/3.5, ADO.Net, C#. NET, VB.NET, Subversion.

Confidential, Portland, OR

SQL / ASP.Net Developer

Responsibilities:

• Involved in Design, Development and testing of the system.
• Interacted with Team in Analysis, Design and Develop database using ER Diagram.
• Created database tables, stored procedures, functions, views, DML and DDL Triggers, constraints.
• Worked with ASP.NET web forms to create web pages.
• Worked with ADO.NET data adapters, readers, data tables, datasets, Data Relations, Data Views, Row filtering and sorting.
• Worked with connected and disconnected data mode in ADO.NET.
• Worked with SSRS 2005 reporting to build reports and deployed to report manager.
• Used SSRS Report viewer in ASP.NET web forms to render the reports.
• Created parameterized reports in SSRS 2005.
• Worked with testing teams to support testing in QA and UAT.
• Involved in deploying web code in IIS Web server and tested functionality.
• Migrated DTS Packages developed in SSIS 2005 Packages.
• Created DTS Packages in SSIS 2005 and deployed to File system.
• Tested DTS packages deploying in SQL Server File System for complete functionality.

Environment: SQL Server 2000/2005, Oracle 9i, Windows Server 2000, ASP.Net, C#. Net, VB.Net, ADO.Net, .Net Framework 2.0, T-SQL, Erwin 7.0, and TOAD, IIS 6.0.