PROFESSIONAL SUMMARY:

• Over 11 years of experience with the 32bit, 64bit Confidential SQL Server in Production, Development and Testing in Clustered and Stand - alone Server Environments.
• Expertise in software analysis, design, and development of applications including providing Business Intelligence solutions using SQL Server Business Intelligence Development Studio with tools like SQL Server integration services SSIS, SQL Server Reporting services SSRS, SQL Server Analysis SSAS .
• Domain expertise in HealthCare, Market Research, Reliability and Data warehousing.Administration
• Involved in Attunity Replication, SQL Server Pull Replication
• Experience in analyzing locks, Dead locks and handling the Isolation levels and concurrency effects
• Extensively used the native tools like index tuning wizard, database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor and Event Viewer for performance Analysis
• Experience in backing up, Restoring the database manually and also by scheduling the jobs and maintenance plans
• Configured SMTP server for Database Mail setup and received alerts for the threshold values
• Implemented side-by-side Migration and in-place upgrade of MS SQL Server 2005/2008/2008 R2 to 2012
• Extensive experience in implementing high availability solutions on physical and virtual machines
• Handled multiple SQL instances on cluster environment for server consolidation projects
• Auditing of databases for worked on logins, user permissions and security in SQL server level and fixing Orphaned usersT-SQL/Design, Development
• Involved in all the phases of software development life cycle SDLC process (Design, Development and Unit Testing, System Integration Testing and Functional Testing).
• Expertise in working with all the DDL and DML Commands.
• Expert in Data Integrity, Performance Tuning and Query Optimization
• Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL Joins
• Enforced Constraints (Primary & Foreign Key) on Tables for Consistency and Integrity.
• Expert in handling Source Control tools like Visual Source Safe (VSS) and Team Foundation Server (TFS).ETL Development (SSIS)
• Created SSIS packages to perform ETL and generate3 types of reports (text, Excel and Delimited) from SQL server.
• Data validation framework created. SSIS package will create a separate report for bad data and a separate report for correct data
• Experience in Data Migration (using tools like BULK INSERT, BCP and Replication) between different homogeneous/heterogeneous systems and SQL Server.
• Excellent skills and experience in using different Tasks and Transforms like Conditional Split, Aggregate, Chapter Map, Pivot, Data Conversion, Lookup, Sort, Merge etc.
• Implemented Precedence Constraints based on the combination of the execution results and the evaluation of the expressions.
• Proficient in creating packages with different Isolation levels and Transaction options, with Break points and Event HandlersBI & Reporting (SSAS, SSRS, QlikView, Tableau)
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2005/2008 (SSRS).
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008/2005.
• BI Dashboards created on QlikView, Tableau.
• Experience Working with MDX Queries for reporting purpose.
• Experience in creating Drilldown, Stacked Pie, Bar, Line Charts using Parameters and automating the SSRS reports with Parameters by caching and using snapshots.

TECHNICAL SKILLS:

Database: SQL Server 2000,2005, 2008, 2008 R2, 2012, 2014, MS Access, Oracle 9i

Confidential BI Technologies: SSRS, SSIS, SSAS

Programming Language: Visual Basic Applications

Operating Systems: Windows 2000, Windows 2003, Windows Server 2008

Tools: Informatica, TOAD, Ultra Edit-32, Confidential Compare

CM Tools: Product Studio, Visual Studio Team Foundation, PPS, VSS, SVN

BI DashBoards: QlikView, Tableau, QlikSense

Reliability Tools: Reliasoft Weibull, ALTA

WORK EXPERIENCE:

Confidential

Admin/SQL DB Developer

Environment: s SQL Server 2014, SSRS, SSIS

Responsibilities:

• Handled Administration role to maintain the smooth project flow.
• Involved in SQL Server Pull Replication
• Involved in Paxit data, Formulary Drug, RGIS data, Moodle and delivery data.
• Data compare between replicated objects (various SQL server to one destination)
• Involved in Data Integrity, Performance Tuning and Query Optimization
• Created objects like Tables, Views, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL Joins
• Involved in Database Design, Performance Analysis and development
• Extensively used the native tools like index tuning wizard, database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor and Event Viewer for performance Analysis
• Involved in backing up, Restoring the database manually and also by scheduling the jobs and maintenance plans
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data marts.
• Experience in Data Migration (using tools like BULK INSERT, BCP and Replication) between different homogeneous/heterogeneous systems and SQL Server.

Confidential

Admin/SQL DB Developer

Environment: s SQL Server 2008R2, 2012, SSRS, SSIS

Responsibilities:

• Created SSIS packages to perform ETL and generate3 types of reports (text, Excel and Delimited) from SQL server.
• Involved in 834 files extraction, 837 claims extraction.
• Involved in ICD9 to ICD10 conversion.
• Involved in creating an application for Case Manager Portal
• Involved in Attunity Replication
• Attunity upgrade across servers
• Implemented side-by-side Migration and in-place upgrade of MS SQL Server 2005/2008/2008 R2 to 2012
• Involved in Data Integrity, Performance Tuning and Query Optimization
• Created objects like Tables, Views, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL Joins
• Performed BCP, Bulk Insert, imported and exported data from different Data Sources
• Involved in Database Design, Performance Analysis and Production Support for very large and Complex databases
• Analyzing locks, Dead locks and handling the Isolation levels and concurrency effects
• Extensively used the native tools like index tuning wizard, database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor and Event Viewer for performance Analysis
• Involved in backing up, Restoring the database manually and also by scheduling the jobs and maintenance plans
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.
• Used ETL to implement the SCD transformation, to maintain historical data in data warehouse. Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Worked on framework which will schedule the SSIS packages using setid through jobs

Confidential, Houston

Senior BI Developer

Environment: s SQL Server 2008, SSRS, Reliasoft

Responsibilities:

• Representative of the Report Team from offshore.Involved in the development of new modules which was followed from Requirements Gathering to Design to Coding to testing
• Involved in creating Jobs, SSRS Reports, new excel reports (macros)
• Involved in database backup and restore.
• Involved in doing change requests and enhancements.
• Involved in preparing Analysis documents, test cases for extensive testing.

Confidential, Redmond

SQL Server Developer

Environment: s SQL Server 2008

Responsibilities:

• Representative of the Development Team from offshore.
• Involved in the development of new modules which was followed from Requirements Gathering to Design to Coding to testing
• Involved in creating Jobs, SSIS packages, new excel reports (macros)
• Involved in SSRS, SSAS
• Involved in migration of SQL Server .
• Involved in upgradation of Windows server .
• Responsible for deploying the release in different environments.
• Involved in Replication between servers.
• Involved in database backup and restore.
• Involved in doing change requests and enhancements.
• Involved in preparing Analysis documents, test cases for extensive testing.
• Involved in Configuration Management and Quality adherence to keep up the health index of the project.

Confidential

VBA Developer

Environment: MS Office, VB Applications

Responsibilities:

• Coordinated between client and offshore team from Onsite in implementing the project
• Task allocation and coordination between client and offshore team
• Responsible for deploying the application in different environments
• Involved in setting up the hardware and software resources according to the requirements
• Involved in developing Reports
• Coding and testing
• Involved in client discussions and requirement gathering
• Involved in preparing Analysis documents, test cases for extensive testing.
• Involved in Configuration Management and Quality adherence to keep up the health index of the project.

Confidential

Oracle Developer

Environment: s Oracle 9i, VBA

Responsibilities:

• Involved in the development of new modules which was followed from Requirements Gathering to Design to Coding to testing
• Involved in doing change requests and enhancements.
• Involved in developing Stored Procedures.
• Involved in preparing Analysis documents, test cases for extensive testing.
• Involved in Configuration Management and Quality adherence to keep up the health index of the project.

Confidential

Oracle Developer

Environment: s Oracle 9i, Forms, Reports, MS Access

Responsibilities:

• Involved in developing Interfaces used to run batch jobs on a daily basis.Involved in Data migration to load history data into the system.
• Involved in developing Stored Procedures.
• Involved in preparing Analysis documents, test cases for extensive testing.