SUMMARY

• MS SQL Server Developer over 10+ years of strong experience in various domains like Financial, Healthcare, Retail and insurance with expertise in MS SQL Server 2012/2008R 2/2008/2005/2000 and SSIS, SSRS, SSAS.
• Worked on teh entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.
• Proficient in installing, configuring, managing, monitoring and troubleshooting MS SQL Server 2012/2008/2008 R2/2005.
• Developed Logical and physical data model using ERWIN and mapped teh data into database objects.
• Strong MS SQL Server 2012/2008/2008 R2/2005 Developer Skills including writing Stored Procedures, User Defined Functions, Views, Query writing.
• Expert in Microsoft Business Intelligent Studio 2010/2008 (SSIS/SSRS/SSAS).
• In - depth knowledge of T-SQL, SQL (DDL, DML, and DCL).
• Extensive experience in Migration of data from Oracle, DB2, and Sybase to MS SQL Server.
• Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experienced in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
• Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Mastery in extracting and transforming transactional information using DTS Import/Export wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services) and SSIS Packages from SQL Server.
• Good understanding in Database Backup, Recovery and highly experienced in investigating and applying necessary MS SQL Server database Service packs, hot fixes and Security Patches.
• Expert in developing and modifying multi-dimensional cubes using MS SQL Server Analysis Services (SSAS).
• Expert in Microsoft Business Intelligence Studio 2010/2008 (SSIS/SSRS/SSAS).
• Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
• Defined and administered database standards, controls, procedures and documented teh same.
• Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support.

TECHNICAL SKILLS

• MSSQLServer 2012/2008R 2/2008/2005/2000
• Visual studio 2010/2008 (SSIS/SSRS/SSAS)
• Microsoft Access 2007/2003
• Microsoft Excel
• Outlook
• MS SQL Profiler
• SQL Server Query Analyzer
• IndexTuningWizard
• ASP.NetFrameWork 2.0
• C#
• Oracle
• DB2
• Crystal report
• Erwin8/7.3/3.5
• Windows 2007/2005 Advanced Server/Professional
• Windows XP
• MS Access
• Java
• My SQL
• HTML
• CSS.

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

MS SQL Developer SSIS/SSRS

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for teh application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface teh database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on teh fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 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.
• Developed Unit Test Plans for SSIS packages for checking teh functionality of each component.
• Modified teh existing SSIS packages to meet teh changes specified by teh users.
• Scheduled Jobs for executing teh stored SSIS packages which were developed to update teh database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled teh monthly/weekly/daily reports to run automatically onto teh Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured teh report viewing security for various users at various levels using Report Manager.

Confidential, Gainesville, VA

SQL Server Developer/Business Intelligence

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Designed and developed web based ecommerce application.
• Worked with Oracle Server to extract, load information of Customers.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance teh performance of databases.
• Accountable for Backup and Recovery Strategy and Planning.
• Created ETL packages with different data sources (SQLServer, Flat files, Excel source files, Oracle) and loaded teh data into target tables by performing different kinds of transformations using SSIS.
• Managed teh Metadata associated with teh ETL processes used to populate teh Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Used Packages by testing and cleaning teh Standardized Data by using tools in Data.
• Data flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing and new packages.
• Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008R2.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008R2.
• Generated daily, weekly and monthly reports for teh managers.
• Used sub reports functionality for complex report calculations.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Responsible for database tuning using normalization and application tuning.
• Documentation for all kinds of reports and SSIS packages.

Confidential, Virginia Beach, VA

MS SQL Developer SSIS/SSRS

Responsibilities:

• Gatheird user requirements to develop teh business logic and analyzed and designed database solutions.
• Generated Performance reports on SSIS packages, Stored Procedures and Triggers.
• Created OLAP cubes using SSAS to analyze teh business condition of teh sales.
• Wrote complex queries for teh drill down reports and used conditional formatting using SSRS.
• Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2005.
• Formatted reports for various Output formats as requested by teh management using SSRS.
• Actively supported business users for changes in reports as and when required using SSRS.
• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in teh reports and created report models.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Designed high level SSIS architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.

Confidential, Houston, TX

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in given period.
• Involved in scheduling reports to run weekly, quarterly, monthly based on teh data to be reviewed by teh manager.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports using Global Variables, Expressions and Functions using SSRS 2008.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert teh data depending on teh criteria into teh tables of hub.
• Wrote T-SQL queries, created dynamic Stored Procedures by using input values.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Applied monthly patches and hot fixes.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Maintained teh table performance by following teh tuning tips like Normalization, Creating Indexes etc.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Using ETL to build teh required data mart.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Confidential

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Interacted with business users and analysts and gatheird and documented teh technical and business metadata.
• Designed database, tables and views structure for teh new data mart.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005 using SSIS Packages.
• Generated ETL packages with different data sources and loaded teh data into target tables by performing different kinds of transformations using SSIS.
• Managed teh Metadata associated with teh ETL processes used to populate teh Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Performed unit testing and SQL performance tuning.
• Helped provide end users with teh ability to access and utilize teh data stored in teh data mart.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.