Now you can Instantly Chat with Satish!
About Me
Overall 14 years of IT experience out of which 9 years in data ware housing environment. Hands on experience Pentaho Data Integration8.2(kettle) 8 Years Hands on writing SQL Query tuning and optimization Involved in SQL Performance tuning to improve ...
Show MoreSkills
Portfolio Projects
Description
ODI, Pentaho Data Intigration 8.1, Oracle 12 c, postgresql 9.6
Project: e-Pragati is a new paradigm in governance based on a Whole-of-Government framework, transcending the departmental boundaries. It adopts a Mission-centric approach in its design and implementation and seeks to realize the Vision of Sunrise AP 2022, by delivering citizen-centric services in a coordinated, integrated efficient and equitable manner
Show More Show LessDescription
e-Pragati is a new paradigm in governance based on a Whole-of-Government framework, transcending the departmental boundaries. It adopts a Mission-centric approach in its design and implementation and seeks to realize the Vision of Sunrise AP 2022, by delivering citizen-centric services in a coordinated, integrated efficient and equitable manner
Show More Show LessDescription
Manuh solutions is a health care service system, which process the individual hospitals data and provides the business solutions. Manuh Solutions delivers high-quality, high-value IT solutions to healthcare customers. We excel in analyzing, problem solving and innovating and have a proven track record of customer satisfaction
Show More Show LessDescription
PennyMac Loan Services consists of three primary businesses:
Correspondent Lending: PennyMac acquires newly originated loans from small banks and independent originators. PennyMac is the largest non-bank correspondent lender in the United States and the 3rd largest overall according to Inside Mortgage Finance.
Retail Lending: The retail lending business originates new prime credit quality, first-lien residential conventional and government-insured mortgage loans on a national basis to allow customers to purchase or refinance their homes.
Loan Servicing: The loan servicing business performs loan administration, collection and default activities, including the collection and remittance of loan payments; response to customer inquiries; accounting for principal and interest; holding custodial (impound) funds for the payment of property taxes and insurance premiums; counseling delinquent mortgagors; and supervising foreclosures and property dispositions. PennyMac provides prime servicing for conventional and government-insured loans, as well as special servicing for distressed loans that have been acquired as investments.
Show More Show LessDescription
NextGen is a credit bureau product of the client Experian, GVAP is the data warehouse. GVAP application extracts data from source schema/files validate the records files will be processed loaded into staging tables. Fact tables will get filled from the staging tables.
Show More Show LessDescription
NextGen is a credit bureau product of the client Experian, GVAP is the data warehouse. GVAP application extracts data from source schema/files validate the records files will be processed loaded into staging tables. Fact tables will get filled from the staging tables.
Show More Show LessDescription
This application takes multiple customers information and compares the data based on the location/region, city based on the SKU category, which will be useful to give the customer status among the customers. This application reads the data from various sources of data to fill the data mart using Star schema.
Show More Show LessDescription
This application provides channel visibility and location services to companies that sell through complex channel partner networks. Channel Insight, gives companies rich, timely and actionable data on channel sales, including enhanced market intelligence on partners and end customers. Managing the master data and the transaction data, in such a way that data can be fit in data ware house and the reports.
Show More Show LessDescription
This application provides channel visibility and location services to companies that sell through complex channel partner networks. Channel Insight, gives companies rich, timely and actionable data on channel sales, including enhanced market intelligence on partners and end customers. Managing the master data and the transaction data, in such a way that data can be fit in data ware house and the reports.
Show More Show LessDescription
PHH Mortgage (previously known as Cendant Mortgage) is 6th largest retail mortgage loan originator in the U.S.A. PHH Mortgage is a full service lender and a leader in relationship-driven mortgage banking, serving real estate brokers, affinity groups, credit unions, financial institutions, corporations and government agencies. External interface deals with writing the procedures to generate flat files for various banks for reporting purpose. Additional interfaces deal with the movement of data between different interfaces i.e. databases for the processing of loan for the levels of secondary marketing, funding and closing of the loans. There are 16 interfaces for this purpose, which have to be maintained or enhanced as per the requirements of the client.
Show More Show LessDescription
The Wireless Terminal Business Unit (WTBU) of Kirloskar needs a Portal for maintaining the data of the WTBU group employees. The People Portal is developed to assist them to organize, manipulate and report the data of an individual employee. Based on the activities of an employee, the People Portal has got around 15 modules namely Projects, Assets, Competencies, Balance Score Card, Travel Log, Recognition, Publications, Patents and Reports. The application is also well separated by providing different levels of access to the respective employee based on the organizational hierarchy.
Show More Show Less