SUMMARY

• 8+ years of IT experience in Data Design and Development on Microsoft SQL Server 2012/2008R 2/2008/2005/2000 , T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS and Data-warehousing.
• Experience in using Business Intelligence tools(SSIS,SSRS, SSAS) in MS SQL Server 2008
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Hands on experience on various SQL Server Services like Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2008/2005/2000/7/6.5.
• Great ability to create and manage various database objects like tables, views.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Experienced in using ETL tools in (SSIS) MS SQL 2008,MS SQL 2005 and DTS in MS SQL 2000
• Hands on experience in using ProClarity to browse cubes, create views and books.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Experience with logical and physical data modeling and database design using Erwin.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in modifying MDX Cubes and Dimensions in SSAS.
• Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS:

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server 2008,SQL Server 2005 Management Studio, DTS, SSIS, SSRS, SSAS.

Database: MS SQL Server 2012,2008R2,2008,2005, 2000, 7.0, MS-Access

Language: C, C++, T-SQL, VB.Net, HTML

Operating System: Windows XP/NT/2000, DOS, Windows Server 2007, 2003

Tools: Erwin, Microsoft Visual Studio 2008/2005,Share Point Server 2007, Microsoft Project Server 2007, ProClarity, Team Foundation Server (TFS), AtTask.

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Reporting Tools: SSRS (SQL Server Reporting Services), Crystal Reports

ETL Tools: SSIS (SQL Server Integration Services), DTS

PROFESSIONAL EXPERIENCE:

Confidential, CO

SQL SSIS/SSRS Developer

Responsibilities:

• Worked closely with Business Analysts and data modelers in design of logical and physical design.
• Written T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers.
• Used Try catch block, Merge and Common table expressions in T-sql
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Created different type of reports including Cross-tab, Conditional, and Drill-down, OLAP and Sub reports.
• Have deployed packages on different servers by using Package configurations.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Worked with development teams in the design of physical databases and in modification.
• Strong knowledge of backups, restores, recovery models, database shrink operations,clustering, database mirroring, replication in Microsoft SQL Server 2012.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools in Microsoft SQL Server 2012.

Environment: Microsoft Windows 2007 Advanced Server, Microsoft SQL Server 2012, 2008 and 2008(R2), SSIS, SSRS, OLAP.

Confidential, Rockville, Maryland

SQL Server (SSIS, SSRS) Developer

Responsibilities:

• Worked with Business Users and Business analyst in gathering requirements and preparing the functional and technical documentation.
• Implemented logical and physical modeling of data warehouse using Erwin.
• Used Temporary tables, table variables in Stored procedures to simply complex queries
• Optimized queries by analyzing different query options, and indexing strategies.
• Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using SSIS.
• Created ETL packages that reads Product, Vendor, and Order data from an FTP server into a SQL Server database. The solution also validated incoming Data and performs notifications when jobs complete.
• Created SSIS packages to load data from Heterogeneous sources like Flat files, CSV files and Excel.
• Implemented custom logging to keep track of the packages being run automatically. Configured the packages to run on different servers using Package Configurations.
• Created packages in SSIS with error handling using Event handlers.
• Used various transformations in SSIS like Lookup, Derived Column, Union all, Merge to modify the data which is stored in various forms efficiently.
• Scheduled SSIS packages using SQL Server Agent.
• As part of a team created various reports according to the business requirements. Individually authored, installed, deployed and managed reports using SSRS 2008.
• Worked on migration of SSRS 2005 to SSRS 2008.
• Generated drill through, drill down which projected data as per the user requirements using SSRS.
• Redesigned older reports in Crystal reports to meet the changing requirements to cater and provide business solution to the end user using SSRS 2008.
• Implemented Conditional formatting using Expression in SSRS 2008.
• Create Parameterized reports using Text and Stored procedures as source in SSRS
• Used report model project and Report Builder 3.0 to generate ad-hoc reports using SSRS 2008
• Deployed SSRS reports to share point server and also used Excel services in Share point application.
• Managed subscriptions and data-driven report subscriptions to provide timely reports to the clients and end users, also created snapshots to reduce loading time.
• The order data loaded into the SQL Server was used to generate reports and charts using the SSRS 2008 reporting functionality (Tablix control, charting features).

Environment: SQL Server 2008/2005, MS Excel 2007, MS SQL Query Analyzer, Crystal Reports, SQL Profiler, ETL, MS SQL Server Reporting Services, MS SQL Server Analysis Services.

Confidential, Philadelphia, PA

SQL Server Developer

Responsibilities:

• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, OLAP reporting,dashboards, and scorecards.
• Involved in the dimensional modeling of Data warehouse using Erwin tool
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
• Created appropriate Triggers to assist efficient data manipulation and data consistency
• Migrated DTS Packages of SQL Server 2005 to SQL Server 2008 as per business requirement
• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS)
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages
• Created dynamic Package Configuration of type Sql Server table.
• Developed Query for generating Drill Down and Drill Through Reports in SSRS 2008(R2)
• Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
• Deployed SSRS reports to Share Point Sever 2010 and also configured SSRS 2008 to Share Point Integration mode.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Involved in Analyzing, designing, building of OLAP cubes with SSAS 2008(R2) Identified and defined Fact relationships in SSAS
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Worked on PERFORMANCE POINT SERVER to build advanced KPI’s for the cubes
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
• Involved in Optimization and Performance of queries and stored procedures using Sql Execution Plan

Environment: Erwin, SQL Server 2008R(2), MS Server Integration services, SSRS (MS server Reporting Services), MS SSAS, Window 2007 Server, Crystal Reports, Share Point Server 2010,VB.net.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept
• Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes and Execution Plan)
• Developed User Defined Functions and created Views
• Created Triggers to maintained the Referential Integrity
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment: SQL Server 2005, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5,ASP/VB.NET

Confidential

MS SQL Server Developer

Responsibilities:

• Verified the databases for data entry errors
• Created and managed schema objects such as Tables, Views, Indexes and Stored Procedures
• Created database triggers in T-SQL to check the referential integrity of the database
• Worked with the developing team in the writing functions in Visual Basic 6.0 for Upload and download functionality, Data transfer and migration
• Transformed data from one server to other servers using data transformation services (DTS)
• Developed SQL queries to fetch complex data from different tables in remote databases using joins
• Actively involved in Normalization & De-normalization of databases
• Managed version control and documentation of all SQL Server objects
• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Managed rollback segments, and table spaces to ensure less space used by the database.
• Created documentation on the all the tables, stored procedures, views and user defined functions.

Environment: SQL Server 2005, SQL Profiler, T-SQL, Windows 2003, MS Access, Visual Studio.