Project Manager Oracle
Resume:
Mobile: +1-917-***-****
Providence, RI 02903
*****.*******@*****.***
JOECY C. DATILES
INFORMATION TECHNOLOGY PROFESSIONAL
Expertise: System Analysis & Design, Oracle or Database Development, Oracle versions 7-11g, Oracle Forms (6i-10g) & Reports,
PL/SQL, Unix, Project Lead/Management.
Highly experienced, deeply driven, motivated system analyst/software engineer with 11+ years of track record in Oracle database (from
ver. 7 to 11g) and system development. Has worked with various industry such as local government agencies (created, designed and
partially coded an Accounting System, that is modular and integrated), manufacturing, software consultancy, utilities, telecom and
insurance (function focus: CLAIMS (Pension/Annuity), New Business, Policy Administration, Underwriting, Agency, partial Account
for Agent commission) . Led a big team of software developers, database administrators, quality assurance analyst and document
analyst. Extensive involvement in the different stages of software development, maintenance and support. An Oracle Certified
Associate and pursuing Oracle certifications (OCP/OCM/OCE). Have experienced in doing minor DBA roles/jobs.
Technology Snapshot:
Software: Oracle PL/SQL, Oracle versions 7.0, 8.04,9i, 10g and 11g, Oracle Forms 6i and 10g versions, Oracle Reports,
Digital UNIX OSF/1 4.0B/4.0D, MS-DOS 2.x–6.22, Microsoft Windows ver. 3.xx/95 xx/98, Intel/Alpha Based
Microsoft Windows NT Workstation/Server Oracle SQLNet, Oracle Developer Server 1.6.1, Oracle WebServer
2.1.1, Oracle Jinitiator 1.1.7.27, Oracle Developer 2000 Forms Release 4.5, 6.0,6i, Oracle Designer 2000, Seagate
Info, Crystal Reports, Microsoft Office products, Connectivity and Terminal emulation software like Xcursion, Kea!
Term, Delphi4.0/5.0, PowerBuilder 8.0, Citrix, Putty, PVCS, SmartFTP, Microsoft Visual SourceSafe, Oracle
Developer SQL Data Modeler, Visual Studio, Microsoft Clear Case, Oracle SQL Developer, OBIEE
RDBMS:Oracle Enterprise Server Edition 7.x.x.x (with Distributed, OPS, EBU, and Replication implemented), ROSS, Oracle Database
8, 9i, 10g and 11g, AS400
Hardware: DEC Alpha Based Machines 4100/8200 models, Intel Pentium, IBM PC and Compatibles, IBM AIX, IBM Power7
• •
Product/Software Development Data and Application Architecture
• •
Product Support/Maintenance Structured System Development/Information Engineering
• •
Familiarity with Agile Development Knowledge in Oracle EBS (thru online reading)
PROFESSIONAL EXPERIENCE
INFOSYS JULY 2012 - Present
Technology Analyst/Oracle Developer
Client : Fidelity Investments SEPTEMBER 2012 – Present
Part of GEM (Global Employee Management) team that monitors the activities of Fidelity Investments’ access employees with
regards to trading.
• Provides effort needed in the changes or enhancement (back end only) to the GEM system required by the business users.
• Analyzes changes, foresees impact to the totality of the system and business in order to minimize possible risks
• Designs and develops physical data models and schemas for projects and on-going application enhancements.
• Writes and executes stored procedures, triggers, and complex cursors.
• Ensures data integrity, security and performance through review of physical data models against application processing and
architectural designs.
• Performs database-related testing in conjunction with other application testing efforts.
• Coordinates the implementation of database objects, tables and stored procedures into DIT and SIT environments.
JOECY C. DATILES
• Supports development efforts, including consulting on the design and execution of all data-related tasks.
• Designs, creates and executes test cases based upon business requirements and system requirements to validate system functionality
Page 2
BAKER & TAYLOR (YBP Library Services), USAOCTOBER 13 – June 2012
Oracle Developer
Baker is Taylor is the world’s largest distributor of physical and digital content and value-added services.
• Lead and perform data analysis for projects and on-going application enhancements. Develop lasting conceptual and logical
data models and designs that support current and future business requirements. Identify and document the interactions
between data and business/application processes. Participate in and lead logical data model discussions.
• Design and develop physical data models and schemas for projects and on-going application enhancements. Write and
executes stored procedures, triggers, and complex cursors. Ensure data integrity, security and performance through review of
physical data models against application processing and architectural designs.
• Lead and perform database-related testing in conjunction with other application testing efforts. Coordinate the
implementation of database objects, tables and stored procedures into production. Support development efforts, including
consulting on the design and execution of all data-related tasks.
• Support and perform the resolution of production application data issues, Oracle upgrades and maintenance. Contribute to
projects, enhancements and conversions by writing and maintaining Oracle procedures, functions, and packages.
Recommend improvements to or replacement of application databases, data processes and data modeling tools.
ITAC RESOURCES, Malaysia JUNE 2010 – JUNE 2011
MATADOR SINGAPORE JUNE 2009 – JUNE 2010
Client: Hong Leong Assurance Malaysia
Senior System Analyst/Oracle Developer
Hong Leong Assurance Berhad (HLA) is one of the largest insurance companies in Malaysia. It is a well-established and respected
Malaysian brand offering financial planning and protection solutions to meet the various needs of Malaysians at different cycles of their
lives.
Extensive exposure in New Business, Underwriting, Claims(Pension, Annuity, GMAT, Death, TPD, PPD and other claims) and Policy
Servicing, Unit Link module, Group Life System. Traditional and Takaful Insurance. Minor knowledge in Finance/Accounting. Minor
knowledge in General Insurance
• Provided effort needed in the changes or enhancement required by the user particularly on Claim Modules (Pension or Annuity,
Maturity), New Business, Agency, Policy Administration, Agent’s Commission accounting entries, Underwriting and others
• Produced technical designs and specifications from the functional requirements, development of functional and technical
specifications into working application modules in addition to completing documentation and testing. Ultimately working with
other developers to incorporate code into a larger application
• Solved issues raise by our end-users, doing so would include investigation on how and why the bug had occurred (root cause
analysis), rectifying the problem, testing and documenting particularly on Claim Modules (Pension or Annuity, Maturity), New
Business, Agency, Policy Administration, Agent’s Commission accounting entries, Underwriting and others.
• Analyzed changes, foresee impact to the totality of the system and business in order to minimize possible risks
• Assisted any member of the team in solving an issue
• Monitored user requirements and sees to it that the RFA’s assigned are delivered on time
• Monitored the performance of the injected programs, provided solution if in case the injected program caused system slowdown
AETINS, Malaysia – (PENTASOFT)
System Analyst/Oracle Developer JUNE 2007 – MAY 2009
A company that offers a single end-to-end Insurance Solution that covers all lines of business: Individual Life, Group Life, Investment
Linked and General. It spans across functions like illustration, quotation, new business, policy servicing, claims, agency management,
commission and benefits, accounting and services. The main business is to help Insurance Companies to strategize and operate by
leveraging on Information Technology, a key enabler to achieve transformational growth through Operational Excellence and
Innovation.
• Produced technical designs and specifications from the functional requirements, development of functional and technical
specifications into working application modules in addition to completing documentation and testing. Ultimately working with other
developers to incorporate code into a larger application.
• Provided effort needed in the changes or enhancement required by the user particularly on Claim Modules (Pension or Annuity,
Maturity), New Business, Agency, Policy Administration, Agent’s Commission accounting entries, Underwriting and others.
• Solved issues raise by our end-users, doing so would include investigation on how and why the bug had occurred (root cause
analysis), rectifying the problem, testing and documenting particularly on Claim Modules (Pension or Annuity, Maturity), New
Business, Agency, Policy Administration, Agent’s Commission accounting entries, Underwriting and others.
• Analyzed changes, foresee impact to the totality of the system and business in order to minimize possible risks
• Converted some Oracle Forms 10g version to 6i version (Security Forms).
• Assisted any member of the team in solving an issue
• Provided support for product enhancements to meet the customers’ requirements.
• Designed, created and executed test cases based upon business requirements and system requirements to validate system
functionality.
• Analyzed and documented test results, investigated discrepancies and tracked issues.
• Helped in takafulization (Conversion of some conventional insurance terms to Islam-accepted insurance word/s) forms for Islamic
Insurances.
• Monitored the performance of the injected programs. (Minimal fine tuning experience)
ACCENTURE PHILIPPINES
Senior Software Engineer JULY 2005 – JAN 2006
Accenture is a global management consulting, technology services and outsourcing company. Combining unparalleled experience,
comprehensive capabilities across all industries and business functions, and extensive research on the world's most successful
companies, Accenture collaborates with clients to help them become high-performance businesses and governments
Client : SC Gas
SC GAS is a subsidiary of Southern Company, the premier super-regional energy company in the Southeast United States. The century-
old company is known for its excellent customer services, high reliability and competitive prices and was rated No. 1 among electric and
gas utilities on Fortune Magazine’s Most Admired Companies. Southern Company GAS is one of Georgia’s largest natural gas
providers, serving approximately 200,000 customers with a commitment to providing competitive prices and the highest level of service.
• Gave aid to Accenture Business Services for Utilities client in Canada
• Handled RMT’s (Request Management Tool) for Unix and Oracle PL/SQL
• Prepared Detail Design, Test Plans and Test Scripts for every RMT assigned
• Created, modified, tested and fixed bugs and errors in Unix and PL/SQL
• Monitored user requirements and made sure that the RMT assigned is delivered on time
• Provided support for product enhancements that meet the customers’ requirements
• Designed, created and executed test cases based upon business requirements and system requirements to validate system
functionality
• Analyzed and documented test results, investigated discrepancies and tracked issues
• Performed application fine tuning
CYTRONICS INTERNATIONAL INC., Philippines FEB 2000 – JULY 2005
Project Manager/System Analyst
Cytronics International Inc. (CII) is an information technology (IT) services Company established back in 1988. It was founded by
professionals having a combined total of over 300 man-years of comprehensive IT experience. It was established primarily as an
organization that specializes in providing IT manpower resources to various organizations.
Client : Makati City Hall
Local Government Information System (LGIS) is composed of 30 applications, categorized as follows: Revenue Generation, Financial
Management, Administrative Support Planning and Development Building Permit, Barangay Operations, Legislative Management,
Point of Payment System and Executive Information System.
• Analyzed, Designed and partially coded a full Accounting System that is modular and integrated (captures the following modules:
Account Receivable, Account Payables, General and Subsidiary Ledger, Cash Management, Fixed Asset and others).
• Produced technical designs and specifications from the functional requirements, development of functional and technical
specifications into working application modules In addition to completing documentation and testing ultimately working with other
developers to incorporate code into a larger application. Such application/system are: Accounting System, Procurement, Inventory,
Document Tracking, Public Safety, Asset Management, Cash Collection and other systems.
• Provided progress or status reports to the project’s consultant, these include problems encountered during system development
phase
• Ensured relevant technical specifications and processing information of integrated solutions are communicated to the interface
systems teams and operation teams
• Involved in an end-to-end solution design, development, project management, testing and roll-out
• Designed, created and executed test cases based upon business requirements and system requirements to validate system
functionality
• Analyzed and documented test results, investigated discrepancies and tracked issues
• Facilitated small to medium size group meetings for information gathering and problem solving
• Elicited requirements thru facilitated workshops, interviews, review of existing systems and/or business documents and feedback
loops to customers, users and managers
• Collaborated with software architects/DBA to develop both high level and detailed application models that meet the business needs
• Proactive in identifying inefficiencies in system use from a technique or process viewpoint and proposed changes that may include
process redesign and/or system enhancement
• Monitored process performance (e.g. requirements management, testing, etc) and recommended process improvement actions
aimed at elevating product quality across the entire organization
• Assisted in prioritization of requirements/product features and balance against development and implementation schedules.
• Full accountable for ensuring development projects are on schedule
• Evaluated programmers’ development and working capabilities
• Contributed to Feasibility & evaluation activities and peer reviews
Other Projects under Cytronics Internation Inc.
• Social Security System : First project assignment was with Social Security System that handles the contribution made by private
employed individuals, SSS BOIS or Branch Online Inquiry System has Pension and Funeral modules.
• Questronix (Client: Social Security System): Associate Programmer
• Hewlett Packard (Client: Globe Telecoms): While leading a big team, I was called to partially work in HP for their Globe
Telecommunication client.
• Goodyear Philippines
• Participated in system presentation/demo of LGIS for possible future clientele.
EDUCATION
POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
Bachelor of Science, Industrial Psychology; March 1998
TRAINING AND CERTIFICATION
Pentasoft/Aetins
• PentaISF • •
Technical Standards Risks & Products in Life
Insurance
• • •
Insurance Concepts (Life & General) Analysis of Premium and Sum Fundamentals of Islamic
Assured Insurance
Kosher Software
• VB.Net & ASP.Net • •
MS SQL Server JavaScript
Accenture
• • •
PL/SQL Application Testing Leadership
• • •
Developer 2000 UNIX Capability Maturity Model
(CMMI)
Cytronics Internation Inc.
• PL/SQL • •
UNIX Designer 2000
• Developer 2000 • •
Oracle Web Programming PowerBuilder
• SQL Plus • •
Oracle (Character Based) Delphi
Baker & Taylor
• Agile Development
• Visual Studio
• Oracle Certified Associate (OCA)
ADDITIONAL INFORMATION
Nationality Philippines
Gender Female
Status Single
US Work Authorization H1B
Contact this candidate