Professional Summary:

• Over 7 years of IT experience in Database Development and Business Intelligence Technologies with expertise on ETL process, Reporting and Analyze using MS SQL Server 2008/2005/2000 as a MS SQL Server Developer.
• Worked in various domains like Retail Banking, Health Care, Transportation, Pharmaceuticals and Business.
• Experienced in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Excellent in Migration of SQL Server 2000 to SQL Server 2005 & SQL Server 2005 to SQL Server 2008.
• Expert in creation of Database Objects such as Tables, User Defined Data Types, Stored Procedures, Views, User Defined Functions, CTE’s and Triggers.
• Expert in writing SQL queries involving multiple tables using inner, outer joins and sub queries.
• Expert in Extracting and Transforming data using DTS in SQL Server 2000, SSIS in SQL Server 2008/2005,SQL Server Import Export Wizard, Bulk Insert Task and Bulk Copy Program(BCP).
• Involved in Migrating DTS packages to SSIS using Package Migration Wizard.
• Worked with control flow tasks like Execute SQL Task, File System Task for Backup, FTP task, Send Mail Task, For ,For each and sequence containers, Execute package and process task.
• Excellent in Data Extraction, Transforming and Loading (ETL) DTS Packages & 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, Audit , Derived Column , Merge, Lookups and Union all.
• Experienced in Error and Event Handling, Precedence Constraints, Break Points, Check Points.
• Experienced in Log Shipping to back up and restore databases to improve Performance.
• Expert in deploying packages using Deployment Utility, DTUTIL Command Line Tool and SSMS.
• Scheduled packages using DTEXECUI windows application and SQL Server Agent.
• Experienced in developing SSAS Cubes, Dimensions, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and deploying and Processing SSAS objects.
• Extensive experience in writing MDX Scripting and MDX Queries.
• Expert in creating Table, Chart, Matrix, Toggle, Linked, Parameterized, Ad-hoc and Sub- report in SSRS.
• Designed interactive reports by providing Drill down and Drill through with sorting option.
• Expert in deploying reports to Report Manager and Share Point Portal using Share Point Server.
• Experienced in optimizing performance of various long running queries and stored procedures using SQL Profiler, Index Tuning Wizard and Database tuning wizard.
• An enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills with good work ethics.
• Ability to work independently or as part of a team to accomplish critical business objectives. And to make decisions under pressure.

Education Qualifications: 
Masters in Computer Applications.

Skill Set:
MS SQL Server 2008/2005/2000, MS SQL Server 2008/2005 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), DTS, ETL, MS SQL Reporting Services (SSRS), Microsoft SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), Erwin Data Modeler 4.1/4.0/3.5, T-SQL, PL/SQL, C++, ASP.NET 3.5, VB Script, MS Visual Studio 2008/2005, MS Access 2007/2003, HTML 4.0, XML 1.0, DHTML, CSS, Java, Java script 1.8, AJAX V3.0, Oracle 10g, MS Visio 2007/2003, MS Visual Source Safe 4.0, MS Visual Basic 6.0, Windows 2000/2003 Advanced Server/Professional and Windows NT 4.0 Server/Workstation.

Projects Summary:

Confidential, New York 05/2010 - Present
MS SQL Developer/BI Developer (SSIS/SSAS/SSRS)
Confidential is the nation\'stop bookseller brandfor theseventh year in a row, and is ratednumber two in trust amongallretailersfor the second year in a row,according to the EquiTrend Brand Studyby Harris Interactive. The main aim of the project is to design and maintain centralized Data System which serves enterprise Reporting, Analysis and External data feeds based on the data coming from different source systems in the process of new business requirements and change management processes.
The ultimate goal of the project is to make sure that the up to date information is available to the business users for better analysis and decision-making purposes. The business users access the data through the centralized report portal and data cubes, which are based on MS SQL Server Reporting and Analysis services.
Hardware/Software: 
MS SQL Server 2008, SSIS, SSRS, SSAS, T-SQL, MS Office, VB.NET, C#.NET, Outlook Soft 4.2, Visual Studio 2005, SQL Profiler, Excel, Access, Share Point Server 2007.

Responsibilities:

• Involved in planning, defining and designing database using Erwin on Business requirements.
• Involved in installation and configuration of SQL Server 2008.
• Developed TSQL scripts with Views, Joins and Common table expressions (CTE).
• Implemented Stored Procedures and triggers to capture updated and deleted data from OLTP systems.
• Created SSIS packages to migrate data from heterogeneous data sources like Excel, Access, Flat files and Oracle to SQL Server 2008.
• Wrote T-SQL queries and stored procedures to perform Data Cleansing to eliminate dirty read.
• Implemented FTP task to download and uploads data files from an FTP server to local server.
• Used Data Conversion, Lookup, Fuzzy Lookup, Derived Columns, and Condition Split, Term Extraction, Aggregate, Pivot Transformation, Merge, Multicast and Union All transformations while extracting data.
• Ensured data changes in the source system by using Slowly Changing Dimension Transformation.
• Configured Send Mail Task to send the mails upon successful deployment of package using STMP.
• Developed SSIS packages to conduct simple and complex transformations, deployed and executed these packages using the Execute Package Utility.
• Performed package configuration to maintain environmental variables for packages.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server/BI Reporting Services (SSRS) and deploy it in SharePoint server.
• Scheduled reports on a weekly basis to generate the details of weekly calls for various location for assessing the business for that week.
• Subscribed reports to different users using SSRS 2008 and Share Point Server.
• Used VB code and Batch Script for maintenance of reports.
• Used Script Task as a performance counter in packages.
• Used Analyzing Services to build the data cubes using SSAS.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports.
• Improved Performance of the database by creating clustered and non clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Confidential, NY01/2009 – 04/2010
MS SQL Server Developer/BI Developer 
Confidential is afinancial servicescompany, the largestbank holding companyin the United States, by assets, and the second largest bank bymarket capitalization. The project was about migration the existing database from SQL Server 2005 to SQL Server 2008 and worked on improving the performance of the system. Reports are also created for the banking process on the daily and weekly basis. These reports are reviewed by directors and analysts to calculate different categories like banking calculation. It also involved in creating new database from different scatter database. The primary responsibilities of my role in this project were to design and develop the ETL procedures using SSIS and in creating cube using SSAS. 
Hardware/Software:
MS SQL Server 2008, SSIS, SSRS, SSAS, Oracle10g, Visual Studio 2005, VSS 2005, Erwin r7.2, Windows NT/2003, asp.net, MS Access.

Responsibilities:

• Actively participated as a team to gather requirements along with lead, DBA and technical manager.
• Migration of databases from SQL Server 2005 to SQL Server 2008.
• Extensive T-SQL Development on SQL Server 2008 for evolving business requirements, enhancement to existing procedures.
• Created SSIS package to load data from Flat File, Excel and OLEDB to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Deployed and scheduled the packages using SQL Server Agent Job.
• Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Table.
• Participated in requirement gathering of the cube design using SSAS.
• Involved in creating cube structure for the analysis of business condition and for creation of report using SSAS.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Used “SQL Profiler TSQL Duration” template for tracking execution time of TSQL Statements.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Confidential, New York03/2008 -12/2008
MS SQL Server Developer/ETL Developer
The Central Access System of HIQA (Highway Inspection and Quality Assurance) will enable HIQA Inspectors to electronically access and capture Inspection related data in the field. This will improve operational efficiency by eliminating duplicate entry of the same data on paper and into different systems. Carrying large amounts of data into the field and searching through it will also be easier and paperwork will be reduced.
The goals of the HIQA unit are to maintain the integrity of the streets of NYC, to expedite pedestrian and vehicular traffic flow around construction activity and increase the level of safety
Hardware/Software: 
MS SQL Server 2005, SSRS, SSIS, T-SQL, JavaScript ,VB Script, MS Visual Source Safe, Oracle, Windows Server XP, Erwin 4.0, Excel, MS Access, SQL Profiler.

Responsibilities:

• Developed Database Objects such as Tables, Views, Stored Procedures, Functions, and Triggers using SQL Server Management Studio (SSMS) and T-SQL statements to implement complex business logic.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), MS Excel Spreadsheet to SQL Server 2005.
• Converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of reports.
• Designed dynamic SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS.
• Design and develop SSIS package for loading data from OLTP to Data Warehouse.
• Used ETL to implement Slowly Changing Dimension (SCD) to maintain historical data in Data Warehouse.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Created stored procedures, triggers, indexes, rules, integrity constraints, cursors and views for the business logic.
• Created and scheduled Jobs and Alerts using SQL Server Agent.
• Created Views and Index Views to reduce database complexities for the end users.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data ,normalized tables, established joins and created indexes whenever necessary.
• Worked on pro-clarity to create cost-effective reporting and analytical solutions.
• Worked on Performance point server and created management reports.
• Used “SQL Profiler TSQL_Duration” template for tracking execution time of TSQL Statements.

Confidential, Livingston, NJ 06/2007 – 02/2008 
MS SQL Server Developer 
Confidential is a diversified national managed health care company. It provides a full range of risk and fee-based managed care products and services to a broad cross section of individuals, employer and government-funded groups. The project was mainly to create a database for the different diagnosis done on a patient, with different examiners and to create drill down and parameterized reports for number of diagnosis done on a patient.
Hardware/Software: 
SQL Server 2000 ,Query Analyzer, Enterprise Manager, DTS Designer, MS SQL Reporting Services, SQL Profiler, Index Tuning Wizard, Windows XP, MS Excel, MS Access.

Responsibilities:

• Actively involved in all stages of Software Development Life Cycle from requirement gathering to maintenance of databases.
• Successfully implemented Logical Data Model into Physical Data Model.
• Designed and implemented the system with Microsoft SQL Server 2000.
• Installed, configured and maintained SQL Server 2000 with regard to the requirements.
• Created Database Schema, Database Objects and Normalized database.
• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions and Triggers.
• Maintained data integrity by creating Checks constraints.
• Created views to restrict access to data in a table for security.
• Transformed complex business logic into Stored Procedures, User Defined Functions (UDF), Triggers and Views.
• Created and modified Clustered and Non Clustered Indexes to optimize the queries using Index Tuning Wizard.
• Created DTS packages to transfer the data from the old system to the staging area.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Successfully performed ETL process by pulling large volumes of data using DTS into the staging database from various data sources like MS Access, Excel.
• Performed the Transformation of the data using Transform Task in DTS.
• Handling database objects with Enterprise Manager and Query Analyzer.
• Documented all the procedures and processes for future references.

Confidential 03/2003 – 02/ 2007 
GenEx LIMS
Software Developer
Confidential is a multi-platform, multi-user, cost-effective Laboratory Information Management System (LIMS) designed to greatly improve the performance of Institutes for Biomedical Research and Life Sciences. Laboratory and User Administration, limiting each user access level in the associated laboratories by assigning specific authority, Sample tracking, Plate tracking, Inventory tracking, Instrument tracking, Project Design and Scheduling, Execution of each project and tracking resultant information and observations on each sample/plate processed, Instrument integration for automated data capture and report generation for project execution for statistical analysis.

Hardware/Software: 
J2SE, J2EE, EJB 3.0, Swings, Hibernate 3.0, Oracle 10g, Windows 2000, XP, Visual Source Safe, Windows Server, Windows NT.

Responsibilities:

• Interacted with business analysts to convert business requirement to technical requirement.
• Involved in designing, implementing, integrating, testing the modules such as Inventory Tracking, Protocol design, Location Management, Laboratory Management and Staff Management modules of the system.
• Enhanced the existing project based on the requirements from client.
• Developed the GUI using Swings and involved in developing the common controller for the events.
• Implemented object/relational persistence mappings using hibernate and Created hibernate mapping file and Data source configurations.
• Played a key role to optimize the application to meet GenEx LIMS response time requirements.
• Created and reviewed the test cases (both Unit and Integrated) at both functional level and process level.
• Worked hard for delivering the bug free code within the time lines of the project with all the coding standards.
• Created new tables, stored procedures, views, triggers for the GenEx LIMS application and some user defined functions.
• Involved in designed and implementing the Stored Procedures and Triggers for automating tasks.
• Involved in creating databases and developing Stored Procedures, Functions, Triggers, Tables, Views, SQL joins and statements for applications using PL/SQL.
• Involved in implementing most of the reports used in GenEx LIMS.
• Created and automated regular Jobs such as Daily/Weekly Report Generations.