Project Oracle
Resume:
Manju Awasthy
Atlanta, GA
EXECUTIVE SUMMARY
IT professional having 10 years plus of experience in IT Strategy & Governance . Rich industry
experience on different versions of Oracle as 8i, 9i, 11 using PLSQL involving use of TOAD, SQL
Developer, DB Artisan, MS Access . Has worked in multiple customer-facing roles, & managed teams
across multiple geographies. Extensive consulting & implementation experience on Oracle PLSQL.
HIGHLIGHTS:
An experience of over 10 years in IT Governance
Worked on different versions of Oracle as 8i, 9i, 11 using PLSQL
Experience and exposure to Analysis, Design, Performance Tuning, DB modeling and
Development of PLSQL using different database tools like TOAD, SQL Developer, DB Artisan,
MS Access.
Extremely diligent, strong aptitude, willing to learn new technologies, worked in as well as lead
various challenging development projects
Excellent Communication, Organizing, and Team building skills with result oriented approach
towards goals
Involved in database modeling and design with team/DBAs around different Client’s applications
Strong analytical skills and quick at grasping new concepts. Possesses excellent interpersonal
skills and has effectively worked in teams
Strong capabilities and experience as a technical Trainer
Along with development projects, the consultant has also been involved in various Business Development
activities which include client road map designing, demos / proof of concepts, content preparation, data
consolidation and management etc.
Consultant has extensively worked for customers from USA, APAC and India for various assignments.
EDUCATION:
o Bachelor of Engineering (Information Technology), D.A.V.V, Indore (M.P.), India
TRAININGS / CERTIFICATIONS
Process/ Functional
o ITIL Foundation Course
o Quality Management System (QMS-TM)
o Process Championship Workshop (TM)
o SOX Compliance
o Impact Gold for Communication Skills
o QTP Functional Training
Tools/ Products
o Oracle Database Scripts and Jobs
o Oracle Apps integration with ITG
TECHNICAL EXPERTISE
Language PL/SQL, SQL, C, C++, VB, Java, Servlets, XML
RDBMSTechnologies/ Databases Oracle 8i, 9i, 10g and 11, MS Access, IBM DB2
Database Tools TOAD, DB Artisan, SQL Developer, SQL Loader
Operating Systems Windows7, Windows XP, UNIX
Office Packages MS-Office 2000\XP\2007\365
Web Technologies JSP, HTML
Other Tools Visual Source Safe, SharePoint, Rational Rose, IBM WSAD,
Microsoft Project
CONSULTING/ DELIVERY EXPERIENCE
PROJECT DETAILS –
Prodware Solutions (April 2014 – Till Date)
Project Description
Working as senior IT consultant and subject matter expert for the firm helping Clients by providing
solution, maintaining their applications, database tuning/modeling and supporting them by using PLSQL.
Genpact Headstrong Capital Markets (February 2008 – March 2014)
Project Name Project Governance IT Corp Tech
Client Morgan Stanley
Location New York
Role Senior Consultant and Subject Matter Expert
Duration Feb 2008 – March 2014
Team Size 25
Project Description
This is a Development cum Maintenance Project adopting agile methodology for their developments
using Oracle 11 and PLSQL. Business Objects reporting is done through various ETL (Extract, Transform
and Load) scripts for various PPM nodules.
Key Responsibilities
1. Worked as subject matter expert and onsite coordinator for providing Maintenance, Enhancement
& Support to the Client.
2. Works on customization for different modules, tuning SQL
3. Creation of PLSQL and SQL scripts for reporting, reopen multiple requests, convert Project
Types from one particular type to another for bulk Projects, close the Workplan if Project gets
closed
4. Involved in Unit testing, Risk assessment and documentation for the new developments
Database: Oracle 9i, Oracle 11
Languages: PL/SQL
Wipro InfoTech (November 2007 – February 2008)
Project Name Phoenix, IT Governance Solution
Client Genpact
Location Gurgaon ( New Delhi, India)
Role System Analyst
Duration Nov 2007 – Feb 2008
Team Size 1
Project Description
Phoenix project manage the IT projects of the Organization across various business units. The client was
managing all their Projects and related aspects like Resources, Financials and Time related data into their
tool using PLSQL, SQL and different scripts. I was responsible to solely handle the application from the
functional perspective, development perspective as well as administrative perspective.
Key Responsibilities
1. Worked as software analyst/administrator and aligned with top management authorities for
providing Maintenance, Enhancement & Support services
2. Involved in: Requirement Gathering, Analysis, Designing Business Solutions, Implementation,
Performance Tuning, Database modelling as per approved Business Logics
3. Played role of Quality Representative to meet the Quality norms of the organization
4. Configured different Reports, scripts utilizing Oracle queries, stored procedures, JSP pages
Database: Oracle 9i
Languages: PL/SQL
Birlasoft Inc. (July 2005 – October 2007)
Project Name Giant Eagle
Client Giant Eagle
Location India
Role Technical Consultant
Duration Feb 2007 – Oct 2007
Team Size 2
Project Description
Giant Eagle use their tool for maintaining their IT portfolio, enterprise project tracking using Oracle
PLSQL, SQL.
Key Responsibilities
1. User Administration,Requirement Analysis, Solution Design, Unit and System testing
2. Worked as a Technical Consultant for providing maintenance, enhancement and support
3. Writing Oracle stored procedures, functions, views, triggers, JSP pages for reporting,
customizations, SQL tuning
4. Creation of Use Case and Functional Specification documents
Database: Oracle 9i
Languages: PL/SQL
Project Name Server Administration & Trainer
Client Birlasoft Inc.
Location India
Role Server Administrator and Trainer
Duration July 2006 – Jan 2007
Team Size 1
Project Description
The objective is of the project is to provide Server Administration for maintaining Enterprise projects
with-in Birlasoft Inc. using UNIX/ LINUX / Oracle PLSQL / SQL
This project cater the Project and Portfolio management needs of the organization. The scope also
included training the Project Managers/ Interns for Project Management activities along with conducting
sessions with the end users to increase awareness and adaptability.
Key Responsibilities
1. Involved in various trainings conducted across the organization
2. Involved in case study and Presales activities of the organization
3. Acted as an Trainer as well as administrator for the project involve server side activities
Database: Oracle 9i
Languages: PL/SQL
Project Name SEI CMM Initiative
Client Birlasoft Inc.
Location India
Role Developer/ Consultant/ Solution Provider
Duration July 2005 – July 2006
Team Size 8
Project Description
Project insight team – The project provides support for all technical issues, development & enhancements,
to internal clients of the organization situated at India, US and other locations. The support includes end
user training tool as well as enhancing the existing applications.
Key Responsibilities
1. Creation of scripts (VB & SQL) & their automation for uploading data in the tool
2. Integrating databases for data upload. Developed a VB code using PLSQL/VB/excel integration
to create requests automatically.
3. Documenting Design and Script Docs for facilitating users & developers
4. Wrote PL/SQL Script, functions & procedures for automating different processes
Database: Oracle 8i and Oracle 9i
Languages: PL/SQL, Visual Basics
Contact this candidate