SUMMARY

• Experienced in developing server - side database management system (DBMS) applications on multiple platforms.
• Proficient in query optimization and TEMPeffective database management in different versions of MS SQL Server.
• Extensive expertise in writing SQL Procedures, Indexes, Views, Cursors, Triggers, and User Defined Functions.
• Profound knowledge and hands on experience using SSRS, SSAS, SSIS and BCP.
• Proven success designing high-integrity relational databases and business intelligence solutions supporting critical business areas.
• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business applications.
• Strong knowledge of data warehousing, including Extract, Transform, and Load Processes (ETL).
• Wide exposure to insurance, claims, marketing and e-commerce domain.
• Solid experience in ASP.NET and C# programming language.
• In-depth knowledge of database development methodologies, design and implementation.
• Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks.
• Expert base impact analysis of backend data to support regression.
• Has been ed and appreciated for developing multiple utility tools.
• Ability to work individually and as part of a cross functional team.
• Demonstrated sense of logic, decision making and problem resolution with an excellent ability to translate business requirements into programming specifications.
• Excellent communication, written, analytical and organization and collaboration skills.
• Attention to detail and commitment to quality of work, passion to learn and improvise.
• Ability to focus and remain focused on key deliverables.

TECHNICAL SKILLS:

Programming Languages: C#, SQL, Transact-SQL, JAVA, C/C++, VB.Net, VBA.

Database: Microsoft SQL Server 2005/2008/2012 , Microsoft Access 2007/2010, MYSQL.

SQL Server Tools: SSRS, SSIS, SSAS.

Web Technologies: ASP.NET, JSP, Java Servlets, HTML, JavaScript/JQuery, AJAX, CSS, CFML.

Frameworks: Microsoft .Net Framework 3.5/4.0, Windows SharePoint Services (WSS 3.0), ColdFusion8

IDE: Visual Studio 2005/2008/2010 , Eclipse.

Other Tools: Management Studio 2005/2008/2012 , SQL Profiler, Query Analyzer, Excel and other Microsoft tools, Adobe Dreamweaver, Adobe Photoshop, Smart Draw, Microsoft Visio, VMware.

Operating System: Familiar with Windows, Linux and UNIX based system.

PROFESSIONAL EXPERIENCE

Confidential, San Diego

Database Administrator

Environment: SQL, Transact SQL, XQuery, SSRS, SSIS, SSAS, PowerShell, SQL Server 2008/2005, ASP.NET, C#, Javascript, JQueries, AJAX, .NET Framework 4.0, MS VS 2010.

Responsibilities:

• Policy Client Management (PCM) System: Single handedly designed and developed a web based application that replaced the outdated spread sheets with the centralized repository system; avoiding data redundancy and hence improving the data consistency, security and productivity.
• Implemented data integration using SSIS (SQL Server 2008) which involves data extraction, transformation, and loading (ETL architecture) by combining data residing in different data sources and providing a unified view.
• Created automated jobs in SQL Server for the outbound policy and broker feed to save it on the billing and claims administrator FTP servers, and written Windows Web Service to send policy information to another claims TPA.
• Design the shredding process to import the data from Duck Creek database to PCM database using XQuery which halps in avoiding double data entry and building fast reporting database.
• Wrote script and automated the process to sync broker and producer information between Salesforce.com and Duck Creek system using data loader.
• Designed various subscription based reports using SSRS for the management, operation, marketing, underwriting and accounting departments.
• Tuned database transactions by creating / modifying stored procedures, triggers, and user defined functions, views and indexes.
• Wrote multiple scripts in SQL and windows services to monitor and send email notification for the ETL job, Duck Creek shredding, FTP file upload, daily submission and print form generation.
• Performed installation, backup / restore, check database integrity, index rebuild / re-organization.
• Database automation using PowerShell.
• Coordinated with the management to discuss business needs and designed database solutions accordingly.
• Trained new DBA on business rules and on writing efficient SQL queries.
• Automated the printing job by developing the Form Print Utility tool in C# to print invoices, notices of cancellation and monthly report forms.
• Quick Quote: Designed and developed web-based application using ASP.NET and C# to get the instant quotes. Credits:
• Received 2011-Overachiever: Recognition for extraordinary effort and contribution of an employee.
• Consistently received high ratings on all performance appraisals.

Confidential, San Diego

SQL Database Developer

Environment: SQL Server 2005, T-SQL, SSRS, C#, ASP.NET, SQL, MS VS 2008Responsibilities:

• Developed stored procedures, views, triggers and user functions using T-SQL to preserve referential integrity and provide application functionality.
• Proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Responsible for query optimization, performance tuning and troubleshooting day to day application issues.
• Supporting Users for their Business needs and working on the user requests from time to time.
• Created SQL jobs and stored procedure to import the data from various sources like Amazon.com, 4psite.com, USPS and UPS and save it in the SQL database.
• Checking the Status of Servers, Drive Sizes, Backup Schedules, Data Base Maintenance Plans and Job Schedules on Application Databases.
• Developed and maintained scripts and programs for data exchanges and interfaced with external systems.
• Created and publish number of reports to track the sales, inventory and loss ratio via SSRS.
• Produce SQL needed indices for data analysis purposes.
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.

Confidential ., Carlsbad, CA

Software Engineering Intern

Environment: C#, Javascript, ASP.NET, .NET Framework 3.5, SQL, Transact SQL, MS VS 2005, SQL Server 2005 Windows SharePoint Services (WSS 3.0), CFML, Coldfusion 8.

Responsibilities:

• Designed and developed the HR-Database for the company using ASP.NET, C# and SQL Server 2005.
• Designed advanced SQL queries, stored procedures, triggers, scripts and cursors.
• Enhanced the functionality of the customer website using Coldfusion8 and SQL Server 2005.
• Implemented companywide intranet portal and workflow using SharePoint (WSS 3.0).

Confidential, San Diego

Research Assistant

Responsibilities:

• Worked at Department of Exercise and Nutritional Sciences, SDSU as Research Assistant and developed an application using Java Swing to process the data of accelerometer. This application is used by the research students to interpret the accelerometer output into readable reports.
• C# Programming (me and II) Program2011