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

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

WORK 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, PHP, Shell scripting, DTS, MS Office Access 2007, T-SQL, PL/SQL, BIDS, Linux, BMC Remedy

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