Its a development and support project for processing of various applications of the client.

a hospital automation to enable transformation in patient care, resource management and information management

• Its a CRM based project for the sales,services and campaigns.The data is huge and needed to be maintained as well as regular campaign data needed to be migrated to CRM DB.
• Created mapping tables to find out the missing attributes for the ETL process, for CRM 365 application.
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Participate on or lead technical implementation team
• Lead development of technical specifications based on functional specifications
• Lead and develop components of the customer solution that include application enhancements, system integrations, data conversions and migrations.
• Oracle 11g/10g/9i/8i/8.0/7.3, PL/SQL, SQL *Loader, Physical database design, Logical database design, Data Modeling (PowerBuilder), Data Mapping, Cleansing, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Security Administration, Resource Management, Software Maintenance, User & Security Management, Oracle Tuning & Optimization.
• creation and scheduling of T-SQL jobs to run daily

Hospital automation to enable transformation in patient care, resource management and information management

• Designing page according to client reqirements.

• Writing code behind and stored procedures according to new requirements

• Fully aware of standard templates being followed for the preparation of relevant document useful for the project.

• Responsible for unit testing and some part of integration testing.

• Providing proper validations in the page .

• Worked in all production issues involving in my pages.

• Have worked in different modules like billing,wards,lab and nurses

Involved in the product team to stabilise the product server and got experience in services relating issues

• Designing page according to client reqirements.

• Writing code behind and stored procedures according to new requirements

• Fully aware of standard templates being followed for the preparation of relevant document useful for the project.

• Responsible for unit testing and some part of integration testing.

• Providing proper validations in the page .

• Worked in all production issues involving in my pages.

• Have worked in different modules like billing,wards,lab and nurses

Involved in the product team to stabilise the product server and got experience in services relating issues

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Upgrading of SQL Servers.

• Implemented Template Columns for Custom Nested GridViews

• Worked on exporting reports to Excel from Gridviews and Ultrawebgrids.
• Offshore SPOC
• Attending daily scrum meetings with Scrum Master and Product Owner.
• Web page analysis for dividing into levels and components
• Writing Template Building Blocks for the new pages
• Issues related to content mismatch and customization
• Components and page creation
• Unit testing and Automation testing
• Making sure the published pages have passed the automation testing.

Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks

• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Working in data analysis & data cleansing.
• Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C# and vb.
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
• In production support (L2 and L3) in rotational shifts for all the application that has been gone live from the team while continue development for new projects

Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 usingSSIS/DTS, and exe applications.

It’s a Production Support and enhancement Project.There are many applications with UI as c# and Winforms and backend of oracle and sql.There are Tidal jobs and reports those are in SSIS and SSRS.Most of the Jobs are ETL process where as applications are used to create and update claims.

• Get requirement from client and created HLD/ LLD for the same, get it approved and start working on the same.
• PL/SQL, SQL, Database Design (both Physical and Logical), Data Exports & Imports, Performance Tuning, Administration, Software Maintenance, User & Security Management, Query Optimization, Export/Import Utilities

• Giving L2 and L3 production support for claims team.

• Development of EXE application for claims processing usingc# and web services.

• Using MVC architecture for front end design of application and supporting the same for production live.