SUMMARY

• Over 8 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2012/2008 R2/2005 in Production, QA and Development Environments.
• 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.
• 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.
• 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/2008 R2 Reporting Services (SSRS), SQL Server 2005/2008 R2 Integration Services (SSIS) and in SQL Server 2005/2008 R2 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, Error Handlers 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/2012).
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, 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.
• 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 MS Analysis Services.
• Involved 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

Operating System: Windows NT 4.0,Windows 2000/2003/2008 R2 Enterprise/Datacenter Server, XP Professional, UNIX.

Databases: MS SQL Server 2012/2008 R2/2005/2000, MS Access, My SQL

Programming Languages: T-SQL, C, C++, Shell Scripting, SQL, XML, C#, VB.NET, MDX

Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook.

Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS,SSAS.

Reporting Tools: Reporting Service (SSRS) 2000/2005/2008 R2/2012

ETL Tools: DTS, SSIS,PENTAHO 4.0

MS Tools: Management Studio, Visual Studio.SharePoint,TFS 2012.

Internet Tools: Internet Information Server (IIS 5.0 / 6.0), FTP, TCP/IP

Other Tools: Source Depot, Octopus, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Script Components, error handling.
• Development & support PENTAHO 4.0/5.0 ETL to load ODS tables.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Developed optimal stored procedures and queries to create data sets for reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Develop/Build/Deploying all the reports and ETL objects using TFS 2012.
• Support in design/developed of Cube with Star Schema.
• Monitored and scheduled existing/new jobs on production environment.
• Optimizing Database Queries for performance enhancements using SQL Profiler.
• Responsible for gathering business requirements to create business user reports.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQLServer 2008/2012,Windows 7, T-SQL, SSIS,SSRS,SSAS,TFS, ASP.Net, VB.net,PENTAHO 4.0/5.0

Confidential, Richmond, VA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in complete SDLC life cycle.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• 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, 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 tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Migrated data from IBM-DB2 to SQL Server 2008/2012 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.
• Done migration from SSIS 2008 to SSIS 2012.
• Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Develop/Build/Deploying all the database and ETL objects using TFS 2012.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
• Developed optimal stored procedures and queries to create data sets for reports.
• Created SSRS Reports on the top of the cube using some MDX queries.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Migrating COGNOS reports to SSRS.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Developed Cube with Star Schema.
• Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.

Environment: MS SQL Server 2008 R2/2012, DTS, T-SQL, XML, Flat File, SQL Server Reporting Services, Visio, IIS, Windows XP/7,TFS 2012

Confidential, Morristown, NJ

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked in creating complex Stored Procedures, 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.
• 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.
• 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.
• 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 target.
• 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 Oracle using SSIS.
• Created ETL SSIS packages both design and code to process data to target 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.
• 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.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: Windows 2003/2008 R2 Server, MS SQL Server 2005/2008 R2, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Source Depot, JIRA.

Confidential, Beaverton, OR

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2005 and develop and unit test SSIS load processes for performance check.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
• Involved in migration and Conversion of Reports from SSRS .
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Business Objects, SharePoint, Octopus.

Confidential, Seattle, WA

SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in all the phases of SDLC.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used Stored Procedures for updating Servers.
• Used tools like SQL Profiler to Monitor Performance issues with queries or Application (i.e. Opening/Closing Connections by application, Read/Write etc.)
• Analyzed and tuned Database Growth and Space Requirement as data were growing day by day.
• Standardized company reports by implementing SQL Server Reporting Services (SSRS).
• Generated the Reports with all the subcategory Information to Business users.
• Interviewed Clients and management to identify additional reporting needs Develop report requirements and specifications to meet Reporting needs.
• Developed and Deployed different types of Reports like List, Drilled Down, Matrix, and Chart and Sub Reports etc.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Deployed and Scheduled the Reports in Report Manager. 7
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House and for OLTP side.
• Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa.
• Creation/Modified complex stored procedures which are used for various reports.
• Created/Maintained clustered/non clustered Indexes for fast and efficient reporting process.
• Used DDL and DML to writing Triggers, Stored procedures to check the Data Integrity and payment verification at early stages before calling them.
• Optimized the performance of T-SQL Queries by modifying the existing Index Tuning system and rebuilding indexes again with respect to the I/O.
• Documented the Stored Procedures and User Defined Functions (UDF) for future references and maintenance.

Environment: SQL Server Reporting Services, SQL Server Integration Service (SSIS), Microsoft Access 2003, Microsoft Excel 2003, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft Visual Studio 2005, DTS, Enterprise Manager, DTS wizards, DTS Designer and DTS programming interface.

Confidential

SQL Server DBA /Developer

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Worked on replication server and managed.
• Fine tuning of database objects and server.
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created Triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Monitoring the servers using spot light third party Quest software.
• Recovering the databases from backup in disasters
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000/2005.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• 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.
• Coding, debugging and testing of the application

Environment: SQL Server 2000/2005 Enterprise Edition, T-SQL, Enterprise manager, VBS, MS Office & Windows 2K platform.