• Coordinating with functional team and business analysts to discuss on application flows.
• Examine and identify database structural necessities by evaluating operations, applications
• Design and implement effective database solutions and models to store and retrieve Project data.
• Prepare accurate database design and architecture reports for Leadership and executive teams.
• Educate team members through training and individual support.

Deloitte NextGen Project Estimator is a web application which is being used by leadership and senior managers to estimate projects lifecycle

• Model staging and pre-sync tables
• Perform data cleansing and consolidation activities on the staged data
• Integrate source to destination mapping in the packages based on the BRD
• Created data workflow patterns for both full and delta loads.
• Unit test the workflows on the DEV and provide support for QA and UAT phases

Altus offers comprehensive receivables management services, as well as a powerful infrastructure, sound business ethics and strong investigative capabilities

• Assess BRD and provide estimation on the tasks to deliver.
• Design the SSIS framework for extracting data from multiple source like (csv, xml, Oracle, SQL Server).
• Create complex stored procedures to load data in to Dimensions and Fact tables in Data mart.
• Manage all indexing, debugging, optimization and performance tuning using T-SQL.
• Deploy and configure the SSIS flows in to various servers and documenting the process.
• Schedule the SSIS packages and stored procedures to perform delta load in Dimension and fact tables by creating a Job using SQL Agent in SSMS.

AmeriHealth Administrators has built its reputation on providing nimble, collaborative approaches to health and benefits services. Through state-of-the-art technology and a world-class customer experience, we enable flexibility and support strategic initiatives that help our customers meet the demands of next generation health care.

• Gathering all requirements from Business Analysts and documented entire process of Data Flow and Data Analysis process from all the source systems.
• Created SQL server objects like Tables, Stored Procedure, Views, and Indexes to facilitate efficient data manipulation and data consistency.
• Managed all indexing, debugging, optimization and performance tuning using T-SQL.
• Created SSIS Packages to transfer data from various Sources like SQL Server, Text File, and Excel using SSDT 2012/2014.
• Created Centralized Data Mart and developed De-Normalized Structure based on requirement.
• Created ETL design Specifications, Performed Unit Testing, Data Validation and Integration testing.
• Worked with various transformations like Lookup, Fuzz Lookup, Merge, Sort, Multicast, Conditional Split, Loop Containers, Execute SQL Task and lot more using SSIS.
• Deploying SSIS Packages On respective Server and effectively using configuration files.
• Created custom loggings and package configurations to change connection strings and variables dynamically. Used all types of Containers in SSIS.
• Designed, processed and partitioned cubes using SSAS. Pleasant experience in designing aggregations and Calculations. Experience in deploying SSAS objects using deployment wizard.
• Created and maintained Measures, Actions, KPI's, Perspectives and MDX Queries.
• Adding new dimensions, Calculating members, roles and KPI's to existing Cubes.
• Created Windows Schedule tasks to run SSIS Packages on different time intervals by using Power Shell Scripts.
• Involved in fixing Bugs in the Data Mart and ETL.
• Involved in documenting the project steps and presenting to the team members.

MSESDAX is a Microsoft intelligence project that deals with various kinds of business data like HR, Vendor, Accounts, Inventory, Purchase, Store Information and Taxation.

A HRMS (Human Resource Management System) is a combination of systems and processes that connect human resource management and information technology through HR software. Its helps customers to automation of repetitive and time-consuming tasks associated with human resources management frees up some of the companies most valuable employees and allows the focus to shift to culture, retention, and other highly impactful areas.

YES, BANK is Indias fourth largest private sector bank, founded in 2004. It is the only Greenfield Bank license awarded by the RBI in the last two decades. YES, BANK is a Full Service Commercial Bank, and has steadily built a Corporate, Retail & SME Banking franchise, Financial Markets, Investment Banking, Corporate Finance, and Wealth Management business lines across the country.