• Confidential offers over twenty years of Information Technology experience as a Senior Technology Analyst and Technical Project Lead in numerous projects involving Application Development, Software Solutions and Process Improvement towards operational excellence.
• She has expertise in projects involving Data Migration, Data Analysis and Report Development, Database Technologies and ETL Development, Manufacturing Execution Systems, Calibration Systems, System Support and Administration, Web development and administration.
• She is proficient in all aspects of Business Objects and Crystal Report reporting application, MS Access DB, Oracle Database and technologies, PL/SQL and similar query languages, UNIX and shell scripting, Microsoft Project, Informatica Powercenter and Web Portal Application.

Applications Systems Knowledge

Project Profiles Employment History

Confidential

Developer/Systems Analyst Unix, PL/SQL, Oracle

Assigned as a contractor through LiquidHub Consulting to work with the third party software developed by FISERV within the project upgrade and configuration for the Middle Office.

Responsibilities included:

Worked as a developer and systems analyst for the upgrade project and configuration of the third party software developed by Fiserv. Utilized varied skills related to recommending solutions and configurations including UNIX, ETL, PL/SQL, TIBCO, FISERV, SQL and Cognos Framework Configuration. Designed, developed, tested and implemented unix and pl/sql code as needed to aid their upgrade project and daily solutions. Revised their Cognos Business Views after the upgrade projects and later on designed Cognos baseline reports for the business team.

Confidential

Production Support Analyst

Assigned as a contractor through LiquidHub Consulting to work with the production support group for the legacy application called CCRIS Commercial Credit Receivable Inventory System

Responsibilities included:

• Worked as an on call production support for the application. Daily activity involves addressing reported production problem, bugs, and issues within the agreed resolution implementation. Recommends solution, finding the root-cause, coding and design for solution, change implementation and deployment to production.
• Technologies used: Oracle DB, Oracle Forms, PL/SQL, Perl Shell Scripts, Pro C, and Crystal Reports. CCRIS Commercial Credit Receivable Inventory System is a DLL commercial finance system used to create and maintain relationships between vendors and dealers allowing the approval and invoice process to flow.

Confidential

Senior Technology Analyst

Consistently delivered expertise on maintaining the Enterprise System Calibration Management, provided technical knowledge and systems analysis for Reports Development, provided expertise on Data Analysis for Data Migration from legacy Wyeth to the Pfizer EAMs Asset Mgmt. System

Responsibilities included:

• Worked as the technical lead for EAMS Enterprise Asset Management System migration project tasked to design mapping and solutions for data migration of legacy enterprise CCMS system.
• Worked with cross-sites global business teams to provide functional and business expertise on software release management and custom core solutions, upgrades and break-fix processes, installations and configuration, testing, qualification and validation, deployment, training and level-3 support for the enterprise core solution called Blue Mountain Calibration Manager CCMS .
• Designed and implemented the solutions delivery process for our global resource outsourcing solutions. Managed projects relating to CCMS Report Optimization project to improve performance of reports with a known bottleneck in cross-sites processing.
• Project manager and deployment lead for CCMS Enterprise solution to the Wyeth Nutritional sites in Asia, specifically China and Philippines. Managed the migration of manual paper calibration system to the validated computerized system involving development of custom solutions, configuration and installation and deployment and validation process supporting Go-live
• Technologies used: Crystal Developer, MS VISIO, MS Project, MS Access, Oracle Toad, Visual SourceSafe, SharePoint, BMQR Calibration Manager, SAP-xMII, Oracle, MS SQLServer, Documentum, and Web services.

Confidential

Senior Software Engineer

Responsibilities included:

• Worked as a consultant from Accenture directly reporting to AstraZeneca BIS Sales Tools and Operations Support team.
• Responsible for loading monthly IMS/Sales data provided by IMSHealth and made available for AstraZeneca field sales supporting the application interfaces for the Sales force Contact Management System called Compass and Northstar used by the field sales.
• Provides level-3 support to current core system problems. Responsible for different operational activities and adhoc requests, project management, system analysis, QA/testing, programming and development, scripting, testing and technical documentations.
• Technologies used: Unix, Oracle, PL/SQL, , SQL plus, Autosys, Visual Source Safe, SCCS, Pro-C, PERL program and other related skills for design, coding, testing and implementation.

Confidential

Senior Software Engineer / ETL Data Architect

Responsibilities included:

• Worked directly with the Global Data warehouse team that provided business solutions to cross functional units.
• Designed, revised and implemented mappings within the repository that addressed current production problems.
• Designed backend jobs that managed the Informatica Powercenter processes that deliver data to the front end web reporting tool using Microstrategy.
• Formally trained using UNIX Kornshell scripting and Informatica Powercenter, involved in the design, development, testing and implementation of Global Purchasing workbench data warehouse project.
• Acquired proficient skills in Informatica Powermart ETL tool, Unix Kornshell, PL/SQL and SQL Plus reports. Provided core solutions support for Manugistics Supply Chain System migration projects.
• Designed the report and batch programs to assist core system day to day activities.Designed and developed interface system for Manugistics Oracle database to export/import manufacturing and planning data from AS400 and Mainframe databases.
• Technologies used: Informatica Powermart ETL tool, Unix Kornshell, PL/SQL and SQL Plus reports, Unix Kornshell, PL/SQL and SQL Plus, also AUTOSYS, Connect: Direct network utility and PVCS dimensions.

Confidential

Application Developer / Software Engineer

Responsibilities included:

• System ESS, a customer-driven supply chain management software and solutions that include demand replenishment order entry, delivery/shipping, invoicing and billing procedures. As part of the Customs-Solutions Group, involved in the analysis, integration and customization for clients.
• Technologies used: C, PL/TRIM, PL/SQL, Oracle and UNIX

Confidential

Reports Designer / Systems Analyst

Responsibilities included:

• Delivered solution to their reporting problems. Designed and developed customized reports for health care provider clients such as Independence Blue Cross.
• Enhanced report query for optimal performance. Involved in development and testing of reports. Performed testing and quality assurance solutions to the reports to be delivered to client
• Used Crystal Reports 5.0 as the reporting tool interfaced with M-database.
• Delivered solution to their reporting problems. Designed and developed customized reports for health care provider clients such as Independence Blue Cross. Enhanced report query for optimal performance. Involved in development and testing of reports. Performed testing and quality assurance solutions to the reports to be delivered to client Used Crystal Reports 5.0 as the reporting tool interfaced with M-database.
• Technologies used: Crystal Reports, MS Access, SQL-Server

Confidential

DBA / Reports Development

Responsibilities included:

• Formally trained as Oracle DBA with job training in Arizona and New Mexico sites.
• Designed and developed customized reports for shop floor control manufacturing execution system WorkStream
• Administered production Oracle database and Crystal report servers, VAX System VAX 4705, 7730s series OpenVMS 6.1 .
• Managed real-time data transfer between Rdbms database and DecRdb across plants using Real-Time-Reporting on 24x7 production support.

Technologies used: Crystal Reports, Oracle, SQL Server