Prakher Bhargava

 Prakher Bhargava-- SUMMARY Overall experience of 5.8 years with organizations, including TCS, Fidelity international. Worked as the software engineer for Tata Consultancy services (Mar2015-Jul2017), as the Program Analyst(Aug2017-Program Analyst), on diverse variety of innovative projects. Employment Analyst Programmer Fidelity International Aug2017 – Present Promoted to Lead Billing application for decommission Old System developed on Sybase and Migrated into new system which work on Oracle database and Vermillion to create report based on Functional Billing Model .Implement Sybase procedure and rewrite into oracle procedure ,automate old manual scenario to generate funds invoice based on assets, shares, bonds, equity Worked on development projects that were based on Data Virtualization concepts and creating web services in Denodo. Good experience in RDBMS, PL/SQL, TOAD,DENODO - Data Virtualization. Developed Data Model by Data Virtualization techniques using Denodo 6.0 by connecting to multiple data sources such as Oracle etc. Created Base Views, Derived Views, Joins, Unions, Projection, Selection, Union, Minus, Flatten Views, Interface and associations of data service layers in Denodo. Created Data Models by extracting the data from various data sources by connecting through JDBC, ODBC. Doing POC for migration of Denodo 6.0 to Denodo Express 7.0 and solved many challenges and provided suggestion to Denodo Vendor for future enhancements. Assistant System Engineer Tata Consultancy Services March2015 – Jul2017 Training: Trained on Oracle database, Informatica 9.6.1(Location –Trivandrum ). Projects: Client : CITI BANK(Gurgaon)-Implement and developed PL/SQL procedure , Developing Relational, OLAP, Optimizing SQL query, PL/SQL procedure performance, Designing and creating mapping, workflow, session using INFORMATICA 9.6.1 PowerCenter to migrate data. Client :Ceridian(Lucknow)- Developing and created SCD 1,SCD 2 type mapping, workflow to migrate the data source to target using Informatica 9.6.1, Creating report on employee level data ,give access to employee to view. report at front end . Managing leave related data for all TCS employees across the world including casual leave, pay without leave, Earned leave etc. Grant and remove administration right to employee at report level. Education BBDNIIT,lucknow University of Uttar Pradesh Sep 2010 – May 2014 B.E in Computer Science and Engineering May 2014. Grades: 75%. Schooling from minor in Science Stream May 2009. Grades: 71%. Engineering Coursework: Software Foundations; Computer Architecture; Algorithms; Artificial Intelligence; Comparison of Learning Algorithms; Computational Theory. Schooling Coursework: Programming Languages- C language; Physics; Chemistry; Math’s . Technical Experience Projects DATA VIRTUALIZATION : Integrated different platform data by creating different Base views, Derived views and data sources and based on different criteria determines the best query execution plan to deliver the optimal performance, considering data source statistics and indexes, as well as the special characteristics of data sources, to provide blazingly fast access to data to end users FUNDS BILLING: Worked on and understand the financial terms like assets,diiferent fund,bonds ,based on that generate the new billing system which is in optimized form and perform calculation based on funds purchased by customer . CITIBANK-CMS Module : The project requires flow of Customer Data between various modules, data processing and reverse flow of data to the database. It consists of different modules to capture and store the customer information. Additional Experience ,Awards,Certificates Assistant Engineer (JUL2014 – JAN2015): Working in Qspear Consultancy Services (Noida) as partime employee. Working on developing Plsql Stored Procedure,Trigger,Function,etc. Implement and get trained in Oracle Apps module GL (Basic).Work on client location as OracleApps-PL/SQL developer (Client –AmarUjala & Uflex Noida), On spot Award: In Fidelity For making new Billing application by decommission Old System, automate and optimized in new way . Certificate: Oracle certified Associate in database PLSQL (JUL-2017) Languages and Technologies C; PL/SQL; SQL; Data virtualization, DatawareHousing, OLAP Toad, SQL developer,Denodo,IBM Udeploy tool.