Senior Informatica Developer
Resume:
CRISELDA M. TARUN, PMP
Home 905-***-**** Cell 416-***-****
*******@*****.***
http://ca.linkedin.com/in/cmtarun
SUMMARY
A dedicated IT professional with 16 years of solid technical and business experience in a global environment. Experienced developer with effective project planning expertise and proven track record for successfully completing projects on time and within budget. Managed and implemented small to large size system projects encompassing enhancements, re-engineering and full life-cycle implementations in different modules. Liaised with various members of internal (business user, validation and IS) and external (vendors and consultants) groups for project activities and issues. Strong technical troubleshooting and analysis skills balanced with excellent strengths in communication, teamwork, and leadership. Collaborates well with multi disciplinary teams.
PROFESSIONAL EXPERIENCE
KIK CUSTOM PRODUCTS Concord, ON 2011
One of North America's largest custom manufacturers of both National Brand and Retailer Brand consumer products.
Senior Programmer Analyst
Customized and created programs that supported Business needs in JD Edward’s World environment.
WYETH PHARMACEUTICALS (a Pfizer Company) Markham, ON 2005 - 2010
Wyeth is one of the leading manufacturers and distributors of pharmaceutical, biotechnology and animal healthcare products worldwide.
Senior IT Specialist
Designed, developed and facilitated a variety of projects that met business requirements and improved business processes involving strong collaboration with local and international colleagues.
* Spearheaded and completed the design, development and implementation of a global data extraction project for JD Edwards (JDE) spend data (16 countries, 25 sites) using Informatica PowerCenter (ETL) for business analysis (BI Initiatives) that led to significant project cost and time savings.
* Key player and contributor in developing the global project strategy to decommission JD Edwards system.
* Led the design, development and implementation of the JDE decommissioning project using Informatica PowerCenter that reduced development and implementation cost and time.
* Successfully led the implementation of SAP interface project using Informatica PowerCenter and provided first-line support resulting in user’s satisfaction, this includes any enhancement and development of Informatica mappings. Documented all additions and modifications to the programs.
* Initiated design and development of a Cognos (BI) based sales data warehouse solution using Informatica PowerCenter with user’s satisfaction and created technical documentation. Used type II slowly changing dimension.
* Successfully created and implemented various ETL projects using Informatica PowerCenter 6.x/7.x/8.1 that loads data from DB2, flat files and other data sources to Oracle, SAP BW and other targets used for reporting. Created mappings for both full and delta loads.
* Successfully developed Informatica mappings for Tax audit requirements.
* Successfully administered Informatica PowerCenter. Additions or modifications to programs are being recorded in the Peregrine systems (Service Center) which are approved by the Change Control Management Committee (CCMC). All program migrations are done following the approved Working Instruction (WI).
* Performed thorough data analysis to generate files and created Cognos reports for internal GMP (Good Manufacturing Practice) compliance and regulatory group audit requirements such as Product Recalls Report and financial tax audit information for Canada Revenue.
* Involved in the analysis and documentation of the conversion of a reporting solution from Siebel Analytics to Cognos.
GOODRICH AERONAUTICS, Oakville, ON 2005
Goodrich is a leading global supplier of systems and services to the aerospace and defense industry.
Analyst/Programmer
Supported business needs including JD Edwards’s administration and RPG development.
WYETH PHARMACEUTICALS, Markham, ON 2003 - 2005
Contract Analyst/Programmer
* Managed and led a global project implementation that screens JD Edwards Customers (25 countries, 100 sites) using RPG development.
* Provided all technical documentations using Documentum and presentations to affiliates for the global project.
* IT lead person for the Global Spend Project Proof of Concept using Informatica, Power Center which became Wyeth’s corporate ETL tool (7 affiliates).
UNITED LABORATORIES INC., Mandaluyong, Philippines 2002 – 2003
A pharmaceutical company that develops and manufactures prescription and consumer health products in the Philippines.
Contract Analyst/Programmer
* Assisted in the JD Edwards implementation of Accounts Receivables, Sales Order and Inventory modules of an affiliate.
WYETH PHILIPPINES INC., Makati, Philippines 2000 – 2002
Contract Analyst/Programmer
* Developed new and modified existing JD Edward’s screens and reports in different modules.
* Enhanced JD Edward’s manufacturing program such as Work Order Allocation and printing improving business process.
WARNER LAMBERT PHILIPPINES, Pasig, Philippines 2000
Manufacturer of pharmaceutical, consumer health care and confectionery products.
Contract Analyst/Programmer
* Developed new and modified existing JD Edward’s Financial & Fixed Asset reports.
Previous positions in the Philippines prior to 2000 include:
Consultant, Contract Analyst/Programmer, Analyst/Programmer/Group Leader
Worked with clients, in-house and external programmers and performed system analysis, design, development and implementation activities for system enhancements and new functionality in different modules to support client needs. Mostly JDE (World version) activities.
Clients/Company: Ayala System Technology ,Inc. , EDS International Phil. Inc., Astra Pharmaceuticals Philippines, Honda Cars Philippines, Kraft Food Philippines, Dole Philippines, Ayala Land Inc., Cargill Philippines Inc.
EDUCATION
Bachelor of Science - Computer Science
AMA Computer School, Quezon City, Philippines
PROFESSIONAL TRAINING & ASSOCIATION
Courses Attended :
* Data Warehousing & Business Intelligence Tools
* Unix Shell Fundamentals
* Unix Shell Scripting
* Cognos 8 BI Report Studio : Author Professional Reports Advanced (8.4)
* Cognos 8 BI Report Studio : Authoring Professionals Reports
* SAP BW (BW 305) – Reporting & Analysis
* SAP BW (BW 310) – Data Warehousing/Loading
* Oracle Database 10 g : Introduction
* Informatica Power Center Developer
Association :
* Member of Project Management Institute (PMI)
Contact this candidate