SUMMARY

• 6 - 7 years of experiencein SQL programming on SQL Server 2005/2008/2012
• 6+ years of experience in creating and deploying ETL and data flow tasks using SSIS
• Ability to optimize stored procedures and ad-hoc SQL queries on SQL Server platform
• Experience working with indexes, views, and triggers on SQL Server
• 4+ years of experience in creating and deploying reports using SSRS
• Experience of SQL programming on MySQL and Oracle databases
• Good understanding of database theory, design, and application
• 4+ years of experience developing web application using C#, ASP.Net, WCF, HTML/HTML 5, CSS/CSS3, and JavaScript
• 1-2 years of conducting unit test experience using .Net framework
• 4 years of preparing design document experience
• Ability to create and consume web services using .Net framework
• Experience working with jQuery library
• Strong understanding of using object-oriented programming principles
• Ability to program in core JAVA and VB.Net
• Good understanding of Hadoop framework and ability to write distributed programs in JAVA following the MapReduce concept
• Experience with version control using Git, SVN and CVS
• 6+ years of experience gathering requirements from the business teams and providing technical support to the internal clients in terms problem research through data analysis.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008/2005/2000 , Oracle, MySQL, MS-Access 2003/2007/2010

Programming Languages: T-SQL, C#, PL/SQL, XML,HTML, VB .NET, core JAVA

Operating Systems: Windows Server 2008/2003, Windows XP/ 2000/ 95/ NT

SQL Server Tools: SQL Server Management Studio (SSMS),SQL Server Data Tools, Business Intelligence Development Studio (BIDS), SQL Server Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, Import & Export, Visual Studio Net

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services(DTS)

OLAP/ Reporting Tools: SQL Server Analysis Services (SSAS), SQL Server Reporting services (SSRS), Crystal Reports

WORK EXPERIENCE

Confidential

Software Engineer/SQL Server Developer, Blacksburg, VA

Develop, maintain and upgrade a HIPAA compliant Medicaid-billing software. Coordinate with fellow software engineers on design and implementation of features, enhancements and code reviews. Provide training /consulting to client representatives and business analysts on the effective use of the system including data analysis activities to help the business team understand the root cause of the outcome generated by the application.

Selected Contributions:

• Developed a .Net based reporting application that provides web server & application specific metrics on a daily basis; provided project and business managers helpful metrics and insight
• Generate and schedule ETL tasks using SSIS packages to load the data warehouse
• Helped Synchronize Salesforce with SQL Server using SSIS
• Create and scheduled SSIS jobs through SQL Server agent
• Generate and deploy reports using SSRS based on the requirements provided by the functional team
• Worked with the business teams in understanding and analyzing the requirements and generated ad hoc and scheduled reports that were sent to external clients
• Provided application support to the internal clients in the form of research of technical problems through data analysis, data cleansing and complex application related issues
• Performed data profiling on the application web logs pulled from the SQL Server database for the end of quarter reporting
• Performed analysis of the state’s Medicaid agency’s claim acceptance criteria by reviewing their proprietary companion guides in order to accommodate new projects to use the application for generating and sending claims to the state Medicaid agency
• Performed analysis using the Idera’s SQL diagnostic manager and report on the database objects that comprise more than 50% of the size. This was a routine activity performed every quarter for the purpose of upgrades and maintenance of the software and hardware resources
• Helped protect against SQL Injection by improving the code
• Increased performance by adding indexes to the database tables and fine tuning stored procedures; decreased time to perform critical data operations that implement core business logic
• Developed a custom data access layer using C# that harness the inbuilt data access classes and methods provided by the .Net framework
• Was part of the development of one of the most important feature that helped generate Medicaid claims with better precision; helped the business team account for every dollar amount when generating claims through the application
• Automated the deployment process using windows batch scripts; replaced several manual steps and minimized the risk of human error
• Assist client representatives to adhere to the changing state Medicaid requirements and provide feedback that would help them to submit correct claims either through customization or a new feature or sometimes by offering an Ad hoc solution in appropriate cases

Confidential, Bloomfield, CT

SQL/SSIS Developer

Confidential it’s a global health insurance organization. Confidential runs a full-service staff-model HMO (health maintenance organization) with satellite clinics throughout the region, known as the Confidential Medical Group. Confidential also has certain run-off operations, including a Run-off Reinsurance segment.

Selected Contributions:

• Interacted with business users in collecting the requirements, solving issues and making changes as required
• Transformed data from different data sources like Oracle, Flat files, SQL data bases to SQL Server 2008 using OLEDB connection providers by creating various SSIS packages
• Migrated data from flat files to SQL Server
• Implemented the concepts of incremental data load, Slowly Changing Dimensions for updating and maintaining the history of the records
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions
• Created database objects like tables, indexes, stored procedures, views, user defined functions, cursors and triggers
• Implemented C#.Net scripts and performed testing
• Developed and scheduled DTS packages for each system Interface using SQL code
• Managed indexes and optimized queries using execution plan
• Used temporary tables, table variables and common table expressions (CTE) for the better performance of the queries according to the requirement

Environment: MS SQL Server (2008, 2008R2), Visual Studio (2008, 2010),SSIS, SSRS, Query Analyzer, Windows Server 2003, SSAS, T-SQL, C#

Confidential, Houston, TX

Software Engineer/SQL Developer

Selected Contributions:

• Designed and developed application database and business logic
• Designed and developed a Windows forms based software application along with a team of junior developers from the ground up focusing towards the freight forwarding market to automate the process of Export Declaration
• Participated in requirements gathering by collaborating with project manager, stakeholders and industry member
• Provided training and support to the junior developers to meet the requirements in a timely manner
• Created design documents and UML diagrams
• Developed application code using C#
• Created database objects like tables, indexes, stored procedures, views, user defined functions, and triggers
• Migrated the clients data from the access database and excel files into the SQL Server database using SSIS
• Undertook the responsibility of integrating and certifying the application to be Automated Export System (AES) compliant
• Developed reports using the Crystal reports 2008 software

Environment: MS SQL Server (2008R2), Visual Studio (2008, 2010), SSIS, Windows Server 2003, T-SQL, C#, Crystal Reports 2008

Confidential, Indianapolis, IN

SQL BI Developer

Selected Contributions:

• Interacted with business users to gather business requirements
• Created new tables, wrote stored procedures for application developers and some user-defined functions
• Created SQL scripts for tuning and scheduling
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Performed data conversion from flat file into a normalized database structure
• Created Triggers to enforce data and referential integrity
• Create new SSIS package (2008) to extract data from legacy to SQL Server Objects
• Installation and configuration of reporting server
• Modified DTS to SSIS packaged to accomplish critical business logic
• Defined Check constraints, Business Rules, Indexes, and Views
• Configured Server for sending automatic mails to respective people when a SSIS process failed or succeed
• Developed, monitored and deployed SSIS packages (2008)

Environment: MS SQL Server (2008), SSIS, Windows Server 2003, T-SQL

Confidential

Database Developer

Selected Contributions:

• Worked with application developers in maintaining/creating database objects on SQL Server 2005
• Created the data flow tasks using SSIS for loading bulk data in the reportingenvironment
• Worked with the business team to gather requirements and write SQL queries to create reports using the SSRS reporting tool
• Contributed by creating and documenting user manuals for the software application

Environment: MS SQL Server (2005), SSIS, SSRS, Windows Server 2003, T-SQL

Confidential

SQL Server Developer

The Confidential group is one of the largest healthcare groups in India. The MPMS (Medical Practice Management System) project was aimed at building a data warehouse for tracking patient records. Flat Files, Oracle tables, DB2 tables and Excel spreadsheets were part of the source data, which came in on a daily, weekly and monthly basis.

Selected Contributions:

• Created and modified procedures, triggers and functions
• Used profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
• Modified store procedure for performance tuning
• Used DTS packages to do file operation, to apply business rules
• Extensively used Ultra-Edit to verify the text file provided by employer/agency and keep trace of files provided by employer/agency
• Transformed data from text file to SQL server using OLE Automation Objects
• Deployed database objects from development/testing environment to production environment
• Created DTS package to export and import data from SQL Server to text files and data files
• Worked with Application Developers to support Development activities and achieve optimal efficiency
• Monitored and scheduled existing/new jobs on production environment
• Created all administration tasks of SQL Server
• Used system stored procedures and DBCC commands
• Keep trace of version of store procedure in Visual SourceSafe
• Responsible for keeping system and databases up-to-date by making necessary changes

Environment: MS SQL Server 2005, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005, T-SQL, BIDS