Ravi G.

Experience

• 

  Marriott International

  Feb 2006 - May 2007

  Web Application Developer
• 

  Ika Systems

  Jun 2007 - Jun 2009

  Enterprise Web Portal Developer

  Built .NET web portals for health insurance companies allowing insurance company brokers to collect demographic data about employers. Built common workflow interfaces, overview dashboards, and administration consoles to receive and present member data to marketers, underwriters, and super users. Worked in a large team setting with dedicated Quality Assurance analyst and Business Development personnel.* Implemented business objects using Object Oriented design principles, employed data modeling techniques to create database schema, and wrote stored procedures for CRUD operations* Allowed client to create multiple user groups and set granular permissions based on user role by implementing authorization administration module to provide client greater control over user management* Built common overview dashboard, workflow interfaces, and administration consoles to receive and present member data to marketing agents, insurance underwriters, and super users.* Application was built for usability and accessibility in mind and to make user interactions straightforward and intuitive Show less

• 

  Transportation Security Administration (TSA)

  Jul 2009 - Nov 2009

  Web Application Developer

  Upgraded a data entry and reporting web application from ASP to .NET 2.0 web forms to track Transportation Security Administration (TSA) real estate properties and administrative financial expenses.* Upgraded Office of Real Estate (ORES) web application to a newer technology platform for tracking activity data generated by financial transactions within finance department* Enhanced the internal TSA software by constructing three inter-related modules: financial tracking, real estate portfolio, and request management* Built Crystal reports using SQL Server Reporting Services (SSRS) that pulled data from all three modules used to reconcile fiscal year administrative budgets* The financial module allowed TSA to track financial transactions such as rent, training, travel, and tuition for financial administrative bookkeeping. The portfolio and rent modules facilitated the tracking of property leases, furniture requests and property renovation. Show less

• 

  Federal Deposit Insurance Corporation (FDIC)

  Nov 2009 - Mar 2013

  Web Application Developer

  Actively involved in the development and enhancement of a wide-ranging set of n-tier enterprise web applications to present critical financial data to internal FDIC employees for the Open Bank line of business as a contractor to IBM using Microsoft stack and supported legacy mainframe COBOL code.* Updated core business logic in highly visible revenue generating application that keeps track of bank assets, liabilities, revenues, and other fiduciary insurance related data to generate a quarterly invoice* Built an ETL program to automate PDF conversion process for documents received from external financial agencies in the Federal Reserve and Department of Treasury* Processed quarterly XML data files using XSLT to transform complex sets of data to present fiscal bank data in a predefined format set by Federal Financial Institutions Examination Council (FFIEC)* Helped define technical specifications for multiple concurrent projects to define project scope, document client expectations, and specify use cases to help ramp up project support for division and deliver critical projects in timely manner* Produced document artifacts using Rational Unified Process to assist project team with interpreting technical specifications and clarifying deployment plans to business stakeholders* Maintained code base using Borland StarTeam, tracked requirements in HP ALM, and performed unit and system testing of code to detect and resolve software defects across Open Bank suite of data reporting applications * Responsible for assignment of priority BMC Remedy helpdesk tickets based on SLA requirements for set of applications within Open Bank portfolio* Addressed application security vulnerabilities by interpreting rule based code enhancement recommendations from HP Fortify Software Show less

• 

  NORC at the University of Chicago

  Apr 2013 - Sept 2013

  Web Application Developer

  Built custom solutions for administering and conducting research surveys focused on public health and international projects using ASP.NET, C#, Entity Framework, jQuery, and SQL Server* Spearheaded a major ETL project to migrate a large dataset from a legacy data source to a new database structure for 3 years of survey data* Enhanced core web application by adding significant features to meet specific project needs* Delivered a set of custom reports to assist university researchers to view aggregate participant responses, track key metrics & trends, and identify leads for follow up questions Show less

• 

  Office of Energy Efficiency and Renewable Energy (EERE), U.S. Department of Energy

  Oct 2013 - May 2019

  Web Application Developer

  Maintained ASP.NET and Drupal web applications for Department of Energy. Used the latest web technologies in ongoing development projects to create visually expressive applications and interactive content.* Developed web applications using C#, .NET controls, and Entity Framework to display user data. Built user interfaces using HTML5, CCS3, and jQuery. Developed reporting interfaces using Angular to generate exportable Excel reports. * Developed web content and leader board for Solar Decathlon home building competition. Added high priority features to website during two-week competition. Restructured site in preparation for next competition. Used GitHub and bash scripts to deploy code files to virtual machines in AWS cloud.* Used web forms to create user management and authorization administration modules. Employed data modeling techniques to create database schema. Wrote stored procedures to implement business logic to process, insert, and update large number of data records. Built a custom module that integrates with the site login to validate multi-factor authentication token.* Designed a database queue to monitor product additions to a .NET web application. Created a Windows program to read from the queue and send XML records to a web service hosted by DOE lab. The program generates a weekly summary report email for all new products.* Developed a custom Windows .NET forms utility to accelerate migration effort from legacy system to a newer platform. The program assisted in migrating thousands of web pages and saved thousands of man hours for the web migration team.* Created and administered Drupal websites. Built custom views and content types to aid in site design. Used responsive design to create content types. Implemented indexing using Apache Solr and maintained multi-site projects. Wrote MySQL scripts to manage user permissions. Managed deployments between environments and handled updates to PHP, Apache, Drupal and associated modules. Show less

• 

  Regulatory Affairs Professionals Society (RAPS)

  Jul 2019 - now

  Web Administrator

  Enabling the healthcare regulatory community to enhance their careers. Engaging professionals with current news, popular events, chapter communities, topical products, and valuable certifications.