SUMMARY

• Over 8 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008 R2/2005/2000 with various business domains like Healthcare, Insurance, Finance in Development, Testing and Production Environments
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2012/2008/2005.
• Experience in Creating Tables, Joins, Views, Indexes, Triggers, Stored Procedures, User Defined Functions, synonyms, collections, Exception handling, Query Tuning using query optimizer.
• Experience in writing T - SQL objects, stored procedure in SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012.
• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Responsible for database development and performance tuning of the T-SQL queries using SQL Profiler and Activity Monitor.
• Successfully implemented indexes on tables and views for optimum performance tuning and debugging.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Performed some of theDBAactivities likeBackup, Restore, monitoring etc.
• Involved in database security for assigning permissions to the users, logins and also data administration.
• Experience working with XML documents and extracted data from XML to SQL server.
• Expert Knowledge of Integration Services (SSIS) and Reporting Services (SSRS). Worked Extensively on ETL process using SSIS packages from flat file, XML, COBOL and different sources.
• Excellent in creating 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.
• Knowledge in creating SSIS Packages using oracle source and oracle destination and extensively used Team Foundation server (TFS) to check SSIS packages in to the source control.
• Experience in testing SSIS Packages using SOAP UI by configuring end points of WCF services.
• Worked with re-directing outputs into different formats including XML Files and various other data sources.
• Experience in Developing, Deploying and Monitoring Packages for ETL Tasks using SSIS, DTS Import/Export Utility, BCP (Bulk Copy Program) and DTS Packages.
• Responsible for designing ETL solutions/ framework with SSIS. Also responsible for the performance tuning of the ETL packages.
• Involved in designing complex Crystal Reports 2011/2008/XI/10.0/8.5 including Cross-tab, Conditional, Drill-down/summary, Top/Bottom N and also reports involving multiple Sub reports, On Demand Sub reports, Charts, Conditional formatting, Summaries and Complex formulae.
• Responsible for Data Migration from SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012 Databases.
• Strong Knowledge on concepts of Data Modeling Star Schema/Snowflake modeling, FACT & Dimensions tables and Logical & Physical data modeling.
• Designed the web UI using Angular JS, HTML5, CSS3, JavaScript and AJAX controls.
• Hands on experience on developing a Single Page Application (SPA). Used MVC and MVVM design patterns while designing the UI.
• Experience in Designing, Developing and Maintaining Web Applications using Visual Studio .NET, ASP.NET MVC 3, C#, VB.NET, ADO.NET.
• Good communication with the project team throughout all stages of design, managing time effectively, and work on multiple project timelines simultaneously in a demanding deadline driven environment.

TECHNICAL SKILLS

Programming Languages: C#, C, C++, VB.NET, Visual Basic for Applications (VBA), XML and ASP.NET.

RDBMS: MS SQL Server 2012, 2008 R2, 2008/2005/2000, Oracle 8i/9i/10g, MS- Access 97- 2007

SQL Server Tools: SQL Server Management Studio (SSMS), Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio (BIDS), SSIS, SSAS, SSRS, Crystal Reports 9/10, TFS 2008/2010,WCF, SOAP UI, Data Transformation Services.

Data Modeling Tool: ERwin r7.3/7x/4.0, MS Office Visio 2003/2007.

Operating System: Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

Other tools: Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize.

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

SQL Server BI Developer /SSIS

Responsibilities:

• Developed Complex SQL Queries using sub queries, functions, joins, views, triggers etc.
• Created Joins and sub-queries for complex queries involving multiple tables.
• Developed ETL packages with different data sources (SQL Server, Flat Files, XML files) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Expert in using Lookup transformations, Merge Joins, Derived Columns, Aggregate, conditional split, SQL task, script task etc. with multiple dataflow tasks. Used different control flow tasks and dataflow tasks for creating SSIS packages and different types of transformation for data conversion, sorting and data cleansing from different sources.
• Worked on complex ETL packages to extract data from staging tables to partitioned tables with incremental load.
• SSIS Packages were developed from Flat file sources and also to Flat file destinations by staging data in staging tables and using different transformations.
• Developed SQL Queries and SSIS Packages which were involved with state benefits data from COBOL sources.
• Expert in using Lookup transformations, Merge Joins, Derived Columns, Aggregate, conditional split, SQL task, script task etc. with multiple dataflow tasks. Used different control flow tasks and dataflow tasks for creating SSIS packages and different types of transformation for data conversion, sorting and data cleansing from different sources.
• Worked on complex ETL packages to extract data from staging tables to partitioned tables with incremental load.
• SSIS Packages were developed from Flat file sources and also to Flat file destinations by staging data in staging tables and using different transformations.
• Worked with re-directing outputs into different formats including flat files, XML files and various other data sources.
• Created bat files and WCF Services to call SSIS packages.
• Experience in creating Error Handling using Event handlers on error, on warning, on task failed event types.
• Worked extensively on SQL Queries, Stored Procedures and SSIS packages in testing environments.

Confidential

Mid .Net/UI Developer

Responsibilities:

• Developed WCF Services endpoint for the UI application to retrieve the data from the database and display for the user.
• Designed the web UI using Angular JS, HTML5, CSS3, JavaScript and AJAX controls.
• Utilized Entity framework technology extensively for data retrieving, querying, storage and manipulation using LINQ.
• Consumed Oracle Identity Manager (OIM) - SOAP Web Services for secure login purposes.
• Created and maintained database objects like complex Stored Procedures, Triggers, Cursors and Tables, Views and SQL Joins.
• Used Master pages and Cascading Style Sheets (CSS) to maintain design consistency across all web forms.
• Hands on experience on developing a Single Page Application (SPA).
• Used MVC and MVVM design patterns while designing the UI.
• Also used Unit of Work, Dependency Inject and Bootstrap patterns.
• Hands on experience in using the WCF and SOAP Web Services.
• Used SMTP library to generate the Automatic Email Generation for the client and the users to update about the changes in their profiles.
• Responsible for maintaining versions of source code using Team Foundation Server 2013.
• Created Futuristic Responsive UI that are devise independent by using the latest Web / client side technologies like HTML5, CSS3, Bootstrap, JavaScript and JQuery.
• Participated in the SIT (System Integration Testing).
• Supported the testing team to development Test Cases and Scenarios for the testing phases.
• Also supported the testing team to create the Defects and resolved the defects in the SIT phase.
• Hands on experience working in the Waterfalls methodology.
• Troubleshooting-Worked with resolving the issues from the Issue Log of the current Project.

Confidential

SQL Server BI Developer /SSIS

Responsibilities:

• Developed Complex SQL Queries using sub queries, functions, joins, views, triggers etc.
• Created Joins and sub-queries for complex queries involving multiple tables.
• Optimized SQL queries and Stored procedures using SQL profiler and Query Analyzer for handling huge data.
• Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.
• Experience in Error handling and fine tuning Queries, Stored Procedures and enhanced the performance based on execution plan.
• Involved in database security for assigning permissions to the users, logins.
• Involved in data administration tasks like database mirroring and synchronization.
• Created and developed Stored Procedures reading XML files and extracted the data into tables using SSIS packages while also handling errors. Involved extensively in coding and debugging these SQL Stored Procedures and SSIS Packages from XML files under critical circumstances for UAT in few days which would have needed more than a month.
• Developed ETL packages with different data sources (SQL Server, Flat Files, XML files) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed SQL Queries and SSIS Packages which were involved with state benefits data from COBOL sources.
• Expert in using Lookup transformations, Merge Joins, Derived Columns, Aggregate, conditional split, SQL task, script task etc. with multiple dataflow tasks. Used different control flow tasks and dataflow tasks for creating SSIS packages and different types of transformation for data conversion, sorting and data cleansing from different sources.
• Worked on complex ETL packages to extract data from staging tables to partitioned tables with incremental load.
• SSIS Packages were developed from Flat file sources and also to Flat file destinations by staging data in staging tables and using different transformations.
• Worked with re-directing outputs into different formats including flat files, XML files and various other data sources.
• Created WCF Services to call SSIS packages using C# Scripts.
• Experience in creating Error Handling using Event handlers on error, on warning, on task failed event types.
• Worked extensively on SQL Queries, Stored Procedures and SSIS packages in testing environments.
• Experience in testing SSIS Packages using SOAP UI by configuring end points of WCF services.
• Provided support for production deployments. Extensively involved in SQL, SSIS validations, file and batch monitoring during production from SFTP Server.

Environment: SQL Server 2012, T-SQL, MS Visual Studio 2013/2012 (SSIS), WCF, SOAP UI, Dashboards, C#, ASP.Net.

Confidential, Oklahoma City, OK

Senior SQL Server BI Developer SSIS/SSRS

Responsibilities:

• Developed Databases using complex Stored Procedures, Triggers, Functions, Constraints, Indexes and Views as required in a SQL Server environment.
• Dealt with Fine-Tuning stored procedures to improve performance with a Query Plan using SQL Tuning Advisor.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Monitored and Tuned SQL server Database Performance and Query Analysis for optimizing report performance.
• Analysis and documentation of SSIS packages and existing reporting system.
• Performed some of theDBAactivities likeBackup, Restore, monitoring etc.
• Implemented error handling and resolved issues by troubleshooting the scripts in failure to load the data into database.
• Worked with re-directing outputs into different formats including XML Files and various other data sources.
• Created, loaded, and modified new packages added and configured components by using Control Flow Tools and Data Flow Tools in Microsoft SQL Server Integration Services (SSIS).
• Knowledge in creating SSIS Packages using oracle source and oracle destination and extensively used Team Foundation server (TFS) to check SSIS packages in to the source control.
• Created ETL tools and packages to extract heterogeneous data from Excel, Flat file, XML, OLE DB Source to SQL Server.
• Reviewed and developed data models and database designs with development teams.
• Populated Data Warehouse using SSIS Packages.
• Deployed SSIS packages dynamically into Development, Testing and Production environments by creating Environment variables and Windows variables.
• Developed SQL Server Reporting Services (SSRS) reports using Global Variables, Expressions, and Functions.
• Developed and deployed different types of reports like Drill Down, Drill Through, Parameterized, List, Tabular, Chart, Linked and Sub Reports etc. using SSRS and integrated into the web front end.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008.

Environment: SQL Server 2014/2012/2008, T-SQL, MS Visual Studio 2012 (SSIS, SSRS), Query Analyzer, Enterprise Manager, Dashboards, C#, ASP.Net, Star Team.

Confidential, Miami, FL

Sr. SQL Server BI Developer SSIS/SSRS/SSAS

Responsibilities:

• Created database objects like tables, complex Stored Procedures, Functions, Views, Triggers, Indexes and T-SQL queries (DDL and DML) to meet the business requirements using T-SQL.
• Used DDL and DML for writing Triggers, Stored Procedures, and Data manipulation.
• Involved in writing SQLStored Procedures to access data from MS Access. Developed SQL queries to check the database.
• Created functions and developed procedures for implementing application functionality at the database side for performance improvement.
• Pulling the data from T-SQL stored procedure to make the parameterized reports.
• Hands on MS SQL Server configuration, performance tuning, debugging, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using SQL Server Profiler, Execution Plan, Performance Monitors.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component.
• Performing DBA functions, installing, configuring and supporting database systems.
• Responsible for Data Migration from SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012 Databases.
• Experience in providing Logging and Error handling by using Event Handler and Custom Logging for SSIS Packages and involved in scheduling and administering the SSIS packages.
• Extracted data from XML to SQL server.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS) version.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Used VB.Net and other .NET languages for Script task. Script task is primarily to control the flow of SSIS package.
• Backing up, Restoring system & other databases as per requirements, and also scheduled those backups.
• Developed Query for generating drill down, drill through, parameterized, cascaded reports in Crystal Reports 2011.
• Worked on SQL Server Reporting Services (SSRS) and Report Builder Model to generate custom reports.
• Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.
• Worked on Tabular data models and created cubes in SSAS.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Experience in Dimensional Data ModelingStarandSnow Flake Schemas.
• Provided support for production deployments and automation. Provided second level support for production issues related to the BI environment.

Environment: SQL Server 2012, T-SQL, Crystal Reports 2011, MS SQL Server Integration Services (SSIS), Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Query Analyzer, SQL Server Profiler, SVN version controlling, ASP.NET Framework 3.5/4.0, C#, Visual Studio 2012, XML, ADO.NET.

Confidential, Buffalo, NY

SQL Server BI Developer SSIS/SSRS/SSAS

Responsibilities:

• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables. Developed views using complex split week logics.
• Performed Data Modeling in the initial stages of the project.
• Worked in AGILE methodology using SQL Server 2008 R2.
• Experience working with XML documents.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Involved in query optimization, performance tuning and debugging.
• Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
• Implemented error handling in several existing Stored Procedures using Try Catch blocks.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes.
• Design, deploy, and maintain various SSRS Reports in SQL Server 2008 R2.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports, Tabular, Matrix etc.
• Handled complex financial data and large databases.
• Involved in the design and development of the SSAS cubes.
• Developed multi-dimensional databases (MDDB), OLAP cubes and data marts using SQL Server Analysis Services (SSAS) 2005 that stored and maintained the data.
• Provided technical guidance and support to end-users by developing documentations required.
• Used ADO.NETfor retrieving, querying, storage, and data manipulation. Implementation of client side validations using ASP.NET validation controls.

Environment: SQL Server 2008 R2/2008, T-SQL, Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Query Analyzer, SQL Server Profiler, SVN version controlling, ASP.NET, C# 3.5/2.0, .NET Framework 3.5/2.0.WebService, ADO.NET,HTML.

Confidential, Livingston, NJ

SQL Server BI Developer SSIS/SSRS

Responsibilities:

• Actively participate in gathering of user requirement and system specification.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and SSIS.
• Increased query performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created/Maintained clustered/non clustered Indexes for fast and efficient reporting process. Indexed views, dimensions and stored outlines for optimal performance.
• Check the performance of each and every query using SQL Profiler, Index Tuning Wizard and Estimated query plan optimize the performance tuning of SQL queries and stored procedure.
• Created partition table for very large database for good performance.
• Backups and Restoration / Database Recovery, Resource allocation / Monitoring
• Involved in Data Migration from SQL Server 2000 to SQL Server 2005 Databases.
• Deployed SSIS packages and Reports to Production Servers.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Responsible for designing ETL solutions/ framework with SSIS. Also responsible for the performance tuning of the ETL packages.
• Generated database monitering and data validation reports in Proclarity and SQL Server Reporting Service (SSRS). Reported all events and requirements through established reporting mechanisms in SSRS.
• Designed and developed OLAP using MS SQL Server Analysis Services
• Created complex business components in C# using .NET Class Library assemblies while migrating and implementing them in a multi-tier environment suitable for .NET Remoting,XML Web Services, Microsoft Transaction Server (MTS) to address applicationinfrastructure issues associated with building scalable enterprise level applications for multiple clients.

Environment: SQL Server 2008 R2/ 2008/2005/2000, Oracle 9i, T-SQL, Excel, MS Access, Advanced Windows 2000/2003 Server, Visual Basic .Net, SQL Server Data Tools, Query Analyzer, SQL Server Profiler.

Confidential, Houston, TX

SQL Server BI Developer SSIS/SSRS

Responsibilities:

• Installation, configuration of MS SQL Server 2005/2008.
• SQL serverUpgrade from 2005 to SQL 2008.
• Designing and creation oftablesandstored procedureswith E-R diagrams.
• Merging 2 different versions of databases to one single database and upgrading to SQL 2008.
• Designed the Dimensional modeling of the Data warehouse using Erwin.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
• Extensively involved in designing (Logical and Physical) of customer database.
• Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.
• Database and log backups and restoration, backup scheduling the backups.Backing up master and system databases and restoring them.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Data Warehousing using Data Transformation Services Package (SSIS).
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

Environment: MS SQL Server 2005/2008, Windows 2003 Server, SQL Query Analyzer, SSIS, TSQL, C#, ASP.NET.

Confidential, Clifton, NJ

SQL Server BI Developer

Responsibilities:

• Gathered Functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
• Actively involved as a part of a team for gathering and analyzing the User Requirement.
• Modified existing database to fit new business requirement by adding tables and relationships.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults. Upgraded SQL Server 2000 databases to SQL Server 2005.
• Managed the legacy data in the data warehouse from various data sources.
• Created Indexed View to optimize query performance by facilitating easy user interface implementation.
• Created Linked Server to retrieve data from other databases.
• Worked on SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server.
• Documented different Stages of Data Transformation, procedures and scripts.
• Worked on XML parameters for inserting data into tables using FOR XML, OPEN XML.
• Performed Backups and Restore of the databases.
• Upgraded DTS Packages to SSIS Packages.
• Involved in Import and Export of data between various sources and destinations using SSIS, BCP and Bulk Insert.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.
• Created jobs using SQL Server Agent and generated SSRS (SQL Server Reporting Services) reports as a part of each job.

Environment: Windows 2000 Advance Server, SQL Server 2000/2005, T-SQL, DTS, BIDS, SSIS, SSRS.

Confidential

SQL Server Developer

Responsibilities:

• Involved in Physical and Logical design of the databases.
• Developed DTS Packages to transfer the data between SQL server database and files and Scheduled Jobs for DTS packages.
• Created and maintained Data Transformation Service (DTS) packages for migrating data.
• Used BCP/Bulk Insert to publish table output to text files.
• Created advanced T-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers, User Defined Functions and Stored Procedures.
• Responsible for database development and performance tuning of the T-SQL queries using SQL Profiler and Activity Monitor.
• Used all Declarative Constraints for maintaining Data Integrity.
• Created Views to restrict access to data in a table for security.
• Involved in performance tuning of T-SQL queries, stored Procedures and implemented Auditing using triggers.
• Created schema objects, rules and granted roles to the users.
• Used SQL Profiler to debug T-SQL and slow running queries.
• Monitored the Database Performance using execution plans and Index tuning.
• Optimized the query performance with modifications in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins.

Environment: MS SQL Server 2000, T-SQL, Windows 2000 server, Windows NT 4.0.