Software Engineer
Orion India System Pvt. Ltd
Total years of experience :11 years, 0 Months
OLAP DB design and management(De Normalized tables)
Good in metadata management and design
Migration of codes from Legacy to Reengineering standards
Basic knowledge in SAP
Daily interaction with client for requirement gathering and status updates
Creating table indexes that optimize query speeds
Optimizing any existing queries to speed up performance using SQL profiler and execution plan.
Storage management using file groups
Working with VSTS and git services.
Sound Experience and understanding of SSAS, OLAP cube and Architecture.
Expert in creating Star schema cubes using SSAS.
Extensively worked on OLAP cubes using SSAS.
Created and Managed OLAP Cubes using SSAS.
Identified the dimension, fact tables and designed the data warehouse using star schema.
Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
OLTP DB design and management(Normalized tables)
Experience in creating, maintaining and tuning stored procedures, User defined functions, Triggers and Views.
Experience in configuring linked servers for data access between new and old servers.
Created clustered and Non-clustered indices on tables, views and columns.
Involved database back up and restoration.
Experience in trouble shooting dead lock and optimizing database objects.
Experience in designing all the DB objects for a financial project and an inventory module for hospital project.
Manages all the modules associated with Accounts, inventory and payroll.
Creating and designing tables when new modules are added to a software product
Creating database jobs for automation (Automatic Patient Discharge)
Writing queries used for front-end applications
Determining what data must be returned to the application and writing queries for it
Creating database replication for report generation and performance improvement of transactional DB
Implemented automatic daily voucher posting and automatic financial year end process.
Application Support for Hospital Domain