Having 17+ years of experience in designing & developing enterprise applications in Microsoft Visual Studio Environment & SQL Server.
Proficiency in developing Queries, Stored procedures in SQL Server.
Experience in all stage of Software Development Life Cycle using OOAD.
Extensive experience in Building and Delivering BI solutions using Microsoft technologies such as SQL Server integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
Experience in creating Migration Specifications and Data-Mapping spreadsheets and developing complex T-SQL scripts to Transform various relational Database into SQL Server.
Hands on expertise in Crystal Reports and Microsoft CRM SDK.
Experience in application development using LeadTools Medical Image Management tools.
Experience developing applications for various interface engine using HL7 Specifications.
Specialties (Database Development):
- Data Modeling
- Data Conversion
- Tuning & Optimization of Databases
- Indexes
- Transact – SQL
Specialties(Application Development):-.Net Framework 4.0, C#, Silverlight 4.0, MEF, MVVM, TSQL, VB, ADO, VBScript, Java Script, WCF RIA, LeadTools Image Managment Tools, Symphonia HL7 Engine, Microsoft CRM SDK
Interface Developer/Database Developer @ - Developing custom features for Ultrasound Reporting & Image Management solution.
- Creating Migration Specifications and Data-Mapping spreadsheets and developing complex T-SQL scripts to Transform various relational Database into SQL Server.
- Building and Delivering BI solutions using Microsoft technologies such as SQL Server integration Services (SSIS) and SQL Server Analysis Services (SSAS).
- Analyzing and reviewing the application to increase operational efficiency by creating and maintaining Indexes, Performance Tuning and Optimization of Databases.
- Developing applications for various interface engines using HL7 Specifications.
- Customizing Microsoft CRM for company needs using CRM SDK.
- Developing applications for transferring medical images to and from PACS servers using Lead Tools Medical Imaging Suit. From November 2007 to Present (8 years 2 months) Software Architect/Founder @ Involved in Design and Development process of Customized Enterprise Resource Planning and Order Processing Software for Textile Industries. From 1998 to 2007 (9 years) IT Consultant @ Developed Order Management Application for Export Division in Visual Basic 6.0.
Developed Central Excise Duty Documentation Application for Export Division.
Developed a budgeting tool with Excel VBA for Finance Department. From 2005 to 2006 (1 year)
HDSE, Software Eng. @ ACE India From 1995 to 1998 MMHS Santosh Rana is skilled in: Silverlight, Visual Studio, C#, JavaScript, .NET, WCF, XML, SQL Server, T-SQL, Application Development, Visual Basic, SQL, MySQL, Software Development, LINQ