SUMMARY:

• 6+ years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server 2012/2008R 2/2008/2005/2000 system in OLTP and OLAP environment.
• Excellent experience in SSIS , SSAS and SSRS of MS SQL Server.
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• In depth knowledge of T - SQ L, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL .
• Hands on Experience in Installing, Configuring, and Managing, monitoring and troubleshooting SQL Server 2012/2008R 2/ 2008/2005/2000.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2012/2008R 2/2008/ 2005.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS , DTS, Bulk Insert, and XML).
• Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012, MS Project, MS Visio, ERwin 9.2, Data Modeling , Visual Basic Analysis(VBA), MS Office, ALM for QA testing and Software Development Life Cycle ( SDLC ).
• Responsible for data quality testing and leading a team that performs data reconciliation to identify data anomalies.
• Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using SSIS and Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manger) with Strong understanding of OLAP and OLTP Concepts.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical.
• Expert in designing complex reports writing like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS).
• Very strong in Azure system configuration, database migrations, backup and recovery, geographic data replication, performance monitoring and tuning and disaster recovery configuration and execution.
• Expertise in developing and extending MS SQL Server Analysis Services (SSAS) cubes, data mining models, deploying and processing SSAS objects.
• 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).
• Have basic knowledge on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), Microsoft Azure

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Informatica power center 9x,8x, Visual Studio 2010,2012,2013

Reporting Tools: SQL Server Reporting Services (2005/2008 R2,2012,2014,2016), Tableau, MS Access, MS Excel

Database: MS SQL Server 2014/2012/2008/2005 , MS Access, Azure SQL

Modeling Tools: Microsoft Visio, SQL Diagrams, ERWIN 4.1

T: SQL, PL/SQL, VB.Net, XML, HTML

Web Technologies: HTML, DHTML, XML, XSL, CSS, PERL

Operating Systems: Windows 2012/2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows C Unix, Linux

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, TriZetto Facet, Citrix, Diagnostic Manager, IBM WebSphere (One Run, CMU ), TWS, Service Now, Ultra Edit, One Note, MS Outlook, SOAP UI.

PROFESSIONAL EXPERIENCE:

Confidential - Bethesda, MD

SQL Server Developer

Tools: and Technologies: MS SQL Server 2016,Visual Studio 2015, SQL Server Integration Services (SSIS), Data Warehouse, PL/SQL, Unix, Windows 10, MS Office, MS Visio, ERwin 9.2 Data Modeling,, ERP, CRM software, Widows server 2012.

Responsibilities:

• Data source/element mapping, creating load scripts, identifying and resolving conversion issues.
• Used T-SQL to create complex codes/programs for conversion and data testing.
• Scrambling of live data to test data, executing conversion processes.
• Created various database object like stored procedures, functions, tables and views
• Created SSIS package to load data from Flat Files, Excel spreadsheet and SQL Server 2008R2 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Planned, Defined and Designed data based on business requirement and provided documentation.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Converted the Oracle DB objects to MS SQL Server 2008 DB objects like Tables, Views, and Stored Procedures.
• Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

Confidential - Bethesda, MD

Sr. SQL Server/ BI Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Implemented Performance tuning to optimize SQL queries using query analyzer.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module with project managers.
• Created the reports based on the requirements using SSRS 2008.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Identified and defined the Datasets for the report generation.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed, monitored and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Examine two-way database replication using SQL server.

Tools: and Technologies: MS SQL Server 2008, DTS, Windows 2003, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Query Analyzer, Erwin, MS Visual Source Safe, FTP Communication, MS-Visual Studio, MS Access, Oracle 10g, UNIX, XML, XSLT, ADO.Net.

Confidential

SQL Server/ SSIS SSRS Developer

Responsibilities:

• Developed logical and physical database (using ER-win, Normalization, Dimension Modeling and Enterprise Manager).
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS ).
• Used SQL Server Agent to automate the SSIS 2008 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2005/2008 and then created reports using this data using SSRS .
• Configured and maintained Report Manager and Report Server for SSRS .
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.
• Tested and managed the SSIS 2005 and SSIS 2008 packages and was responsible for its security.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Maintained all records of project status and followed changes as per control procedures.
• Provided technical support to internal developers and external clients.

Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Tools: and Technologies:

MS SQL Server 2005/2008, MS Access 2000, Erwin v7.0, T-SQL, MS-Excel, MS-Access, SQL Server Management Studio, MS SQL Profiler.