ResumeLogin
Search for: Jobs   Resumes
Keywords or title City, state or zip code

Developer Business Oracle Sql Project Dba Engineer

Post jobs
Country: India
State: Karnataka
City: Bangalore
Postal Index: 560068
Salary: More Than 2.5 Lacs p/a
Posted date: 4/20/2012   all resumes
Email: ebdgu9@r.postjobfree.com
Contact Info: *******.**********@*****.***
Show Full Resume Send Message Free
Email me new resumes like this


Email
Resume Text:


PUSHPENDRA CHOUBEY
Email: ebdgu9@r.postjobfree.com
Mobile: +91-725*******

CAREER OBJECTIVE:

To be a part of any IT organization where my knowledge and experience can be shared and enriched. That offers professional growth and gives me scope to apply my knowledge and skills.

PROFILE SUMMARY:

• 2+ years of experience in PL/SQL & Oracle DBA with ETL Developer
• Have knowledge on Unix & Linux Administrator
• Extensive experience in Creating and customization of Transformation’s using Informatica
• Expertise in creating and execution of the PL/SQL Block-Function, Procedure & Trigger
• Having basic programming knowledge in C,C++,.Net language
• Well experienced in Designing Transformation, Function’s ,Procedure,Trigger,Package’s
• Flexible work on any project.
• Have good working knowledge on oracle dba concept
• Ability to learn new things and quick learner.

PROFESSIONAL EXPERIENCE:

• Presently working for Schwantech India Pvt Ltd, Bangalore as a PL/SQL With ETL Developer since July 2010 to till date.

Project #1 -As a PL/SQL Programmer
Title : Billing Travel and Transport
Environment : Oracle10g, Informatica 8.6, Office2003, Windows_xp_sp2
Domain : Travel Domain
Description : In this, Business users want to see every end of the month how much business have in & out.

Responsible for
• Analyze requirements and system design documentation to develop a PL/SQL Object
• Mainly responsible for database development tasks and duties by using SQL database programming knowledge
• Responsible for reporting to senior programmer
• Queried from different database tables as per the requirement
• Preparing reports.
• Used Informatica to link different data sources
• Developing PL/SQL procedures, packages, triggers, functions
• FOR UPDATE Clause for updating & Deleting Data into server Asynchronously with CURRENT OF Clause.
• REF Cursor (cursor object) , BULK COLLECT, FORALL Statement.

Project #2- As an ETL Developer
Title : Analysis on Banking Transactions
Environment : Oracle10g, Informatica 8.6, MS Office2003, Windows_xp_sp2
Domain : Banking
Description : Analysis On Banking Transactions, Business users want to see historical snapshot data of customer. Every account has a primary balance. The business wants to group different types of accounts in the same analyses and compare primary balances. It helps the Business user to analysis in end of every month according to his business.
Responsible for:
• Analyzing the source, designing the transformations.
• Used source analyzer to import the source and target.
• Designing the Relational connection in Workflow Manager for Oracle & Excel Database.
• Designed the ETL processes using Informatica tool to load data from Oracle and Excel DB into the target Oracle And Flat File DB.
• Creating Targets based on the mappings.
• Worked on various types of Transformations like Lookup, Update Strategy, Joiner, Filter, Source Qualifier, Aggregation, Union, Router, Sorter, and Sequence Generator
• Implement DBA Concept- Table creation,Security,Constraint.

Project #3- (Academic Projects)

Title : Automatic Share Transaction System
Environment : Asp.Net, C#.Net, IIS, SQL-Server 2005, Windows_xp_sp2
Domain : Share Market
Team Size : 3
Training Center : Naresh i Technology Hyderabad

Knowledge Of-

• Oracle11g Architecture. Object Oriented (oop’s) Concept in Oracle10g.
• Deferrable & Immediate Constraint state with its implementation.
• Performance issue with the help of Creating Index’s, Materialized View.
• Merge statement for the ‘ON Going Loading’ in The DWH(OLAP) Environment
• OLAP Function In Oracle10g
• PL/SQL Data Type- Record Type, PL/SQL Table Type. Ref Cursor , cursor communication

SUMMARY OF QUALIFICATIONS:

• Successfully completed Oracle10g, Informatica 8.6 Training Course from “NARESH i TECHNOLOGY” Hyderabad
• Successfully completed Oracle11g DBA Training Course from “WILSHIRE S/W TECHNOLOGY” Hyderabad
• Successfully completed RHCE (Red Hat Certified Engineer) Training Course from ZOOM Technology Hyderabad
• Successfully completed .Net Technology (ASP, C#, SQL SERVER), UNIX, C++ Course.
• Successfully completed MCA in Thakral College Of Technology from Bhopal Scored 68% (2010)
• Bachelor’s Degree in Science (B.Sc.), 2006 Rani Durgawati Vishwavidyalaya Jabalpur (50%)
• 12th from M.P.B.S.E., Bhopal 2002(61%)
• 10th from M.P.B.S.E., Bhopal 2000(67%)

PERSONAL PROFILE:

• Excellent communication skills both written and oral.
Name : Pushpendra Choubey
Date of birth : 31th Dec1984
Citizenship : Indian.
Passport Number : J1431150
Marital Status : Married.
Contact Number : 725*******
Languages known : English and Hindi
Permanent address : Infy PG Roopena Agarahara,Near of Silk Board , Madiwala, Bangalore Pin:- 560068

Declaration:

I hereby declare that information furnished above is true and best of my knowledge

DATE: -
PLACE:-BANGALORE PUSHPENDRA CHOUBEY



©2013  PostJobFree.com - Home - Latest Resumes - Post jobs - Update or Delete my resume