Experience

  • Senior Oracle Developer

    at Deloitte Consultancy

    January 2015 - October 2015

    Kuala Lumpur

    Client: 7Eleven, Malaysia Project: Data Migration Platform: Oracle10g, Toad, Unix Role: Sr. Oracle Developer Team Size: 5+ Description: The Project is divided into two phases. The first phase includes the implementation of GST feature in current system and Second phase is for Data Migration from current system to SAP using Oracle. Report generation (using Oracle SQL) for Data Matching and Data Analysis is also part of the project for project closure. Key Responsibilities: • Interaction with client for new requirement • Analysis of new requirements and Development using PL/SQL, SQL scripting writing and UNIX. • Writing SQL queries for Reporting and Data Analysis. • Prepare Test Scenarios/Test Cases/Test Data, Execution of test cases, Bug fixing and Data Matching with Client. • Reviews, preparing checklists and Process Documentation.

  • System Analyst

    at Vserv Business Solutions

    July 2011 - December 2014

    Gurgaon - Haryāna

    Client2: 4Medica, US Project: 4Medica Platform: Oracle 10g, PHP, WinCvs and SSRS Role: Technical Leader / QA Lead Description: 4medica is web-based Integrated Health Record (IHR), designed to create easy access to real-time, patient-centric, multi-organizational, multi modality clinical data from multiple inpatient & outpatient sources. Starting out as a lab outreach connectivity company, 4medica has expanded its offerings into an IHR that helps hospitals & physician practices leverage existing technology platforms to provide Clinical Integration with an easy to use & deploy application. Key Responsibilities: •Team Management, Client Interaction, Team Coordination. •Analysis of new requirement received form onsite team •Development using PL/SQL and SQL scripting writing •Prepare Test Scenarios/Test Cases/Test Data, Execution of test cases, Bug fixing and logging defects in bugzilla. •Reviews, preparing checklists and Process Documentation.

  • Team Leader

    at Collabera

    April 2010 - October 2010

    Mumbai - Mahārāshtra

    Client: JP Morgan Chase, UK Project: Global Liquidity Program (GLP) Platform: Oracle 10g, UNIX and Clear Case Designation/Role: Team Lead Team Size: 5+ Description: The ICD Spy provides two levels of feedback (i.e. ICD Spy Level 1 (File Format) & ICD Spy Level 2 (Staging Area Data Checks) for each file played into FDW. Each Level corresponds with completion of a key piece of processing in the overall FDW data Land & Load process. The detailed output from each ICD Spy Level is emailed to stakeholders Key Responsibilities: •Managing Team at Client site, Interaction with client Onsite Manager regarding new requirements •Analysis of new requirement received form onsite team •Development using PL/SQL and UNIX scripting writing •Review of code, bug fixing and Documentation.

  • Team Leader

    at Polaris Software Labs Ltd

    August 2008 - September 2009

    Gurgaon - Haryāna

    Client: RBS,UK Project:Group Risk Data Warehousing(GRDW) Platform: Oracle10g, UNIX & Clear Case Description:The GRDW Architecture Redesign has been initiated in order to meet the increase in data volumes from ABN AMRO integration. GRDW will be split into Core GRDW application & Historic Data Store (HDS). Key Responsibilities: •Managing Team & Interaction with Onsite client Manager regarding requirements •Analysis of requirement & preparation of DTS •Development using PL/SQL, UNIX SQL writing, global/local indexes, Materialized Views, Dynamic Query, Ref Cursors •Preparation of mock test environment,test scenarios,test cases,test data creation scripts, test data creation. •Analysis of Migrated Data & bug fixing •Execution of test cases,logging bugs in clear case. •Reviews at different stages,preparation of checklists & process documentation. Major Achievement: As a complete SDLC, project covers all phases till Sign Off.

  • System Analyst

    at Hexaware Technologies

    May 2006 - July 2008

    Mumbai - Mahārāshtra

    Client:CitiBank,Germany Project:EBS Migration Platform:Oracle10g,UNIX,DB2,MQC Role:TestLead Key-Responsibilities:Preparation of TestScenarios/TestCases/DataAnalysis/Testing of migrated data/Logging Defects -------------------- Client:Solera Inc,US Project:AUDATEX Platform:Oracle10g,PL/SQL,TeamTrack Role:Team Lead Key Responsibilities:Analysis of new req,Communication with client/Team/Delivery-Management, Development using PL-SQL/SQL/global-local indx/Materialized Views/Dynamic Qry/Ref Cur,Preparation of TestScenarios/TestCases,Reviews,Preparing doc/checklists/Testing/bugfixing --------------------- Client:AXA,Japan Project:AXA Platform:Oracle10g,PLL,D2K,VSS Role:Team Lead Key Responsibilities:Analysis of new req,Communication with client/Team/Delivery Management & Development using PL-SQL/SQL/global-local indx/Materialized Views/Dynamic Qry/Ref Cur.Preparation of TestScenarios/TestCases,Reviews,Preparing doc/checklists,Testing/bugfixing

  • Data Analyst

    at Reliance Infosolutions

    March 2005 - May 2006

    Mumbai - Mahārāshtra

    Client:Reliance Infocom Project:Calling Card App Platform:Oracle10g, UNIX,VSS Role:Data Analyst Description:Decision Support System (DSS) delivers vital info to Biz Users to make timely & accurate info for biz growth leading to effective/efficient operations to gain a competitive edge in market place to collect data from multiple sources, summarizes data for biz needs. Create standard,comprehensive & accurate view of biz op. as per biz req. DSS has divided OLAP rep into Billing/Outgoing/Incoming/NRI/Prepaid/Postpaid/Voice/SMS/Network Key Responsibilities: •Analysis of req/documentations •Writing ADHOC SQL to fetch data,predict future trends for making valuable & vital biz decisions by Higher Mgmt •Write PL/SQL blk to schedule jobs to fetch data on hdd,for ETL & BO Crystal Rep. •Reviews code/data & prepare chklist •Analyze Migrated Data into staging/prod tables •Communication with client/Team/Delivery Mgmt Major Achievement:Qry Performance Tuning & Data Analysis

  • Senior Software Develper

    at Vaman Technologies

    February 2003 - January 2005

    Mumbai - Mahārāshtra

    Client:Internal Project:ODBC Driver/Compatibility Setting of D2K/PL-SQL with Vaman DB Platform:Vaman DB,MS-Access,Oracle8i/9i,D2K Role:TeamLead Description: Vaman DB is a contemporary/independent DBMS solution consisting of Server integrated with DB.The server uses Finite State Machine model. Standard C is used as Programming language. To connect Vaman server with available frontend Vaman Develop ODBC/OLEDB drivers also. As by-Product 'Data Migration' tool is also developed,which transfer data from one DB to any other DB Key Responsibilities: •Analysis of Oracle Features in all version & documentation •Development using Vaman,C,PL/SQL,D2K •Review of code,bug fixing & Doc •Communication with client,Team & Delivery Mgmt •Preparation of TestScenarios,TestCases,TestData.Mock Applications for Testing •Execution of TestCases & reporting bug in VSS Major Achievement:Achieved desired goal of 100% compatibility of Vaman DB driver with other frontend like D2K, Ms-Access

  • Software Developer

    at CMC Ltd

    April 2001 - January 2003

    Mumbai - Mahārāshtra

    Client:Oil & Natural Gas Commission (ONGC) Project:Integrated Material Management Systems (IMMS) Platform: Oracle 7.3/8i, UNIX & D2K Role: Programmer Description: Objective is to develop IMMS to replace existing legacy system This application processes extensive inventory transactions daily and consists of about 350 forms and reports Key Responsibilities: •Analysis of new requirement and preparation of requirement document •Development using PL/SQL, D2K, writing, global/local indexes, Materialized Views, Dynamic Query, Ref Cursors •Review of code, bug fixing and Documentation •Managing Communication with client, Team and Delivery Management •Preparation of Test Scenarios and Test Cases •Analysis & Testing of migrated data Major Achievement: As a complete SDLC project covers Information Gathering, Detailed Technical Specification (DTS), Coding, Testing, Bug Fixing, and Implementation of code and Sign Off.

Education

  • BSc Computers

    at Kurukshetra

    1993 - at Present (25 years) Kurukshetra - Haryāna

  • Foundation Course in Data Science Using R

    at University of Austin

    2014 - 2015 (1 year)

  • MCA

    at Ahemdabad

    1998 - 2004 (6 years)

  • PGDPM

    at Kurukshetra

    1998 - 1999 (1 year) Kurukshetra - Haryāna

  • Certificate in Computing

    at Karnal

    1998 - 1998 (1 year)

Knowledge and keywords

Languages

  • English Conversation

  • Hindi Native

Followers (2)

Hives