Description
SUMMARY OF EXPERIENCE About 16 years of experience in IT with expertise in Data Warehouse (ODS-DM-ETL), Oracle Data Base, Exadata Administration / Development, BI, Informatica, Data Modeling and in Analysis, Design, Development, Testing, Implementation and Maintenance of databases (including backup and recovery), PL/SQL, UNIX Shell Scripting, Reporting and front end applications. * In-depth expertise throughout DSS life cycle experience from Business Requirements - Conceptual Design - Detail Design phase - Development - Application Quality Assurance - Go Live - Maintenance. * Successfully designed (logical and physical), setup, developed and implemented the data warehouse for JPMI - from scratch, working with the business team, IT, management and consultants (CSC) . * Successfully stood up the conversion of ERP from SAP to Deltek with Oracle Data Warehouse, playing a significant role in all fronts from the database and the DW design through implementation of the Reporting in Cognos. Lead the setup of all environments from scratch . * Strong analytical and problem solving skills * Efficient in creating, managing and monitoring backup/recovery RMAN, setting up DataGuard * Professional experience with Star/Snow Flake, normalized Schema Design to meet OLAP needs. * Proficient in installing, configuring and performing upgrades of Oracle, OEM 12& 13& Informatica. * Skilled in monitoring the system performance and trouble shooting issues of OLTP and DW. * Excellent leadership and communications skills, planning, delegation and execution. * Reputation for high-quality work, cost reduction and a commitment to user satisfaction. * Experience managing a team of technical associates, consultants, vendors and offshore associates. * Strong ability to translate business problems into technology solutions on time and budget. Proven experience in delivering innovative solutions using the latest technology in environment. * Ability to communicate in a variety of settings including 1 on 1s, small and large groups, with peers, project team, business partners, and senior management. * Worked extensively under heterogeneous environments including mergers, acquisitions and spin-offs in Finance, ERP, Investments Brokerage & MF, 401K, ID Card (images) DOT, DET. * Highly motivated and able to juggle multiple priorities concurrently * Migrated from Oracle Linux/SAN to Exadata, implementing Transparent Data Encryption and Compression