Sr. Principal Consultant
Resume:
SANDEEP KUMAR SINHA: +1-630-***-**** ****************@*****.***
A highly motivated and vastly experienced Information Technology Professional with over 10 years of experience as a highly regarded technology professional with a deep understanding of Oracle ERP,Oracle Database Administration,Demantra,OBIEE,OBIA & ODI . Worked for many high profile companies contributing in the success of several business critical projects, has the energy, passion and a relentless ambition needed to ensure that positive project outcomes are achieved within the parameters of time, cost, scope, risk and benefits. I have hybrid of skill sets as well as extensive technical ability and knowledge of the R&D processes. As a true professional I can act as a bridge between the IT department and other sections of a business. On a personal level I am friendly, but always highly professional and has a positive ‘can-do’ approach as well as a flair for thinking on feet.
SUMMARY:
Defining IT solutions and then presenting those solutions in written or oral reports.
Managing project dependencies, preparing project briefs, compiling reports and maintaining records.
Ensuring that all stakeholders are up-to-date and up to speed with developments.
Helping project teams to move through the various stages and decision points of a program.
Proactively identifies and nurtures opportunities, ideas and innovations.
Assisting the business to win, sustain and grow corporate clients.
Developing and maintaining relationships with third party vendors.
Helping clients meet and exceed their goals.
Maintaining credibility with the customer at a high level.
Established service level agreements with end-users.
Participated for pre sales, proposals, effort estimations, project plan activities.
Well-prepared with the necessary equipment, training, and experience to get the job done.
Excellent Client relation building skills.
Experience in working with US and UK clients.
Proven experience in Oracle Business Intelligence and OBIEE Administration
Knowledge of installing, upgrading and configuring OBIEE tools
Proficient in the use of repository variables
Administer ETL and data warehousing applications and tools
Understand the standard of best practices in BI administration environment
An effective communicator with relationship management skills and ability to relate to people at any level of business and management.
Excellent in building team and keeping them motivated
Hands on experience on Oracle BI Implementation, upgradation
Hands on experience on Oracle Apps and Database administration.
Experience of various applications on UNIX (Solaris/Red hat) and Win environment
End to End Implementation of Oracle Apps R11i and R12 on different platforms.
Upgradation of Oracle Application from 11i to R12 on Linux and windows environments.
Upgradation of 9i and 10g databases on various platforms
End to End Implementation of Oracle Application Server 10g, FMW11g (OID,SSO, Portal)
Implementation of Oracle Enterprise Content Server.
Implementation of Oracle database Vault, Label Security and Audit Vault.
Good knowledge in using Apps Utilities (patch, adadmin. Cloning etc)
Delivered vital consistency through introduction and implementation of enterprise-wide set of database standards
Outstanding organizational, communication & presentation skills
A team player with exceptionally good organizational, analytical, training, troubleshooting, and interpersonal communication skills
Skills:
Technology
Tools
Databases
Oracle 10g,11g,12c, RAC
Datawarehouse
Informatica, DAC, OBIEE, ODI, OBIA
ERP Administration
Oracle Release 11i, R12.0,R12.1,R12.2
Application Servers
10g Application server, SSO, weblogic
O/S
Windows, Linux (RHEL,OEL),AIX
RDBMS
Oracle 10g, 11g,12c
FMW
SOA,ODI, OBIEE,weblogic,Goldengate,Demantra
Tools
Oracle Enterprise manager 12C, Informatica, DAC,Delphix
Content Management
Oracle Enterprise content management
Security
Oracle Database Vault, Label Security and Audit vault, EUS
Project Summary
Client
Start Date
End Date
McDonald's
Nov-11
Present
Georgia Health Sciences University
Feb-11
Aug-11
Unisys
Jul-10
Feb-11
Agility Logistics
Mar-10
Jul-10
HDNL UK
Sep-09
Feb-10
TDIC-Dubai
Dec-08
Aug-09
Harvest - Egypt
Mar-08
Nov-08
Unisoft
Aug-07
Jan-08
EXPERIENCE
Duration : Nov2011 to Till Date
Company : Fujitsu America
Client : McDonald's Corporation US
Position : Oracle DBA/Lead
Environment : OBIEE, ODI, SOA, weblogic,Oracle Apps R12,Goldengate,Delphix,RHEL 5
Project : Support project / Upgrade /Implementation/DC Move/Platform Migration
Description : Worked on multiple project of MCD US
Responsibilities
Responsible for support for OBIA,Oracle Apps instance as Lead Oracle Apps DBA
Interacting client to understand business requirements and mapping the same to Oracle Applications.
Completed poc for multimode implementation R12.2 on AWS and 12.2.6 upgrade is ongoing.
Completed poc for Oracle Enterprise Manger 13c…
Responsible to design the project & provide solutions.
Interaction with Oracle Support Services to resolve mission critical issues
Providing process driven support to end users and application developers.
This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.
OBIA upgrade/Implementation, migrating INFM to ODI
Responsible to provide Production Support after Go Live as well.
Coordinating with shared pool DBA’s for 24*7 support.
Project:
OBIA Implementation, upgrade
INFM to ODI migration
AIX to RHEL 5.9 Platform Migration
Datacenter move
Oracle Database Upgrade, (Patch set upgrade,Version Upgrade)
Oracle Apps Upgrade (R12.1.3)
SSO and EUS implementation
Duration : Feb2011 to Aug2011
Company : CampusEAI Consortium
Client : GHSU (Georgia Health Sciences University)
Position : Oracle Apps DBA
Environment : Oracle Application Server10g, FMW11g, LINUX
Project : Migration of Oracle Portal and OID and Upgradation of 10g Application server to FMW11g
Description : Founded in 1828, Georgia Health Sciences University is home to the Medical College of Georgia, the 13th-oldest continuously operating medical school in the United States and the third-oldest in the Southeast. It has implemented Oracle Application Server 10g. It has instances each for development, test, quality, performance and production instances. We are currently migrating, Virtualization and upgrading their 10g Apps to FMW11g; on all the above mentioned instances including production instances. The project involves providing support to Oracle Applications instances. Migration of their existing Instance on new server is quite complex as they have lot of customization on the portal.
Responsibilities
Responsible for Migrating portal and OID to new setup and upgrade it to FMW11g
End to End implementation of Application server10g OID,SSO,&PORTAL.
Virtual Name and SSLing.
Upgradation of 10g Application server to FMW11g.
This implementation also includes database upgradation from 10g to 11gR2.
Interaction with Oracle Support Services to resolve mission critical issues
Providing process driven support to end users and application developers.
This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.
Interacting client to understand business requirements and mapping the same to Oracle Applications.
Responsible to design the project & provide solutions
Duration : July2010 to Feb2011
Company : Hexaware Technologies Mumbai
Client : Unisys
Position : Oracle Apps DBA
Environment : Oracle 10g, Oracle R12.1.1, Oracle Apps 11.5.8 on Windows server,
Project : Oracle Apps 11i to R12 upgradation
Description: Unisys is a US based IT firm functioning in eighteen countries across the globe. It has implemented Oracle Applications 11.5.8 and is using over 10 modules. It has two instances each for development, test, quality, performance and two production instances. We are currently supporting and upgrading their 11i instance to R12, all the above mentioned instances including two production instances. The project involves providing 24X7 supports to Oracle Applications instances. This is a quite complex environment comprising of 6 mid-tier servers in production with Applications file system sharing enabled on Windows. Parallel Concurrent Processing has been implemented to enable load balancing and failover of concurrent processing.
Responsibilities
End to End upgradation of Oracle Apps 11.5.8 to R12.1.1
Basic database & APPS environment troubleshooting
Acknowledging the support requests as per SLA.
Resolving the issues reported on Development and Production environments.
Troubleshooting problems reported with technology stack components.
Troubleshooting and fixing problems with concurrent managers.
Cloning and Refresh of the non-production instances from production instance.
Merging the patches.
Patching the instances.
Planning the technical activities lined up for the regular maintenance and provide steps for execution
Interaction with Oracle Support Services to resolve mission critical issues
Providing process driven support to end users and application developers.
This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.
Duration : Feb2010 to July2010
Company : Hexaware Technologies Mumbai
Client : Agility Logistics
Position : Oracle Apps DBA
Environment : R12.1.1, SSO, Discoverer, OBIEE, Linux
Project : Implementation of Oracle Apps R12.1.1, SSO implementation
Description : Agility logistics is the biggest logistics leader in the Middle East. It is one of the biggest logistics brand with over 55 offices globally. We have implemented one of the most complex Oracle SSO implemented for Agility. The major achievement we achieved during the implementation of Agility was DC level mapping and automatic synchronization between AD and OID and the peer level. We have integrated the Oracle E-Business Suite with OID .The integration happened between the employee number and the userid( Email username) of the user. Also the implementation involves 35000 end users with which 15000 users will be accessing using the SSO and the remaining 20000 user through the Oracle E-Business Legacy homepage.
Responsibilities
End to End Implementation of Oracle Apps R12.1.1
Implementation of Oracle 10g AS SSO with Oracle Apps R12.1.1
Troubleshooting Issues related to Oracle Apps and SSO.
Interaction with Oracle Support Services to resolve mission critical issues.
Providing process driven support to end users and application developers.
Performing daily and weekly health check.
Preparing the Checklist and setting up the Action Plan for the project and each activity.
Preparing the Environment Build Checklist for the server and other OS access details.
Preparing the MD120 technical document for the complete migration.
Preparing the Delivery Report to be send to the Client for Assessment.
Checking the resource utilization and budgeting.
Creating and maintaining Users, Responsibilities, and Menus.
Managing the terminations at the client system in Oracle Applications HRMS system.
Duration : Sep2009 to Feb2010
Company : Inatech Info Solutions (A California Software Company)
Client : HDNL UK (Home Delivery Network Ltd. UK)
Position : Associate Consultant
Environment : Oracle 10g, Oracle R12.0.4, Linux, SOA
Project : Oracle Apps R12.0.4, FMW11g SOA implementation.
Responsibilities
End to End Implementation of Oracle R12.0.4 installation in HDNL Servers
Performing Weekly Database and Application Backups
Basic database & APPS environment troubleshooting
Monitoring Oracle Applications Instance and Oracle Databases
Trouble shooting Oracle Applications Issues
Backup and recovery via RMAN & Snapshot backup
Patching databases and applications on various platforms
Interaction with Oracle Support Services to resolve mission critical issues
SOA Administration and Troubleshooting
Providing process driven support to end users and application developers.
This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.
Daily Health Check of SOA Environment and Non SOA Environment.
Duration : DEC 2008 to Aug2009
Company : Inatech Info Solutions (A California Software Company)
Client : TDIC-Dubai
Position : Associate Consultant
Environment : Oracle 11g, Oracle R12.1.1, Linux, Database Vault and Audit Vault, Oracle Enterprise Content Management
Project : Oracle Enterprise Content Management
Responsibilities
Oracle R12.1.1 installation in TDIC server
Installation Oracle database 10g and Stellent (UCM)
Installing Database Vault and Audit Vault and Configuring both
Integrating Database Vault with Oracle R12.1.1
Creating Realm of Restricting unauthorized user to access other tables
Configuring Audit Vault of R12.1.1
Integrating content Management with Microsoft Dynamics.
Configuring UCM
Applying Extra modules as per requirement.
Workflow configuration for Content management.
Administration of Stellent product
Creating users, user grants and application appropriate privileges, maintaining Database & application security
Monitoring tablespace and extent growth
Monitoring Oracle Applications Instance and Oracle Databases
Trouble shooting Oracle Applications Issues
Cloning R12 application from Multi node to Single Node
Backup and recovery via RMAN & Snapshot backup
Applying Patches on Database and Application level.
Interaction with Oracle Support Services to resolve mission critical issues
Providing process driven support to end users and application developers.
This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.
Performing Weekly Database and Application Backups
Project – 6
Duration : Aug 2008 to Nov 2008
Company : Inatech Info Solution Pvt Ltd. (California Software Company Ltd.)
Position : Associate Consultant
Environment : 9i/10g, Oracle 11i Apps, ESSO, Linux
Responsibilities
Installation Oracle Applications from 11.5.10.2
Installation of Logon Manager Administrative Console and Agent
Configured the Oracle Logon Manager to contribute with Various Applications
Patching and upgrading databases and applications on various platforms
Cloning using Rapid clone, manually clone, Autoconfig and adclone utility
Administration of Oracle Apps using ad admin utilities
Creation of Concurrent Mangers, Programs, and Request sets
Creating users, user grants and application appropriate privileges, maintaining Database & application security
Monitoring tablespace and extent growth
Hot and Cold Backup and Recovery of the database
Configured ESSO Setup in the Application Server
ESSO-LM lets you use a single password to log on to any password-protected application on your desktop, your network, and the Internet. It works “out-of-the-box” (without programming or additional network infrastructure) with virtually all applications, including Windows, Web, proprietary, and host or mainframe applications
Project -7
Duration : Aug 2007 to July 2008
Company : Inatech Info Solutions (A California Software Company)
Client : Harvest - Egypt
Position : Associate Consultant
Environment : Oracle 10g, Oracle 12R, Linux
Project : Offshore support for “HARVEST”
Responsibilities
Oracle R12 installation in Harvest server
Performing Weekly Database and Application Backups
Installed Arabic patch and Translated patch in Harvest server
Worked on Oracle R12 Cloning
Basic database & APPS environment troubleshooting
Monitoring Oracle Applications Instance and Oracle Databases
Trouble shooting Oracle Applications Issues
Cloning R12 application from Multi node to Single Node
Backup and recovery via RMAN & Snapshot backup
Patching databases and applications on various platforms
Interaction with Oracle Support Services to resolve mission critical issues
Providing process driven support to end users and application developers.
This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.
EDUCATION:
B.E Electronics & Telecommunication from Shivaji University Kolhapur Maharashtra.
CERTIFICATION:
Oracle Certified Associate (OCA)-10g
Contact this candidate