SUMMARY:

• 7 years of experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite Development, UAT and Production Environment in various domains like Banking, Insurance, Healthcare and Retail
• Experience in Implementation of Microsoft Business Intelligence BI platforms including SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS in SQL Server 2012/2008/2005
• Highly proficient in the use of SQL Server Management studio and T-SQL for constructing triggers, schemas, views tables, user functions and stored procedures.
• Experienced in SQL Server DTS and SSIS Integration Service package design and deployment
• Experienced in various Extracting, Transforming and Loading ETL tasks using SSIS including tools like BCP utility, DTS and SSIS 2012/2008/2005 Packages with proper control data flow elements.
• Expertise in developing SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Rich experience in doing MSSQL migrations and up-gradations.
• Troubleshooting the environment issues that come up during deployment of databases.
• Applied patches on different versions of SQL Server on Production as well as Non Prod Environment.
• Devised and Implemented Disaster Recovery strategy for critical production environment.
• Experience in configuring SSIS packages using Package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Highly experienced in performance tuning of database and queries by creating indexes, views and verifying execution plan and optimization of Complex SQLqueries.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows PerformanceMonitor for monitoring and tuning MS SQL Server Performance.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduling DTS Packages.
• Highly proficient in high level design of ETL SSIS/DTS packages for integrating data from heterogeneous sources Excel, Xml, Oracle, flat file, Text Format Data to MS SQL Server.
• Expertise in Relational Database Management Systems using SQL Server 2012/2008/2005/2000.
• Expertise creating SQL scripts to insert/update and delete data in MS SQL database.
• Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP.
• In-depth knowledge in Object Oriented Concepts and experience in OOAD Technologies, developing Use Cases, Activity diagrams, Sequence Diagrams and Class Diagrams using case tools like Rational Rose.
• Extensively worked on system analysis, design, development, testing and implementation of projects SDLC and capable of handling responsibilities independently as well as proactive team member.
• Good working knowledge of programmability enhancement features in SQL Server 2012
• Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good team player with excellent team work skills.

TECHNICAL SKILLS:

• Languages : T-SQL, PL/SQL, C , Asp.Net, HTML
• RDBMS : MS SQL Server 2012, 2008, 2005, 2000, MS Access
• Database Tools : SSIS, SSRS, SSAS, Cognos, SQL Server Data Tools, SQL Server
• Profiler
• Operating Systems : Windows Server 2012/2008/2003, Windows 7/8
• Architecture : Relational DBMS, Client-Server Architecture, OLTP, OLAP
• Version Control : Visual Studio Team System
• Tools : SQL Server Management Studio, BI Development Studio
• Web Applications : Share Point

PROFESSIONAL EXPERIENCE:

Confidential

Role: SQL Server Developer/SSIS/SSRS

Responsibilities:

• Responsible for Data Modeling based on the client requirements.
• Prepared the Technical and Function specifications based on the project requirements.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Redesigning the ETL process from the existing legacy DTS packages into SSIS Packages.
• The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Migrated data from different sources text based files, Excel spreadsheets, and Access to SQL Server databases using SQL Server Integration Services SSIS .
• Modified stored procedures to meet current design and used them in SQL Server.
• Developed queries in Data Warehouse in OLTP/OLAP environment.
• Created complex Stored Procedures, Datasets, Object Data Sources, and SQL Data Sources.
• Modified web pages to do database inserts, deletes, modify.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Troubleshooting Database performance issues and implementing necessary database changes.
• Trained 10 business users so that they can create reports from the report model I created.
• Created report models from OLTP OLAP.
• Created ad-hoc reports using SQL server 2005 Reporting Services SSRS .
• Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports.
• Involved in Development, Review and testing of the new system by implementing business rules and transformations.

Environment: SQL Server 2012/2008/2005, T-SQL, DB Artisan, MS Integration, Analysis and Reporting Services, Management Studio, Query Analyzer, Windows 2007 Server, Oracle 10g/ 11g

Confidential

Role: SQL Server Developer

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Designed, Developed and Deployed packages in SQL server environment using SSIS-2008.
• Involved in tuning and configuration of SSIS.
• Deployed SSIS packages from Development to Testing Servers
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2012/2008/2005 Reporting service SSRS
• Designed SSIS Packages to extract, transfer, load ETL existing data into SQL Server from different environments for the SSAS cubes.
• Worked on QA testing by writing scripts for source and target data to verify the integrity of the data.
• Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS.
• Event handlers, which are workflows that runs in response to the events raised by a package, task or container in SSIS.
• Involved in utilizing SSIS Checkpoint, Loading Dimension with the SSIS slowly changing Dimension Wizard and used different SSIS Control Flows.

Environment: SQL Server 2012/2008/2005, SSIS, SSRS, VSS, VBScript, XHTML, XML and Windows 2008/2003 Server

Confidential

Role: SQL Server Developer

Responsibilities:

• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files and Oracle databases.
• Designed and developed Complex SSIS packages for auditing using SQL SERVER 2008 Integration Services SSIS .
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion.
• Worked with different Control Flow elements like For Loop Container, for each Loop Container.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Involved in Maintenance and Deployment of SSIS Packages.
• Create database objects in SQL Server 2008 including Tables, Triggers, Views, Stored Procedures,
• User Defined Functions UDF and Indexes.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintained Referential Integrity.
• Created and executed SSIS packages to populate data from the various data sources.
• Created SSIS packages using SSIS designer for export heterogeneous data from OLE DB Source Oracle , Excel spreadsheet to SQL Server 2008
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services SSRS .
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.

Environment: SQL Server 2008/2005, SSIS, SSRS, VSS, VBScript, XHTML, XML and Windows 2003 Server

Confidential

Role: BI Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning
• Managed user access. Created and managed new security accounts.
• Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance test

Environment: SQL Server 2005/2000, MS Visio, DTS, MS excel 2003, T-SQL.