SUMMARY

• Over 8+years of experience in Database design, development and administration using MS SQL Server 2000/ 2005/2008/2012 in Production, Test, Development environment.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub - reports, navigation
• Strong working experience in SQL Server and T-SQL in constructing triggers, tables(DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2005/2008 for both OLTP (Batch Processing, Online Processing) & Business Intelligence (SSIS, SSRS) applications.
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Strong technical knowledge in MS SQL Server development including Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Expertise in Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Written Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non Clustered indexes on tables
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expert in generating Drilldown reports, Parameterized reports, Linked reports, Sub reports and filters, charts in SSRS 2005/2008.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2005/2008/2012
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Expertise in performing administrative tasks: database files management, backup/restore, security management, data integration and synchronization
• Scheduled the backups for Databases and Transaction log. Performed restoration operations, Suggested backup strategies.
• Identifying & resolving blocking and deadlocks.
• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role and 24x7 on call Production support.

TECHNICAL SKILLS

Databases: SQL Server 2000/ 2005/2008/2012

Operating Systems: Windows Server 2003, Windows 98/NT/XP/Professional

Languages: T-SQL, PL/SQL, C/C++, HTML, DHTML, XML, VBScript, VB.NET

ETL Tools: SQL Server Integration Services (SSIS)

Reporting Tools: SQL server Reporting Services (SSRS)

Tools: SQL Server Enterprise Manager, Management Studio

Protocol: FTP, TCP/IP, Named Pipes

PROFESSIONAL EXPERIENCE

Confidential, Conshohocken, PA

SQL Server Developer/SSIS

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Extensively used SSIS to move data from text files to SQL Server.
• Views using T-SQL in Development and Production environment for SQL Server 2008.
• Created Quality Assurance stats reports using SSRS
• Created SSIS packages for new projects utilizing Business Intelligence Development.
• Writing complex Stored Procedures to meet the business requirements.
• Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created data sources, connection strings and defined the datasets for generating the report.
• Worked on all types of report types like tables, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Developed, monitored and deployed SSIS packages.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages through Active Batch Job Scheduler.
• Created subscriptions to provide a daily basis reports. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.

Environment: MS SQL Server 2008/2012, Windows 2003, Excel, TSQL, Microsoft Visual Studio 2008,SQL Reporting Services, SQL integration services, SQL Analysis services

Confidential, Jacksonville, FL

SQL Server Developer/ SSRS/SSIS

Responsibilities:

• Worked in Agile Scrum Methodology with daily stand up meetings, great knowledge working with Visual SourceSafe for Visual studio 2010 and tracking the projects using JIRA.
• Involved in upgrading the databases and servers of SQL Server 2008R2 to SQL Server 2012.
• Helped BI Team in moving all the deployed reports toMobile BI Interactive Analytics(IPAD, IPhone) anddashboardsusing Roam BI Enterprise server.
• Experience in creating packages to transfer databetween ORACLE, MS ACCESS, Informix, FLAT FILES, Excel Files, toSQL SERVER 2008R2usingSSIS.
• Deployed theSSISPackages and created jobs for efficient running of the packages.
• Expertise in creatingETL packages using SSISto extract data from heterogeneous database and then transform and load into the data mart.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Great Expertise inDeployingSSISPackage to Production and used different types of Package configurations to export various package properties to make package environment independent.
• Experience with SQL Server Reporting Services(SSRS)to author, manage, and deliver both paper-based and interactive Web-based reports.
• Developed storedprocedures and triggersto facilitate consistent data entry into the database.
• Wrote store procedures to generate different FTE (Full Time Equivalency) Reports and College Internal Reports.
• Created different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.
• Wrote complex SQL Queries using multiple joins for creating Adhoc reports using Report builder based on the requirements.
• DesignedSSRSreports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Deployed SSRS reports to Report Manager and created linked reports, snapshots and subscriptions for the reports and worked on scheduling of the reports.
• Involved in migration ofSSRSfromSQL 2005 to SQL 2008R2.
• Performed maintenance duties likeperformance tuningand optimization of queries, functions and stored procedures.
• UsedSQLProfilerfor troubleshooting, monitoring, optimization ofSQLserver2008and SQL code.
• Worked withT-SQLto create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2008/2012 Enterprise Edition, SSRS, SSIS, T-SQL, Windows Server 2003, Performance Point Server 2007,C/C++, Oracle 10g,PL/SQL, Visual SourceSafe, visual Studio 2010

Confidential, Rochester, MN

SQL Server DW /BI Developer

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Understanding of existing business processes, project functional and technical specifications.
• Involved in meeting with business and exploring requirements and planning for creating Datamart for different systems.
• Involved in identifying facts and dimensions for the Datamart based on reporting requirements and existing reports.
• Designed and developed packages/workflows for data warehouse using Integration services (SSIS) SQL Server 2005/2008 and Business objects Data Integrator by Implementing SCD Type 1 and SCD Type 2.
• Created ETL logging Control tables for maintaining a log of all the loads.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Imported data from text files/excel spread sheets, Informix Database into SQL Server 2005/2008 database using SSIS package.
• Designed SSIS Packages using various Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, Execute Package Task, active script task, xml task.
• Responsible for Deploying SSIS Package onto Production and used different types of Package configurations to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations.
• Experience in Creating Views/Indexes/Functions for dimension and Fact Tables on Staging/Core/Datamart Stages for improving flexibility and Performance.
• Performed Data Validation to ensure data integrity in source, staging, core and destination databases for the Projects.
• Created Stored Procedures for Reports.
• Created source to target field mapping document for Datamart.
• Experience in Creating Standard/Sub Reports/ Drilldown Reports using Crystal Reports.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, Data Integrator, Windows Server 2003, Performance Point Server 2007,C/C++, SAP Crystal Reports.

Confidential, Atlanta, GA

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Created various kind of reports like f004, f006, f003, Aging, Summary lane reports.
• Automation of creating Accounting code module for each bill.
• Creating dashboards for different departments.
• Bulk data migration using SSIS from flat files.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Created different Parameterized Reports (SSRS 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.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Designed models using Framework Manager and deployed packages to the Report Net Servers.
• Created pages in the reports to display depend on Prompt values.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL Server 2005/2008, Windows 2000/2003, Sybase, Excel, TSQL, Microsoft Visual Studio 2008,SQL Reporting Services, SQL integration services.

Confidential, NJ

SSRS/SSIS Developer

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, and Reports using stored procedures 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.
• 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.
• Involved in scheduling, creating snapshots and subscriptions for the reports. (SSRS 2005/2008).
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy exact lookups using SSIS tasks.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Experience in Planning and Monitoring reports in Performance Point Server.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Performance Point Server 2007,C/C++.

Confidential

SQL Server Developer

Responsibilities:

• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas
• Created impromptu SQL queries for data verification and analysis.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Wrote Transact SQL utilities to generate table insert and update statements
• Wrote various Transact SQL utilities to add functionality to E-enterprise system.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins database links and formatted the results into reports and kept logs
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: SQL Server 2005, Windows 2003 Server, C++, T-SQL.