Ryan Razavi Email & Phone Number

Oakland, California, Us

Oakland, California, Us

Oakland, California, Us

• Creating ad-hoc reports using high level PL/SQL and SQL programing• Automated working schedule to generate a daily schedule from the monthly master working schedule using excel macros• Automated rop_category mapping using dynamic sql• Created OSM Budget Mapping Tableau report according to the new cpt grouper• Converted budget forecast report to an automated report by extracting data from database using pivot tables and pl/sql programming• Automated uploading AP, GL and Interentity recharges data receiving from ETL team via sql loader plus error monitoring system.• Developing a robust algorithm in order to map CPT Codes in their respective specialties by using Oracle match_recognize (measures and pattern)• Identifying and implementing emerging developments, tools and IT trends and Modeling method(s)• Optimizing and converting existing Teradata queries to Oracle queries• Converted Teradata to Exadata queries used for referral and external claims

Managed software releases through entire SDLC, assigning tasks to engineers and ensuring on-time completion of high-quality deliverablesServed as the primary customer interface from project inception through completionCompiled project data, created reports, and monitored status of all customer engagements

Victoria Island, Lagos, Ng

Led a team of offshore DBAs responsible for application developmentManaged mission-critical ICD9 to ICD10 conversion process from inception to completionTested, deployed and improved existing Oracle applications and maintained all DB objects

Oakland, California, Us

Maintained 36 Oracle DB production and test servers across 9 regionsMonitored and debugged SQL and PL/SQL issues for all Oracle jobsCoded and deployed SQL and PL/SQL code using Toad in the support of 6 enterprise Oracle DBs and managed company-wide ICD-9 to ICD-10 data conversion

Redesigned database schema across the enterprise to allow for a more efficient and manageable relational data modelTroubleshoot performance on all Oracle enterprise production DBs using Automatic Workload Repository (AWR) reportsCreated a stream mechanism to increase efficiency by reducing load from production DBs

Scottsdale, Az, Us

Coded, tested, and debugged over 20 custom UNIX, Linux and Windows B2B applications supporting a nationwide corporate client baseSupported all client issues and served as an escalation point across entire client baseCreated a management dashboard enabling one-stop ticket tracking and processing

Charlotte, North Carolina, Us

Extracted, analyzed, and reported on raw data from multiple Oracle enterprise databases to ensure existing airplane engine safety standards had been sufficiently metEnforced quality assurance of engine health by identifying specific patterns within extracted dataResponsibly for the installation, configuration and ongoing patch management of all enterprise workstations