Deloitte Consultancy January 2015 - October 2015Client: 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.
• 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.
Vserv Business Solutions July 2011 - December 2014Client2: 4Medica, US
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.
•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.
Collabera April 2010 - October 2010Client: 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
•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.
Polaris Software Labs Ltd August 2008 - September 2009Client: 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).
•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.
As a complete SDLC, project covers all phases till Sign Off.
Hexaware Technologies May 2006 - July 2008Client:CitiBank,Germany
Project:EBS Migration Platform:Oracle10g,UNIX,DB2,MQC
Key-Responsibilities:Preparation of TestScenarios/TestCases/DataAnalysis/Testing of migrated data/Logging Defects
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
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
Reliance Infosolutions March 2005 - May 2006Client:Reliance Infocom
Project:Calling Card App Platform:Oracle10g, UNIX,VSS
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
•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
Vaman Technologies February 2003 - January 2005Client:Internal
Project:ODBC Driver/Compatibility Setting of D2K/PL-SQL with Vaman DB
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
•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
CMC Ltd April 2001 - January 2003Client:Oil & Natural Gas Commission (ONGC)
Project:Integrated Material Management Systems (IMMS)
Platform: Oracle 7.3/8i, UNIX & D2K
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
•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
As a complete SDLC project covers Information Gathering, Detailed Technical Specification (DTS), Coding, Testing, Bug Fixing, and Implementation of code and Sign Off.
1993 - at Present (24 years) Kurukshetra - Haryāna