PROFESSIONAL SUMMARY:

• MS SQL Server Developer 2012/2008R 2/2008/2005/2000 with 8+ years of IT experience in various Industry verticals like Finance, Health Care, Technology and Electronics.
• Maintained positive communications and working relationships at all business levels.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.
• Expert in ETL - Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Prepared technical and functional designs in collaboration with teams and business users for Netezza
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008r 2/2008/2005.
• Expert in developing Drill through and Drill down reports using MS SQL Server Reporting Services (SSRS)
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages
• Expert in using SSIS (integration services) with MS SQL Server 2012/2008R2/2008/2005
• Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2012/2008R2/2008/2005
• Hands on experience in production/staging/test/development database administrative: Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

TECHNICAL SKILLS:

• MS SQL Server 2012/2008R 2/2008/2005/2000/7.0
• MS SQL Server 2008/2005 Integration Service (SSIS)
• MS SQL Server Reporting Services (SSRS)
• Business Intelligence Development Studio (BIDS)
• SQL Profiler
• SharePoint
• Enterprise manager
• Management studio
• Microsoft Access 2000
• ERWIN 4.0/4.1/4.2/7.2
• Microsoft Visio 10.0/11.0
• T-SQL
• ASP.NET
• C#
• VB.Net
• HTML
• XML
• XSL
• Oracle 11g/10g
• Crystal Reports 8.5/9/10/11
• TFS
• Netezza 6.0
• Visual source safe 2005
• MS office 2007/2003
• SharePoint
• Windows 2008/2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE:

Confidential, Rockville, MD

MS SQL BI Developer

Responsibilities:

• Analyzed & designed the business rules for complex stored procedures used for one of the key dashboards being created in Tableau and Qlikview.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Designed business solution to email all the employees that have not completed certain trainings using SSIS.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources. .
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
• Migrated packages from development server to production server using package configuration.
• Conducted user training sections and supported the requests for enhancements, modifications and new reports.

Confidential, Boston, MA

SQL Server /SSIS/SSRS/BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers and created documentation for the same.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Prepared technical and functional designs in collaboration with teams and business users for Netezza
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.

Tools: & Technologies: MS SQL Server 2012, T-SQL, SSIS 2012 , SSRS 2012, TFS 2010, Advanced Server, SSMS, ERwin v7.2, ASP.Net, C#, SharePoint.

Confidential, Creamridge, NJ

SQL Server/ SSIS/ SSRS/ BI Developer

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Used Visual Intercept Manager, the premiere bug tracking system for the Microsoft development environment, which is project oriented, scalable and optimized.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Provided technical guidance for re-engineering functions of teradata warehouse operations into Netezza.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Tools: & Technologies: SQL Server 2008R2, SSRS, SSIS, Oracle, DB2, MS Access 2003, MS Excel 2007, MS BIDS, Windows 2008 Server, Visual Studio 2008, VB. Net, C#.net, Performance Point Server.

Confidential, New York, NY

MS SQL Server/ SSIS/ SSRS/ BI Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server2008R2on the development server.
• Automated the migration of data from Flat file to MS SQL Server 2008R2 DB using Microsoft SQL Server Migration Assistant (SSMA).
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Migrated the entire schema as well as data into MS SQL Server 2008R2 and also validated the migration process to ensure that it has been successfully migrated.
• Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Provided documentation for all kinds of reports and SSIS packages.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Created SQL Server Drill down, Drill through, Adhoc, Cross tab report using SSRS to fit business requirements.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.

Tools: & Technologies: MS SQL Server 2008R2, SSIS 2008R2, SSAS 2008R2, T-SQL,MS Access 2007, Windows Server 2008, Erwin v7.1.

Confidential, NY

MS SQL Server SSIS/SSRS/BI Developer

Responsibilities:

• Involved in all the phases of SDLC.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used Stored Procedures for updating Servers.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House.
• Used VB. Net and C# code in Script Task and Script Component.
• Developed, deployed and monitored SSIS Packages. Involved in creating log files for SSIS packages.
• Created SSIS Package configurations for executing in different environments.
• Enabled Check points in SSIS package. Created break points in order to view the status of data, variables and over all status of SSIS package.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created/ Maintained clustered/ non clustered Indexes for fast and efficient reporting process.
• Used SSRS to create interactive reports with an ability to drill down into details.

Tools: & Technologies: MS SQL Server 2005, SSIS, SSRS, T-SQL, Crystal Reports 10,Visual Studio 2005, MS Office 2003, SQL Profiler, Windows 2000/2003.

Confidential, Newark, New Jersey

SQL Server /SSIS/SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect used (Kimball’s approach)on the development of logical data models.
• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources (Teradata) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to CDW with the help of SSIS.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2005 with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Established backup and recovery of MS SQL server 2005 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Used Visual Source Safe (VSS) for version control.

Tools: & Technologies: MS SQL server 2005, MS Server Integration services,SSIS, DTS, SSRS, Profiler and Windows Server 2003.

Confidential, NY

MS SQL Server SSRS/SSIS Developer

Responsibilities:

• Defined and designed the data sourcing and data flows, data quality analysis.
• Identified the data source and defined them to build the data source views.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SQL Server Agent to automate the SSIS 2005 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2005 and then created reports using this data using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2005.
• Tested and managed the SSIS 2005 and SSIS 2005 packages and was responsible for its security.
• Developed reports using efficient data retrieval techniques and tested the reports.
• Created Cross-Tab, Drill-down and Sub-Report using SSRS 2005.

Tools: & Technologies: MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Integration services, T- SQL, Erwin, MS Excel, MS word, Visual Studio 2005.