Jitendra Rajput Email & Phone Number

Pittsburgh, Pa, Us

Pittsburgh, Pa, Us

New York, Ny, Us

Client Name :- Deloitte - State of Tenneessee • Writing complex functions, Packages and procedures in SQL/Pl-SQL.• Designing the technical and functional specific document.• Troubleshoot and resolve client data issues in test and UAT environment.• Design, implement, and maintain new and existing database objects including tables, indexes, constraints, stored procedures, and user-defined functions in support of data conversion utilities and projects. • Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans and Trace Sessions.• Worked on profiling and tracing PL/SQL program to analyze the execution of program in order to enhance performance of program.• Getting requirements for the mapping sheet from Business and preparing mapping and rules for Data Migration.• Involved in developing SQL *Loader scripts for data loading.• Prepare and Execute the Unit test - cases based on the Technical Design document (TD). • Identify the exact changes to be made in the script/data (do Root Cause Analysis wherever required) and implementing them following the standards set for making changes and promoting them to Live environment with accurate testing.• Deploy the changes to live environment after approvals from authorized personnel

Troy, Michigan, Us

Client Name :- State Street, Boston, MA, USAState Street’s AIS offers fund services through International Fund Services (IFS), a State Street company. The objective of State Street's AIS is migration the Data stage jobs from Sybase to Oracle. The objective is migration Investran Data Integration (MIFA) into Private Equity Data Warehouse (PED). Once the PED Data warehouse is migrated using Data stage, Private Edge Data Integration is migrated into Private Equity Data Warehouse (PED) using Data stage. AIS Involved in validation of the Private Edge Data that will be integrated into PED.Responsibilities:• Involved in developing SQL *Loader scripts for data loading.• Writing complex functions, Packages and procedures in SQL/Pl-SQL.• Designing the technical and functional specific document.• Troubleshoot and resolve client data issues in test and UAT environment.• Design, implement, and maintain new and existing database objects including tables, indexes, constraints, stored procedures, and user-defined functions in support of data conversion utilities and projects. • Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans and Trace Sessions.• Worked on profiling and tracing PL/SQL program to analyze the execution of program in order to enhance performance of program.• Getting requirements for the mapping sheet from Business and preparing mapping and rules for Data Migration.• Prepare and Execute the Unit test - cases based on the Technical Design document (TD). • Identify the exact changes to be made in the script/data (do Root Cause Analysis wherever required) and implementing them following the standards set for making changes and promoting them to Live environment with accurate testing.• Deploy the changes to live environment after approvals from authorized personnel

Troy, Michigan, Us

Client Name : CDPHP, Albany, NY, USACDPHP private marketplace – where brokers, employees and employees and individual consumer can shop enroll, make premium payment and manage life events for medical and ancillary products. This will include all commercial market segments and product lines using phased in approach starting with small group and commercial individual markets. This initiative enables manual workflows to be automated creating significant efficiencies in business process for sales, Enrollment, billing and reconciliation.Responsibilities:• Implement new business features based on requirement specification / technical design• Fix bugs in existing applications reported by clients or internal testers• Execute development tests, create unit tests• Participate in creating internal business specifications, creating technical design for business features, breaking down features to technical tasks, workload estimation• Cooperate with colleagues in the development team / entire company• Deploy the changes to live environment after approvals from authorized personnel

Troy, Michigan, Us

Client Name : State Street Corporation, Boston, MA GPA data warehouse receive daily feeds and pricing from various external system. It does the computation for various performance and statistical information. This performance and statistical information is displayed through various reporting system, dashboard application. Daily feeds are also delivered to various clients as per the client SLA. GPA receives data from various sources including market data. The data is stored in a data warehouse and is used to produce dynamic reports.Responsibilities:• Created Stored Program Units like Functions, Triggers and procedures for implementing complex database intensive business rules.• Used features like bulk collect to process large amount of data in data base.• Improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL.• Developed Unix Shell Scripts to automate backend jobs, loading data into the database using SQL* Loader.• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning. • Interacted with client to gather the requirements and implement the same in the project.• Understand / Review the Functional Design document (FD) and prepare the Technical Design document (TD). • Prepare and Execute the Unit test - cases based on the Technical Design document (TD). • Attending daily customer call for current status and plan for new work.• Deploy the changes to live environment after approvals from authorized personnel

Troy, Michigan, Us

Client Name : Allstate Insurance Company, Northbrook, ILIt is an Insurance management System. There are several applications like SCEPTOR, SRLINK, DATAMART etc. in which client puts their day to day transactions like new Policy, Claims, Settlements & etc. They are processed under one roof called PROCEDE which is ceded engine. The system is designed in such a way that claims from Canada get processed in SCEPTOR application and rest all are processed in PROCEDE. SCEPTOR application maintains all the historical claim and policy data of NESCO & PAFCO; to process direct transactions on a daily basis. The statistical and financial information is utilized by the Accounting Department for analysis and reporting. The direct transactions are interfaced, where applicable, on a nightly basis to ceding system for accessioning to the reinsurance market.Responsibilities:• PL/SQL Development.• Worked on ad-hoc requests as well as enhancements if there are any.• Understand / Review the Functional Design document (FD) and prepare the Technical Design document (TD). • Prepare and Execute the Unit test - cases based on the Technical Design document (TD).

Mumbai, In

The aim of the project is to provide investor services using a centralized database for servicing Investors across any location and having a common system for any kind of fund which UTI has in existence or which it may launch in future.Repurchase is a process or a facility given to the investor which allows REDEEMING the Holdings. Investor can opt for partial or full redemption of the Holdings.Responsibilities:• Understand / Review the Functional Design document (FD) and prepare the Technical Design document (TD). • Develop the code as per the Technical Design document (TD) prepared.• Prepare and Execute the Unit test - cases based on the Technical Design document (TD).

Be, Computer Science

Computer Science