Tushar Agarwal Email & Phone Number

Gurugram, Haryana, India

Gurugram, Haryana, India

Gurgaon, Haryana

 Analyze, understand the business requirement and create the draft for development Environment (including Oracle 10g and solaris OS). Analyze the required functionality in Application module and Effort Estimation. Create the Technical Specification document and Unit Testing Strategies. Create the code draft for the development and Enhancement. PLSQL Development in ORACLE 10G/11G. i.e. creating Packages, Stored Procedures, Views, Materialized Views, Triggers, Cursors, Collections etc. as per the business requirements. Creating and Scheduling Unix Batch using UNIX Shell scripting and Autosys which would run overnight and produce various feeds/reports to be sent to various users (via email) and various systems (For reconciliation). Using SQL Loader Utility for loading external files from upstream systems for further reconciliation. Also automate the whole process via overnight batch. Create & Manage Topology, Models and Mappings in ODI 11 G. Enhancing and designing the Star Schema and Data Marts in Oracle DWH. Designing the OBIEE 11G RPD as per the Business Requirements. Created business reports using OBIEE 11G “Answers” as per the business requirements. Create Task/Sub-Tasks in Jira Tool as per Agile Methodology. Debug the database related issues pertaining to partitioning, expdp/impdp, data file size etc. Worked on migration projects and regulatory projects of Financial services compensation scheme for Financial Security Agency, UK and Anti Money Laundering (Actimize). Part of Process improvement methodology team.

- A Techno-functional role, which requires complete interaction with business users (middle office and back-office users).- Handling user's queries, handling EOD and EOM activities.- Subject Matter Expert of some middle office and back-office applications. - Analysing and investigating the code of the application if the business user reports any problem in any business application and then after finding the root cause, proposing the code fix to raise a defect in the application.- The analysis or investigation is expected to be done on both front end and back end and code fix can be anywhere. Hence, need to understand the full architecture of the application. -Creation and modification of stored procedure, functions, etc in Sybase and Oracle (PL/SQL) database as per business’s requirements.-Supporting end of day and end of month tasks.

Database Programmer, Generating and automating reports for business users using PERL scripts, Scheduling jobs using Autosys, making Unix shell scripts.

Database Programming, providing interface for telecom billing for the customers using PHP, supporting various telecome(VOIP) based services, the customers of which are directly the end-users all over the world.

B.Tech, Information Technology, Ist Grade

Xii, Science