SUMMARY

• Around 7 Years of IT experience as a MS SQL Server 2012/2008R2/2008/2005 Developer in various industries like Finance, Insurance, and Health Care.
• Good Experience in installing MS SQL SERVER 2000, 2005, 2008, 2008R2 and 2012 updating with the hot fix and service packs.
• Skilled developer in Creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors etc.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles.
• Install and configure database software, associated database tools and performance monitoring software.
• Experienced in up gradation from MS SQL Server 2000 to MS SQL Server 2005 and MS SQL Server 2005 to MS SQL Server 2008 R2 and MS SQL Server 2012.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008/2008R2/2012) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in Developing Reports for business end users using Report Builder with updating Statistics.
• Experience in migrating Crystal Reports 8.5+ to SQL Server Reporting Services
• Expertise in Designing SQL Server SSIS packages to import and transform data between databases and external sources.
• Experienced in using Normalization and De - Normalization techniques.
• Experience in Query Optimization, Performance Tuning, Client/Server Connectivity, and Database health Check, Indexing, and Updating Statistics. Experience in using DMV and dynamic management functions (DMF) of Tables, Triggers, Store Procedure etc. for finding out long running queries.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities.
• Experience in writing complex logical algorithms in Macros using VBA

TECHNICAL SKILLS:

Operating Systems: Windows Server 2000/2003/2008 , Windows 98/2000/XP/VISTA/7 UNIX, OS 400

Databases: MS SQL Server 2000/2005/2008/2012 , Oracle (8.3-9.1), DB/400, MS Access

Database tools: SQL Enterprise Manager, TOAD

Business Intelligence tools: SSIS, SSRS, SSAS, MS Access 2003 and SQL Server Management Studio

Applications: Microsoft Office, ProClarity, AdobePhotoshop7, Adobe Illustrator

Languages: T-SQL, PL/SQL, VB, C, COBOL

Web Scripting Languages: HTML, DHTML, VB Script, ASP

Web Tools: MS-Front Page, Dream Weaver

Design/Version Control: UML, Rational rose

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior SQL/BI Developer

Responsibilities:

• Involved in designing and creating Tables, Views, complex Stored Procedures and Indexes using T-SQL.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Written custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Designed and implemented ETL processes with SSIS packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files, Text files, etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc and used configuration files and Environment variables for production deployment.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Implemented Server and Client side validations using ASP.NET validation controls and JavaScript.
• Used Dataset, Data Table, Data Adapter, Data Reader etc. for ADO.NET connectivity controls.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre and Post Execution, On Task Failed etc.)
• Worked on Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.
• Worked on both Star and snow flake schemas to build cubes using the fact and dimension tables, perform processing and deployed the cubes to SQL server analysis services database.
• Generated multiple Enterprise reports using SSRS and Report Builder 2.0 from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created ad-hoc SQL queries for customer reports, executive management reports.
• Evaluated database performance and performed tuning, backup, restoration and disaster recovery.

Environment: MS SQL Server 2012/2008/2005 , T-SQL, SSRS, SSAS, SSIS Packages, SSRS, ETL, ODBC, Excel, MDX, OLAP, OLTP, Access, Windows 2003 Server.

Confidential, Boston, MA

Sr. SQL/BI Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Used SSIS to migrate and transform data from different sources like SQL server, Oracle, DB2 to different destinations.
• Used joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Use the SQL Analyzer and Profiler for studying the SQL statements and procedures.
• Used T-SQL for programming for stored procedures and queries.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Performed data conversion from flat file into a normalized database structure.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Created various Weekly and Monthly reports showing detailed information.
• Responsible for creating the reports basing on the requirements using SSRS.
• Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Developed SSIS Templates which can be used to develop SSIS Packages.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio and updated in Visual studio 2008.
• Developed, monitored and deployed SSIS packages.

Environment: SQL Server 2012/2008/2005 /2000,Oracle,DB2,SSIS, SSRS, Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access 2003.

Confidential, Chicago, IL

SQL Server BI Developer

Responsibilities:

• Involved in User Requirement Gathering and Technical Specification Documentation.
• Developed Stored Procedures, Functions, Triggers and Cursors.
• Used Inner joins, Outer joins and other Complex joins for data retrieval from complex tables.
• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Set up the SSIS packages for the exchange of data between different data sources.
• Defined and processed the Fact table & Dimensions using SSIS.
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
• Updated the multi-dimensional cube data using SSIS- Import/Export wizard.
• Co-developed the ETL architecture design and the metadata model.
• Designed ETL packages for different data sources (SQL Server, Flat Files, and XMLs etc).
• Used various ETL tools like DTS/SSIS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Migrated SQL Server 2000 DTS objects to SQL Server 2005 integration services (SSIS) environment.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the users.
• Involved in designing of Star, Snowflake schemas and dimensional data models.
• Designed/implemented the information access and delivery effort for the data warehouse.
• Created logical and physical data models according to the business requirements.
• Monitored the performance of SQL Server using SQL Server Profiler.
• Designed different kinds of transactions for the application.
• Performed data transformation services and bulk inserts for large amounts of data.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Experienced in setting up SQL Server and database configuration parameters.
• Developed a Tabular Reports using SSRS Report Designer.
• Debugging reports and deploying reports on server.
• Installed and administered Microsoft SQL Server Reporting Services. Configured SMTP server and scheduled reports and send the reports via email.
• Created ad-hoc reports using SSRS Report Builder.

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services 2005, Windows 2003 server.

Confidential, Long Island, NY

SQL Server / SSIS / SSRS / Developer

Responsibilities:

• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Monitored and modified Performance using execution plans and Index tuning.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Involved in Scheduling jobs using MS SQL server Agent.
• Created and managed users, login IDs, security, and add groups to Windows and SQL Server.
• Involved in Performance tuning of existing database objects such as stored procedures and complex stored procedures
• Prepared documentation related to database design, objects security and rules.
• Created DTS Packages for migration of data between SQL Server and other databases like MS Access, MS Excel and Flat Files.
• Performed daily database backup & restoration and monitor the performance of Database Servers.
• Generate various ad hoc reports using MS Reporting services.

Environment: SQL Server 2000/2005, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows XP.

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created & managed the Database Users, Login and Security.
• Scheduled database backups and restored the Database from DR.
• Provide 24X7 support to all Production, QA & Development MS SQL Server Environments.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server
• Configured Replication Server, worked on replication server.
• Logical and Physical Data Modeling using Erwin.
• Identified the necessary steps to enhance user response time by checking fragmentation and re-index tables for efficient application access methods.

Environment: SQL Server 2000/2005 Enterprise Edition Advanced Windows 2003 Server, Erwin, SQL RedGate, SQL Backup, and Dell Power Edge 8450.