SUMMARY

• Over 7 years of experience in MS SQL Server 2012/2008R 2/2008/2005/2000 with Business Intelligence in MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS).
• Interacting with Business users to perform analysis of business requirements, document the user requirements and translate requirements into system solutions.
• Excellent ability in writing specifications and gathering requirements from the user to develop Reports as per the needs of the client and maintain documentation of the reports for future .
• Involved in the full System Development Life Cycle (SDLC) of a Data Warehouse and responsible for designing, coding, testing, implementing and supporting the ETL processes for data warehouse solutions and related data marts.
• Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server 2008/2005/ 2000 and Access 97 - 2007 databases. Some experience with Oracle and MYSQL Databases.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2008/2005.
• Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.
• Experience in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.
• Experienced in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SSRS.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Worked on administration tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000/2003/2008 , Windows XP/Vista

Languages: T-SQL, PL/SQL, C#.Net, VB.Net, ASP.Net, XML, HTML, Java Script

Tools: /Utilities SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL * Plus, Toad, Ervin

Databases: MS SQL Server 2012/2008/2005/2000 , Oracle10g/9i, MS Access, Foxpro, Visual Foxpro, Filemaker, dbase

Data Modeling Tools: Microsoft Visio, UML

Software: MS Office, Adobe Dreamweaver, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, MS SQL Server Integration Service (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Service (SSRS), T-SQL, PL-SQL, SQL Server Management studio (SSMS), MS SQL Server Index Tuning Wizard, SQL Profiler/Analyzer, Bulk Copy Program (BCP),Database Engine Tuning Advisor, SQL Agent, Service Manager, Crystal Reports, Business Objects, Excelcius

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

MS SQL Server Developer SSRS/SSIS

Responsibilities:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Develop, Deploy and Monitor SSIS Packages.
• Involved in designing, developing and deploying SSIS packages in MS SQL Server environment using SSIS-2008(BIDS).
• Involved in Migration of Databases from SQL Server 2008 to SQL Server 2012.
• Widely used SSIS transformation such as Derived Column, SQL Task, Script Task, Send mail task, Fuzzy lookup, Fuzzy Grouping, Data Conversion, Aggregate, Condition Split etc.
• Developed auto generated system to schedule packages.
• Involved in upgrading SQL server 2008R2 to SQL Server 2012.
• Upgrading all SSIS 2008 Packages to SSIS 2012.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Execute SSIS 2012 package in SQL Server 2008 R2 usingDTEXEC.EXE Command Line Utility.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Used Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• We used Agile Methodology for our Project.

Environment: MS SQL Server 2005/2008R2, SQL Server Integration Services 2008(SSIS), SQL Server Reporting Services 2008(SSRS), SQL Server Analysis Services 2008(SSAS), Microsoft Visual Studio, SSMS, ASP.NET, MS Excel, T-SQL, HTML

Confidential, Piscatway, NJ

Senior SQL Server/SSRS/SSIS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Performed various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
• Created SQL server configurationsforSSISpackages.
• Responsible for creating reports based on the requirements using SSRS 2008.
• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Defined the report layout and identified Datasets for the report generation.
• Successfully created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Created numbers of complex formula in sub report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Successfully Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Implemented Star Schema for OLAP cubes using SSAS.
• Created Packages to group logically related column types and to transfer data.
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Designed both logical and physical data models in Erwin r 7.2

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Analysis Server 2008, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Confidential, Secaucus, NJ

SQL Server SSRS/SSIS Developer

Responsibilities:

• Involved in gathering the report specifications by interacting with the business users
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs, Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Planned, defined and designed data based on the business requirement.
• Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Upgraded MS SQL Server 2005 databases to 2008, using Detach/Attach, Back up & Recovery and by Replication.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.

Environment: MS SQL Server 2005/2008R2, SQL Server Integration Services 2008(SSIS), SQL Server Reporting Services 2008(SSRS), SQL Server Analysis Services 2008(SSAS), Microsoft Visual Studio, SSMS, ASP.NET, MS Excel, T-SQL, HTML.

Confidential

SQL Server Developer

Responsibilities:

• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2000 using T-SQL.
• 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, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Migrated from SQL server . Installed SSIS and SSRS systems.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Involved and coordinated with users to gather new requirements and resolved existing issues.

Environment: MS SQL Server 2000, MS Access, DTS (Data Transformation Service), BCP, Query Analyzer, SQL Profiler, Erwin3.5, Windows Performance monitor, text files, Windows XP.