Homepagina
Lessen geven
200€/u
Helaas is deze leraar onbeschikbaar. Onze excuses voor het ongemak.
Geverifieerd lerarenprofiel
Reactietijd 24u
Lessen aangeboden door Pankaj
  • In een groep
De lessen vinden plaats
  • Online (via webcam)
Onderwezen onderwerpen
  • Basis computervaardigheden
  • SQL
  • Oracle
  • Database
Niveaus
  • Alle niveaus

Professional Training online - Oracle PL/SQL, SQL, ETL, Informatica Power Center 9.5

Methodologie

Teaching methods is
- Online session, you can attend from anywhere
- Logical Practical explanation of every theoretical topics.
- Cover most advanced topics , only experienced in Industry during works time
- 100% live programming by screen sharing practical demo of every theoretical/Practical sessions
- Every day exercise review of previous session of first 15 minute

Ervaring

Having 12 year of experience in multiple Fortune 500 industries. As an experience you will find logical explanation of every theoritical topics with hands with practical examples. My specialization are is RDBMS, SQL, Oracle PLSQL, ETL, Datawarehousing, Informatica Power Center

- Handle multiple projects on Architect level
- worked as a Technical Lead

Tarieven

Tarief voor lessen via de webcam : 150€/u
Tarief voor 5 lesuren : 600€
Tarief voor 10 lesuren : 800€
Lessen aangeboden door Pankaj
In een groep
De lessen vinden plaats
webcam
Onderwezen onderwerpen
  • Basis computervaardigheden
  • SQL
  • Oracle
  • Database
Niveaus
  • Alle niveaus

Pankaj's achtergrond

+(Opgeslagen informatie)2 (Calling Number)
+91 (Opgeslagen informatie) (What'sapp Number)
(Opgeslagen informatie) (Hangout)

Experience Summary:
Technology Specialist with 11.10 years of experience in PL/SQL & Informatica 9.5 with extensive experience in design, development, integrated solutions. End to end handled multiple projects using various SQL/ETL tools like toad, SQL-developer, Pl/SQL developer and Informatica.
• Experienced of Informatica designing maplets, mapping, user-defined functions under Repository and many more...
• Domain knowledge of Insurance and Life-Science.
• Knowledge of .Net as secondary skills.
• Implementing Pl/Sql best practices, and multiple times awarded for best practice in COGNIZANT.
• Proposing solutions and mitigation strategies for known technical gaps and risks.
• Good hands on experience in developing SQL and PL/SQL queries.
• Fair understanding of ETL processes.
• Handled Client interactions right from Requirement Gathering to Solution Demonstrations and User Training.
• Working knowledge of different- different clients like KOTAK LIFE INSURANCE, DLF-PRAMERICA, MNYL, CITI-FINANCIAL, SEDGWICK, ASTRA-ZENSA.

Employment History

• NiiT Technologies Ltd- From 10 Jun 2016– Till Date.
Duties/Responsibilities are as Technology Specialist.

- Involve in feature grooming at the beginning of PSI.
- Understanding of FRAS from client and playback to team.
- Technical coordination with team
- End to End Delivery Responsibilities.

• JK Technosoft, Noida - From 17th November 2014 – 8 Jun 2016.
Duties/Responsibilitiesare asSystem Analyst
- IT Application Development
- Maintenance, Support& Requirement Gathering

• Cognizant Technology Solutions India Pvt. ltd. Gurgaon - From 14thMar 2011 – 14thNov 2014.

Duties/Responsibilities as Senior Software Developer:
- IT Application Development
- Maintenance, Support& Requirement Gathering
- Performance Tuning

• Qualtech Consultants Pvt. Ltd, Noida - From 6th Dec 2006 – 10thMar 2011.

Duties/Responsibilities as Engineering Analyst – L2:
- IT Application Development
- Maintenance & Requirement Gathering


Currently Location : Netherlands

Visa Status:
• B1 (USA) valid till 2025
• Work permit – Netherland for 1 year valid till 10-Jun-2019


Academic/Professional Qualifications:
• MCA (Master of Computer Applications) from IGNOU in Dec-2005 with 65%.
• CIC (Certificate in Computing)from IGNOU in Jul-2002 with 72%.
• B.Sc. (Computer Science) from Dr. B. R. Ambedkar University, Agra with 55%.


Skills Exp. in Months Skills Exp. in Months
Languages Operating Systems
PL/SQL 120 Windows 108
Linux 6
Software Tools ETL
Toad 50 Informatica 9.5 60
Pl/Sql Developer 60 Domain
Databases Life Science 43
Oracle 11g, 10g, 9i 110 Insurance 50


Experience Details (Reverse Chronological Order):

NiiT Technology Ltd, G. Noida 02nd Apr 2018 – Till Date
Netherlands Duration-Technology Specialist

NNIP is an investment partner provide solution to different platform to various client like Institutional investors, retail service, individual investors, Advisors.

Responsibilities and Achievements:
• Worked as a Team Leader for 6 month, apart from my work, guiding and helping the team for quality and timely delivery of tasks given to them..
Technology Used: Oracle PL/SQL, Informatica Power Center 9.5,


NiiT Technology Ltd, G. Noida 10th Jun 2016 – 30-Mar-18
SEI USA, Duration-Technology Specialist

SEI (NASDAQ: SEIC) is a leading global provider of asset management, investment processing, and investment operations solutions for institutional and personal wealth management. SEI deals directly with banks to provide the up-to-date data to share market across all regions of asia

Responsibilities and Achievements:
• Worked as a Team Leader for 6 month, apart from my work, guiding and helping the team for quality and timely delivery of tasks given to them.
• Conducting system study, Analysis of Speciation Document and coordinating with team members for requirement mapping, system design & integration, Coding, implementation, testing/peer review etc.
Technology Used: Oracle PL/SQL, Informatica Power Center 9.5,




JK Technosoft, Noida 17th Nov 2014 –8thJun 2016
Client : Sedgwick CMS, USA
About Client :Sedgwick Claims Management Services, Inc., is the leading global provider of technology-enabled claims and productivity management solutions. Sedgwick and its affiliated companies deliver cost-effective claims, productivity, managed care, risk consulting, and other services to clients. The company specializes in workers’ compensation; disability, FMLA, and other employee absence; managed care; general, automobile, and professional liability; property loss adjusting; warranty and credit card claims services; fraud and investigation; structured settlements; Medicare compliance solutions; and forensic investigations. Sedgwick and its affiliates design and implement customized programs based on proven practices and advanced technology that exceed client expectations.

Size ofEngagement:Total 8 Resources working for the client out of which
3 in PL/SQL, 1 in .NET, 2 in Informatica and 2 in QA
Role : System Analyst
Project Title :Affinity Business Solutions
Project Duration : Nov 2014 – Till Date
Environment (Technical) :Oracle PL/SQL, Informatica Power Center, .Net, Progress - 4GL
Responsibilities :
• Understand customer business requirements,
• Prepare Technical design document
• Involvement in Development

Cognizant Technology Solutions 14th March 2011 – 14th Nov 2014

Client : AzRow
About Client:As India’s leading multi-format retailer Future Group inspires trust through
Innovative offerings, quality products and affordable prices that help
customers achieve a better quality of life every day.
Size of Engagement :In total there were 40 Developers, 5 testers and 3 BA
Role : Senior Developer

Project Title :AZROW – Sales Planning Tool
Project Duration : Mar 2011 – Nov 2014
Environment (Technical) :Oracle PL/SQL, Informatica Power Center, .Net
Responsibilities : Analysis, Designing, coding, Unit testing, bug fixing. Code reviews and writing
unit test document.
Project Team Size :40
About Project
This is pharmatical Industry product, covers 65 countries all over the globe. This is the project of internationalization that we handle on database. Application converts as based on logged-in user of different-2 countries. There are two types of hierarchy in this system
• Geographical hierarchy
• Sales Hierarchy.
We create Geographical hierarchy based on Geography, Region and district and bricks/zip code. Sales hierarchy is the customer hierarchy that based on the mapping of geographical hierarchy. We create different-2 alignment based on geographical structure. We have different-2 kinds of functionalities in this system
• Account Management
• Professional Management
• Exclusion Mgmt. Based on standard rules of segments/metrics
• Change Request Management
• Sales Position Mgmt. to assign an employee on sales position
• Admin
• Incremental Load design
• Adjudication & Affiliations


Qualtech Consultants Pvt Ltd, Noida 6stDec 2006 – 10th Mar 2011
Client : DLF PR-America
Size of Engagement :Total 4oracle & .Net resources in this engagement
Role : Engineer Analyst – L2

Project Title :Reports Development
Project Duration : Oct 2010 – Mar-2011
Environment (Technical) :Oracle Pl/Sql
Responsibilities : Analysis, coding, Unit testing, bug fixing
Project Team Size :4
About Project :Generating Different kinds of Reports using database RPDB (TCS Bancs) and CTA database .RPDB is maindatabase used for reporting database and CTA is call tracking system for renewal of policies or made a reminder call regards payment . In CTA application we generate different kind of reports like Renewal reports ,Ecs reports, Sales reports, Skypack reports. Currently working for fetching reports of Commision or Sm-Incentive. Writing SE Reports.

Client : Kotak- Life Insurance
Size of Engagement :Total 15 resources in this engagement
Role : Senior Developer

Project Title :Unit Transfer with Employee Search
Project Duration :Sep 2009 – Oct-2010
Environment (Technical) :Oracle Pl/Sql
Responsibilities : Analysis, coding, Unit testing, bug fixing
Project Team Size :15
About Project :The scope of this project is to re-allocate/terminate of an agent if Sales manager terminates due to any reason in organization, this can be of two types automatic or manual based on some standards rules and configurations (for calculating performance). This can be calculated on the basis of CPI, NOP, total Sum assured (after calculating weightage), and CLA etc. There are 3 level of processes of transfer/terminate the LA.
Initiator : Who initiates the process of termination or reallocation of process
Approver: There are 2 level of approvers , first are ABM(Non Mandatoryy)BMAND AM second are RM AND AM. If Non mandatory Rejects the task the task will fully rejected
Finalizer : channal support team arefinalizer for taking final deisions.
After finishing process at each level, task automatically assigned to next level for taking actions.
Finally sms/email framework comes into the picture at the time of initiation of process or sending mails/sms to next level approver just for information purpose.
.
Client : Kotak – Life Insurance
Size of Engagement :Total 15 resources in this engagement
Role : Engineer Analyst – L2

Project Title :Activity Report
Project Duration : Aug 2008 – Sep 2009
Environment (Technical) :Oracle Pl/Sql
Responsibilities : Analysis, coding, Unit testing, bug fixing
Project Team Size :15
About Project :
Business completed by marketing channels may be directly (means via SM, AG) or via any third party channels like Tide agency. We shows the reports based on that business spread by sales manager. If any other reporting agency manager or branch manager logins in the system related to sales is able to view the report till sm level. Here we create two types of reports like (1) Recruitment Report (2) H.O. Report
Marketing hierarchy description
Business did by Kotak may be via agents or supervising agent related to marketing. In this scenario Kotak assigns the target CPI value to agents with in a particular time period. If agents covers the target CPI means he achieved the Launchpad otherwise he is fail to achieve the Launchpad. this reports also shows the PHF profile of agents. Here we generated reports weather agent refer by any other agents and calculate the Launchpad of that pla’s. here we generate two types of reports like
(1) La refer La reports ( with LP) (2) La refer Summary (With La details).

Client : Kotak – Life Insurance
Size of Engagement :Total 5 resources in this engagement
Role : Engineer Analyst – L2

Project Title :KTrack – Sms Push, Pull & Email.
Project Duration :Sep 2007 – Aug 2008
Environment (Technical) :Oracle Pl/Sql
Responsibilities : Analysis, coding, Unit testing, bug fixing
Project Team Size :5
About Project :
The scope of this project is to send the SMS/email (in a particular format) to policy owner or AG or SM etc. Here We Work on Ktrack (Kotak track).
Push framework divides into two category first is batch based and second is trigger based. In batch mode , DCO runs the batch file, batch file connect with data base and call the sms framework and generate the sms second is trigger based , at a particular event entry raised and called at every 5 minute interval level through scheduler process. Here we create the triggers , functions and procedures for sending sms to customer who applied for a policy (that is currently proposal) as proposal login, Requirement isued(if document is not submitted) ,Pre-NTU (if Request is calcelled and proposal not converted as a policy), Cheque-Bounced(if cheque is not cleared of customer) Policy Conversion (if proposal is converted in policy) etc..
Pull Description : In sms-Pull Architecture, customer send the sms with some fix predefined keyword. Then our request engine and process engine comes into the picture. Input Request engine parse the input string and decide which part is keyword and which part is parameter send by user. Then our process engine called, first it decide the request type (Authentication), mean mobile number is authenticable or not. if mobile number is not available then sends authentication failed error message otherwise check in request repositrary depends on input string. If valid then process begins and process the request means called the business object based on input parameter and calculate sending template and send to user.

Email Description: Scope of Email framework is to push emails to customer, as push; email is also divide into two categories, first is trigger based and second is batch based. Email contains the flexibility of containing the html template, image path and attachment path.

Vergelijkbare leraren

Basis computervaardigheden in de buurt? Hier een selectie van leraren die je kunt bekijken. Superprof kan je ook helpen bij het vinden van lessen in SQL. Leren is geen probleem meer, Oracle toegankelijk voor iedereen! Lessen volgen in Database is nog nooit zo makkelijk geweest: je kunt je kennis eindeloos ontwikkelen!

Den Haag
Masterstudent geeft lessen basis computervaardigheden aan studenten en volwassenen in de regio Den Haag
22€
Simon
  • (4 beoordelingen)
1e les gratis!

Bij specifieke vragen of problemen kom ik langs om uitleg te geven en samen te oefenen. Daarnaast kan ik algemene...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Den Haag
IT'er geeft lessen computervaardigheden aan volwassenen en studenten in de regio Den Haag/Delft
20€
Roy
1e les gratis!

Ik ben de hele dag bezig met het oplossen van problemen. Dus les geven en duidelijk toelichting geven over Basis...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Delft
Student Computer Science en Wiskunde leert je python programmeren en leert je algoritmes ontwerpen
14€
Saïd-Ahmed
  • (1 beoordeling)
1e les gratis!

Ik begeleid de leerling(en) om zelf de taal te ontdekken. Ik laat de leerlingen zelf spelen met de taal en geef ze nieuwe...

1-op-1 lessen Goedgekeurd profiel
Den Haag
Professional software engineer helps in basic and advanced Mathematics, Computer Science, programming using Linux, Python, Git and other modern tools.
25€
Ole
1e les gratis!

I mostly focus on narrow topics and practical questions, which can be handled in a few hours. My classes fit the best to...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Delft
WO student Lucht en Ruimtevaarttechniek, geeft les technische vakken zoals: programmeren, natuurkunde, wiskunde, ed
21€
Luigi
1e les gratis!

Ik baseer mijn lessen op korte uitleg van principes, met daarna oefeningen waar studenten vragen kunnen stellen. Het is erg...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Den Haag
Need some help for using your computer ? I can teach, in the Hague area. Windows, Linux or osx.
10€
Christina
1e les gratis!

The best for me is to give demo, and practice. And if we could make it with a smile (and a coffee!)

Online les via webcam 1-op-1 lessen
Rotterdam
Master Student Stedenbouwkunde, geeft les in alle Adobe Creative cloud programma's, e.a. Photoshop, Illustrator, Indesign
30€
Emilie
  • (1 beoordeling)
1e les gratis!

Mijn methode van les geven is eerst bekijken wat de kennis van de student is. Wat zijn/haar ervaring is en wat het doel van...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
De Bilt
Programming development course for beginner and intermediate in C ++ / Java
25€
Sebastien
  • (5 beoordelingen)

Je vous apprendrais à développer dans un langage de programmation. Je vous apporterais les connaissances suivante: -...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Tilburg
Ervaren IT-Trainer in Excel en programmeertalen C#, Java, HTML, Javascript, CSS en SQL.
19€
Remsey
  • (7 beoordelingen)
1e les gratis!

Ik leg alles op een rustige en begrijpelijke taal uit. Jouw leerdoelen staan centraal. Wil je meer leren over Excel? Of...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Hoorn
Software Developer & Data Scientist geeft Python en Machine Learning les aan beginners en gevorderden
20€
Tony
1e les gratis!

Alle lessen pas ik aan op de student en zijn of haar niveau. Ik baseer mijn lessen op mijn ervaring tijdens mijn studie en...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Maassluis
Enthousiasteling en verkoper binnen de ICT, te Maassluis met meerdere it certivicaten
15€
Rick
  • (5 beoordelingen)
1e les gratis!

Ik focus erop dat je mij op de lange termijn niet nodig meer hebt. Ik focus er dus ook op tijdens het lesgeven! Ik heb een...

Online les via webcam Goedgekeurd profiel
Roosendaal
HBO Student geeft bijles in omgang van Apple producten - iPhone - iPad - Mac
12€
Nick
  • (1 beoordeling)
1e les gratis!

De methode waarop problemen worden verholpen gaat als volgt. Allereerst worden de aanwezige problemen opgesomd. Vervolgens...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Oosterhout
Student IT Netwerkbeheer: ICT basis, beveiliging, en systemen; Windows en Linux; te Oosterhout
6€
Quinten
1e les gratis!

Ik probeer mijn lessen te baseren op mijn eigen ervaringen, en laat ook zien waar je tegenaan kan lopen. Voornamelijk...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Utrecht
Les van ervaren ict'er in begrijpelijke taal. Word zelfredzaam met nieuwe manieren van denken.
18€
Tim
  • (1 beoordeling)
1e les gratis!

Ik doe dingen in kleine stapjes voor, waarna je het zelf onder begeleiding mag doen. Vervolgens leg ik de onderliggende...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Amsterdam
Computerhulp, Computerles en alle hulp bij alle andere elektronische apparaten te Amsterdam!
20€
Lodewijk
  • (1 beoordeling)
1e les gratis!

Aangezien ik jaren ervaring heb opgedaan op het gebied van computers en elektronische apparaten, ben ik breed...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Amsterdam
Een expert in Lightroom maakt ook van jou een expert in Lightroom!
25€
Tjade
1e les gratis!

Van basisvaardigheden tot verdieping. Op basis van jouw wensen zorgen wij voor een op maat gemaakt lesplan. Hierbij zal ook...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Kaatsheuvel
Ik help je graag bij alles wat je wilt weten over grafisch design in de adobe programma's!
30€
Peggy
  • (2 beoordelingen)
1e les gratis!

Ik ben heel flexibel. Jij bepaald hoe jij wilt leren! Ik vind werken met PDFjes heel handig. Hierin leg ik vanalles uit aan...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Amersfoort
Student Media & Design student die graag bijles geeft over ongeveer alles wat met computers te maken heeft.
15€
Kylian
1e les gratis!

Ligt aan het leerdoel van mijn leerling. Als mensen hulp nodig hebben met programma's leg ik ze de tools uit zodat ze hier...

Online les via webcam 1-op-1 lessen Goedgekeurd profiel
Bij de leraar thuis Bij jou thuis Online (via webcam)
1 uur Niet beschikbaar Niet beschikbaar 150€
5 uur Niet beschikbaar Niet beschikbaar 750€
10 uur Niet beschikbaar Niet beschikbaar 1500€
Helaas is deze leraar onbeschikbaar. Onze excuses voor het ongemak.