Pravin Tahiliani
Data Integration Architect @Nasa Ames Research Center
Signup · Get unlimited contacts
WORK HISTORY
Data Integration Architect @Nasa Ames Research Center
NASA Ames Research Center– Moffet Field, CA July 2008: NASA Air Traffic Management Systems (ATM) data warehousing projects using PostgreSQL, Oracle 11g, Erwin data modeling including metadata modeling, Java 1.6 on Red Hat Linux 5.2, Mac OSX, bash and Perl scripting. Responsibilities also include working at Data Center for Infrastructure setup of database servers and NAS storage servers for Moffet and DFW NASA locations.Project 1: ATM plays a critical role in National Airspace System (NAS), as their flight planning decisions have a direct impact on the efficiency and safety of the resultant traffic flows and on contingency plans to deal with possible events that could arise while en route. Their decisions also have an important impact on the operating costs for an airline. Surface Operations Data Analysis and Adaptation (SODAA) tool stores airport surface adaptations and terminal area data for different airports. SODAA capabilities facilitate searching, visualizing, and analyzing airport surface and terminal area data, with the goal of improving understanding of airport surface and terminal area operations. Project 2: NASA NextGen Air Traffic Management System Data warehouse includes sources : LDM- Load data Manager, RUC- Rapid Update Cycle, CIWS – Corridor Integrated Weather System, Center Radar Capture, TRACON Radar Capture, ASDI- Aircraft Situation Display to Industry, CTAS- Center TRACON Automation System includes CM_SIM data, NFDC - National Flight Data Center, ACES - Adaptation Controlled Environment System and ITWS – Integrated Terminal Weather Systems, OTTR - Operational TMA/TBFM Repository – Report of National TMA Metering Usage and Flow (Configuration) Information, SMS CM file, ASCII-based output file, one file per adaptation set per 6 hours, AODB – Airport Operational Database, one file per airport per system restart, METAR – once an hour between 50 minutes past the hour and the top of the (next) hour, ASDE-X binary output - one file per day.
EDUCATION
Thadomal Shahani Engineering College
Bachelors in Engineering, Bio Medical Electronics
California State University
MBA
University of Mumbai
Engineer’s Degree, Engineering
SKILLS
ABOUT PRAVIN TAHILIANI
Senior Data Warehouse Enterprise Data Architect/Integration Lead - expert with over 20 years of experience with an outstanding record of delivering complex technology and system integration projects on time and within budget. • Designing and reverse engineering enterprise systems using multi dimensional (Ralph Kimball’ and Bill Inmon’ approach), metadata modeling and relational system data modeling.• Managed ETL teams including architecture and security done for different environments: development, UAT, SIT and production. Architecting water fall database replication.• Domain expertise with FCC regulations (Telecom), FDA regulations (Healthcare) and FAA regulations (NASA Ames) including SOX compliance.• Handled large volume data warehouse to the tune of 18+ terabytes on NAS storage systems with total volume of 40+ terabytes growing monthly to the tune of 1+ terabyte.• Experience include performance tuning at database level included design changes, adding hints, splitting source data into multiple threads, bit mapped indexes, database parameter changes and modifying sql.• Demonstrated team building, relationship building and communication skills. Mentoring experience in a lead capacity.• Worked on RFP creation and evaluation, project budgets, project savings, project management (offshore and onsite), product decision maker for enterprise level solutions.• Infrastructure architecture and software setup for different environments in data centers.• Presentations to senior management on architecture, team members on projects/technical training and business units on systems.• Conducted in-house and client training on software applications and tools/software used.• Designed/Re-architected projects amounting to company savings to tune of 1+ Million dollars/year.Specialties: Data Integration expert, Architect, Design Specialist - OLTP and multi dimensional data modeling, Project Management.Projects include data integration, migration, synchronization, MDM, data deduplication, data quality and data profiling, and implementation of large and complex enterprise data warehouses using star and snowflake schemas, data access layer, data translation layer. Project planning, organization and management, implementation, infrastructure architecture and budgeting.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.