SUMMARY

• Senior SQL Server developer with 9 Plus years of IT experience in design database using SQL MS SQL Server. Expertise Database on Microsoft Business Intelligence tools DTS, SSIS, and SSRS in various domains - finance, healthcare, insurance and banking.
• Experience in Client requirement analysis, Physical, Logical design, Estimation, Resource Planning, Coding, Debugging, Testing, QA and UAT Support and Maintenance of Business applications using SQL Server 2012/2008R 2/2005/2000.
• Hands on experience in creating ETL packages using SQL Server 2012/2008 Integration Services (SSIS) and creating reports using SQL Server 2012/2008 Reporting services (SSRS).
• Experience in writing complex SQL queries involving multiple table inner and outer joins.
• Experience in optimizing the queries by creating various clustered and non-clustered indexes and indexed views.
• Create and automate portable SSIS packages for inbound and outbound data feeds for Data Warehouse.
• Working on Systems integration project to merge the data into Data warehouse coming from different source systems while performing the data validation and Analysis.
• Expertise in Extraction, Transformation, Loading data from SQL Server, Access, Excel, Flat Files and XML using SSIS.
• Used PGP Encryption, FilecryptSB encryption software’s to encrypt the sensitive data using public key, private key while sending to vendors via automated ETL processes.
• Creating complex ETL processes using SSIS to pull the data from external data bases such Oracle and IBM AS-400.
• Experience in creating Tables, Views, Stored Procedures, Triggers, User defined Function and Other T-SQL statements for various applications.
• In-depth knowledge of T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and SQL Server Management Studio functionality using T-SQL Scripts and Batches.
• Experience in Data Migrating /Data Integration using SSIS.
• Experience in data validation and cleaning, data mapping using SSIS.
• Creating drill down, drill through parameterized and sub reports on financial data for business users and managers for data validation and analysis purposes.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP).
• Designing and deploying SSRS reports onto report server/enterprise report portal to be reviewed by Business users and Data Managers.
• Experience in providing Logging, Error handling by using event handler and custom logging for SSIS packages.
• Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, and Drill down, Top N, Summary and Sub reports using SSRS and formatting them.
• Excellent in creating SSIS Package for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transactions provide by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS).
• Expert in handling parameterized reports and Cascade Parameterized Reports in SSRS 2008/2005 which resulted in efficient decision making.
• Extensive experience in creating SQL server Analysis Projects using MS SQL Server.
• Experienced in data loads, database integration/conversions, performance tuning and optimization using MS SQL Server.
• Replication models (like Snapshot, Merge and Transactional), Locking and SSAS Analysis services.
• Absolute knowledge of software development life cycle (SDLC), database design, data migration concepts.
• Extensively used C# and VB.net to design script components and script task design while designing the SSIS packages.
• Trouble shooting the server jobs and fixing the errors occurred during job execution.
• Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Excellent analytical and communication skills to present points precisely and solve problems efficiently.

TECHNICAL SKILLS

Database Tools: SQL Enterprises Manager, SQL Profiler, Query Analyzer SQL Server setup, Security Manager, Service Manager, SQL Server Analysis Services (SSAS), Database Engine Tuning Advisor and Business intelligence development studio

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Import Export wizard.

Languages: T-SQL, COBOL, and Visual Basic 6.0

Reporting Tools: SSRS, MS Excel, Oracle SQL developer and Oracle report designer

Databases: SQL Server 2000, 2005, 2008 and 2012, Oracle 10g, MS Access.

OS: Windows 95/2000/2003/ XP/VISTA, UNIX, MVS.

PROFESSIONAL EXPERIENCE

Confidential - Bridgewater, NJ

Senior SQL BI Developer

Responsibilities:

• Migrated the DTS packages into SSIS and create new SSIS packages to Extract, transform and load the data from old data warehouse to new data warehouse and OLTP to OLAP.
• Removed the DTS package s from stored procedures and created as SSIS packages and embedded those procs in the SSIS package to retain the load functionality of the system.
• Worked entirely on SSIS script task, look up transformations and data flow tasks using T-SQL.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Used Vb.net to design script task for SSIS packages and converted VB script code to VB.net code while migrating packages from DTS to SSIS versions.
• Migrated data from MS SQL source databases to destination database in SQL Server 2008 database using SSIS.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Created and used extended stored procedure inSSAS.
• Designed SSIS packages to export and import data from SQL Server to MS Access, Oracle, text files and Excel files.
• Experience in ETL tools like SSIS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper data mapping and data cleansing.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
• Writing SSIS packages for loading the data from source to target as per the requirement.
• Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.
• Successfully implemented and monitored Transactional replication with update subscribers, snapshot replication on production environment with publisher, distributor and subscriber topology.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
• Created weekly, monthly and quarterly based financial reports using SQL Server 2005 Reporting services.
• Used the Default logging as well as Custom Log to keep track of the package.
• Migrated several databases from SQL Server 7.0 into SQL Server 2000.
• Performed data backup, recovery, and transfer operations.
• Used DTS to extract, transform and consolidate data from different sources into Data Warehouse.
• Created report models for ad hoc reports and deployed on report server using SSRS.
• Configured Log shipping from one production server to the reporting server.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the performance of the server on daily basis in email format.
• Tested the Integration of different modules.
• Performance tuning ofSQLqueries and stored procedures usingSQLProfiler and Index Tuning Wizard inSSASand SSIS.
• Performance Monitoring with SQL Profiler and Windows System Monitor.
• Provided technical assistance and mentoring to staff for developing conceptual and logical database design and physical database.

Environment: SQL Server 2000 and 2008 management studio, Business intelligence development studio, DTS, SSIS, SSRS, T-SQL, Report manager, Report Configuration manager, SQL Enterprise manager, SQL profiler, Microsoft Visual Studio 2008R2 and Windows 2003 professional server.

Confidential - Edison, NJ

Microsoft SQL Server Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Involved in performing Extraction, Transformation and Loading using SSIS (utilized SCDs).
• Performed query optimization and scheduled the several jobs by automating the SQL Server using management studio and Red-Gate.
• Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MSSQLServer Analysis Services (SSAS).
• Generated scripts to migrate databases from Oracle to SQL Server and MySQL to SQL Server.
• Created and Designed Data Source and Data Source Views UsingSQLServer Analysis Services 2008 (SSAS).
• Administered Report server and migrated reports from SQL Server 2005 to SQL Server 2008 Environment.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SQL Server 2008 Reporting Services (SSRS) for generating reports which resulted in efficient decision making.
• Worked extensively with client gathering requirements to generate customized SSRS Reports (Subscriptions Created for users).
• Worked Extensively on SQL Server 2008 and 2008R2.
• Developed all the required Stored Procedures, user defined Functions, Triggers, Views using T-SQL as per business logic.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon for ETL Loads and Reports processing.
• Worked extensively on all the Environments: Development, Testing and Production.
• Created maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Worked with SQL server Profiler generated traces to optimize the performance of the database.
• Evaluated and implemented various query optimization techniques.
• Server & Application fine-tuning & trouble shooting, Monitoring MS SQL Server performance and windows server issues.

Environment: SQL Server 2008 and 2008R2, SQL profiler, DTS, SSIS, SQL Enterprise manager, SQL Server agent, T-SQL, MS Excel, power pivot, Microsoft Visual Studio 2008R2 and Windows server.

Confidential - Baltimore, MD

SQL BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Updated many of the legacy reports with new data source and the new attributes.
• Worked with FACETS and NASCO databases to build different types of SSRS reports such as tabular, matrix, drill down etc.
• Created procedures, functions and packages to support new products released for CVS.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created Matrix reports, Navigation reports, drill down and Drill through reports, parameterized, and aggregation reports in MS SQL Environment using SSRS.
• Designed report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to AMS.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL Server.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, Script Components, Error Handling.
• Worked closely with BA team for report requirements and documented them for implementation.
• Involved in release planning, scrum meetings, review meetings and demo meetings.
• Updated user interface guidelines with the changes from BA team to support new reports.
• Supported multiple production issues in reports, ETL packages and performance tuning queries.
• Configured SQL email agent for DTS process failure or success notifications.

Environment: SSDT Data Tools 2012, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, SSAS, T-SQL, SQL, MS Excel, MS Visual Studio, MS Visio

Confidential - Mount Laurel, NJ

Microsoft SQL Server Developer

Responsibilities:

• Created database objects such as tables, indexes, stored procedures, functions and triggers in SQL Server 2000.
• Experience in ETL tools like SSIS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper data mapping and data cleansing.
• Writing SSIS packages for loading the data from source to target as per the requirement.
• Involved in installation and configuration of SQL server 2005 on Servers.
• Created Stored Procedures and views in SQL Server using T-SQL to collect data for the crystal reports.
• Implement and maintain database security.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Going through the client’s requirements and coming up with database design and application architecture.
• Developed and tested complex Transact-SQL on MS SQL Server 2000.
• Designed, developed, modified and enhanced the database structures and database objects using complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Applied patches and service packs to keep the database at current patch level.
• Implemented database standards and naming convention for the database objects.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Fine tuned Stored Procedures, using Execution Plan in T-SQL for better performance.
• Monitor failed and long running MS SQL Server jobs in SQL Enterprise manager.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2000 and 2005, SQL profiler, DTS packages, SQL Enterprise manager and SQL Server agent, Microsoft Visual Studio 2008R2, Windows 2000/2003/NT/XP.

Confidential, Richfield, MN

Microsoft SQL Server Developer

Responsibilities:

• Created functional specification and technical specification from BRD.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide.
• Structure to store data and to maintain database efficiently.
• Established Inner Joins, Outer Joins and created Indexes whenever necessary.
• Involved in unit testing of Store Procedure and UI as per requirement on different server (Dev, DIT, and SIT).
• Developed Test Cases bases on Requirement Specifications and Design Documents.
• Interacted with testing team to fix the defects raised during the testing period. Worked closely with the developers and testing team to Resolve Bug Issues.
• Responsible for modification and executing of the Test Scripts.
• Involved in integration of the front end with the SQL Server backend.
• Created jobs on daily basis and schedule on every minute to update recent data by using SQL Server Agent jobs.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.

Environment: Microsoft SQL server 2000, SQL Agent job scheduler, SQL Enterprise manager, DTS, AS 400, Turnover, MS Excel, Visio, DOS batch scripting.

Confidential

Microsoft SQL Server Developer

Responsibilities:

• Preparation of Functional and Technical Specification documents as deliverables to the client.
• Designed, Developed and distributed reports using DTS packages in MS SQL Server 2000 environment.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Created stored procedures to calculate pension and annuity information, when called will give the details for an employee on the website.
• Creation/Maintenance of Indexes for fast and efficient reporting process.
• Involved in Data Migration to import and export data into tables using SQL Server 2005, creating tables, views and Stored Procedures using SQL Server.
• The task involved writing a lot of SQL Code and distributing adhoc reports out of database.
• Tested for different test cases based on the requirements. Developed Test Cases and Test Scripts.

Environment: MS SQL server 2000, DTS packages, Windows XP, T-SQL, Windows 2003 professional server, Visual basic and windows batch scripting.

Confidential

MS SQL Server Developer

Responsibilities:

• Created Tables, indexes and constraints.
• Created backups for databases.
• Created T-SQL stored procedures, functions, tables, views and SQL joins and other statements for various applications, maintained referential integrity and implemented business logic.
• Optimized SQL statements for customer summary reports.
• Monitored user accounts, user permissions and backup.
• Involved in analysis and Design Documentation, User Requirements and maintained good documentation.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Used T-SQL to create various queries.
• Carried out a Developer’s role on MS SQL Server 2005, MS Access Databases (using DTS, Stored Procedures and Views).
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Daily Database backups and integrity checking.
• Developed SQL Scripts to Insert/Update/Delete data, satisfying the referential integrity constraints.
• Partly involved in Performance Tuning.
• Performance tuning to optimize SQL queries using query analyzer.

Environment: MS SQL Server 2005, MS Access, T-SQL, Stored Procedures, DTS, SQL Server Query Analyzer, SQL Profiler, MS Office