SUMMARY

• MS SQL Server Developer with around 8 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 the 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, ER Studio and mapped the 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 DB2, Oracle, and Sybase to MS SQL Server.
• Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
• Affluent in Web Technologies like HTML, CSS, XML, JavaScript, JSP, core Java etc.
• 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.
• Expertise in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS).
• 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.
• Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• 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.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R 2/2008/2005/2000
• Visual studio 2010/2008 (SSAS/SSIS/SSRS)
• Microsoft Access 2007/2003
• Microsoft Excel (Pivot Table)
• Outlook
• MS SQL Profiler
• SQL server Query Analyzer
• Index Tuning Wizard
• ASP.Net Frame Work 2.0
• C#
• Oracle
• DB2
• Crystal report
• Erwin8/7.3/3.5
• Windows 2007/2005 Advanced Server/Professional
• Window XP
• MS Access
• Java
• My SQL
• CADIS 8.1

PROFESSIONAL EXPERIENCE

Confidential, WARREN, NJ

SQL Server/ BI Developer

Responsibilities:

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

Tools: & Technologies: T-SQL, MS SQL Server Integration Services 2012, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio, Erwin, Windows XP, MS Office 2007/2010, MS Access, Power Pivot, CADIS 8.1.

Confidential, Bensalem, PA

SQL Server TSQL/SSIS/SSRS

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• 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,SQLProfiler and Database Engine Tuning Advisor to optimize queries and enhance the 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 the data into target tables by performing different kinds of transformations using SSIS.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Data quality done by using the Data cleansing by using ETL development
• 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 2012.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Generated daily, weekly and monthly reports for the managers.
• Maintain data quality by using the SCD and loaded into target database
• 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 2012.
• Responsible for database tuning using normalization and application tuning.

Tools: & Technologies: MS SQL Server 2012, T-SQL, SQL server Integration service 2012, SQL server reporting service 2012, Erwin7.3,Query Analyzer, Index Tuning wizard, SQL Profiler Windows server 2003.

Confidential, Omaha, NE

SQL Server T-SQL Developer /SSRS/DBA

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 the data to be reviewed by the manager.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2.
• Created reports using Global Variables, Expressions and Functions using SSRS 2008R2.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the 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 2008R2.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Maintained the table performance by following the 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.
• Generated Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Tools: & Technologies: MS SQL server 2008R2, SSRS, SQL Profiler and T-SQL, Windows 2003 server, and Visual Studio 2010, Microsoft Office, Index Tuning Wizard, Query Analyzer, SQL profiler.

Confidential, Sacramento, CA

MS SQL Developer/ SSRS, SSIS, SSAS Developer

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Identified data source and data views for building the OLAP cube in SSAS.
• Defined measures, dimensions and attributes for building the cube in SSAS.
• Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
• Created OLAP cubes using SSAS to analyze the business condition of the sales.
• Wrote complex queries for the drill down reports and used conditional formatting using SSRS.
• Scheduled and monitored all maintenance activities of SQL Server 2008 including database consistency checks and index defragmentation.
• Created Parameterized, matrix and drill down reports using SSRS 2008.
• Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2008.
• Formatted reports for various Output formats as requested by the 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.
• Used complex expressions to group data, filter and parameterize reports.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Helped designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Deployed the generated reports created using SSRS 2008 on to the server.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.

Tools: & Technologies: MS SQL Server 2008, MS Analysis Services 2008,MS SQL Reporting Services, T- SQL, Crystal Reports, Windows XP, Query analyzer, SQL Profiler, MS Excel.

Confidential, New York, NY

SQL Server Developer/ SSIS Developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008 using SSIS Packages.
• Generated ETL packages with different data sources (SQLServer, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Managed the Metadata associated with the ETL processes used to populate the 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.
• Tuned SQL statements Using Indexes and stored procedures.
• 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.
• Involved in implementation and maintenance of disaster recovery solutions such asreplicationand log shipping.

Tools: & Technologies: SQL Server 2008, SSIS, Windows 2003 server, MS Access, Excel

Confidential, Atlanta, GA

SQL developer

Responsibilities:

• Mostly involved in gathering business Requirement.
• Implemented batch processing for approval process by creating a wrapper driver which used ISQL conducting various BCP, select out and select into commands.
• Wrote complex stored procedures to process prospective customer information and balanced the processing load between frontend and backend.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2005.
• Successfully migrated old data from external system including DB2 and excel into SQL Server 2005 using DTS, BCP and ActiveX scripts.
• Monitored query using query analyzer and tuned queries and procedures to boost database performance.
• Used SQL profiler to optimize remote procedures and queries by creating workload files and setting various filters and parameters like cash hit ratios.
• Created stored procedures to backup transaction logs, flush/grow/shrink log files, maintaining and archiving tables.
• Assisted in designing and creating user Interface.

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