PROFESSIONAL SUMMARY:

• Over 5+ years of IT Experience in Database Design, Development and business intelligence of MicrosoftSQLServer
• Expertise inSQLServerIntegration Services (SSIS) andSQLServerReporting Services (SSRS) with good knowledge onSQLServerAnalysis Services (SSAS).
• Experience in Creating and writing complexSQLand T - SQLqueries, Views, Indexes, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Experienced in writing complex T-SQLqueries using Inner, Outer and Cross Joins.
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS).
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Integrity using all kinds ofSQLServerConstraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
• Experience at Transforming and validating data usingSSISTransformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. usingSSIS.
• Proficient in OLTP, OLAP and Data Warehousing Design concepts
• Established ETL design practices for optimization and performance of packages and ParameterizedSSISpackages with the use of environment variables.
• Created dashboard reports with drill down reports, drill through reports, parameterized reports, table reports, chart reports, matrix and sub reports.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts inSSRS.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) usingSSRS.
• Knowledge of creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions usingSQLServerAnalysis Services (SSAS).
• Sound knowledge of Designing, Creating, Deploying and Processing of Cubes usingSSAS.
• Expertise in Debugging, Optimizing and Performance Tuning of MSSQLSERVER
• Cooperative person and self-starter with phenomenal relational abilities, capacity to work autonomously or as a piece of group and equipped for grabbing new aptitudes rapidly.

TECHNICAL SKILLS:

Languages: T: SQL, SQL, Dynamic SQL, Java

RDBMS: SQL Server 2012/2008/2005 and MS Access 2003/2000

Database Design Tools and Data Modeling: MS Visio, FACT & Dimensions tables, Physical & logical data modeling and De-normalization

DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio.

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Visual Studio, Crystal Reports.

Operating Systems: Windows XP/ 2003/2008/2012

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

SQL Developer

Responsibilities:

• Involved in Requirement gathering analysis, Preparing Functional and technical Specifications, design, development and testing of database program development.
• Wrote Complex Stored Procedures and Triggers.
• Converting complex business logic into backend programs like Stored Procedures and Functions to achieve business functionality required by business analysts
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads
• Developed various reports in SSRS like drill down Reports, Canned Reports, parameterized reports based on the business requirement.
• Extensively worked on the stored procedures and functions for creating the SSRS reports. Since they enhance the report performance and make it efficient to use.
• Involved in design, development and testing of numerous SSRS reports based on the business demands and experienced in deploying the reports securely in SharePoint environment for secure access.
• Efficient use of Joins and sub-queries in queries that retrieve data from multiples tables.
• Transformation of Data into SQL Server database by development of views, staging tables and load data into tables using Stored Procedures.
• Involved in development and debugging of complex T-SQLprocedures and functions.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures

Environment: SQL Server 2016, SQL Server 2012, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Access, Visual Studio 2008, SQL Profiler, Query Analyzer.

Confidential

SQL Developer

Responsibilities:

• UsedSSISto create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Converted ETL from DTS toSSIS.
• Extensively used T-SQLto manipulate and architect to produce results for users.
• Worked with development teams in the design of physical databases and in modification.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• CreatedSSISprocess design architecting the flow of data from various sources to target.
• Performed efficient tuning ofSQLsource queries for data load/ Usage of stored procedures for performance.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements UsingSSRS.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses usingSSISand DTS.
• Actively engaged in client meetings in requirement gathering and development updates.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Performed efficient tuning ofSQLsource queries for data load/ Usage of stored procedures for performance.

Environment: SQL Server 2008/2012, SQL Server Reporting Services, SQL Server Integration Services, Windows Server 2003, Windows XP, MS Office, Visio, Excel, SSRS 2012.

Confidential

SQL Developer

Responsibilities:

• Actively involved in different stages of Project Life Cycle.
• Actively participated in gathering of User Requirement and System Specification.
• Created cursors and User Defined functions.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults.
• Writing complexSQLqueries to populate data from different tables and which can be used forSSIS packages

Environment: MS SQL Server 2005, TSQL, MS Access.