Ramesh Changal Email & Phone Number

Tustin, Ca, Us

Tustin, Ca, Us

Alexandria, Virginia, Us

Managed migration of large-scale and complex data systems from on premise Oracle to Postgres on the Azure cloud.Analyzing data to be migrated, transformed data according to customer requirements, and ensuring the integrity of the dataFormulate data migration plans and strategies Coordinated and reviewed work with other engineers, performed testing of migrated dataMentored junior engineers and interns.Worked with Systems Integration Engineers to resolve issues encountered during integration testingAdept in maintaining Postgres databases on Azure cloudCreated Postgres database snapshots, and setup data replication for the disaster recovery on Azure cloudGood working knowledge of Azure services like VM’s, Databases, Storage Accounts, Private endpoints, Resource groups etc. Identifies and reports issues encountered when performing data transfers and processing using custom migration utilitiesParticipated in design and planning activities, following Agile methodologyDeveloped custom data migration software components in Python and Linux ShellConfigured IDEMIA Biometric Information System products to support migration activities including custom Oracle, Java, and PostgreSQL utilities.Deployed custom data migration solutions to Dev, Test, and Production environments

Los Angeles, Ca, Us

Interacting with business analysts and SME’s to collate business requirements and create data mapping for the required matrix Create technical design solutions by providing sample data model and solution approach using ORACLE PL/SQL and SAP Data ServicesAutomate OFSAA custom Sql’s to avoid manual intervention and improve throughput and flexibility in testing. Preparing and Maintaining ETL design documents such as Data Mapping Document, Data Requirement Document, and Design document using version control tools such as TFS and GIT.Creating Project Plan using agile approach following the SDLC processAssessing requirements for completeness and provide the users an output using a database executable in order to verify the design.Participating in the User Acceptance Testing and application release in production environment

Worked on design patterns like MVC (Model-View-Controller), DAO in the development of Enterprise Applications using Jdeveloper 12c.Designed and developed solutions for enhancements using Oracle exit-point based architecture within loan origination and servicing system. Extensions are done leveraging Oracle PL/SQL, packages, tables, triggers, views, materialized views, external tables and SQL Loader for loading the data in Oracle 12c.Designed Pl/SQL engine to parse JSON data retrieved from valuations REST API from the Manheim market report. Good understanding of end user authentication using OAuth 2.0 JSON Web TokenDesigned and developed SOAP and Restful web services to interface Five9 system with OFSLL application.Worked with Oracle product engineering to design, develop, test, and deploy solutions on various customizations on their key product offering in the auto finance marketWorked with business stakeholders, corporate providers (data providers/receivers) to build and maintain point-to-point and SOA-based interfaces and ensuring complete delivery of project and support tasksCoach, mentor, and motivate team members, influencing them to take positive action and accountability for assigned work.Worked with business stakeholders to automate various correspondence letters using Oracle 12c BI PublisherDesigned Service members Civil Relief Act (SCRA) DoD outbound and inbound interface programs to verify customer’s active military status before proceeding with court judgments, collections, repossession, and foreclosure.Provide Tier3 production support as necessary.Created simple to complex SQL Server business intelligence SRS reports to support the business needs.Create SSIS packages for data replication from ORACLE database to SQL server

Basking Ridge, Nj, Us

Developed reusable components and rule based engines for improving productivity using Oracle PL/SQLUsed JSP extension to identify which server contains the user specific details in order to check logsWrote Unix shell script programming for automated background processesProvided production support and maintained data

London, Gb

Pearson Power school state Reporting Oracle 11g, JAVA/XML/HTML Worked on reporting needs for enterprise school information system (SIS) for State and Federal reporting.Worked with a mixture of standard technologies and proprietary frameworks. Reports driven by Oracle SQL defined in an iBatis format.Reports were driven from a custom user interface within a java based application. Responsibilities included working in a scrum environment, determining development approach from analyst's requirements, writing and testing Oracle SQL code for report(s), end to end testing from SIS system to report output, and working with QA to resolve any defects.

Atlanta, Georgia, Us

Global Payments (NYSE:GPN is one of the worlds) largest electronic transaction processing companies headquartered in Atlanta, Georgia, USADeveloped system to system real time interface (SSRI) to synchronize customer data with multiple subscribing systemsDesigned and implemented complex audit system to capture system edits using database triggers, Global temporary tables GTT(Session specific).Designed and implemented Application/Data security using fine grained access (FGA) and virtual private database (VPD).Designed and implemented batch jobs using Oracle DBMS_SCHEDULERS

El Segundo, Ca, Us

Guthy- Renker is a largest direct television response-driven marketing company focused on finance and operations with sales and marketing efforts, ensuring all the products are promoted by infomercial and different channels of distribution like catalog, internet, HSN/QVC marketing etcTo reduce the inventory in GC warehouses with better forecasting, Business Intelligence solution was provided which involved an extension to their current Oracle Applications ERP system built on data mart where users can do forecasting based on rules built on historical data.Was involved in development of Data mart and Forms for material forecasting system Created FSG Interfaces.Designed and developed inbound interface to bring history data for start KitsResolved Complex table locking issues and worked on performance & Tuning

Worldwide, Oo

Clients:Tecumseh Products Company, Grafton, WIAgilent Technologies, San Jose, CAACCO Brands, San Mateo, CA Work with business functions to understand business processes and recommend, design, develop, enhance, implement, and support high quality business applications to facilitate and improve productivityCapturing the requirements, Collate and document the requirementsInvolved in development and deployment of Performance tuning using the utilities like Explain Plan and TKPROFModified various PL/SQL packages, procedures and stand-alone procedures and functions and triggers based on the Defect Resolutions (DR) and Change Requests (CR).

Bangalore, Karnataka, In

Quality Control System (QCS) Enhancement and SupportQCS is Web-based software that tracks "customer returns", "test data" and "analysis results" of returned parts. It also has a "corrective actions" (Systematic Process Improvement - SPI) database tied in. In addition, QCS tracks all quality-related non-conformances (system, product, process and warranty). Around 200 canned reports and ad-hoc querying capabilities are available. Having developed the system in 1994 we have provided 24 X 7 X 365 support to about 1600 registered users in varied time zones Involved in Developing forms, Interfaces.Customized Reports using Report Builder 6i based on the user requirements.Written various PL/SQL Packages, Stand-Alone Procedures and Functions according to business needs.Modified various packages and procedures based on the Defect Resolutions (DR) and Change Requests (CR).Involved in fixing the bugs during the system testing phase

Created custom applications to support pre-sales, sales, service, spare parts, finance and admin modules using Oracle 9i, Forms 6i and Reports 6i

Bengaluru, In

HR-Package is a user-friendly, menu-based complete customized ERP software designed and developed for Personnel and Human Resource Development Department of Hindustan Aeronautics Ltd. (Bangalore Complex). This package acts as a complete computerized solution to their various departmental activities. Actively participated in requirements gathering from the business users and designing the system from the scratch.Customized and creating Forms, Interfaces and reports using Forms Builder 6i, Report Builder 6i Creating custom DB schemas, Tables, Views, synonyms, Global Temporary Tables, Constraints (Table and column level), Privileges, Roles, Indexes, database links etc. Backup Recovery and maintenance of the development environment.Written various complex PL/SQL Packages, Triggers, Stand-Alone Procedures and Functions as per the business needs.