Oracle Apex Dba
Resume:
Robert Fruchtman
Senior Oracle PL/SQL Developer Senior PowerBuilder Developer, Clipper Axiom v9/Axiom v10 Postgres MySQL Python, Java Oracle ODI Oracle Apex Oracle DBA Cobol Developer
Location : Old Bethpage, New York, United States
Email ID : *******@*****.***
Linked In ID : https://www.linkedin.com/in/robert-fruchtman/
Contact Details : +1-516-***-****
PROFESSIONAL SUMMARY
I have 30 + years of IT experience working with top fortune 50 Clients and delivering the top Notch results.
Skill
Years Used
Last Used
Oracle PL/SQL
30 years
2024
Oracle ODI Oracle DBA
12Years
2024
Oracle Apex
12 years
2024
Python development
6 years
2024
Axiom SL/ XML (Axiom V9/Axiom V10)
8 years
2024
AWS with Snowflake,C#
2 years
2024
Clipper, Visual Fox Pro, PowerBuilder
25 years
2024
SQL Server
20 years
2024
Java Development
20 years
2024
PostgreSQL/MY SQL
10 years
2024
Cobol Developer
7 years
2024
Involved in Development, Maintenance, Support, system upgrades, customizations, and implementations of Oracle EBS v10.7, 11i and R12 and Data warehousing applications. Worked with Oracle 8i, Oracle 9i, Oracle 10g, 12C.
Expert in RDBMS principles, database design and normalization
Expert in PostgreSQL database architecture, concepts, features, and high-availability technologies
Excellent conceptual knowledge of Oracle (9c- 23c), PL/SQL and SQL.
Expert in writing DB objects, PL/SQL Procedures, Functions, Packages and Database triggers.
Designed, Modified, Maintained and Migrated APEX forms and reports as per client's needs, to meet business requirements.
Excellent skills using Oracle Applications, date tracking concepts, Oracle Apps APIs, AOL, Key Flex fields, Descriptive Flex fields, Responsibilities, Menus, Building Task Flows, Defining Alerts, Quick Codes, Cascading Dependencies, Value Sets, and Concurrent Manager etc.,
Oracle R12 Upgrade experience, planning and reimplementation or upgrade of Oracle R12's functional & technical architecture to Oracle Applications HRMS Release 12 from Oracle 10.7 NCA.
Experience with Databases ORALCE 7.3, 8.x, and 9i,10g, 12C Oracle Forms 4.5,6i,9i,10g Reports 2.5,6i,9i,10g, SQL, PL/SQL and Internet technologies using HTML, ASP, Java, and Java Script.,
Expertise in using APEX 19.1/18.1/5.1.2/4.2 application builder tool to build database driven applications such as developed Interactive Reports and Interactive Grids.
Expertise in using HTML, CSS, Jquery, JavaScript and Ajax in APEX applications to have client side
Experience in using Oracle Apex 19.2/18.1.0/5.1.2/5.0/4.2, Forms 10g/6i/5.0&4.5, Reports 12c, Oracle designer 12c/11g, Oracle discoverer 10g for developing end user screens and reports and also adept in using Oracle Tools like SQL* Plus, Toad.
Designed application framework and developed Oracle APEX Application.
Hands-on experience in using HTML and CSS to customize the look & feel and behavior of Oracle Apex applications.
Demonstrated experience in newer versions of Oracle Apex version 18.2 or higher.
Having good understanding of the structure of XML, JSON, DOM and jQuery and Java Script
Oracle Database Design and development (SQL & PL/SQL) with respect to Application Development
Strong working knowledge in PL/SQL coding and Application Express API
Responsible for developing custom application using APEX. This involves developing APEX Reports and Forms, conversion of Oracle Reports into Oracle APEX Reports.
Developed the user interface using the Oracle Apex form types depending on the requirements.
Developed different typed of interactive reports, SQL reports and charts based on the user requirements in APEX, Oracle Fusion.
Industries I’ve been involved with include Real Estate, Finance, Healthcare, Government, and Insurance.
Database expertise is in Oracle, both as a PL/SQL Team Leader, PL/SQL Developer, and Developer DBA.
Database expertise in PostGreSQL (4 Years), MySQL (5 Years), and SQL Server (5 Years).
The sizes of these databases were as high as 5 TB. For Data Warehousing, we used ETL processes.
26 plus years of experience in development of applications using Oracle 4 – 19c.
Expertise in developing SQL, PL/SQL scripts in oracle, postgresql, mysql, sql server distributed environment.
1-2 years in C# with C# REST API using the GET method selecting data. I used VSCODE and made an ASP.NET 5.0 Framework and CORE WEB API project.
Demonstrated proficiency in Oracle Data Integrator (ODI) for data integration, transformation, and loading processes across heterogeneous systems and databases.
Possess strong programming knowledge in Oracle PL/SQL 6-19c, SQL*PLUS, SQL*LOADER, and loading data in all Postgresql, MySQL, and Sql Server.
Created Validations and Computations in Apex during the page submission time.
Worked with JavaScript API’s in APEX for various purposes.
Involved in developing user interface using Oracle APEX forms.
Created parameter entry forms for the Oracle Reports to integrate them with APEX.
Created Page level and item level validations and also page processes and computations using APEX.
Implemented validations using AJAX and JavaScript processing for server side data fetches.
Implemented JQuery tabs, auto complete features, popup alerts and date pickers in APEX
Installation & Maintenance of Oracle 10G RAC on Solaris. Plus many more daily Axiom SL features.
Database Upgrade from 8i to 10G, 9i to 10g (Manual & DBUA)
Creation of Database & Install Oracle Client / Server Software upon client requirement.
Extensive Knowledge in Database Patching activity using Patch.
Proactively Involved in Database Security Patch Management (CPU Patch).
Installation & Maintenance of Oracle 10G RAC on Solaris.
Experience with Golden Gate replication administration and production support
Applied the latest CPU and Bug fix patches on oracle 10g and 11g build databases.
Support Online and RMAN backup issues.
Build, setup, and deliver Oracle 19c RAC databases on RHEL hosts.
Managing, and troubleshooting resolving Oracle RAC database and Application issues.
Installed and configured High Availability Oracle Golden Gate systems on Oracle 12C RAC environments.
Providing a complete solution in high availability, real-time data integration, transactional change data capture, data replication, transformations, and verification in Golden Gate replication.
Manage & Perform Database Upgrades, Patching, and Perform Database Refreshes of Oracle and PostgreSQL databases.
PostgreSQL installation, Configuration, Migration, Upgrades, and patching. Sever versions ranged from postgreSQL 8.2 to 9.5.
Extensive experience in ETL (Extract, Transform, Load) development using Oracle ODI, including designing and implementing complex data workflows to efficiently move and transform data.
Extensively used oracle tools like TOAD, SQL Navigator, and Sql Developer, etc.
For Oracle Cloud database replication, we use Golden Gate on Exadata at client.
Designed and developed various applications using all 4 database products/tools for process automations software into database server using CRON, UNIX/Linux shell scripts, PL/SQL packages, procedures, functions, and database triggers based on client/server and multi-tier technologies along with Postgresql, MySQL, and Sql Server.
Experience in Data migration Projects which uses SQL Loader, Data Pump, and RMAN, and PL/SQL programming, coding Procedures, triggers and functions, and packages,
Experience in data extraction, data migration and Data loading
Expertise in query optimization, debugging and application tuning using AWR, ADDM, along with Oracle DBA and session tables.
Knowledge of Axiom v9/v10's security features and protocols, including access controls, encryption, and authentication mechanisms, to protect sensitive data and prevent unauthorized access.
Proficiency in diagnosing and resolving issues within Axiom v9/v10, including troubleshooting network connectivity issues, identifying configuration errors, and analyzing system logs to ensure smooth operations.
Experience Ellucian Banner system for Suffolk County Community College
Knowledge in ETL process using PL/SQL/Postgresql, MySQL, and Sql Server.
3 plus years in Python development.
I have 3 years experience with Tableau.
Batch support / Production support for Oracle, Postgresql, Unix, Sql Server, Sybase, Perl, Java, Python, C++ jobs
Support government agencies from North Carolina, South Carolina, Georgia, Florida, and New York.
3 years Oracle 12c Forms and Reports
2 year of AWS with Snowflake
5 years of POSSE workflow
TECHNICAL SKILLS:
Databases: ORACLE 7.x, 8.x, 9i, 10g, 12C MS-SQL Server, and MS-Access etc
Development Tools: Oracle Designer/2000, Developer/2000 (Oracle Forms and Reports), Visual Basic. ORACLE APEX: Oracle APEX, or Oracle Application Express, is a web application development tool for the Oracle database that allows developers to create attractive, responsive, and data-driven applications.
ORACLE APPLICATIONS: Oracle Human Resource Management System (HRMS 10.7), Oracle Applications R12 Suite.
CASE TOOLS: Designer/2000 (Versions 1.3, 2.x, 6.0, 6i).
Data Ware Housing Tools: Business Objects, Tableau.
Other Applications: MS Excel, MS Project, MSWord, MS Power point, MS Access etc.,
Programming Languages: SQL, PL/SQL, Java, C, PASCAL, and COBOL.
Testing Tools: Mercury Projects (Quality Center, Test Director), SQA and Silk
WEB: JAVA, ASP, HTML, DHTML, JavaScript and VB Script, Mac Graphics (Quark 4.1& PhotoShop 6), Citrix Server, Microsoft FrontPage v2.0. HTML, CSS, XML, JSON, DOM, jQuery and Java Script.
Configuration and Project Management: MS-PROJECT, PVCS Version Controller, StartTeam 2008.
Operating Systems: Solaris, Linux, HP, Windows 2000 (20-25 Years)
Shell Script Languages: C, Bourne, Bash, Perl, Korn, Sed, AWK. TCP/IP Sockets, FTP and SMTP
PowerBuilder
Other Languages: C, C++, PowerBuilder, Java, Clipper, Visual FoxPro, PL/SQL, Netegrity Siteminder, Delphi Visual Basic 6.0, VBA, Com, Com +, Dcom, Rational ClearCase, ASP 2.1, JSP, c#/dot.net, php
XML Development: XSLT, XML, XSD, DTD, XML-Schema, Oracle XDK, XKU, XSD style sheets
Oracle : Oracle Apex 19.2/18.1.0/5.1.2/5.0/4.2, Forms 10g/6i/5.0&4.5, Reports 12c.
EDUCATION
BS Computer Information Systems, Dowling College, Oakdale, New York, 1988
Certifications
Certified Tableau Desktop Specialist - 3/26/2022.
EDB PostgreSQL 12 Associate Certification
Oracle Certified Associate for Oracle 9i DBA Track.
Oracle Certified Professional for Developer 9i Track.
Oracle APEX Cloud Developer Certified Professional
Professional Experience:
Client: Bank of Montreal (Tata Consultancy Services) Mar 2024 – Present
Senior Axiom Developer v9/v10 OFFSA
I handled Design and Configuration for both Canadian and US reporting.
Some of the securities the bank is involved in are ABS, Swaps, Loans, Derivatives, Bonds, Mortgage backed securities.
I supported full workflows, data models, data sources, portfolios, freeforms, aggregations. I was involved in onboarding numerous projects for the US including, CCAR, FFIEC (002,031,041,101), FRY-15, FRY 14 (A/M/Q), FRY-9C, FRY-9LP.
OTBI was used for
The data that we used was scrubbed to make sure if met regulatory requirements based on OFSSA.
Canadian Projects include, EB_ET_2A, I3, M4, Mgmt_Reports, P3, PS, QS, S1, S2, and Z4.
Client: Humana, Inc (Tata Consultancy Services) 2/17/2023 – Feb 2024 Senior Oracle PL/SQL DBA / PowerBuilder Developer / APEX DEVELOPER / /PostgreSQL Developer / Oracle DBA
Responsibilities:
I supported a transformation from a PowerBuilder 19 Healthcare system that is being transformed to Oracle Apex with Oracle Fusion.
Implement enhancements to the DNA platform by creating or modifying existing PL/SQL code and database objects.
Migrating FoxPro .DBF files to Oracle for the website. At Humana, they support patients that leave the hospital for after hospitial care.
Responsible for creating packages and procedures for validating data created with Axiom Reports.
Excellent conceptual knowledge of Oracle (9g- 23g), PL/SQL and SQL.
Expert in writing DB objects, PL/SQL Procedures, Functions, Packages and Database triggers
Our Linux based systems with Oracle are using Golden Gate for real time processing on Exadata. When our local data is processing ETL and we have issues on data with validation, we store this data on Golden Gate.
I am involved in handling claims with EDI.
I helped with creating reports with OBTI to view analytical data from fusion applications.
We take advantage of the large language model for our pages.
Developed and optimized PL/SQL scripts for transaction processing in Fiserv DNA, resulting in a 20% improvement in system performance.”
We are also using Golden Gate for replication in the cloud on Exadata.
In-depth understanding of ODI components such as Repositories, Models, Interfaces, Mappings, Packages, and Scenarios, leveraging them to build robust data integration solutions.
Expertise in using HTML, CSS, Jquery, JavaScript and Ajax in APEX applications to have client side
Experience in using Oracle Apex 19.2/18.1.0/5.1.2/5.0/4.2, Forms 10g/6i/5.0&4.5, Reports 12c, Oracle designer 12c/11g,
Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
Designed and developed various custom packages triggers and forms.
Formulated SQL queries, functions, and processes as per customization requirement for APEX.
We are also using OpenAi API for real time solutions for questions asked on Apex screens.
Supported APEX applications and conducted performance tuning for PLSQL.
Skills: PL/SQL, Fiserv DNA, Oracle Database, SQL, Data Migration, Performance Tuning.
Client : Capgemini Feb 2022 – March 2023
Senior Oracle PL/SQL DBA / PowerBuilder Developer / APEX DEVELOPER /MySQL /Axiom V10 / OFSSA, PostgreSQL Developer Oracle DBA
Responsibilities :
Proficient in integrating Oracle ODI with other Oracle technologies such as Oracle Database, Oracle Business Intelligence (OBIEE), Oracle Fusion Middleware, and Oracle Cloud services for end-to-end data management solutions
Pl/sql development work and Oracle ETL with Oracle ODI. Loaded data from MySQL and Sybase data into Oracle, including Oracle Fusion data.
The data that we used was scrubbed to make sure if met regulatory requirements based on OFSSA.
Responsible for designing, implementing, and maintaining critical database systems (PostgreSQL) which support a growing 24x7 SAAS platform.
Expert in RDBMS principles, database design and normalization.
Expert in PostgreSQL database architecture, concepts, features, and high-availability technologies.
Expert in query optimization, indexing knowledge, modeling basics, materialized views and partitioning.
Expert with PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQL. Proficiency with operating PostgreSQL in a Linux environment.
Client: Wells Fargo (Ashley Saxton) Sep 2021 – April 2022
Senior Oracle PL/SQL DBA / PowerBuilder / APEX DEVELOPER / MySQL /Axiom V10 / PostgreSQL Developer
Responsibilities:
We move data from an old program written in Access and Teradata. We have this IROD application with 100’s of user stories written against Access and Teradata that we are converting to straight Oracle. This is using all bulk processing, arrays, etc.
Our processes are managed and automated using posse. Created reports in Tableau. We have a dot net website in which I created some scripts in C# to pull SQL server and PostgreSQL data into the website. I had to convert several PowerBuilder v12 and FoxPro v9 compliance applications to their latest versions and then to support the current work and future work as well. On call for batch and production support 1 week of every month. We did access Unix for production support using tools such TCP/IP Sockets, FTP and SMTP was used.
Securities types of data include Swaps, Derivatives, ABS, CDO’s, MBO’s, Futures and Forward contract data.
Version control / Code Consistency is GitHub / Jenkins
Experience in performance tuning and optimization of ODI jobs and processes, identifying and resolving bottlenecks to improve overall data integration performance and efficiency.
Client : Bank of America June 2021 – Sep 2021
SQL Server/PostgreSQL Developer And Oracle PL/SQL DBA
Responsibilities :
I worked as part of team that handled any up and coming Jira work that came into our pipeline. I spent the last 2 weeks taking 3 tables and porting them as materialized views with synonyms and grants, and also making the AutoSys jil jobs for refreshing. Using Bitbucket repos, and Jenkens, along with Datival and XLR, I was able to port these changes from Dev-Load Test, in 2 downstream environments .
I created a few programs for migrating Oracle to PostgreSQL for reporting and bringing data to the web with Oracle fusion.
I handled numerous database sql creation queries for reporting, which I also created the AutoSys jilt jobs for calling the reports. Most AutoSys jobs are called via shell scripts or oracle SQL loader. Reports were created using Tableau. On call for batch and production support 1 week of every month.
Some of the financial instruments are CDO’s, derivatives, MBS, Loans.
Familiarity with implementing error handling mechanisms, logging, and auditing features within ODI workflows to track data processing activities, troubleshoot issues, and ensure data integrity.
Version control / Code Consistency is GitHub / Jenkins
Client : Nimble Tec Jan/2021 – Jun/2021
SQL Server/PostgreSQL Developer And Oracle PL/SQL DBA
Responsibilities :
We exported data from Oracle to PostgreSQL, and created Websites with both Django and Flask using PostgreSQL. We did data analyses and manipulation, and aggregation using Pandas. This is a proof on concept used by Nimble Tec. Junior Mongo dB skills, Maintained and configured MongoDB instances, Keep clear documentation of the database setup and architecture, wrote procedures for backup and disaster recovery and ensure that the databases, achieve maximum performance and availability, Design indexing strategies, Configure, monitor, and deploy replica sets.
The client had an older version of VB6, which needed some oracle table changes and vb screen changes for their banking client. Working on a Spring Boot Risk Application. We used Hibernate and JPA. For some of our UNIX projects, I used TCP/IP Sockets, FTP and SMTP. The project is based off of Spring Initializer and Spring Tool Set (STS). The databases used were PostgreSQL, MySQL, and SQL Server . I maintained the current Risk System by maintaining the Oracle DB, SQL tuning, PL/SQL. Numerous data migrations from Oracle to PostgreSQL and migrated many of dbase III+ databases to PostgreSQL.
Using Oracle Fusion and WebLogic Web-Forms and Web-Reports, I was able to create numerous Parent/Child forms and reports for one of our clients Bank of Japan. Some the banks we work with use posse I automate their business processes, and we also used numerous LOV objects while in the canvas. Using AWS and a Snowflake instance, I was able to migrate some of our Oracle data to the AWS cloud with Snowflake instances.
I migrated a VB6 client customer relations application to Oracle/Java based website. There were over 40 screens to migrate. I created the data models and new designs on the database side and worked with teammates on the front end including JavaScript.
Client : Bank of America Aug /2020 - Jan /2021
Oracle PL/SQL, PostgreSQL, PowerBuilder, Production Support, Jenkens, XLR, Datival,MYSQL
Responsibilities :
Development and Maintenance of a large PowerBuilder v2017 and just converted to v2019. We have a huge scheduler application called Nightly Cycle which acts as job scheduler for all process of events at the bank, from imports of data to running of shell scripts to Oracle package procedures and PostGreSQL. Data is coming from numerous securities. Report done with Tableau. On call for batch and production support 1 week of every month.
We did access unix for production support using tools such TCP/IP Sockets, FTP and SMTP was used.
Version control / Code Consistency is Github / Jenkins
Client : Nimble Tec Nov/2019 –Aug/2020
APEX DEVELOPER / Oracle 12c-19c Pl/SQL, Python/Sybase, PB 12.5-2019, Java 14, Spring 2.2, Foxpro
Responsibilities :
• Oracle/PostgreSQL/MySQL/Sql Server Application DBA (Performance tuning SQL, tuning Indexes, enforcing parallelism, partitioning strategies, making use of Oracle packages for memory, design strategies on tables and other objects, monitoring of databases for memory, disk space, users).
• Support for FoxPro client systems and conversion of .dbf to Oracle
• Responsible for creating packages and procedures for validating data created with Axiom Reports.
• Responsible for tuning SQL for our team, including adding parallelization of Index creation and SQL.
• Creation of Analytical reporting done from data created with Axiom.
• Performance Tuning.
• Importing and Exporting of data.
• Shell Scriping.
• Developer DBA.
• Used Pl/SQL Developer, Toad.
• We have a customer that wanted to use his legacy SAP Sybase ASE database with Python 3.1 by using the sybpydb Sybase Module for Python. We are working to use it with Django.
• Development and support for the company’s PowerBuilder Scheduling ETL system. I have also migrated the program to PB 2019.
Client: BNP Paribas Aug 2015 – Nov 2019
APEX DEVELOPER /Oracle 12c – 19c PL/SQL Developer, OFSSA, Axiom SL, Oracle App DBA, Production Support, PowerBuilder 12.5-2017, Tableau 2018.1-2019.1
Responsibilities :
Oracle Application DBA (Performance tuning SQL, tuning Indexes, enforcing parallelism, partitioning strategies, making use of packages for memory, design strategies on tables and other objects, monitoring of the Oracle database for memory, disk space, users).
Integrated Axiom reports with external reporting tools, facilitating seamless sharing of financial insights across the organization
Worked with data based on the OFSSA regulatory framework. All data sent to the Federal Reserve, FINRA or the Treasury department was based on OFSSA.
Created custom financial reports using Python 3.6 by importing both sys and cx. Oracle Python modules. These are in-house reports that coincide with FR Y-9C Fed report but using our internal formats.
All the banks investments are included in reporting including Swaps, Loans, ABS, MBS.
Helped in the implementation of FR Y-9C, 14C, 14A, 9LP. I added custom edit checks between 9C/14A/14C, and the call report.
Performed some BA work for working on transformation specs and making data specs.
Performed much data analysis and unit testing of data with mock submissions.
Perormance Tuning
Importing and Exporting of data
Production Support of systems 1 week out of the month
Shell Scriping.
Developer DBA.
Hands-on experience with ODI tools such as ODI Studio, ODI Console, ODI Agent, ODI Topology Manager, and ODI Scheduler for designing, deploying, and managing data integration solutions.
Used Pl/Sql Developer.
I handled development and support of their PowerBuilder 2017 Scheduling System.
Client : Barclays Bank Feb 2014 – Aug 2015
Oracle Database Developer/Oracle PL/SQL Developer, Axiom SL, PowerBuilder 12.5
Responsibilities :
Created a supported pl/sql – ETL routines to load data into our schema or create and supporting numerous regulatory reports.for federal reserve.Plus many more daily Axiom sl features.
All work done in Axiom SL can only take place using their controller view.
Responsible for creating packages and procedures for validating data created with Axiom Reports.
Responsible for tuning SQL for our team, including adding parallelization of Index creation and SQL.
Creation of Analytical reporting done from data created with Axiom.
Helped in the implementation of FR Y-9C, 14C, 14A, 9LP. I added custom edit checks between 9C/14A/14C, and the call report.
Designed and implemented interactive dashboards within the AxiomSL platform, providing stakeholders with real-time insights and facilitating data-driven decision-making.
Perform numerous daily tasks for edit checks on 14A using a combination of Axiom system tables and multiple aggregations and displaying results in free forms for our business users.
Performed some BA work for working on transformation specs and making data specs.
Performed much data analysis and unit testing of data with mock submissions.
Plus many more daily Axiom sl features.
Perform numerous daily tasks for edit checks on 14A using a combination of Axiom system tables and multiple aggregations and displaying results in free forms for our business users.
All work done in Axiom SL can only take place using their controller view.
Shell Scriping.
Developer DBA.
Team Lead and documentation.
Used Pl/Sql Developer.
PowerBuilder developer support for a legacy Trading System.
Client : Citibank, NY July 2012 – Feb 2014
ORACLE PL/SQL WITH Developer, PowerBuilder 9.5 Dev and BAU, ASP 2.1, batch and production support
Responsibilities :
On a daily basis, we bring in 20+ types of data sources such as bond data and swap data. This data is brought into a staging environment using Java Spring classes which I support from time to time. The data is then messaged via Oracle packages.
The team that I work with supports Citibank Treasury Risk. We support approx. separate pl/sql ETL processes which allow us to store every time of product that the bank supports including fixed, floating, and swap bonds, mmkt deposits, trups, hedge funds, deposits, etc.
Used Pl/Sql Developer.
Support our systems as batch and production support
Developer and support person for the company’s PowerBuilder Scheduling System.
Created some internal websites for our Oracle database using ASP 2.
Client : Estee Lauder, NY Jan 2011 – Jun 2012
ORACLE PL/SQL Developer and ETL App DBA Support, shell scripting, Batch and Production Support, ETL, CVSNT
Responsibilities :
Java Spring classes are used for bringing in staging data for our pl/sql ETL processes.
To bring in CVSNT into a dynamic company such as Estee Lauder, a large amount of database and source control was necessary.
I also create, and configure Oracle databases, tablespaces, perform datapump exports and imports, properly setup up memory configuration, and handle any production support questions.
I created a data model for bringing in new clients of Estee Lauder. Each new client has their own needs for what needs to be stored in our database, to be shown in their websites.
Our migration work is all based on fully documented ETL procedures.
On call for batch and production support.
Flow charts created to describe the whole CVSNT process using Allclear Flowcharter software. Earlier in the process of using CVSNT, Visio was used, we switched because management liked Allclear better.
Many of our management sales reports are delivered using Excel and VBA.
Used Pl/Sql Developer
Client : Verizon Wireless, NJ Nov 2010 – Jan 2011
Oracle 11g PL/SQL development, shell scripting, Sybase 12.7 ASE to Oracle 11g Migration
Responsibilities :
This was a temporary assignment. Most time was spent performance tuning various running SQL statements. I fine tuned various packages for performance.
Using BCP scripts generated by Sql Developer to extract the Sybase database metadata to files to create a Captured Model in Sql Developer using offline capture. We used Sql Developer with thi captured model, to convert the captured objects to Oracle-format objects and building structures in the destination database with a converted model. We then had Sql developer create DDL statements to create the new objects from the created model. We used Sql developer to generate the bcp scripts and sqlldr files for offline moving
Used Pl/Sql Developer
Client : Jefferies and Company, NY June 2010 – Nov 2010
Oracle PL/SQL development, Data Warehouse support, ETL, shell scripting, PowerBuilder 9.2, 9.5
Responsibilities :
I worked on several projects including supporting many websites for database support. I created and altered numerous packages, procedures, triggers for these sites. Many management reports were also created.
I created several ETL PL/SQL scripts for data migrations. We brought in SQL Server and Sybase data into Oracle. This was in support of a large data warehouse. I performed data cleansing strategies for normalization, and business rules. I met with several business analysts.
Used Pl/Sql Developer.
PowerBuilder Support and Development of a legacy Trading System.
Client : Cognizant, NY/NJ Jan2010 – June 2010
Oracle 11g PL/SQL, shell scripting, Powerbuilder 9.2
Responsibilities :
I supported and enhanced a Mortgage back securities program written in Powerbuilder. I also created and supported, and tuned, several PL/SQL programs in support of this Mortgage program. I also created numerous Crystal Reports for this Mortgage program.
Designed reports in report designer with end user interactivity by using parameterized and drill through features in SSRS and Java Spring.
Automated certain jobs on daily basis for fresh data.
Client : Nassau Community College, NY (Ellucian Banner System) Feb 2009 – Sept 2009
Oracle PL/SQL Developer/DBA, developer on large SAP impl, shell scripting, ETL work
Responsibilities :
All the reports in the Ellucian Banner system are designed using JSP. I created a lot .JSP programs for showing this accounting data.
I supported the SAP developers by helping them to create SQL queries, by helping them to understand what Packages, Procedures, Functions, Triggers, etc were. This was mostly a teaching assignment, all developers at this college were SAP developers, and didn’t understand SQL. I trained them on how to use PL/SQL for their reports. SCT Banner from SAP was used in
Contact this candidate