SUMMARY

• Over Nine (9) years of IT experience, which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server, Oracle) in production environments and providing ETL/Business Intelligence solutions using Microsoft components to various clients (SSIS, SSRS).
• Extensive experience in Systems Development Life Cycle (SDLC) from Design, Development and Implementation.
• Excellent skills in exporting and importing data using Microsoft ETL technologies (SSIS).
• Excellent skills in providing ETL solutions to the clients for integrating data from different sources (XML,Excel,Delimited,Oracle,Teradata,SQL Server, flat file) using multiple transformations provided by SSIS.
• Experience in generating XML formatted files using FOR XML clause in T - SQL.
• Excellent skills in designing Logical and Physical Modeling of databases.
• Expereince using Change Data Capture methodology in SQL Server.
• Experience using high complex T-SQL Queries and SQL scripts to perform efficient data load based on complex business rules and produced results for users.
• Extensive experience in TSQL Development which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and User Defined Functions.
• Excellent skills in creating indexes and performace tuning the T-SQL queires uing SQL profiler.
• Excellent skills in reading and understanding T-SQL execution plans and performance tuning with SQL Server Dynamic Management Views.
• 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, SMTP Mail in SSIS.
• Experience in creating simple to complex parameterized SQL Reports using SQL Server Reporting Services (SSRS).
• Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Experience in using Performance Monitor/Profiler to monitor and solve performance issues like Dead Locks and Long running queries.
• Stored procedure (SP), user defined function (UDF), and user defined table function experience with DB2 SQL/PL.
• Experience in SSRS with Report authoring, Report management, Report Delivery and Report Security.
• Experience in defining query for generating drill down reports in SSRS 2005/2008.
• 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 with .NET in interacting with Business users and the development team.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and interpersonal communication skills.
• Actively involved in AGILE SCRUM work environments.
• Good understanding of Health Care, Financial, Banking, Telecom and Insurance domains.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008/2005/2000 , Oracle 11g/10g/9i/8i, DB2, Teradata, 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, Windows Server 2008, Windows 7, Windows XP

Other Tools: SQL Loader, ERWIN, ER Studio, Microsoft Visual Source Safe, Microsoft Office, Microsoft Visio, MS Visual Studio 2003/2005/2008/2010/2012/2013 , Microsoft BIDS, Crystal Reports, Team Foundation Server, HP Quality Center, Bugzilla, Zephyr, Source Version Control (SVN), SQL Developer, TOAD for ORACLE SQL, JIRA, Confluence, Service Now, Trizetto FACETS, TIDAL(Cisco’s Enterprise Job Scheduler)

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

Sr.Associate Consultant

Responsibilities:

• Interact with business analysts, business users in understanding the requirements and develop complex business logic to extract the required data.
• Create data extracts to send the data acrosss to different vendors (XML, Pipe Delimited, Excel etc)
• Created and managed complex SSRS reports that will be used by Federal government agencies.
• Created multiple extracts using T-SQL FOR XML clause.
• Performance tuning of existing stored procedures and user defined functions.
• Created ad-hoc SSRS reports for internal business users to manage their day to day activities.
• Provided on call support in monitoring the scheduled jobs and troubleshooting the failed jobs in production environments.
• Using ORACLE as a data source and SQL Server as a staging database created multiple business rules to satify the needs of sending the billing related data to various vendors.
• Documented the T-SQL code and business rules for Business Analysts and business users.
• Modified existing ETL technologies to send out automated emails for success and failure of jobs using SMTP in SSIS.
• Worked with DBA’s in transfering the data from different environments to different environments.
• Created SQL scripts for maintaining administration tasks and configured transactional, merge replication and snapshot replication.
• Configured and maintained transactional and merge replication for 2 environments.
• Monitoring server load and server disk space and SQL backups for DBA’s and timely updating the teams for maintenance plans and maintenance windows of the servers.
• Configured SQL Security features and maintained user administration.
• Indexing of the SQL server tables by understanding the execution plans of the existing queries in different environments.
• Using SQL profiler identified slow running queries and tuned them using Dynamic Management Views.

Environment: MS SQL Server 2008/2012/2014 , ORACLE, TrizettoFacets, Windows XP, Windows Server 2012, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Data Tools, MS Excel, Flat File, SQL Profiler, XML, Source Version Control, Cisco Enterprise Scheduler, Service Now, Zephyr, JIRA, Confluence.

Confidential, Tampa, FL

SQL Application Developer

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.
• 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 Developers.
• 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.
• Worked with business team for understanding the potential needs of customers and designing the custom based reports using Crystal Reports 2008.
• Implemented the EDI Remediation Phase 1 project to meet the HIPAA compliance requirements.
• Created the standard process for extracting and formatting the data based on EDI 834 format requirements from different insurance carriers.
• Implemented the EDI Remediation Phase -2 plan to remediate the issues with high turnaround time and to implement the enterprise data extract model for creating the EDI 834 format files that meet HIPAA compliance requirements.
• Involved in Backup and Restoring of databases.
• Involved in creating reports as per requirement using Crystal Reports, SSRS.
• Creating users and granting permissions based on the user job profiles.
• Implemented the standards for creating the EDI 834 ANSI files for exchange health plan enrollment data between employers and health insurance carriers to comply with HIPAA 5010 standards.
• Communicate and follow up with the external insurance carriers on the EDI 834 file layout specifications, group structures, plan structures etc.
• 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.
• Actively monitoring all the EDI jobs and troubleshooting the issues with the EDI BATCH scripts.
• 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.
• Actively involved in communicating and following up with the external insurance carriers on the EDI 834 file layout specifications, group structures, plan structures etc.
• Documented all the processes involved in maintaining the database for future reference.

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

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.
• 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, tuning using SQL P/A, DB2 Explain utilities.
• 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, Windows XP, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS),MS Excel, Flat File, Oracle 10g,DB2, Erwin, SQL Profiler,C#.NET, VB.Net.

Confidential, San Francisco, CA

SQL Developer

Responsibilities:

• 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 load 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 Developer

Responsibilities:

• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers and maintaining Referential Integrity.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Created Stored Procedures and User Defined functions.
• Created Indexes and worked on the performance issues.
• Involved in re-design and development of back-end SQL Server database.
• Reviewed many T-SQL issues using management studio for better performance.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Using SSIS Performed Migration of databases from SQL 2000 to SQL2005.
• Moved the static data from various heterogeneous sources like Oracle, MS Access and MS Excel and text files to SQL Server 2005 database using BCP and dynamic SSIS packages.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Developed complex reports like Drill capabilities, Complex freehand SQL queries, Functions, Master Detail, and Cross Tab with multiple breaks.
• Designed and developed the entire business intelligence reports using SQL Server Reporting Services 2005 and integrating it to the front end application.
• Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.
• Set up Profiler Traces, Analyze and replay Profiler Traces for Performance and long running queries.
• Designed and developed classes using C#.NET, ADO.NET, XML for connectivity.

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), 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 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.