SUMMARY:

• Highly experienced, organized and motivated software professional, possessing excellent communication skills and over 20 years of tech industry experience.
• Worked at Confidential 500 employers at various levels in SF Bay area. Provided services like end to end Solution Architecture, Ruby on Rails development, Application Development, Computer Security and Forensic Analysis, IT Audit, IT Attestation, Database Development, Performance Testing and Tuning, Data Conversion, Oracle Upgrade and general IT work.
• 7+ years of experience with Ruby on Rails development. Architect and lead developer of a number of Rails projects.
• 20+ years of overall experience in design and development of computer applications. Expertise in conceptual, logical and physical data modeling. Deep understanding of inner workings of computer systems. Expertise in SQL and PL/SQL. Extensive experience as Architect dealing with overall solutions including infrastructure planning, capacity planning, hosting and network technologies.
• 15+ experience of SDLC and Project Management experience on large projects. Deep understanding of various project management methodologies like Waterfall, Agile etc. Experienced team leader, having lead teams of junior developer both on shore and off shore.
• 7+ year of experience in database and SQL query tuning using TKPROF, Explain Plan, DBMS Stats gathering, SQL Query Hints, Index creation etc. Intimately familiar with Cost Based Optimizer and importance of Statistics gathering.
• Expertise in C, C++, C#, Perl, HTML, Java, Javascript, PHP, Python, Ruby, Pascal, Cobol, Fortran, Assembly, CSS, XML, SQL, PL/SQL, Forms 2.3,4.5,6i, Reports 2.0,2.5, Perl5, Java, JSP,HTML, Java Script, Shell, Pro*C, C,Developer2000,Developer 6i, Discoverer 3.2, Oracle Workflow Builder3.x with expertise in SQL, PL/SQL, Reports, interface development, data extraction, manipulation and conversion.
• Understanding of Oracle Installation including Real Application Clusters (RAC), Load Balancing, Data Guard etc. Familiar with Database Administration including cloning, patching and upgrading.
• Understanding of Unix and Windows Operating Systems - HP UX, Sun Solaris, DYNIX/PTX, Linux, AIX, Windows 95,98,NT,2000. Actually did System Administration on Linux and Sun Boxes.
• Extensive experience in Data Conversions, ETL processing, Data Warehousing and System Upgrades.
• Experience with code repositories like PVCS, Clear Case, GIT etc.
• Experience as SOX Auditor and SOX Compliance Manager.

FUNCTION AND SPECIALIZATION:

Expertise in Ruby on Rails Solution Architecture, Application Development, Forensic Analysis, Vulnerability Analysis, Penetration Testing, Programming Languages, Database, Oracle Applications, IT Audit, IT Attestation, SOX Compliance

TECHNICAL SKILLS:

Computer Languages: Ruby, Ruby on Rails, C, C++, C#, Perl, HTML, Java, Javascript, PHP, Python, SQL PL/SQL, Pascal, Cobol, Fortran, Assembly, CSS, LESS, SASS, CoffeeScript,XML

Databases: Oracle, MySQL, PostGreSQL, MSSQL, SqlLite

Operating Systems: Windows, Linux, Mac, Android, IOS

Development Frameworks: Ruby on Rails, Qt, .NET, Django

Web Frameworks: Ruby (1.8.7, 1.9.3, 2.1) on Rails (2,3,4), Django, Drupal, Node.JS, React.JS, Angular.JS, Ember.js, Elastic Search, Sidekiq, Reseque, Rufus Scheduler, Twitter - Bootstrap, Phoenix, Elixir, BEAM

Artificial Intelligence: NLP, POS Tagging, Machine Learning, Deep Learning

Computer Forensics: Windows Forensics, Mobile Forensics, Logical and Physical Collections, Forensic Analysis, Incident Response, Nuix, Oxygen ForensicsComputer Security Vulnerability Analysis, Penetration Testing, Metasploit scripting, Malware Analysis, Ethical Hacking, Burpsuite

Performance Testing: Backend SQL query tuning, database tuning, front end load testing with Load Runner, Watir, Cucumber, Nokogiri

Protocols: TCPIP, SNMP, SSH, Telnet, FTP, SFTP, HTTP, SSL, TLS, ARP, SMB etc.

SOFT SKILLS:

• Excellent Communicator
• Team Player
• People Manager
• Hardworking
• Focused
• Goal oriented

PROFESSIONAL EXPERIENCE:

Solution Architecture and Application Developer

Confidential

Responsibilities:

• Architect and lead designer of Global Evidence Management System (GEMS) at Confidential . A feature rich Ruby on Rails application that provides a centralized platform for cataloguing and storing the collected evidence items during forensic investigations and interfaces with other forensic analysis and e-discovery tools in Confidential using a RESTful API. GEMS is enterprise wide tool that stores the physical and logical evidence collected by Confidential during Cyber Investigations.
• The application is loaded with advance features like Access Control based on Roles and Responsibilities, RESTful API, Advance page redrawing using AJAX and jQuery, Input validation and sanitation etc.
• Extensive Penetration Testing and Vulnerability analysis was performed to make the application very secure.
• Application uses MySQL database at the back. The application was originally developed in Ruby 1.9.3 / Rails 3.1 and later upgraded to Ruby 2.1 / Rails 4.1.1. The development was carried using TDD using RScpec.
• Comprehensive background processing engine was built using Rufus-Scheduler.
• Architect and lead designer of ForexBot, a unique combination of C#.NET and Ruby on Rails application with MySQL database at back end that downloaded Forex Data from brokers, performed regression and statistical analysis on the data, and by using patter recognition and machine learning algorithms, tried to predict the short term movements of the markets. Ruby 2.1 / Rails 4.1
• Architected and lead designer of Webot, a Ruby on Rails application with MySQL database at back end that performed automatic testing of websites by scraping the content and filling out forms. Ruby 1.9.3 / Rails 3.1
• Architect and lead designer of ToolERP, a Ruby on Rails application with MySQL database at back end for personal accounting and financial management. Ruby 1.8.7 / Rails 2
• Performed Forensic Analysis and Evidence Collection (desktop, laptop, mobile) for forensic investigations in Bay Area as part of Confidential . Also performed incident response, security audit and penetration testing of large overseas firms.
• Performed IT Audit involving IT Application Controls Testing and IT General Controls Testing for Confidential clients. The scope included but not limited to Application Processes and Data Testing, Application and Data Security, Segregation of Duties Testing and Reports Testing.
• Extensive experience in all aspects of Oracle Applications 10.6 to R12. Designed, developed, maintained and enhanced Oracle Applications, Reports, Forms while working at Confidential in Bay Area. Managed enterprise wide software releases, large upgrade and data conversion projects as part of ERMO in Cisco
• Extensive experience in relational database technologies like Oracle, MySQL, PostGreSQL etc. Worked as application architect, database administrator and database developer for clients in Bay Area. Performed extensive application and database performance testing and tuning as part of Performance Testing group in Cisco.
• Managed and worked on numerous large database upgrade projects involving large volumes of data conversion work, ETL work and general data processing (storing and fetching). Extensive experience in data conversion, throughput, performance tuning and data quality management.

Confidential

Architect and lead designer

Responsibilities:

• I was managing a team of 8 resources. The team provided installation, administration and support services.
• The team provided functional, technical, support and enhancements services to the hosted clients.
• It was involved in design and development of interfaces, customization, enhancements, troubleshooting, data conversions, data loading and manipulations, customization of workflows, creation of API's. etc. in Order Management, Order Entry, Receivables, Payables, Purchasing, General Ledger, Work In Process, Inventory, Bills of Materials. It was really a great experience.
• I handled 11i upgrades, development of new API's for HRMS, countless sql scripts and numerous Oracle TAR's.

Confidential, San Jose

Sr. Oracle Consultant

Responsibilities:

• Supported Order Entry Systems and Interfaces between SJOEPROD, BVPROD and SJPROD. Customized major forms like, Enter Orders, Enter Customers, Enter Vendors, Addresses, Sites, Scheduling, Apply Release Holds etc.
• Designed and developed a of new forms, reports, alerts, procedures, packages etc to carry out a needed customizations to OE and AR. Worked on the Business Analysis and Technical Design of Customer Interface to bring in Customers from Web. Developed reports and alerts for AP, AR, GL and OE.
• Addition to these worked extensively on Item Configurator, Global Scheduling and Sales Credits projects.
• Contributed in development effort for functionality using triggers, procedures and packages.
• Developed numerous SQL scripts to troubleshoot the orders stuck in various interfaces and to move them forward through the system.
• Resolution to Invoice Interface, GL import, lock box issues. Later on moved to Order Entry IT team (CSIT) team whose job was to provide 7*24 support to OE and AR.
• The duties included development of Monitoring Systems and to provide resolution to production problems.
• Developed a number of Concurrent Programs, Alerts etc. for the purpose.
• Also developed various web tools using HTML, Perl5 and Java for monitoring the system over the web, examples being Supply Order Scrubber and SOM Tracker.

Confidential

Sr. Software Engineer

Responsibilities:

• Took the project through its complete life cycle.
• Right from the Business Analysis, Design and development of Customer and Orders Interface.
• Provided resolution to production issues.
• Order Entry Setups e.g. Order Types, Order Cycles, Items etc.
• Interfaced Oracle Applications, to enable Oracle Apps to extract Price Lists, by developing a new concurrent program, which imports Price List data from a Flat File, which is then available to the rest of Oracle Application Modules.
• Auto invoice, Auto Lock Box, Auto Receipts, Tax Localization, Customer import.
• Concurrent Programs definitions, Object Library, Oracle Alerts setup on important tables.
• Standard Past Due Invoices, Auto Invoice Validation, Automatic Receipts awaiting confirmation etc. Customization to Enter Vendors form.
• Enhancements to Invoice Aging, Payment register reports. Enhancements to Enter Purchase Orders form.

Confidential

Software Engineer

Responsibilities:

• Extensive Reporting capabilities were built into each module thus making it a highly useful management tool.
• Provided support and resolutions to production issues.
• Later was involved in the development of Order Entry and Inventory Management Systems.
• All these systems were ported from a legacy system running on COBOL.
• Migration of Finance and Manufacturing Management Systems from COBOL to Oracle.
• Architecture design, configuration and creation of databases, table spaces, user accounts, roles etc.
• Backup and performance tuning.
• Database refreshes, creation of new instances.
• Troubleshooting complex problems like dead locks and lock contentions.
• Development of database standards, procedures and controls.
• Scripts development using Unix shell scripts and PL/SQL.
• Production support and maintenance.