SUMMARY

• Extensive experience in database design and development using different tools of ER diagram, normalization techniques, T - SQL (DDL and DML coding).
• Extensive experience with SQL Server 2012/2008R 2/2008/2005/2000 installation, configuration, and administration.
• Expert in SQL Server 2000/2005/2008/2008 R2/2012 development skills including writing stored procedures, user-defined functions, triggers and proficiency in joins and indexes.
• Extensive experience on migrating data between various versions of SQL Server and between homogeneous & heterogeneous systems using various tools (import export data, bulk insert and BCP, SSIS).
• Highly experienced on all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using SQL Server SSIS.
• Highly experienced on evaluating existing DTS packages on SQL Server 2000 and upgrading them to SQL Server SSIS packages.
• Expertise in SQL Server Reporting Services (SSRS) in generating complex reports: cascaded, parameterized and ad-hoc reports, report model using Report Builder.
• Expert in deploying the reports through Report Manager/SharePoint along with subscription and role constraints.
• Expertise in Crystal Reports in generating various reports: sub-reports, crosstab reports.
• Highly experienced in creating formulas, running totals, calculated members, and embedded summaries conditional display of fields for complex calculations and used them in sub-reports and crosstab reports.
• Expert in deploying the reports through Business Objects Enterprise along with subscription and schedule.
• Experienced in defining Multi-Dimensional Queries (MDX) for developing OLAP cubes including KPI’s, Data Mining, Slowly Changing Dimensions and complex Parameterized Reports in SSAS & SSRS.
• Highly experienced in trouble shooting and query optimization, performance tuning working with large databases.
• Highly experienced in database backup, replication, recovery, restoration, security.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008/2008 R2/2012
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Crystal Reports
• ERWIN 7.0/7.0X
• DTS
• SQL Query Analyzer
• SQL Server Profiler
• Database Engine Tuning Advisor
• TFS
• T-SQL
• XML
• EDI
• C#.NET
• VB.NET
• MS Visio 2003
• Oracle 9i
• MS ACCESS
• Visual Studio 2005/2008/2010.

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

MS SQL Server / Crystal Reports Developer

Responsibilities:

• Involved in designing the structure of database.
• Created database objects like tables, stored procedures, and views.
• Wrote SQL scripts to insert, update, and delete data in MS SQL database.
• Prepare the complete data mapping for loading data from data warehouse into APD database.
• Created stored procedure which exported data from APD database to XML Files.
• Created source files for 837 EDI transmissions.
• Worked with Finance and Marketing department to create, test, distribute and maintain Crystal Reports.
• Developed various charts and graphs like bar chart, line graphs, pie chart etc. by using chart expert of Crystal Reports.
• Created reports to retrieve data using stored procedures that accepts parameters depending upon the client requirements.
• Developed several detail and summary reports including sub-reports and crosstab reports.
• Created number of formula, running totals conditional display of fields for complex calculations and used them in sub-reports.
• Published, deployed, scheduled and modified reports through Business Objects Enterprise.

Confidential, Brooklyn, NY

MS SQL Server /BI Developer

Responsibilities:

• Work with project teams for upgrading SQL Server 2008 to SQL server 2012.
• Migrated data, SSIS packages, SSRS reports from SQL Server 2008 to SQL Server 2012 and performed parallel testing and regression testing.
• Created stored procedures which generated the necessary fact and dimension tables and functions that allowed performing necessary calculations depending upon the requirement.
• Designed and developed SSIS packages to extract, transform and load data from flat files, excel files, XML files and OLE DB to SQL Server 2012.
• Used multiple control flow elements like for each loop, sequence container, execute SQL task, script task, file system task etc., and different transformations like conditional split, lookup, merge join, among others for creating SSIS packages.
• Worked on deployment of SSIS packages using deployment utility.
• Identified and defined the data sources and datasets for report generation.
• Defined report layout including report parameters and wrote queries in creating parameterized reports, drill down reports, drill through reports, ad-hoc reports based on BRD using SSRS.
• Created gorgeous reports with various report tools, such as text box, table, matrix, list, sub-report, chart, gauge, and indicator.
• Deployed reports, created report schedules and subscriptions. Scheduled for execution and generated daily, weekly and monthly reports for managers.
• Defined relationships between dimensions and measure groups. Involved in the design and development of the SSAS cubes and MDX queries.
• Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements.
• Scheduled jobs to call SSIS packages and stored procedure, and also create alerts for successful and unsuccessful completion of scheduled jobs.
• Performed tuning and optimization of SSIS packages and SQL queries using SQL Server Profiler and Database Engine Tuning Advisor.

Confidential, Philadelphia, PA

MS SQL Server Developer/SSIS Developer

Responsibilities:

• Actively involved in normalization & denormalization of database.
• Migrated data between SQL Server 2005 to SQL server 2008R2.
• Created database objects like tables, indexes, stored procedures, views, user defined functions, cursors and triggers.
• Involved in designing common customer view (Operation Data Store - ODS) data model.
• Designed and developed SSIS packages for loading data from OLTP to ODS.
• Imported and exported data from various sources using SQL Server tools such as SQL Server 2008R2 Integration Services.
• Developed various automated data feeds through SSIS to extract daily batch feeds and convert/transform them to ODS.
• Experienced with transformations like derived column, data conversion, lookup transformation, script component, conditional split, slowly changing dimension, among others for data mapping, data cleansing and incremental loading.
• Designed and automated various FTP processes and Email processes using SSIS.
• Used execution plan, SQL Server Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of database.
• Build the dimensions, cubes with star schema and snowflake schema using SQL Server 2008 Analysis Services (SSAS) and created SSRS reports by using SSAS cubes as data source.

Confidential, Wayne, PA

MS SQL Server Developer/SSRS/SSAS Developer

Responsibilities:

• Created complex SQL statements, stored procedures, and functions.
• Involved in performance tuning in SQL Server 2008 using SQL Server Profiler and Database Engine Tuning Advisor.
• Migrated existing SSIS packages to SQL Server 2008 SSIS packages
• Configured and maintained report manager and report server for SSRS.
• Developed several detail and summary reports including sub-reports, linked reports, dashboard reports and cascading reports according to business requirements using SQL server reporting services (SSRS).
• Created reports to retrieve data using stored procedures that accepts parameters depending upon the client requirements.
• Formatted the reports using global variables and expressions.
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing the reports.
• Involved in debugging and deploying reports on the production server.
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Designed and created OLAP cubes by defining the relationship between dimensions and measure groups in star schema and snowflake schema data marts.
• Created partitions and KPIs of the analysis services cube to improve performance.

Confidential, Montvale, NJ

MS SQL Server Developer/ SSIS/SSAS Developer

Responsibilities:

• Involved in the complete life cycle of the project, from planning staging and pushing the codes to production.
• Created database, tables, store procedures, functions, triggers and maintained referential integrity to update and clean the old data. Wrote SQL scripts to insert, update, and delete data in MS SQL database.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Server Profiler and Database Engine Tuning Advisor.
• 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 etc. to generate underlying data for the reports and export data from MS Excel, XML, and Text files.
• Employed the slowly changing dimension transformation to establish historical data in the data warehouse.
• Configured SQL mail Agent for sending automatic emails on errors.
• Created configuration files in order to deploy SSIS packages in different environments.
• Designed and created data source and data source views using SQL server analysis services (SSAS).
• Created and configured OLAP cubes with star schema and snowflake schema using SQL server analysis services (SSAS).
• Enhanced the functionality in database and cubes by creating KPI, aggregations and perspective using SQL server analysis services (SSAS).