Developer Data
Resume:
NIKHIL AGRAWAL
AROUND * YEARS OF EXPERIENCE AS A ORACLE PL/SQL DEVELOPER& ETL DEVELOPER (IBM DATASTAGE)
+91-889*******(altr)
adbrnw@r.postjobfree.com
Objective:
To secure a position within a company where I can involve myself in all aspects of designing, developing, implementing, documenting and maintenance of application software. I would like to work and grow in an environment, where performance is rewarded with new responsibilities.
B.Techin Computer Science and Engineering fromBiju Pattnaik University of Technology,Odishawith 67.4%
12th from Modern Public School, Balasore under C.B.S.E with 63.8%
10th from Modern Public School, Balasore under C.B.S.E with 72.4%
Technical Skills:
Oracle PL/SQL,SQL, Oracle 10g & Above, ETL Datastage,
Programming :
Languages
Oracle PL/SQL, SQL
Web Technology :
HTML
Database :
Oracle 10g& Above
Platforms Used :
SQL Developer, IBM Infosphere, Unix
Professional Experience:
Duration :22 Months
Organization : IBM India Pvt. Ltd(Under the Payroll of DYNPRO India Pvt. Ltd.)
Date of joining : March-2016 – Till Date
Designation : Application Developer
Client : AT & T
Job Profile : PL/SQL developer
: Creating SQL scripts for upgrading the database, Analyzing Procedure, functions, Triggers, Database Objects from database dump. Preparing Migration Advice and Migration Plan, Supporting Onsite Members Running client’s validation script.
1. 1 Global Computing Platform, AT & T
About AT & T
AT&T Inc. is an American multinational telecommunications corporation, headquartered at Whitacre Tower in downtown Dallas, Texas. AT&T is the second largest provider of mobile telephone and the largest provider of fixed telephone in the United States, and provides broadband subscription television services. AT&T is the third-largest company in Texas (the largest non-oil company, behind only ExxonMobil and ConocoPhillips, and the largest Dallas company). As of May 2014, AT&T is the 23rd-largest company in the world as measured by a composite of revenues, profits, assets and market value, and the 16th-largest non-oil company.
Application Description
Bvoip to GDB Load:The Golden Database (GDB) on GCP will be extended and linked to the GCP BVOIP CSI for “BVOIP IP-Flex” service-type data.
This will be a DBOR (DataBaseof Record) for data objects like Assets, Services, Sites, Organizations and Contacts and their associations among each other.
The database will contain read-only representations of data object anchor points using the GCP Enterprise Key Translation. The actual data objects are maintained in other DBORs. GCP will maintain the representing anchor points across the maintaining DBORs.
The database will be mission critical for C-BUS in respect to Contact objects and associations and for eStrategy applications in respect to all objects and associations.
Technologies Used:
Languages Used:Oracle 12c PL/SQL, SQL
Environment: Oracle 12c, SQL Developer
Operating System:Windows 7/8
Roles and Responsibilities in this project:
Single point of contact for coordinating across multiple teams such as system testing team, DBA, Source Team and other cross application teams.
Requirement and information gathering
Analyzing SQL / PL-SQL Programs, Oracle Stored Procedures Creation, etc.
Involved in all aspects of designing, requirement analysis, business model to be implemented and developing components data migration and conversion.
Developed complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
Developed Procedures for transferring data from one schema to another schema.
Creating PL/SQL Packages, Procedures and Functions for data population and updating as per project requirements.
Working as an offshore developer to successfully meet the required deadlines and functionality as per mentioned in the requirement document for the respective components
Performance impact analysis.
1.2 GCP- Transformation (GCP- AT &T)
Project Abstract
This feature is intended to transform the data from all the GCP API’sthat is being transformed to its respective CSI API’s. EachAPI will be transformed from each CSI API for AT&T. This transformed code is first encoded and then decoded as per its required business logic.To support the GCP Trans project, API’s will pass the request to its transformed GCP API’s. This API’s contains the global data.
Technologies Used:
Languages Used:Oracle 12c PL/SQL, SQL
Environment: Oracle 12c, SQL Developer
Defects/Bugs : HP-ALM
Operating System:Windows 7/8
Roles and Responsibilities in this project:
Single point of contact for coordinating across multiple teams such as system testing team, DBA, Source Team and other cross application teams.
Requirement and information gathering
Analyzing SQL / PL-SQL Programs, Oracle Stored Procedures Creation, etc.
Analyzing the defects and fixing it and provide the proper RC.
Developed complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
Developed Procedures for transferring data from one schema to another schema.
Creating PL/SQL Packages, Procedures and Functions for data population and updating as per project requirements.
Working as an offshore developer to successfully meet the required deadlines and functionality as per mentioned in the requirement document for the respective components
Performance impact analysis.
1.3Sidbor Source File to SMX Schema Load(GCP- AT &T)
Project Abstract
This feature is intended to pull the data required from all 4 instances of Service Manager into SIDBOR, to facilitate population of AOTS tickets. One file will be delivered from each Service Manager instance for AT&T VPN Gateway (VD1) data and one file will be delivered from each Service Manager instance for Cisco (VD4) data for a total of 8 AT&T VPN Gateway/Cisco files.
To support PB288 VDNASB (Voice Dynamic Network Application for Small Business) project, Service Manager will provide another file which contains EdgeMarc device data. This file is from the US only.To support the ANIRA project, Service Manager will provide an ANIRA file, with two record types for the VIG Connection and the VIG Pool Data. This file contains the global data. It will also provide a tunnel file, a user ID, and a routing file from all the geographies. The file which contains the global data for the routing data is new.This feature is expected to populate AVTS tickets with as much data that the inventory system(s) offers in existing fields.
Technologies Used:
Language : SQL, Datastage, Unix Shell Scripting
Software : Oracle 12c,Sql Developer,ETL (IBM Infosphere& DataStage Designer).
Environment : Unix, Windows 7
Roles and Responsibilities in this project:
•Understanding the requirements from the client’s perspective as per the business requirements and to design, develop and testing the DataStage code and Shell scripts.
•Responsible for getting source data from the upstream application in the form of files and using them to load data into the GCP tables(SMX) or create files based on the requirement using the ETL logic and provide data to the downstream applications.
•Single point of contact for coordinating across multiple teams such as system testing team, DBA, Source Team and other cross application teams.
Duration : 13Months
Organization : Cheerz Labs
Date of joining : December-2014 – Feb -2016
Designation : Oracle Developer
Client : ING
Job Profile : SQL and PL-SQL Developer
: Creating SQL scripts for upgrading the database, Analyzing Procedure, functions, Triggers, Database Objects from database dump. Preparing Migration Advice and Migration Plan, Supporting Onsite Members Running client’s validation script.
2. 1 Oracle Application Migration, RBS Bank
Project Abstract
RBS is one of the world's largest financial services companies, offering banking, insurance and asset management in over 50 countries. ING has a plan to migrate the existing Oracle legacy servers to Oracle 10g Server. The existing servers would be decommissioned after the successful migration to latest infrastructure. This migration is needed to integrate with the third-party software’s used by RBS and fit the new business process requirements. Along with that this migration will help RBS to extend the IT platform from the legacy version to the new and latest versions.
Migration of two applications (FLOWER-POEH and Afrecon) is considered in 6th Trance Application Migration Project.
Application Description
Flower POEHapplication handles supplier creation and maintenance for RBS bank internal supplier. It is advised to migrate Flower POEH application from Oracle 8.1.6 to Oracle 10g version. After the successful migration of all the database objects and the data the legacy servers will be removed. There is no further support of the legacy system and all the support for the client will be provided in the latest version.
Afreconapplication handles supplier invoice and payment records for RBS bank internal supplier. It is advised to migrate Afrecon application from Oracle 8.1.6 to Oracle 10g version. After the successful migration of all the database objects and the data the legacy servers will be removed. There is no further support of the legacy system and all the support for the client will be provided in the latest version.
Technologies Used:
Languages Used:Oracle 10g PL/SQL, SQL
Environment: Oracle 9i, Toad, Visual Source Safe, Relativity Tool. Operating System: Windows 7/8
Roles and Responsibilities in this project:
Team Member for 6th Trance Migration.
Requirement and information gathering
Performed basic DBA activities like export/ Import, create / alter synonyms, Index creation, grant permission etc.
Analyzing SQL / PL-SQL Programs, Oracle Stored Procedures Creation, etc.
Involved in all aspects of designing, requirement analysis, business model to be implemented and developing components data migration and conversion.
Strong SQL and PL/SQL programming skills. Proficient in writing stored procedures, packages and triggers.
Working as a offshore developer to successfully meet the required deadlines and functionality as per mentioned in the requirement document for the respective components
Performance impact analysis.
2.2 CMDB Data Enrichment, RBS Bank
Project Abstract
RBS has invited Cognizant to participate in the CMDB program that HP is offering to RBS. Specifically, MegnaSoft would be involved in activities for identifying Business Processes and mapping them to Applications, Detailed Analysis of Source and Target database and Data Enrichment.
MegnaSoft and HP is be acting as one team towards RBS and aim to deliver value to RBS throughout the process.
Detailed Description
Data is required to be consolidated and migrated from 22 data sources to the target Service Centre database. Megnasoft is involved in analysis of 12 databases (IRMA, IBAL, INFRA SC, IFSA, ARS, Applix, Web Portal, Chain DB, ECCC, BCDR, WMP, ARIS) and 8 excel spreadsheets (Step Stone, LeRAIX, One Touch).
Megnasoft is responsible for identifying Business Processes, consolidate the date, Correct the data and mapping them to Application.
Technologies Used:
Language : PL/SQL, JSP, SQL, Visual Basic.
Software : Oracle 9i, Eclipse, Microsoft Excel.
Environment : Windows-XP
Roles and Responsibilities in this project:
•Analyzing the data from the different sources and identifying the architectural gap in the tables, views and other database objects (likepackages, procedures).
•Getting the correct data from different sources and make the consolidate data which will be mapped with the user application.
•Creation the migration scripts which will have all the correct data from the different sources and will be moving to the target database.
•Working directly with the users to get the missing information.
•Performance impact analysis for the respective data sources.
Strengths:
Dynamic and Confident in approach, Willingness to learn, Team facilitator, Good coordination skills, Hardworking, Skills of effective management and utilization of time.
Personal Details:
Father’s Name :
Kishore Kumar Agrawal
Sex :
Male
Nationality :
Indian
Date of Birth :
07th September 1992
Contact Address :
Hemanth Nagar, Marathalli, Bangalore-560037
Declaration:
I hereby declare that all the above information given by me is true to the best of my knowledge.
Nikhil Agrawal
Contact this candidate