SUMMARY:

• 9+ years of experience with focus on data base design and development using different tools of ER diagram, T - SQL coding of MS SQL SERVER 2000/2005/2008 /2012/2014.
• Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning, RDBMS concepts and constructs, Kimball and Inmon Data warehousing methodologies
• Proficient in Installing SQL Server 2014/2012/2008/2005/2000 and configuration of their tools.
• Hands on experience in migration of database from SQL Server 2005 to SQL Server 2008, SQL Server 2008 to SQL Server 2012.
• Expert in writing SSIS Template Package using - Configuration, Logging, Error Reporting and Variables in SQL Server Integration Services to make package portable which Deployment and Troubleshooting
• Experience in Micro strategy Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts .
• Good exposure to BI reporting Micro Strategy 8i.
• Expert in MS SQL Server suite of Business Intelligence tools like SQL Server Reporting Services ( SSRS ), SQL Server Integration Services ( SSIS ) and SQL Server Analysis Services ( SSAS )
• Experience in using Audit functions and extensively used exception handling for catching and reporting errors.
• Excellent technical and analytical skills in designing of ER modeling for OLTP and dimension modeling for OLAP.
• Expert in creating indexed Views, complex Stored Procedures, effective Functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency using SSMS .
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP
• Experience in data warehousing including business intelligence tools- SSIS and SSRS. Very Good Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse using in BI Development (SSRS, SSIS, SSAS)
• Experience in migrating SQL 2000 servers to SQL 2005 and SQL 2005 to SQL 2008. Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server Export Utility
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Expertise in SQL Server reporting services (SSRS)2005/2008 in generating complex reports in cascaded reports, parameterized reports and Ad Hoc reports. Knowledge in creating OLAP CUBES using (SSAS) 2005/2008.
• Extensive experience in Data Migration between homogeneous & heterogeneous systems using various tools (DTS Import Export Data, Bulk Insert and BCP, SSIS)
• Experience on Designing, developing and executing tests that validate the data movement processes that are consistent, repeatable and scalable.
• Experience in Finance Industry, Investment banking, Retail banking, Commercial banking, Credit Cards, Insurance and Wealth Management
• Good SQL Server Administration skills including backup recovery, database maintenance, user authorizations, Database creation, Tables, indexes, Partitions.

TECHNICAL SKILLS:

SQL Server Tools: MS SQL Server 2014, 2012, 2008, 2005, 2000,7.0, Microsoft Access 2007/2003 SQL Server Management Studio(SSMS), Analysis Services(SSAS), MS SQL Server Integration Service(SSIS),MS SQL Reporting Services(SSRS), MS SQL Server Index Tuning Wizard, Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DDL, DML, Stored Procedures, UDF, Triggers, DTS.

Operating Systems: Windows 2008/2003/2000/ NT 4.0, Windows XP/98/95.

Data Migration: MSDTS, SSIS, BCP, Data Migration, Import/Export Wizard.

Languages/IDEs: T-SQL, Visual Studio 2015/2010/2008/2005/2003, C, C++, VB.Net, C#

Data Modeling: Erwin 4.x, MS Visio 2000/2003.

Web Technologies: ADO.NET, IIS, HTML, DHTML, XML, Web Services, Visual Studio 2005, MS FrontPage 98/2000

Reporting Tools: SQL Server 2014/2012/2008/2005 Reporting Services, Crystal Reports

Office Suite / Tools: MS Office 2007/2003

PROFESSIONAL EXPERIENCE:

Confidential, Lake Success NY

MS SQL Server BI/ ETL Developer-SSIS/SSRS/SSAS

Responsibilities:

• Created Staging Table and Target Table using SSMS and to load data into tables using SSIS.
• Created various stored procedures using Dynamic SQL, advance T- SQL techniques like Common Table Expressions, ranking functions etc using SSMS.
• Created Merge, Update Statements to load Incremental data using business keys.
• Created User defined functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Created SSIS Packages to load Xml files, Csv Files, Flat Files, Excel Files.
• Designed and implemented a Promotion Process to deploy the SSIS Packages using Project Parameters, Environment Variables on to different environments.
• Scheduled the SSIS Packages to be run on different environments and monitored the process.
• Used Package Logging feature to troubleshoot problems that occurred during the execution of the package during run-time.
• Identified the problems in the data and fixed them on the data flow and validation objects of SSIS. Whenever a new pattern of data problem appears on the incoming data, the problem is logged into the log file, and data is analyzed and immediate solution is provided, validated and implemented into production.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column, Rowcount and Union ALL.
• Added custom logging to new and existing SSIS package to track performance of runtime process.
• Performed Database administration tasks such as taking backup of tables and databases, Restore a database by moving data from one database of a server to another database of a server using import and export.
• Created logical mapping documents and converted into physical mapping document.
• Worked on de-duplication data using SSIS and T-SQL.
• Participating in status meetings, and conducting internal discussions, reviews as well as formal walkthroughs, Knowledge Transfers among team members.
• Provided Production Support for Live code running in production and implemented necessary changes trough release management team.
• Written Technical documents for each object created on Database and SSIS.

Confidential, Wa

MS SQL Server BI/ ETL Developer-SSIS/SSRS/SSAS

Responsibilities:

• Responsible for creating SSRS reports (Drill down, sub-reports, charts, and parameterized linked reports) for paper machine sites using Microsoft SSRS 2008 R2.
• Developing OLAP cubes using SSAS 2005/2008 and Expertise skills in calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005/2008) using multidimensional expression (MDX), mathematical formulas, and user-defined functions
• Used Package Logging feature to troubleshoot problems that occurred during the execution of the package during run-time.
• Identified the problems in the data and fixed them on the data flow and validation objects of SSIS. Whenever a new pattern of data problem appears on the incoming data, the problem is logged into the log file, and data is analyzed and immediate solution is provided, validated and implemented into production.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Designed and implemented a Promotion Process to deploy the SSIS Packages, Configuration Files on to different environments.
• Scheduled the SSIS Packages to be run on different environments and monitored the process.
• Created Reports using SSRS Dashboard - Parameterized, Drill Through, Drill Down, Link, Chart, Gauge report based on parameter and scheduled Monthly, Quarterly, Daily reports.
• Designed, Created, and managed multidimensional structures using SSAS.
• Deploy/Design cubes in SSAS environment Snowflake and Star Schema Designs.
• Added custom logging to new and existing SSIS package to track performance of runtime process.
• Performed Database administration tasks such as taking backup of tables and databases, Restore a database by moving data from one database of a server to another database of a server using import and export.
• Created various stored procedures using Dynamic SQL, advance T- SQL techniques like Common Table Expressions, ranking functions etc using SSMS.
• Created logical mapping documents and converted into physical mapping document.
• Worked on de-duplication data using SSIS and T-SQL.
• Created User defined functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Participating in status meetings, and conducting internal discussions, reviews as well as formal walkthroughs among team members.
• Provided Production Support for Live code running in production and implemented necessary changes trough release management team.
• Written Technical documents for each object created on Database and SSIS.

Confidential, Malvern, PA

SQL Server BI Developer

Responsibilities:

• Developed SSIS packages to extract data from sites (Flat Files, Excel Files OLEDB to Sql Server) and load the data into the Data warehouse.
• Created report formats and delivered personalized messages from the BI platform through Micro Strategy Narrowcast Server to a wide range of users. Worked on Performance tuning of Reports.
• To understand business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development.
• Perform data analysis to identify legacy data that needs to cleanse prior to the migrations.
• Implemented various transformations as per the business requirements to extract the data and load in to the appropriate destination tables such as Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Support existing data warehouse reporting platform and applications to ensure operational availability and scalability.
• Responsible for creating SSRS reports (Drill down, sub-reports, charts, and parameterized linked reports) and give report access to airport sites using Microsoft SSRS 2008 R2.
• Used Package Logging feature to troubleshoot problems that occurred during the execution of the package during run-time.
• Identified the problems in the data and fixed them on the data flow and validation objects of SSIS. Whenever a new pattern of data problem appears on the incoming data, the problem is logged into the log file, and data is analyzed and immediate solution is provided, validated and implemented into production.
• Performed Data Cleansing and Data Profiling using several transformations like DataConversion and Derived Column.
• Designed and implemented a Promotion Process to deploy the SSIS Packages, Configuration Files on to different environments.
• Scheduled the SSIS Packages to be run on different environments and monitored the process.
• Created Reports using SSRS Dashboard - Parameterized, Drill Through, Drill Down, Link, Chart, Gauge report based on parameter and scheduled Monthly, Quarterly, Daily reports.
• Designed, Created, and managed multidimensional structures using SSAS.
• Deploy/Design cubes in SSAS environment Snowflake and Star Schema Designs.
• Added custom logging to new and existing SSIS package to track performance of runtime process.
• Performed Database administration tasks such as taking backup of tables and databases, Restore a database by moving data from one database of a server to another database of a server using import and export.
• Created various stored procedures using Dynamic SQL, advance T- SQL techniques like Common Table Expressions, ranking functions etc using SSMS.
• Created logical mapping documents and converted into physical mapping document.
• Worked on de-duplication data using SSIS and T-SQL.
• Created User defined functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Participating in status meetings, and conducting internal discussions, reviews as well as formal walkthroughs among team members.
• Provided Production Support for Live code running in production and implemented necessary changes trough release management team.
• Written Technical documents for each object created on Database and SSIS.

Environment: MS SQL Server 2008/2012 SSMS,SSIS, SSRS,SSAS, MS Access 2007, Microsoft Visual Studio 2008/2010, VB.net, MS Visio, Share Port, SharePoint, Team Foundation Server and ERWIN

Confidential, Wilmington, DE

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in gathering business requirement with Business Analyst, Database architect and business users.
• The various ETL tools like data flow task, OLE DB, look up were used to extract data from multiple data sources simultaneously
• Created logical - Visio Diagram for understanding process flow based on requirement and updated existing process diagram based on enhancement.
• Created SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.
• Provided technical leadership and expertise in data mapping, database design, and implementation and maintenance phases.
• Created Centralized SSIS Configuration, Logging, Error Handling and Metadata tables.
• Created Database Backup Plans for Full, Differential and Transactional Database Backups with different recovery models (Simple, Full and Bulk Database monitoring and tuning).
• Created functions, tables for tracking the package execution process (start time, end time, load information, suspended records, status etc) using SSMS
• Created SSIS packages for Incremental Load. Using Merge statements/stored procedure.
• Created the base SSIS template package including all necessary components considering best practices like Basic Logging (both SQL Server and text file logging), configuration, connection managers, pre execution, post execution etc.
• Deployment of SSIS package and SSAS Cubes using command line utilities.
• Checked Performance Tuning (Cluster and Non Cluster), Indexing, Query Optimization.
• Successfully implemented Database Mirroring.
• Created and managed SSIS packages, and dynamic stored procedures.
• Used SSIS for data import and export data from SQL Server to Access, text and EXCEL files.

  Created and altered database objects like tables, views, indexes, stored-procedures, triggers, cursors.

• Created Logical Model using MS Visio and Performed data transfer (import & export) using BCP.
• Created approximately 35 packages including extraction from flat files fixed width, excel file, oracle, and load data to SQL server.
• Implemented all types of control flow and data flow transformations in packages to handle different logics.
• Created various stored procedures using Dynamic SQL, advance T- SQL techniques like Common Table Expressions, Pivoting, grouping sets, ranking functions using SSMS.
• Converted various SQL statements into stored procedures thereby reducing the Number of database traffic (since Stored Procedures passes the whole block at one time)
• Ensured that SQL system improvements are successfully implemented and monitored to increase efficiency.
• Developed and assisted with designing all systems integrations using SSRS reporting and all SQL-based stored procedures and databases.
• Developed complex Queries & dynamic Stored Procedure for creating Maintenance Plans to

  Generate Reports every day for Server’s Health check.

• Supported all departments with requests related to SQL database, such as ad-hoc reports, parameterized, drill-down and drill-through reports.
• Used Script task for creating customers invoice related emails.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, T-SQL, Windows Sever 2008, Win 2003, SharePoint Designer 2007.

Confidential, NY

MS SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions and Fact tables.
• To understand business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development.
• Created packages including extraction from flat files, excel file, oracle, SharePoint list and load data to SQL server.
• Implemented all types of control flow and data flow transformations in packages to handle different logics.
• Created stored procedures for application development with user defined functions. Also Created SQL scripts for tuning and scheduling using SSMS.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SSIS.
• Designed and Developed SSIS packages using SQL SERVER 2005 Integration Services for multiple data sources xml, web services, OLEDB, file system task in SQL SERVER Integration Services to upload and download the ETL DATA.
• Imported and Exported data from homogeneous and heterogeneous sources using SQL Server tools such as SQL Server Integration Services.
• Created data Warehouse packages to load Slowly changing dimensions (SCD1 and SCD2) using Merge Statement as well as Upsert in SSIS (Lookup and Merge Techniques)
• Build the Dimensions, cubes with Star schema and Snow flake schema using SQL Server Analysis Services (SSAS)
• Proficiently created drill down reports, linked reports, drill through reports and sub reports using SSRS.
• Proficiently created and manage roles and security of reports and scheduled the Subscription of Reports using SSRS.
• Developed a Tabular Reports using SSRS Report Designer.
• Used complex queries to pull data from excel as well as other databases to the table that has been designed schema.
• Worked on SQL Profiler and Estimated Query plan to optimize the performance of SQL queries and stored procedures.
• Used RANK and PARTITION features in SQL Server 2005.
• Developed export module which can directly export data to xml and text file and also integrated with E-mail, so they can get E-mail notifications.
• Transformations of data such as adding derived column and sorting of data.
• Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.

Environment: MS SQL-Server 2005/2008, DTS, ETL Strategies, BI tools, Database clustering’s, OLTP, OLAP, SQL Server

Confidential, MA

MS SQL Server BI/ETL Developer

Responsibilities:

• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005.
• Created stored procedures, Triggers and functions using SSMS.
• Worked with developers and DBA to tune the queries, run scripts and move the database production to development servers.
• Responsible for creating database objects like table, views, store procedure, triggers to provide structure to store data and to maintain database efficiently.
• Did performance tuning on SSIS Packages, Jobs, Stored procedures and Triggers.
• Converted, loaded and integrated data from Access, Excel, text/ csv files and internal database applications including the mainframe with data captured for security applications.
• Created indexed generic views to facilitate easy user interface implementation, security, and triggers on them to facilitate consistent data entry into the database.
• Created Documentation for the packages and scripts and job created to migrate data from legacy system to SQL Server 2008.
• Created useful user defined functions and multifaceted stored procedures for reporting purposes.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS.
• Proficiently created and manage roles and security of reports and scheduled the Subscription of Reports using SSRS.
• Worked and coordinated with developers in writing and tuning new stored procedures.
• Designed, Created, and managed multidimensional structures using SSAS.
• Created different Parameterized Reports (SSRS 2000/2005/2008 ) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Schedule Jobs to run SSIS package in night feed to DSS system for fresh day data.
• Wrote standard & complex SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements using SSMS.
• Responsible for stored procedures optimization, performance tuning and index tuning. Automated processes using SQL Server Jobs.
• Set up backups for the newly created databases.
• Scheduled transfer of backups and log files to different servers.

Environment: MS SQL Server 2005/2008, MS SQL Server Integration/Reporting Services 2005(SSIS/SSRS), Windows Server XP/NT/ 2003/2000, DTS, SSAS, Performance monitor, SQL Profiler, DTA, DTS, OLAP