Professional Summary

• Over 7 years of IT experience in the Analysis Design Development Testing and Administering Client/server applications using Microsoft SQL Server .Net and BI suite
• Strong Experience in SQL Sybase Oracle C ASP.Net Visual Studio 2010/2008/2005 Web Services WPF
• Strong experience in SQL Development Administration ETL development using Microsoft SSIS Reporting solutions using SSRS and business intelligence delivery using SSAS DTS Performance tuning Designing logical/physical databases and Troubleshooting
• Expert T-SQL PL/SQL development skills in Objects creation such as Tables and Views Table Normalization User Defined functions Indexes Stored Procedures Correlated sub queries Cursors and Triggers using SQL Server 2000/2005/2008R2/2012 and Oracle
• Strong ability in defining query for generating various types of reports like drill down Parameterized Cascading Table Conditional Matrix Chart Sub reports in SSRS and ad-hoc reporting using Report Builder
• Experience in administrating the created reports and assigning permission to the valid users for report execution
• Thorough Knowledge of Various SSIS Objects such as Dataflow Components Control Flow Elements Connections Managers Runtime Events Log Providers and expertise in working on all activities related to the development implementation administration and support of ETL processes for large-scale Data Warehouses using DTS and SSIS with MS SQL 2005/2008/2012
• Experience in Creating and maintaining cubes using SSAS and writing MDX queries to generate Dashboard and Matrix Reports
• Experience in Performance Tuning and Query Optimization experience in using SQL Server Profiler to monitor the SQL server for deadlocks long running queries and tune the same to improve performance
• Healthcare Domain Knowledge good understanding of Claims data EDI X12 Facets and QNXT
• Knowledge of Agile Software Development Process good understanding of Object Oriented Programming Concepts Design Principles Design patterns MVC Architecture and Test driven Development
• Technical Skills
• Languages T-SQL PL/SQL C JAVA C VB Shell Scripting
• Database Environments SQL Server Oracle MySQL Sybase
• Web Development ASP.NET MVC PHP HTML XML Java Script VB Script CSS
• Tools SSMS SQL Server Profiler Tuning Advisor Business Intelligence Development Studio BIDS Visual Studio 2008/2010/2012 Toad Embarcadero Rapid SQL SQL Developer NUnit Microsoft Visio Tortoise SVN Team Foundation Server MS Access Test Complete Performance Analysis

Experience

Confidential

Sr. SQL BI/ .Net Developer

Responsibilities

• Working on EDI applications using SQL Oracle 11g Sybase SSRS SSIS C .Net BizTalk WPF
• Actively participated in design development discussions with DBA team lead and project manager and performed impact analysis
• Designed schemas DDL DML indexes cursors sequences triggers packages and stored procedures that provide input data to be processed by BizTalk server to generate All Paid Claims Data in flat file format Medicaid and EDGE server Data in XML format for the state
• Created User Defined Functions for data cleansing and data scrubbing cross database views to access tables from the base database
• Performance tuning using Query analyzer tuning advisor to improve performance of slow running queries
• Closely worked with business users and business analyst to gather user requirements and generate high level BRD s and Report Mockups for the Report Development
• Created and maintaining drill down matrix parameterized Reports along with their respective subscriptions using SSRS and Report manager
• Creating MDX Queries to retrieve data from SSAS Cubes and to generate cube RDL reports from Cubes
• Create ad hoc reports using Report builder on claims data for business analysts and user groups
• Created and maintaining SSIS Data stage packages to load application specific data to SQL and Oracle Databases using advance transformations i.e. Fuzzy Lookup Derived Columns Condition Split Term extraction Aggregate created jobs to schedule them using SQL server agent
• Created Dynamic SSIS packages using complex expressions variables and control flow components such as For Each Loop For Loop to loop over a Directory to load inbound Medicare Managed Care System Data
• Created application specific claims databases in Oracle SQL and batch jobs using SQL stored procedures
• Deployed Database changes Packages Reports and C applications from development to QA UAT and PROD environments
• Involved in design and development of the Reconciliation tool to reconcile Medicaid Edge data coming from the state using C Oracle WPF
• Created Service Downtime Tracker application using C .Net SQL that pings various services databases and logs the results in SQL tables
• Worked on Quote to Card BEST a Web services application using C .Net SoupUI Sybase
• Conducted Peer review sessions to identify and minimize issues in testing phase. Provided QA and UAT Support by actively fixing issues which are reported in HP Quality Center

Environment SQL Server 2012/2008 Oracle 11g SQL Server Management Studio SSIS SSRS C ASP.NET WPF Web Services Windows 2012 Server/2008 R2 server MS Visio Microsoft Visual studio 2012/2010/2008 SQL Server Profiler Control-M Toad SQL Developer Rapid SQL HP Quality center SVN VersionOne

Confidential

SQL BI Developer

Responsibilities

• Worked on a custom Software called EDGE a diagnostic repair information and inspection system used by Automobile dealerships using SQL SSRS SSIS C .Net ASP.Net Dev Express
• Involved in upgrading the instance of development environment of SQL Server 2005 to 2008R2/2012
• Performed daily backup and created named backup devices to back up the servers regularly
• Responsible for Monitoring Daily running jobs like Data Loading jobs Replication jobs
• Responsible for all data clean up optimization performance tuning and all backups Rebuilding indexes on various tables
• Designing the Logical and Physical databases and development of SQL Server Database
• Created and managed schema objects such as tables views clusters indexes procedures triggers and maintained Referential Integrity
• Creating maintaining the users roles and granting privileges
• Daily support administration troubleshooting monitoring optimization and tuning of server and SQL server environments across entire system query tuning using SQL execution plans SQL Profiler and Database Engine Tuning Advisor for maximum performance and efficiency
• Created Parameterized Matrix Drill down reports on diagnostics sales and payment data using SSRS
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server
• Deployed reports to Reports server and created respective subscriptions and monitored subscriptions
• Created and Maintained Packages to load payment diagnostic and repair data from various dealerships into central database using SSIS
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeeded
• Import and Export of data from one server to other servers using SSIS Periodic monitoring of the system for bottlenecks
• Wrote stored procedures functions to be called from front-end developers Developed features for Treatment Plan 2.0 part of the Edge World Class Inspection Software using C .Net SQL
• Have written product acceptance tests using Java script Test Complete and Power Shell scripts for Build Automation
• Technical Analysis Code Review Implementation 24 x 7 production support work with offshore teams

Environment MS SQL Server 2012/2008R2 Windows 2008/R2 C ASP.NET SSIS DTS MS Office Access 2007 SSRS T-SQL BIDS Linux DevExpress Rally

Confidential

SQL/.Net Developer

Responsibilities

• Design Develop and Maintain Reports Windows Forms Applications using SSRS C .Net WPF and SQL Server 2008
• Created Tabular reports Matrix reports List Chart reports Parameterized reports Sub reports Cascaded parameterized reports Drill down reports as well as interactive reports according to business requirements
• Provided ad hoc reports requested by the managers using Report builder
• Created Reports in SSRS with different type of properties like Chart controls Interactive sorting SQL parameters
• Created Stored Procedures triggers views temp tables for data manipulation and reporting
• Created Reports and respective subscriptions for management using SQL SSRS Report Manager
• Developed a custom Software called Quality Control Automation using C .Net WPF SQL and XML
• Have worked on Conservice Control website using ASP.Net C and SQL
• Have worked on Billing Process Automation for the Billing department using C .Net SQL
• Have worked on Quality Control Automation and Auto Email generation using C .Net SQL

Environment MS SQL Server 2008 C ASP.NET WPF SSRS MS Office Access 2007 T-SQL BIDS Tortoise SVN

Confidential

Database Developer

Responsibilities

• Worked as a database developer for the Technology Support Services using SQL server Oracle writing queries stored procedures triggers performance tuning and database maintenance
• Generate Enrollment Reports of students studying abroad for the University of Houston using SSRS
• Responsible to load student information into TSS database using bulk copy
• Responsible for TSS database backups and maintenance
• Created SQL scripts to archive student and employee information
• Developed web pages for High Performance Physics Group using PHP XAMPP and MySQL
• Developed applications in BMC Remedy programming in Shell script at the back end on Linux server
• Have used C ASP.Net Adobe Photoshop and SharePoint to design and develop web pages for TSS
• Created Windows forms applications using C ADO.Net and SQL

Environment MS SQL Server 2008 Oracle MySQL Windows 2008/R2 C ASP.NET DTS MS Office Access 2007 T-SQL PL/SQL BIDS Linux BMC Remedy PHP

Confidential

Software Developer

Responsibilities

• Requirement gathering Solution design
• Involved in the migration from SQL server 2000 to 2005
• Actively involved in Normalization of database
• Designed DDL and DML for MS SQL Server 2000
• Create rules defaults tables views clustered non-clustered index user defined data types and user defined functions
• Actively designed the database to fasten certain daily jobs stored procedures
• Optimize query performance by creating indexes
• Involved in writing SQL batch scripts
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries and Stored Procedures
• Involved in merging existing databases and designed new data models to meet the requirements
• Created Payment processing Desktop and Web applications using C .Net ASP.Net SQL

Environment MS SQL Server 2000/2005 C ASP.NET T-SQL Visual Studio 2005