PROFESSIONAL SKILLS:

Database skills: SQL, Relational and No SQL database modeling, entity relation diagrams, star schema design (Kimball methodology), NoSQL modeling, understanding data warehouse concepts, ETL development, dashboards design. Cloud computing concepts.

Analysis: Technical analysis, workflow analysis, software system analysis, data analysis, data discovery, Jira stories creation, Confluence documentation.

EXPERIENCE:

Data Architect

Confidential, Honolulu

Responsibilities:

• Analysis of Sabre IX real time passenger data feeds for Passenger ODS project. Meeting with business owners to gather objectives, functional and non - functional requirements, business rules. Meeting with data feed owners and analyzing data feed structures and methods of data delivery. Logical database model using ER/Studio.
• Architected solution for capturing real time baggage data into MongoDB ODS. Project included thorough business analysis, understanding IATA standards for event messaging, logical design, and physical database design. Logical design of system and process APIs. Technology used: MongoDB, MuleSoft, Brock Solutions. Generating logical (ER) and physical(NoSql) data model.
• Architected solution to bring enterprise level reference data to Snowflake analytical platform.
• In role of data architect participated in various projects using Sabre TDB, Sabre ACS and RIS Revera data. Projects included logical and physical data designs in staging and fact level area of EDW. Used ER/Studio to re-engineer various data marts.
• Worked closely with team of onshore and offshore database developers and DBAs.
• AY Tax reconciliation reporting. Designed algorithms for calculating AY tax based on government requirements. This included round trips, open jaw and one way in PNR itinerary. Designed workflow to recalculate AY taxes for previous 2 years.
• Excess Baggage reporting. Designed report to identify potential revenue leaks in processing baggage fees. The project included utilization of Sabre TDB and Sabre ACS data. The reports were designed to drill down to PNR level where user could examine all baggage transactions under PNR, including self-service check-ins by kiosks and agents check-ins.
• Airport Check-in System (ACS) data utilization project. Data discovery for utilization of ACS data in various projects (EMD, excess baggage and other potential usage).

Technology used: MongoDB, SQL Server, Snowflake, MuleSoft, ETL, Data modeling tools ER/Studio, Visio, Jira, Confluence. Brock Solutions.

System Analyst/Database Business Data Warehouse/BI Developer

Confidential, Honolulu, Hawaii

Responsibilities:

• Conducted multiple interviews with business stake holders.
• Helped business stake holders to define goals and desired outcomes.
• Created requirement documentation based on interviews with business stake holders.
• Worked with developers and database administrators to assure proper outcome.
• Helped with QA.
• As data architect:
• Redesigned, automated and implemented various previously manually run reports using T-SQL, ETL SSIS, SSRS, Power Pivot Excel.
• Ad hoc queries, data sourcing, data mapping.
• Designed data warehouse and data mart objects using Kimball methodology. Project included bus matrix, star schema, dimensional and fact tables. Developed ETL processes to upload data to data warehouse.
• Developed ETL process to upload and cleanse data from over 3000 log files. The project included data profiling.
• Designed and implemented ETL streams for retrieving data from across various multi-platform sources such as: Oracle, SQL Server, MySQL, MS Access, Excel, XML, flat files.
• Installed and maintained SQL Server instance. Created databases for staging area, data warehouse and data mart.
• Developed KPI Excel Dashboards using Excel PowerPivot and DMX queries
• ETL, T-SQL and SQL programs to gather data for various Business Intelligence projects. Created SSRS, Power Pivot for Excel reports
• Created mission critical geographical reports with Map Info (Pitney Bowes) software using geocoded data.
• Maintained and administered data warehouse. Controlled user access updated slowly changing dimensions (SCD) 1st and 2nd.

Technology used: SQL Server, Data Tools, SSIS, SSRS, SSMS, Toad, Oracle Developer, SQL, T-SQL, Excel, Power Pivot, MapInfo by Pitney Bowes, proprietary software: ScoreCard (OLAP data warehouse, SQL Server), Sentori (OLTP billing database, Oracle), MySQL point of sale database.

Data/Sytem Analyst

Confidential, Honolulu, Hawaii

Responsibilities:

• Development of customized banking reports in SQL Server Report Builder, MS Access.
• Data analysis. Technical specs. Business flow analysis. Flow charts. App prototypes.
• Reverse engineered “End of the day” batch processing.
• CORE banking system. Participated in Core system conversion to Symitar banking system.
• Database design, logical (ER), physical.
• Build a sample company iPhone app for locating branches, ATMs and shared branching together with banking calculators.
• Developed company web site specs and build prototype. Managed design and development.
• Managed IT side of merger with another credit union. Conducted meetings, organized resources.

Technology used: MS SQL Server 2008, T-SQL, SQL Server Report Builder, MS Access, SQL, Microsoft Environment, XCode, Objective-C, Cocoa Touch, OS X, Windows, Virtual Box, Gliffy, MS Office, Adobe Fireworks.

Freelance iPhone App Developer

Confidential

Responsibilities:

• Design and development of ten database iPhone/iPad applications in partnership with National Swimming Pool Foundation (based in Colorado Springs, CO). Applications were sold in Apple App Store under Confidential and NSPF brands.
• Ongoing updates and development of database iPhone/iPad apps.
• Used Core Data, SQLite and StackMob cloud database technology for data store.
• Design database ER diagrams. SQL, NoSql databases.
• Developed iPhone web apps using JavaScripts and mySQL.
• Managed outsourced programmers in China, India, Russia and Slovakia.
• Managed development of Android apps.

Technology used: Objective-C, Cocoa Touch, Xcode, Core Data, Dashcode, Adobe Dreamweaver CS4, Java Scripts, Adobe Fireworks CS4, MySQL, myPHPSQL administrator.

Chief Technology Director / DBA

Confidential, San Mateo, CA

Responsibilities:

• Developed mission critical database systems for gathering business intelligence and tracking business activities.
• Set up company computer network (Windows).
• Built and maintained a web site (MS FrontPage).
• Interviewed, screened and hired technical staff.
• Managed technical staff.
• Managed outsourced oversea technical staff.
• Responsible for setting up business process flow.
• Implementing bookkeeping and accounting rules and procedures, including data flow, A/R process and timesheet tracking process.

Oracle DBA Contract Positions

Confidential, San Mateo, CA

Responsibilities:

• Developed Unix scripts for monitoring Oracle database and Unix system performance and activities.
• The scripts produced and distributed various reports, created warning signals and alerted DBAs and Unix Administrators about possible problems.
• Generated e-mail and pager alert massages

Technology Used: Oracle 8x, Sun Solaris UNIX, PL/SQL, Unix scripting, Erwin

Oracle DBA Contract Positions

Confidential, Cupertino, CA

Responsibilities:

• Responsible for administration of distributed web-based databases tracking R&D data from various development teams around the world.
• Oracle software installation on IBM AIX Unix.
• Database design and implementation.
• Physical and logical design using Erwin.
• Capacity planning.
• Troubleshooting.
• Performance monitoring.
• Performance testing using various tools to measure performance of queries.
• Back up policies.
• Setting up security policies.

Technology used: Oracle 7x, PL/SQL, AIX Unix, Unix scripting, Apple Power Station, Apple O/S, Windows, Oracle Enterprise Manager, Erwin.

Oracle DBA

Confidential, Santa Monica, CA

Responsibilities:

• Administered and developed tracking system for on and off campus education, inventory tracking and accounts receivable.
• Responsibilities included installation and configuration of Oracle software on Windows NT and DEC Unix.
• Creation of physical database for development, testing and production.
• Capacity planning.
• Participated in database design including entity relation diagram development and maintenance Setting up back up policies.
• Setting up security policies.
• Created ETL PL/SQL streams to upload data to database from various sources.

Technology used: Oracle 7x, PL/SQL, Alpha 2000, DEC Unix, Erwin

Software developer

Confidential, Camarillo, CA

Responsibilities:

• Developed Oracle front end prototypes for migration mainframe-based inventory control system to Oracle database.
• Developed MS Access database for top management information gathering activities. Identified user requirements, designed database schema, developed and implemented and delivered system to client.
• Took initiative to design and develop a system for maintenance and processing data tapes. This system produced lower rate of tape failing in batch processing time, save client time and money for troubleshooting and maintenance.

Technology used: Oracle 6x, PL/SQL, Windows 3.1, MS Access, Unisys 1100, Cobol, Unisys Database, VSAM, ISAM