OBJECTIVE: Seeking a challenging career in an ideal company with a high level of passion for quality service, a unique organizational structure, common methods, and shared values.

SUMMARY OF QUALIFICATIONS:
Over 28 years (since 1985) of broad professional data processing knowledge and Information technology experience in designing and developing systems, databases and applications software development in Telecommunication, Banking, Healthcare, and Manufacturing industries.

Extensive experience and significant strength in:

• Design/Implementation/Maintenance Systems and Applications
• Crystal Reports - Develop Comprehensive Business Metrics
• Proficient in Report Writing and Data Extraction
• Database Administration - RDBMS
• 24x7 Production Support for Business Continuity
• Disaster Recovery Technical Support (planned and unplanned downtimes)
• Application Development / Implementation
• Data Replication
• High-level System Design and Planning for New Business Solutions
• Tuning Systems and Applications for High Performance and High Availability
• Fine tuning Ad-hoc and Scheduled Queries (Performance vs. Data Integrity)
• System/Data Architecture/DBA/Modeling Logical, Conceptual, and Physical
• Transactional Data Management for heterogeneous systems
• Project Manager Methodology and Design
• Data Warehousing - Data Marts - Cubes
• Ability to work in a Multidisciplinary Team
• Customer and Operation Support - 24x7
• Excellent Communication and Graphical Presentation Skills.

EMPLOYMENT HISTORY:

Confidential - CA 10/2011 - Present
Software Developer - Crystal Reports

• Analyze, design, develop and implement metric reports using SAP Crystal Reports against multiple database systems
• Enhance performance and accuracy of existing reports by tuning their formulas and data access methods

Confidential 10/2011 - 10/2012
System, Database and Application Developer Analyst

• Crystal Reports Development BI reports
• Extract, Transfer, Load (ETL) data to 3rd party systems
• Advanced the operational efficiency of the use of MSOW Physician Credentialing reports.
• Provided second level problem determination and resolution of GECE CPOE Order module.
• Responsible for the education of customers as to the solution of software problems by answering questions, interpreting operating instructions, and providing references to the administration of end user applications systems.
• Responded promptly to Help Desk notifications, customer complaints, and customer inquiries.
• Monitored the in-use Help Desk application software, responded to calls received via pager or cell phone.
• Data cleansing - Orders module
• SQL database reports maintenance

Confidential - CA 4/2011 - 10/2011
System, Database and Application Support Analyst

• 24x7 supports for production GECE modules activities: NS system monitoring/maintaining; SQL and Enscribe database enhancing, reports (coding, troubleshooting and bug fixes); Migrate database to target database via GoldenGate.
• Design, create, and develop Master Data Management in SOA for Healthcare industries.
• Produced the Patient Master Index blueprint for generic healthcare routines.
• Enhancing SQL for LOB entities

Confidential - NY 5/2010 - 4/2011
System/Data Base Designer for GE Centricity Enterprise

• Performed and administrated data replication between Tandem and SQL Server
• Designed, created, implemented and maintained the SQL Server PRISMStage databases
• Built the ability to generate ad-hoc reports that will report analytics and quality measures real-time from the Prism application
• Provided 24x7 technical support for PRISM database replication
• Load balance GG processes in HP Operating System
• Reproduced databases in SQL Server for clinical data marts
• Worked with Tandem and NT teams and provided full level support and troubleshooting
• Data mining

Confidential, SLC, UT 10/2006 - 5/2010
System/Data Base Administrator for GEH Centricity Enterprise

• Performed administration and provided operational support for IHC corporate databases including backup, recovery, system availability, performance tuning, installation, security, and troubleshooting
• DR (Disaster Recovery) - RDF and Golden Gate
• Designed and developed ECIS SQL relational database for ECIS Moxie project
• Assured that the Intermountain Healthcare Emergency Care implementation Milestones are met to contribute to the Intermountain Healthcare board goals for GEH Helix and beyond by providing full database and system support to pass successfully the Alpha and Beta phases by Feb 15, 2010
• Developed solutions to several complex ECIS problems across multiple platforms, technologies and computing environments
• Provided full support to Intermountain Healthcare TSA and DBA teams to successfully install three CE releases
• Monitored the Production and QA systems to support maximum system stability and availability. This has been an on-going task for both Prod and QA, which are performed daily in each system.
• Identified and resolved several unplanned and planned downtimes.
• Recommend solutions for system design at the enterprise level. Evaluated database alternatives or new technology for integration with existing enterprise applications and architecture
• Performed research and prepared technical studies and made recommendations. Prepared requirements, feasibility studies and cost justification statements
• Installed Moxie 1.4 into QA and Production
• Consulted with clients and management to guide strategy for infrastructure, architecture, and cross application integration on GEH/IHC ECIS large and complicated project. Consult with both GEH and IHC IT staff to determine impact of new applications or technology on ECIS infrastructure
• Led colleagues by conduct and example
• Performed project tasks as directed. Met agreed-upon schedules with quality
• Adhered to department values, policies, procedures, and security/confidentiality requirements. Respect individual contributions while promoting a cooperative team environment. Followed department-specific standards and methodology.
• Reviewed GEH installation documents to avoid any anomaly against QA and Production systems. Reduced the length and number of downtime for future planned downtime sessions. Designed and implemented pre-downtime processes.
• Encouraged and fostered mutual respect with people by patience, listening, and spending more time with IHC and GEH team members that I work on daily basis by journaling the daily activities and systems performance statistics. Acquired mutual respect oriented feedbacks from my teammates using 360 reviews.

Confidential, MN 8/2005 - 9/2006
System/Data Base Administrator for GEH Centricity Enterprise

• Design/develop/Implement successful quarterly File Maintenances
• Design/develop/Implement Multi-Node schema for Enscribe and SQL databases to improve system performances
• Implement Switch and Stay (for Database) routines for DB
• Support Life Science DB2 data replication from Tandem
• Improved metrics for planned File Maintenances
• Develop guidelines and recommendations for Unplanned downtimes
• Using Golden Gate file replication to reduce the duration and frequency of downtimes as the result of required file maintenances.
• Support Development department in prototyping database objects
• Support Change Management team for installing GE software and Mayo home-grown applications
• Support TSA on daily basis
• Support Mayo Development and Change management teams
• Routine database growth monitoring using Prognosis

Confidential, San Diego, CA 4/2002 - 8/2005
Data Base Administrator for GE/IDX Carecast

• Database administration for all entities of Sharp HealthCare pertaining to implementation, maintenance and support of Carecast Electronic Medical Record (EMR) applications and others that rely on Carecast relational database technology.
• Responsible for the database integrity and growth. Performs functions involved with the implementation, maintenance, and support of EMR systems housed in the Data Center to ensure maximum continuity, availability, and efficiency of computer service. Performs configuration management, maintenance, and performance analysis to ensure structure and database integrity.
• Provides call-back support for the EMR analysts, Computer Operations, and for the Help Desk for Technical Services problems or questions.

Confidential, Bronx, NY 12/2001 - 4/2002
Sr. Tandem Consultant/ Project Manager for IDX Carecast

• Managing, mentoring, designing, coding, testing, and implementing LastWord Patients' Encounter Worksheet Enform reports on the Tandem environment.

Confidential, Scottsdale, AZ 9/2001 - 12/2001
Database Administrator/ Project Lead

• Designing, coding, testing, and implementing data conversion for NDC5.1 HIPAA Implementation Group 1 on the Tandem environment.
• Led, designed and implemented Tandem DBA data conversion tasks checklist.
• Creating and loading a set of renovated tables with strategies for the fallback.
• Comparing and validating the loaded tables.

Confidential, Seattle, WA 6/2001 - 9/2001
Database Designer/ Project Manager

• Managed, designed and developed IDX LastWord's Enscribe Database XML Schema project.
• Data warehousing project life cycle, especially tasks within the ETL phase
• Mapped the business requirements with the IDX legacy systems
• Designed and developed the extract, transformation, load process, data mart design, developing reports.

Confidential, Seattle, WA 11/2000 - 6/2001
Business Information Engineer [Data/Domain Architect]

• Responsible for managing and coordinating the creation of data models, XML Schemas, and transformation rules that satisfy customer requirements.
• Utilized most effective techniques in Information Theory to create data schemas that are based on advanced XML technologies.
• Responsible for modeling disparate data requirements to information-based solutions using Information Theory, XML vocabularies, and other proprietary, analytical techniques.
• Acted as liaison between product development and customer requirements as they relate to future product features and product strategy, to ensure feedback from the customer world is forwarded to engineering so that product strategy can meet market demands.
• Acted as liaison between product management / marketing and market realties - provide feedback to marketing to ensure positioning and differentiation is consistent with market realities.
• Built implementation guides and integration kits for System Integrators, partners, so that they can market, sell and deploy Nimble's software in cooperation with full support.
• Participated in pre-sales activities related to customer education and consulting.

Confidential, Bellevue, WA 6/2000 - 11/2000
Data/Domain Architect - Project Manager

• Microsoft - Designed and reviewed the content of the exam for SQL Server 2000 as a Subject Matter Expert with the emphasis on the Designing and Implementing patterns of the questions. Discussed objectives and a preliminary test plans.
• Honda - AutoSales e-Commerce Site Release 2. The database design phase outlined the architecture of their vision. Designed the logical data model that gave an overview of how data was captured in various entities and their attributes to accommodate the business rules. In addition it also depicted the various relationships that explained the relevance of the data. The SQL Server Database used as the data dictionary that contained the physical specifications for all of the tables. The emphasis within this database schema was performance and speed of execution, with some emphasis in redundancy minimization and flexibility in design.
• Designed an industry standard data format for the Export and Import of Automobile Customer leads using XML.
• Accumulated and enhanced knowledge in E-Commerce fundamentals and e-Business strategies.
• Interacted with clients to gather and implement specifications for Internet/E-Commerce development and business process improvements.

Confidential, Seattle, WA 11/1998 - 6/2000
Data Architect / Modeler / Administrator for IDX Carecast

• Designed and developed LastWord SQL relational database from the Single-Based file system.
• Used Power Designer's Data Architect and Rational Rose case tools to produce Conceptual and Physical data model for LW SQL.
• Researched XML technology for Healthcare (HL7).
• Used XML Authority tool (by Extensibility) to model Conceptual and Physical Semi-Structured data model for LW XML database.
• Implemented policies and guidelines that enable consistent, assessable and valued data to be used in the development and maintenance of products throughout the company, through the application of common data architecture, regardless of the technology platform, with common terminology, data definitions, structures, policies and procedures.
• Responsible for design, development and maintenance of product data models, including the business model and physical design, and Tandem-specific implementation elements.
• Worked closely with the Database Administrator, software engineers, product managers, and users to develop model designs, implementations and documentation.
• Defined overall data needs, analysis and design standards, database implementation strategy, data access methods, and database maintenance requirements.
• Led company wide efforts to ensure that requirements and designs of data-related products with knowledge of the healthcare industry are appropriately integrated with the entire product line.
• Responsible for performing tasks that support a logical view of the data as well as the physical translation of the logical view into a technology specific physical implementation, include the creation and application of a Logical Data Model complete with a text description. Physical support includes tasks such as physical database design (tables or files), data definition (storage characteristics), data security, version control, SQL tuning support, production migration, code table management, access path optimization assistance, back-up and recovery, space management, and performance tuning.
• Assisted the Product Architect in the strategic direction of data-related components of the product, including the definition, development, and/or acquisition of client information management and data access tools.
• Effectively assisted various associates with the data modeling and relational database design activities, including providing internal training on existing product database design and various information management topics, modeling techniques, CASE tool use, and data manipulation using SQL.
• Develop product-specific documentation standards and guidelines as assigned.
• Managed and enforced the standards, and created the new ones as necessary.
• Designed, developed, reviewed, and approved data model and database modifications specified by development and product management staff, before integration into the product design repository.

Confidential, Cupertino, CA 3/1997 - 11/1998
Tandem Senior Consultant

• Provided professional-level computer programming using TANDEM computers including analysis, design, coding, planning and operations.
• Developed the Tandem corporate relational database and application in CABS (SQL and SCOBOL/COBOL85/TAL) used by the clients of Tandem Computers worldwide.

Confidential, San Francisco, CA 11/1996 - 2/1997
Consultant/ Senior DBA / Senior Software Engineer

• Participated as a Tandem technical consultant for the BAAD [Better ATM Availability Delivery] project to prototype a new ATM monitoring and management client/server baseline application.

Confidential, Cupertino, CA 4/1995 - 11/1996
Consultant/ DBA/ Senior Software Engineer

• Developed the On-line Forms application in MRPR (database/server) and TOIS (Client/Server) that is to be used by the managers/employees of Tandem Computers worldwide. This project replaced the old paper routing among managers, employees, and HR personnel with a fully automated on-line PC and MAC workstations.
• Redesigned, developed, installed, and enhanced Tandem-based software for the Form Approval system to include E-mail routing to appropriate managers who are in the approval level chains.
• Enhanced the efficiencies of the SQL cursors as well as coding additional error handling procedures for all embedded SQL servers of On-line Forms application.

Confidential, Houston TX 4/1994 - 4/1995
Consultant/ DA/ Senior Software Engineer

• Led activities directed to the development and implementation on Mobilnet Customer Activation Systems (CAS) on-line and batch processing for six regions across USA.
• Interacted with project managers, software engineers, network engineers and customers to clarify business requirements to develop alternatives and present solutions.

Confidential, Tampa, FL 8/1993 - 4/1994
Consultant/ DA/ Software Engineer

• Designed, developed, installed, and enhanced Tandem-based software for the Fax Me Anywhere (FMA) project that collects and rates the CDR records for each GTE customer to generate bill.
• Solved complex network operations management issues using both FMA and third party point solutions (wireless and wireless with voice, data and multimedia applications).

Confidential Renton, WA 5/1991 - 8/1993
Senior Programmer Analyst

• Analyzed, designed, coded, unit test and implemented customized modules against the user's requirements. Supported Process and Product Document Management (PPDM) software for the manufacturing Engineering Management systems support organization.
• Managed the development support of the Functional Test Management System (FTMS) applications for the SFT Renton Pilot project.

Confidential, Inc., Bothell, WA 7/1989 - 5/1991
Programmer/Systems Analyst

• Led the Bulk Data Transfer project using BCOM for the Puerto Rico Telephone Company from high-level design through implementation that resulted in greater operational effectiveness.
• Developed, installed and maintained components of GTE's large on-line Network Management and Control (NMCC) systems in the TANDEM platform.

Confidential, Seattle, WA 3/1985 - 7/1989
Operation Analyst

• Provided end-user technical support and performed analysis on the performance of medical software applications for major hospitals and clinics nationwide.

TOOLS & LANGUAGE:

• RDBMS - HP NonStop, MS SQL Server, Oracle
• Crystal Reports
• MSOW - Morrisey Credentialing
• Golden Gate: For database replication, maintenance and synchronization
• SQL Server: database administration
• Power Designer / Data Architect: data/process/information modeling via conceptual/physical/object-oriented models.
• Visio 2000 Enterprise: (Automated design and documentation; Database modeling includes business rules and database design and collaboration)
• XML Schema and DTD

EDUCATION:

• Confidential, VA 2012 Certificate, Morrisey
• Confidential, VA 2012 Certificate, Morrisey
• Confidential, CA 2009 Certificate, GoldenGate
• Confidential DBA 2008 Certificate, Oracle
• Confidential (HP) 2007 Certificate, SQL MX
• Confidential, MN 2006 Mini Master, Information Technology
• Confidential, MN 2006 Certificate, Prognosis
• Confidential, CA 2005 Certificate, GoldenGate
• Confidential, Cupertino 2004 Certificate, NonStop MP Query Tuning
• Confidential, Cupertino 2003 Certificate, Several Programming courses
• Confidential, September 2000 Certificate, XML Design and Implement
• Confidential, September 2000 Certificate, Advanced XML/Java
• Confidential, August 2000 Certificate, DigitalThink E-Commerce
• Confidential, July 2000 Certificate, Advanced Facilitation
• Confidential, February 2000 Certificate, Advanced Data Modeling
• Confidential, Dec 1999 Certificate, Data Resource Management
• Confidential LA, Dec 1998 Certificate, Object/Relational DB Design
• Confidential, Dec 1987 Master of Science, Physics
• Confidential, June 1976 Bachelor of Science, Physics

• Member of ITUG (International Tandem User Group) since 1985
• Member of DRUG (Disaster Recovery User Group) since 2003