SUMMARY

• Over 7 years of experience in SQL Server database development and administration, extensively worked in OLTP, OLAP, Client - Server & Enterprise Data warehouse Environments.
• Hands-on experience in Upgrade/Migration of MS SQL Server using any suitable approach.
• Expertise on Business Intelligence Tools (SSAS, SSIS AND SSRS).
• Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T-SQL.
• Extensive experience in designing, developing and deploying SSIS 2008 packages.
• Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Extensive experience in migrating DTS packages to Integration Services Packages.
• Excellent experience in developing Reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Experience in defining Queries for generating drill down and drill through reports in SSRS 2008.
• Experience in Designing, Building Dimensions, Cubes with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
• Experience in installing, configuring and monitoring MS SQL Server 2008/2005/2000 installations.
• Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Extensive knowledge of Normalization and Database Design Concepts.
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies.
• Experience in data modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
• Expertise in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.

TECHNICAL SKILLS:

Databases: MS SQL server 2005, SQL Server 2008R2/2008, Oracle9i/10g, Mysql, MS Access. Knowledge of MS SQL Server 2012.

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio. (SSIS, SSAS, SSRS), SQL Server Query Analyzer.

Languages: HTML, CSS, XHTML, XML, SQL, T-SQL, PL/SQL

Operating Systems: Windows 98/2000/2003/ XP/VISTA, Windows NT/ 7, UNIX

ETL Tools: Data Transformation Services (DTS),SQL Server Integration Services (SSIS)

OLAP/Reporting Tools: SQLServer Analysis Service(SSAS), SQL Server Reporting Service(SSRS), MDX, Crystal Reports, Excel Spread sheet

Methodologies: Logical and Physical database design

Other tools: MS Visio

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Sr. SQL Server Developer/ SQL BI (SSIS) Developer

Responsibilities:

• Developing ETL Packages using SQL Server 2012 Integration Services to migrate data from various data sources into a SQL Server 2012 database.
• Applying various data transformations like Data Conversion, Multicasting, Conditional Split, and Derived column in SSIS.
• Scheduling and executing SSIS Packages, using SQL Server Agent.
• Created SSIS packages to import data from different sources such as Flat Files, Excel files, OLEDB sources etc
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Created various Ad-hoc reports using Business Objects reporting tools - Web Intelligence and Crystal Reports.
• Performing T-SQL coding, Scripts and functions on a day-to-day basis
• Writing complex SQL queries to populate data from different tables and which can be used for reports.
• Designed and implemented various stored procedures for automating tasks/ to be used in reports.
• Created insert/ update scripts to fix data issues, created database objects like Views and Functions. Check in Code into TFS (Source Control) as and when the code is updated.

Environment: MS SQL Server 2008/2012, T-SQL, SSIS 2008/2012, Crystal Reporting 2012, Web Intelligence

Confidential, Houston, TX

BI Developer

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, sub-queries, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules.
• Experience in creating joins for complex queries involving multiple tables.
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Involved in query optimization and tuning stored procedures for better performance.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on different kinds ofTransformations (Data Conversion, Lookup, Derived Column, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Slowly Changing Dimension, Union All etc)inSSISas per the clients Requirement.
• Experience in providing Error handling by using Event Handler for SSIS Packages.
• Worked with different methods of logging in SSIS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Created stylish Report Layouts and Deployed the Reports using SSRS 2005.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS.
• Generated the weekly, monthly, and quarterly reports by using SSRS.
• Hands in improving performance of reports by caching them.
• Created data loads and Upgrade scripts for data migrations and validations.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data warehouse.
• Involved SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point 2007/SharePoint Server.
• Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.

Environment: MS SQL Server 2005/2008 Enterprise Edition, SSIS/SSRS/SSAS 2005/2008, Visual Studio 2008,PL-SQL, Share Point, Performance Monitor, Query Optimizer, Oracle 10g, MS Access, Windows Server 2003.

Confidential, Oaks, PA

MS SQL Developer

Responsibilities:

• Responsible for requirements gathering, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Designed and developed SSIS packages to migrate data from multiple data sources for data analyzing, deploying and dynamic configuration of SSIS packages.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
• Migrated database from SQL server 2000 to SQL server 2005 using SSIS packages.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensively used SSIS for transferring data manually from DTS packages to SSIS packages using SSIS 2005.
• Developed and maintained a combined data store for reporting purposes.
• 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, created aggregation reports and also generated reports using Global Variables, Expressions and Functions 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.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Established backup and recovery of SQL server 2005.
• Used Visual Source Safe (VSS) for version control

Environment: MS SQL Server 2005 Enterprise Edition, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005, DTS, T-SQL, VB Script, Windows Server 2003, Erwin 4.0.

Confidential

SQL Server Developer

Responsibilities:

• Designed, implemented and administrated SQL Server 2005 databases.
• Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
• Create and Modify Stored Procedures, Triggers, Views according to the business.
• Developed various reports to validate the data between source and the target systems.
• Design of ETL processes to transfer customer related data from MS Access, excel to SQL Server.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.

Environment: SQL Server 2005 Enterprise Edition, Enterprise Manager, Query Analyzer, Import & Export Data, VB.Net, Windows 2000, MS Access, MS Excel.

Confidential

Database Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Actively participated in developing T-SQL queries involving joins, stored procedures and views to implement security.
• Involved in the Normalization process to improve performance.
• Designed and developed forms using Visual Basic

Environment: C#.Net, SQL Server 2000, Windows 2000.