Primarily responsible for Data Architecture, Logical / Physical design for Data Warehouse,ETL design and loging process for Staging area and eventually for Datamart in MS SQL 2008 for all Care management related data from different system like FACETS, Care Advance Enterprise (CAE) for different health plans. Design and generated different retulatory and Internal reports,Extracts primarily on Care management for different health plans and vendors using Microsofts BI Stack of applicaion SSIS/SSRS, C# and .NET frameworka with optimal and high performance. Designed many different database objects and their performance tunningSQL,T-SQL, PL/SQL, c#. .NET Framework.

Database Design and Programming,Design ETL Process, configuration and data flow design for loading millions of log records daily in Staging and reporting environment in MS SQL and SSIS. Coded different Procedures and functoins feedding data for different SSRS reports based on log data analysis for different properties. Query optimization and performance tunning been part of all the process analyzing execution plan, dmv,index utilization and creation.

Data Migration from Mainframe to MS SQL for Retirement Plan, Database programming for generating different Reports on Retirement Plans and its automation.

Database Design, ETL, Database Programming, Windows Form Application Development on .NET technology wth C# for Product Optimization Process (POP) Meta Data Management system. The application is for overall metadata management of POP system from edit /update to generating different reports.