SUMMARY

• Over 7 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2008 R2/2005 in Production, QA and Development Environments.
• Strong experience with T - SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Experience in Error handling and debugging coding issues andtroubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005 Reporting Services (SSRS), SQL Server 2005 Integration Services (SSIS) and in SQL Server 2005 Analysis Services (SSAS) in Business Intelligence (BI).
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, ErrorHandlers etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008 R2).
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Hands on experience in installing, configuring, managing, upgrading and migrating,Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2005.
• Experience in Managing Security of SQL Server 2005/2008 R2 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Experience in developing Dashboard, Ad-hoc and ParameterizedReports, Create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Integration of SSRS Reports using various web parts intoSharePoint (MOSS 2007) and various delivery mechanisms.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Good experience in creating OLAP cubes using SQL Server analysis services(SSAS).
• 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 MSAnalysis Services.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Worked with Business Analysts, Web development team, and users on database solutions.

TECHNICAL SKILLS

Tools: &Packages: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), DTS, Report Builder 9.0, HP QC, ProClarity 6.2,SharePoint 2007, Team Foundation Server

BI Tools: SSIS, SSAS, SSRS.

Databases: MS SQL Server 2000/2005/2008, MS Access 97/2003/2005/2008.

Language: T-SQL, PL/SQL, MDX,C, VB.net, C# (.NET)

Operating Systems: Windows vista/XP/2003/2000, Windows Server 2000/2003/2008, UNIX.

Application Packages: MS Office Suite, MS Outlook, Windows SharePoint Services.

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE

Confidential, St Paul, MN

SSRS Report Developer

Responsibilities:

• Created standard report Subscriptions and Data Driven report Subscriptions.
• Created report models and deployed on SharePoint server 2010.
• Created report snapshots and cache for better performance.
• Created tabular, matrix, chart, drilldown reports, drill through, sub, linked reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Created reports using Report Builder 3.0 from OLTP and OLAP data sources and deployed on report server.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Converted MS SSRS 2005 and Excel based reports to MS SSRS 2008 based reports.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
• Generated multi parameterized reports in Report Builder 3.0 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server 2008 R2 and Report Builder 3.0.
• Provided MS SSRS 2008 training to clients in order for them to develop their own ad-hoc reports.

Confidential, Newark, NJ

SQL Server Developer

Responsibilities:

• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Involved in database Schema design and development.
• Migrated Database from SQL Server .
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Executed stored procedures using BATCH files.
• Developed stored procedures and functions for designing various reports.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Used Batch Files to Import Data from other Data Base.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracleusing SSIS.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
• Expert in SSIS Deploying and Scheduling
• Identified and Defined Key Performance Indicators in SSAS 2005/2008.
• Process SSAS cubes to store data to OLAP databases
• Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal.
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dash boards using Microsoft Performance Point service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#,VB.Net, XML, Visual Studio 2008 & 2005,MS Visio 2007,TortoiseSVN.

Confidential, Minneapolis, MN

SQL Server Developer

Responsibilities:

• Worked in creating complex StoredProcedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• I Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Worked with development teams in the design of physical databases and in modification.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to Confidential .
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracleusing SSIS.
• Created ETL SSIS packages both design and code to process data to Confidential databases.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Constructed OLTP and OLAP Databases.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 R2 Reports Services (SSRS).
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, MS Access 2003, Oracle, SharePoint, PL/SQL, C#,VB.Net,ASP.NET, XML, Visual Studio 2008 & 2005,MS Visio 2007,TFS.

Confidential, Montpelier, VT

SQL Server Developer

Responsibilities:

• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tunedqueries by using execution plan for optimizing the performanceof the databases.
• Maintained the physical database by monitoring and optimizing performance, dataintegrity and SQL queries for maximum efficiency using SQL Profiler.
• Extract, Transform and Load source data into respective Confidential tables to build the required data marts.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• 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.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Designed SSAS cube to hold summary data for Confidential dashboards.
• Developed Cube with Star Schema.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: Microsoft SQL Server 2000/2005/2008 Enterprise Edition, MS Access, ETL Packages (SSRS,SSIS),Great Plains, PL/SQL, C#,VB.Net,ASP.NET, .Net 3.5 SP1,SP2 & 3.0, HTML, IIS, Visual Studio 2008 & 2005, Visual Source Safe, DTS, T-SQL, Oracle 10G,nt scripting, VSS,TFS.

Confidential, Atlanta, GA

SQL Server Developer

Responsibilities:

• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Analysis, Design and data modeling of Logical and Physical database using E-R diagrams.
• Involved in database Schema design and development.
• Designed tables, constraints, necessary stored procedures, functions, triggers and packages using T-SQL.
• Audited the Front-end application calls to SQL Server.
• Created efficient Queries, Indexes, Views and Functions.
• Enforced Security requirements using triggers to prevent unauthorized access to the database.
• Optimized the Database for best performance, with DBCC, partition table.
• Design and develop the payroll module using MS SQL Server 2000.
• Installation and Administration of SQL Server 7.0 and SQL Server 2000.
• Installed SQL Service Pack 5a Update and SQL Server 7 Service Pack 3
• Migrated data from MS Access to SQL Server.
• Upgraded database (tables, constraints) from SQL Server 7.0 to SQL Server 2000 using the DTS Wizard.
• Performance Tuning of the client databases for better performance on a regular basis.
• Responsibilities include writing of scripts for Database tasks, releasing Database objects into production.
• Managing the use of disk space, memory and connections.
• Running DBCC consistency checks, fixing data corruption on application Databases.
• Worked in establishing connectivity between VB applications and MS SQL Server by using ADO.
• Supporting ADO and Active-X connectivity to the database

Environment: SQL server 2000/2005,Oracle 9i/10G, MS VB Access, Windows 2003 Standard Edition, Windows 2000 Advanced Server, Microsoft Share point Portal Server, Visual Studio 2005, C#,VB.net 2005,.NET 3.0 SP2,Oracle, PL/SQL, VSS, SSRS, SSIS, DTS, SQL Profiler, net scripting, VSS,TFS.

Confidential, Houston, TX

SQL Server Developer

Responsibilities:

• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Developed, monitored and deployed SSIS packages.
• Experience in Extracting Data From XML and flat files using SSIS
• Expert in SSIS Deploying and Scheduling
• Developed, monitored and deployed SSIS packages.
• Responsible for transferring the data using SSIS packages.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures
• Identified the Data Source and defined them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2005.
• Designed and implemented stylish report layouts.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas and user-defined functions.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created SQL Server Reports using SSRS 2005.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Analyzed reports and fixed bugs in stored procedures.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Drove the adoption of TFS across contracts through briefings, training and requirements gathering. Extended Team foundation server events with custom web services.
• Used Visual SourceSafe for source control and versioning

Environment: MS SQL Server 2000/2005 Enterprise Edition,, .Net,ASP.Net, MS SQL Server Reporting Services 2005,SSIS,SSAS, Erwin 4.1, .NET 2.0 sp1 &sp2,Windows Server 2003,VSS,TFS.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Created new tables, views, indexes, stored procedures and user defined functions.
• Optimized query performance by creating indexes.
• Created users and roles and assigned permissions to them.
• Worked on DTS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Used Profiler for studying the performance problems and tuned them accordingly.
• Performed daily database backup & restoration of Database Server.
• Developed complex stored procedures to create various reports by using SQL server reporting service 2000.

Environment: MS SQL Server 2005, Enterprise Manager, T-SQL, DTS, MS Visio, Windows, Query Analyzer, SQL Profiler, SQL Reporting Services 2005