SUMMARY

• Over Ten (10) years of IT experience, which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server 2012/2008/2005/2000 ) in production environments.
• Excellent skills T - SQL, SSIS, SSRS, SSAS and involved in multiple SQL Server Upgrade projects in Agile SCRUM work environments.
• Excellent skills in designing Logical and Physical Modeling of Relational Database Management Systems (RDBMS).
• Experience in designing Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models.
• Extensive knowledge of data formatting tools to query and manipulate data in varying file formats (CSV, Delimited, Excel, Text etc).
• Thorough knowledge of referential integrities between different tables and environments, large data formats and file structures.
• Extensive experience working with SSIS data quality services and SSIS data profiling toolset.
• Excellent skills working with varying data types and data formats in enterprise level environments.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Extensive experience in Systems Development Life Cycle (SDLC) from Design, Development and Implementation.
• Extensive experience working in Clustering environment and configured SQL server cluster groups as a High Availability Solutions.
• Extensive experience in enforcing (FACETS) PAPER POLICIES AT DATABASE LEVEL.
• Extensive experience in implementing and managing SQL Server policy based management.
• Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and User Defined Functions.
• Extensive experience developing and implementing Microsoft SQL Server integration services (SSIS), Microsoft SQL Server Analysis services (SSAS), Microsoft SQL Server Reporting Services (SSRS) and MDX for data warehouse and data mart solutions.
• Experience in creating packages to extract data from Excel, Flat file, Oracle, DB2, Sybase to MS SQL Server by using MS SQL Server DTS and SSIS.
• Experience in data Migration (using tools like DTS, BCP) between different heterogeneous systems and SQL Server as part of data migration and data maintenance.
• Experience in Jobs, Sending Alerts using SQL Mail.
• Experience in creating simple and parameterized SQL Reports using SQL Server Reporting Services (SSRS).
• Good knowledge in SQL Server Analysis services, OLAP, OLTP Design & Implementation.
• Familiar with OLAP cubes and fact table, star and snowflake schemas.
• Extensive Knowledge in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, query optimization, back-up/recovery.
• Experience working in large enterprise environments involving multiple databases within multiple environments and working with data sets of over billions of records.
• Extensive experience working with data marts in data warehouses.
• Extremely diligent, strong team player with an ability to take new roles.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and interpersonal communication skills.
• Actively involved in Agile SCRUM work environments as a team member.
• Good understanding of Health Care, Financial, Banking, Telecom and Insurance domains.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008/2005/2000 , Oracle 11g/10g/9i/8i, DB2, Sybase, MS-Access.

SQL Server Tools: Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, Export & Import (DTS), SQL Profiler.

Operating System: Windows NT, Windows 2000, Windows 2003, Sp3, UNIX,Linux.

Languages: C, C++, PHP, T-SQL, XHTML, VB6, Unix Shell scripting, VB.NET.

Other Tools: SQL Loader, ERWIN, ER Studio, Microsoft Visual Source Safe, ProClarity, Microsoft Office, Microsoft Visio, MS Visual Studio 2003/2005/2010/2012/2013 , Crystal Reports, Informatica,Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Application Developer/Senior Data Analyst

Responsibilities:

• Upgraded the existing Microsoft SQL Server 2000 database to Microsoft SQL Server 2012.
• Converted the DTS 2000 packages to SSIS 2012.
• Created SSIS packages to load data into Database using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, script task.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Actively involved in unit testing the SSIS packages and database objects, end user files and making sure they align with the requirement of the end users.
• Worked on complex stored procedures which interact with different applications and simply the process of extracting the data into different files using loops in SQL Server.
• Modified complex SQL Server Stored Procedures to make use of loops instead of cursors and simplify them into more granular and detail level.
• Created multiple SSIS packages according to the production workflow and creating interfaces which extract the data from different sources using various transforms and load them into files (CSV, Text, Excel, fixed width, delimited, tabular).
• Documented the existing workflow of application maintenance for future use and assisted DBA in identifying potential issues within the application security.
• Written complex SQL queries which extract the data from different tables, views and perform multiple complex aggregations using complex business logics.
• Worked on SQL Server Data tools for converting the database objects from .
• Worked on DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
• Actively involved in Production deployments of all database objects.
• Regular monitoring of all the SSIS jobs and fixing the issues for end users.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
• Used SSIS 2012 to create ETL packages(.dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases.
• Created policies that can handle entities on the SQL Server objects and the instance of SQL Server databases.
• Worked closely with DBA to standardize policies on FACETS for the organization's SQL Server instances and automate Policy Checking and Enforcement.
• Worked with business team for understanding the potential needs of customers and designing the custom based reports using Crystal Reports 2008.
• Created the standard process for extracting and formatting the data based on EDI 834 format requirements from different insurance carriers.
• Involved in creating complex table structures, stored procedures, views, error reports, SSIS packages.
• Involved in performance tuning of some of the queries that run in multiple databases across different environments with over 40 gigabytes of data.
• Involved in Backing up and Restoring of databases.
• Involved in creating report as per requirement using Crystal Reports.
• Creating users and granting permissions based on the user job profiles.
• Involved in day to day managing and monitoring of EDI Batch scripts/jobs and supporting the FTP applications.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Worked on WSFTP tool for the FTP process and troubleshooting the issues with PGP encryption and GPG encryption methods.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Documented all the processes involved in maintaining the database for future reference.

Environment: MS SQL Server 2000/2008/2012 , Oracle 11g, Windows XP, Windows Server 2012, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), Microsoft Visual Studio 2008, SQL Server Data Tools, MS Excel, Flat File, SQL Profiler, Windows Batch Scripting, WSFTP, FileZilla, Crystal Reports, Visual SVN, Team Foundation Server(TFS).

Confidential, Colorado Springs, CO

Senior SQL developer

Responsibilities:

• Involved in developing logical and physical data models using ERWIN tool.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Developed complex programs in T-SQL, wrote Stored Procedures, Triggers, Views and Queries with best execution plan.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
• Provide query performance monitoring and tuning recommendations, cost estimates.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using SSRS.
• Created queries for generating drill down reports in SSRS.
• Formatted the reports using the Global variables, expressions and Functions.
• Optimized SQL statements for customer summary reports.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Environment: MS SQL Server 2008/2005, Oracle 11g, Windows XP, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Visual Studio 2008, Informatica, MS Excel, Flat File, Oracle 10g,DB2, Erwin, SQL Profiler,C#.NET, VB.Net.

Confidential, San Francisco, CA

SQL Developer/Data Analyst

Responsibilities:

• Involved in designing the logical and physical architecture for database.
• Involved in SQL Server Cluster and Database Mirroring implementation.
• Involved in Backing up and Restoring of databases.
• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert)
• Involved in error handling of SSIS packages by evaluating error logs
• Successfully extracted transformed and loaded data into data warehouse
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports and dashboards and score cards reports(SSRS) according to business requirement
• Created reports by dragging data from cube and wrote mdx scripts
• Used SSIS 2008 to create ETL packages(.dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases
• Improved the performance of long running views and stored procedures.
• Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Tuned the queries using Execution plan, to get index seek from table scan and index scan.
• Improved the performance of many queries by 90%.
• Worked with Erwin data modeling tool
• Created Database objects including Tables, Views, Stored Procedures and UDF.
• Developed User defined functions, stored procedures, indexes, Triggers.
• Extensively involved in writing database scripts.

Environment: SQL Server 2008, SQL Server Management Studio (SSMS), Sybase, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), IIS, VB.Net, Erwin, MS Excel, XML, SQL Profiler.

Confidential, Madison, WI

SQL DBA/Developer

Responsibilities:

• Part of 8 DBA team providing primary DBA support to data bases and developers for various levels and privileges.
• Responsible for General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Loaded the data from multiple systems to the Reporting Data warehouse database.
• Expertise on SQL Diagnostic Manager Tool which can be configured for all production databases
• Reporting and resolving serious SQL Server alerts.
• Created Clustered and Non-Clustered Indexes.
• Involved in SQL Server Cluster and Database Mirroring implementation.
• Involved in Backing up and Restoring of databases.
• Generated different reports using MS SQL Reporting Services.
• Worked on DTS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Monitor Databases for lock escalation, dead Lock, resource utilization by sessions, Capturing long running SQL queries using SQL Server.
• Tuning Queries and Database performance using tools SQL PROFILER, SET IO, QUERY EXECUTION PLAN etc.
• On call 24/7 support to databases on weekly rotation.

Environment: SQL Server 2000/2005, Windows 2000, Query Analyzer, Excel, DTS,SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS), Informatica, T-SQL, C#, .Net, Visual basic, Visual studio2005.

Confidential, Lewisburg, WV

SQL Developer

Responsibilities:

• Created Stored Procedures, Triggers, Views and Functions for the Application. Extensive testing on the Performance of the Stored Procedures.
• Developed complex T-SQL code for the application conversions.
• Imported various Sources, Targets, and Transformations using DTS packages.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files.
• Perform data transfer and database transfer for server relocation using DTS.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Worked with ASP.NET, ADO.NET, C#.NET and SQL Server for developing applications.
• Created backup/restore and disaster recovery plans for production servers.
• Developed and implemented change control procedures to manage system Modifications/upgrades.
• Optimized performance using Data Validation and Data Cleaning.
• Extensive testing on the Performance of the Stored Procedures.

Environment: MS SQL Server 2005, Windows2003, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS), Enterprise Manager, T-SQL, DTS, Query Analyzer, ASP.Net, C#.Net.

Confidential

SQL DBA/Developer

Responsibilities:

• Installed and configured SQL Server 2000/2005.
• Designed and developed the databases.
• Actively participated in logical design of database design to meet new product requirement using ERWIN.
• Wrote and modified stored procedures to implement the complex business needs for generating new customer number, account no, increasing, decreasing and setting credit limit as per business policies, updating user profiles, transaction processing, generating messages with code encryption
• Configured the DTS packages to run in periodic intervals.
• Writing stored procedures and triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Facilitated simplified access of database for end users using demoralized views and created triggers on them to maintain to database integrity
• Created tables, views, triggers, stored procedures and indexes.
• Created integrity rules and defaults.
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment.
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Used SQL Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.

Environment: SQL server 2000/2005, Windows 2000, Oracle, DB2, Flat Files.