TRAN T. BINH

***** **** ****** • Fountain Valley, CA 92708 • 714-***-**** • ad352b@r.postjobfree.com

SYSTEM ARCHITECT

SOFTWARE ENGINEERING • DATABASE ADMINISTRATION • TEAM LEADERSHIP Practiced system architect with proven expertise in development and verification of highly adaptable and technically feasible data and information management systems and components for Boeing Company and military contracts. Led teams of highly skilled technicians and programmers in system maintenance, database management, and architecture-aligned software development. Proficient in architecture model configuration, requirements gathering, and trade-off analysis. Demonstrated skill in researching and leveraging latest technology to optimize infrastructures for high-impact companies and government organizations.

CORE PROFICIENCIES

Technical Team Leadership • Strategic Planning • Technical Writing • Database Management Software Design • Process Improvement • System Design & Management • Web Development Service Standard Development • System Backup/Recovery • Requirement Definition • Business Objects Data Integrator

EXPERIENCE & SELECTED ACCOMPLISHMENTS

Anthem, Bus Info Cerritos, Developer CA Senior (EDW) 2012-Present Responsible for a full range of activities to compliance with Government regulations. Support a team of Administrators with data analysis and problem solving, and generate and implement ideas to continuously improve operational efficiency. Extract, manipulate and analyze (ETL) large volume of data from various sources and extrapolate results to existing business processes.

• Develop processes using ETL tools (Data Integrator 6.5), PL/SQL and SQL

• Design and develop ETL processes, data flows, and Data Marts

• Manage production support of existing ETL and data loading processes

• Designing the BusinessObjects reports' Layouts

• Preparing a schema model for Data warehousing

• Providing support for existing Data warehousing applications

• Creating universes, users, views, daily database updations by retrieving the data from various data sources as per the requirement of day to day business requirement

• Customizing new reports using Business Objects 6.5 functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas

• Standardizing the reports by minimizing the manual intervention with the help of stores procedures & Packages.

• Publishing new reports to the users from the central data warehouse THE Computing BOEING System COMPANY, Architect Cypress, (2002-CA 200*-****-**** Developed and verified robust architectures that ensure adaptability and technical feasibility, spearheading all aspects of nationwide requirement-gathering, function development, and programmer assignment scheduling. Reviewed principles and guidelines to streamline architecture practices. Developed and implemented web applications, and maintained and updated enterprise-wide, high-availability EPDW database. Led activities to define, develop, and deploy effective IT processes and computing standards using adaptive or corrective process improvements.

! Develop data models, logical and physical database Microsoft Sql Server 2014

! Maintenance of Database Microsoft Sql Server 2014 -- adding data files, archiving, backup & recovery

• Developed and implemented for enterprise wide web applications Transportation Resource and Management Systems (TRAMS) for Commuter Office. Using Adobe Flex 3.0 as front end (UI), JavaScript to verify users inputs, ColdFusion version 8.0 to build components (CFC) for business logic tier and Oracle database 10g as back end.

• Designed and built ColdFusion 8 accessible components for Flex requests.

• Created and maintained tag-based skinning utilized by Flex requests.

• Created and maintained forms in PDF format using Coldfusion 8.0 and Adobe LiveCycle.

• Created and maintained displaying of maps using Coldfusion 8.0 and MapInfo MapXtreme.

• Updated new patches and maintained effective ColdFusion Application Server 8 performance.

• Created and optimized MS Sql Server T-Sql stored procedures to reduce query time for ColdFusion Report Builder and charts.

• Created and maintained MS Sql Server 2005 logical and physical table structures database back- end

• Used Oracle Data Guard to provided 24x7 support of high availability for enterprise wide EPDW database.

• Utilized SQL scripting to develop MS SQL Server stored procedures and triggers to maintain and update Enterprise People Data Warehouses database (EPDW ) owned by Human Resource Group.

• Designed and implemented backup and recovery methodology for Demand Management database with Oracle RMAN

• Created and employed logical and physical Commuter databases, Microsoft Sql Server 2008, using Erwin database modeler.

• Developed CMMI level 3 documentation for databases, defining database validation requirements to ensure integrity and reliable backup/recovery.

• Administering Business Objects Reports 6.5, including configuration, installation of client and server products, and security

• Report migration from legacy, Teradata and DB2 database systems to Microsoft Sql Server 2008, Business Objects 6.5

• Performance tuning of Business Objects Reports 6.5, universes, and servers

• Developing and implementing large-scale reporting solutions

• PL/SQL coding experience with both SQL Plus and TOAD 9.7 Sr. Database Programmer/Analyst (1996-2002)

Coordinated and directed staff in development, maintenance, and support of databases. Served as key technical staff member for Wired Assembly Group (WAG), coordinating all PC application development, electronic data interchange, and collector/router development work to track F-15s, Tornadoes, and their ammunition for Royal Saudi Air Force. Provide CASE consulting expertise, allowing for rapid prototype, development, and deployment of systems.

• Developed WAG’s invoice recording system to track history of invoices for error correction

• Promoted and lead "Operatio Ready system" project that resulted in significant reduction in call turn- around time and reduced costs. Reverse engineering existing systems (Oracle Forms/Reports based) and introduced many new automated functionalities that produced further cost reductions. Application was written using ASP.Net, ASP, VB.Net, Oracle PL/SQL

• Responsible for advanced application development projects using C/C++ (Windows), Visual Basic,, SQL/PL SQL, Developer 2000, and Microsoft Access.

EDUCATION

Master of Science in E-Commerce

Bachelor of Science in Computer Science

National University – San Diego, CA

Contact this candidate