Sql Server Data Warehouse
Resume:
ROMEO ROMANO
ad5sj0@r.postjobfree.com
SUMMARY:
10+ years of experience in Oracle, PL/SQL, SQL Server 2019 for backend design, development and strong Forms/Reports Development. Regularly upgrade server and applications to support technology mandates. Designed and built Oracle database schema and interface. Strong Oracle EBS experience, analyzing and resolving custom code and assimilation issues.
Acted together with the users to design the underlying data warehouse and marts.
Experienced in project life cycle, upgraded and migrated Forms, Reports, Libraries, Menus from any version to Forms 12c, from lower version to higher version.
Ability to develop Web Application by enhanced PL/SQL coding through Oracle APEX. Strong experience in OEM (Oracle Enterprise Manager OEM Cloud Control 12c), SQL* Net, SQL Loader and SQL*PLUS.
Extensive knowledge of SQL, PL/SQL, Forms (4.50/5.0/6i/ 10g/11g/ 12c), REPORTS (2.5/3.0, 11g), SQL*Plus in Oracle RDBMS versions 7, 8, 8i, 9i, 1Og, 11g, 12c, 18c and 19c
Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, and SQL*Navigator, PL/SQL Developer, Toad for Oracle l2.0 and SQL Server Management Studio 2019(SSMS)
Use Java Database Connectivity (JDBC) standard is used by Java applications to access and manipulate data in relational databases.
Extensive experience in Oracle RDBMS design and developing Stored Procedures/Packages, Triggers, Cursors using SQL and PL/SQL
Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
Experience in writing basic shell script using ksh, bash, perl for automation of databases and scheduling.
Experienced in Informática (7.x) applications.
Designed and developed the Workflows, Worklets, Mappings, Mapplets, Sessions, Tasks, Transformations and schedule the Workflows and Sessions.
Experienced with Informática tools - Source Analyzer, Warehouse designer. Mapping designer, Mapplet Designer, Transformations Developer, Informática Repository.
Experienced in Analysis, Design, Development and Deployment of Data Warehousing applications using Cognos Report Net v. 1.1, Cognos Power Play v.7.3, Cognos Impromptu v.7.3, Cognos Transformer, Cognos Upfront, Security Server (LDAP SunOne), Web Servers (Apache, IIS) for Oracle environment, MS Access 2000, TIBCO Jasper soft Studio-6.5.1, JasperSoft IReport 5.6.0
Good Hands-on experience on Unix Shell Script, VB Script and Perl Script
Developing web applications by using Oracle Application Express (APEX 19.1 or related)
Develop and maintain ETL processes
Responsible for verifying accuracy of data in data extracts and data warehouse
Troubleshoot and resolve issues in reports, dashboards, and ETL packages
SKILLS:
Linux(RedHat 5/6), DEC-VAX 7600/4500, VMS 6. 1, DCL, Compaq PC/DELL, Windows2000/W
indows NT4.0, Oracle v.6/7.3/8.0/8i/9i/10g, Novell NW 4.0, Developer2000 vl.5/2.1/2.2/6i, Designer2000 v.1.3, C#/C Language/MS Access 2000, VBA, HP Enterprise Servers, HP 9000/800, HP-Unix B.11.0, Toad® for Oracle Sllitev.8.0, PL/SQL Language
PROFESSIONAL EXPERIENCE:
Meijer, Grand Rapid, Michigan May 2023 – Jan 2024
Oracle PL/SQL Developer
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader.
Developing scripts for dll the data requests from client where based on business logic, we need to provide the data to customers.
Designing and implementing database structures, including tables, indexes, and views.
Providing Technical support to end users for any Application Related or Data Related Purchase Order issues.
Using Incident Management techniques for tracking any issue, resolving issue, updating tickets and closing them.
Following Change Management Practices for changes in existing code, processes, bug fixes.
Analyzing and resolving any production issue related to CSM
Quantifying the impacted base for any particular issue and doing clean up in production data base to mitigate production issue impacts
Providing Support for Production Outages, on call support for triage issues and communicating to business and end users accordingly.
Application Monitoring and Operational Readiness to identify any issue proactively and work to resolve it with in SLA.
Strong Knowledge of HTML4/5, JavaScript, CSS, XML, REST API, TOAD, ORACLE Application Express 18+, OBIEE/BI Publisher 12
Oracle concepts like Bulk Collect, FORALL, Collections (Associative arrays, nested tables, arrays), and LISTAGG
Oracle Tools and Utilities - SQL Navigator, TOAD, SQL*Loader, Putty, Crontab, Tortoise CVS version control, WinSCP, MoveIT, JIRA PL/SQL API’s .
Store, retrieve, and manipulate third party data for analysis of system capabilities and requirements using the Oracle utilities such as SQL *Loader, Data Pump, CLOB, UTL Utilities, and XML Utilities.
Unix/Linux based scripting.
Automated data consolidation from multiple sources using VBA, reducing report generation time by 30%.
Streamlined budgeting process by creating a user-friendly VBA tool, leading to a 40% reduction in manual entry errors.
Deployed VBA scripts to optimize inventory tracking systems, resulting in a 20% improvement in supply chain efficiency.
Orchestrated the automation of repetitive data processes with VBA, freeing up approximately 10 hours per week for the analytics team.
Bank of New York Mellon, NY (With TCS) Feb 01, 2022 – Mar 31, 2023
SQL Developer
Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server and Oracle databases.
Wrote complex SQL Queries, stored procedure, triggers, views & Indexes using DML based on inputs.
Improves performance of T-SQL stored procedures using Execution Plan recommendations.
Expertise in Dynamic SQL, Collections and Exception handling. Experience in SQL performance tuning using Cost-Based Optimization (CBO)
Good knowledge of key performance related features such as Query Optimizer and SQL Server Management Studio (SSMS)
Experience in writing basic shell script using ksh, bash, perl for automation of databases and scheduling. Application Monitoring and Operational Readiness to identify any issue proactively and work to resolve it with in SLA.
Strong Knowledge of HTML4/5, JavaScript, CSS, XML, REST API, TOAD, ORACLE Application Express 18+, OBIEE/BI Publisher 12
Oracle concepts like Bulk Collect, FORALL, Collections (Associative arrays, nested tables, arrays), and LISTAGG
Oracle Tools and Utilities - SQL Navigator, TOAD, SQL*Loader, Putty, Crontab, Tortoise CVS version control, WinSCP, MoveIT, JIRA PL/SQL API’s .
Store, retrieve, and manipulate third party data for analysis of system capabilities and requirements using the Oracle utilities such as SQL *Loader, Data Pump, CLOB, UTL Utilities, and XML Utilities
Linux/Unix based scripting
.
Bank of America, Charlotte, NC Aug 2021 – Oct 2021
Oracle PL/SQL Developer
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader.
Partitioned large Tables using range partition technique. Experience with Oracle Supplied Packages such as DBMS_SQL, DBMSJOB and UTL_FILE
Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. Worked extensively on Ref Cursor, External Tables and Collections
Expertise in Dynamic SQL, Collections and Exception handling. Experience in SQL performance tuning using Cost-Based Optimization (CBO)
Good knowledge of key Oracle performance related features such as Query Optimizer.
Optimizing queries stored-procedures, triggers, tables, views, and functions.
Maintained web code/applications using ASP.NET, C#.NET, HTML, Services and MS SQL in backend.
Worked with ASP.Net MVC 4.0, partial views, and master pages and developed Cascading Style Sheets (CSS) for consistent look and feel of the website
Linux/Unix based scripting
Citigroup, NJ(with Larsen and Toubro Infotech) May 2020 - Feb 2021
Oracle PL/SQL Developer
Enforce application stability, attend change requests coming from L1/L2 and addressing mandatory technology changes.
Support business, resolve application issues on a fast-paced environment.
Assisted in configuration, development and testing of AutoSys JIL and other scripts.
Provided technical assistance for development and maintenance of AutoSys and related scheduling solutions.
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. Expertise in Client-Server application development using Oracle 12c/11 g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER. Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
Developed materialized views for data replication in distributed environments.
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader.
Unix based scripting
Partitioned large Tables using range partition technique. Experience with Oracle Supplied Packages such as DBMS_SQL, DBMSJOB and UTL_FILE
Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. Worked extensively on Ref Cursor, External Tables and Collections
Expertise in Dynamic SQL, Collections and Exception handling. Experience in SQL performance tuning using Cost-Based Optimization (CBO)
Good knowledge of key Oracle performance related features such as Query Optimizer
Execution Plans and Indexes. Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS
Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Linux/Unix based scripting. Develop and maintain ETL processes
Responsible for verifying accuracy of data in data extracts and data warehouse
Troubleshoot and resolve issues in reports, dashboards, and ETL packages
Phillips 66 Company, OK(with Larsen and Toubro Infotech) Sep 2019 - Apr 2020
Oracle PL/SQL Developer
Enforce application stability, attend change requests coming from L1/L2 and addressing mandatory technology changes.
Support business, resolve application issues on a fast-paced environment.
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. Expertise in Client-Server application development using Oracle 12c/11 g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER. Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
Developed materialized views for data replication in distributed environments.
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader.
Partitioned large Tables using range partition technique. Experience with Oracle Supplied Packages such as DBMS_SQL, DBMSJOB and UTL_FILE
Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. Worked extensively on Ref Cursor, External Tables and Collections
Expertise in Dynamic SQL, Collections and Exception handling. Experience in SQL performance tuning using Cost-Based Optimization (CBO)
Good knowledge of key Oracle performance related features such as Query Optimizer
Execution Plans and Indexes. Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS
Modify in-house front-end using Microsoft .Net 4.5 framework, ASP.Net (MVC5), C#, Entity Framework
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Unix based scripting
IBM - MTA, New York City, NY Mar 18 - Jul 19
Oracle PL/SQL Developer
Oracle 11/g/12c RDBMS design and developing Stored Procedures/Packages, Triggers, Cursors using SQL and PL/SQL
Used Oracle tools utilities SQL Loader v.8.0. and TOAD 12 and SQL*Navigator
Designed and developed Web-enabled Oracle Forms v.11g/12c and Reports 11g/12c. Including Forms based on stored procedures.
Supported Oracle EBS units and resolved technical programming problems.
Collaborated with end users and developers’ team to provide tire 2 supports.
Oracle performance related features such as Query Optimizer, Execution Plans & Indexes and Solid troubleshooting skills
Unix based scripting
BNP Media, Troy, MI Jan 17 - Mar 18
Oracle Developer/Salesforce Admin
Engaged in Salesforce Administration
Oracle RDBMS design and developing Stored Procedures/Packages, Triggers, Cursors using SQL and PL/SQL
Used Oracle tools utilities SQL Loader v.8.0. and TOAD 12 and SQL*Navigator
Designed and developed Web-enabled Oracle Forms and Reports. Including Forms based on stored procedures.
Created MS Excel VBA custom application for HR Department.
Oracle Apex Webservices/ API dev
Unix based scripting
Oracle Apex Webservices/ API dev
Unix based scripting
OPSEU Pension Trust, Toronto, CANADA Jan 07 - Aug 16
Senior Application Developer
Upgraded 6i client server Oracle Forms and Reports application to web-based lOg and ran the application through Oracle Portal and Single Sign-on
Strong demonstrable experience in systems architecture and N-tier application development using Microsoft's web technology stack (ASP.NET MVC5, C#, IIS6/7/8, ADO.NET, Entity Framework, SOAP/REST Web Services including Web API and WCF, Http Handlers, Http Modules. Java8, jQuery, Spring Framework, JSF, Jasper Reports and Migration Plan
Strong experience implementing standards based front-end development (HTML5, XHTML5, JavaScript, and CSS3)
Experienced in Informática (7.x) applications.
Responsible for design, developing, testing, and documenting using Oracle Application Express Oracle APEX 18.2 Software to meet users' needs.
Designed and developed the Workflows, Worklets, Mappings, Mapplets, Sessions, Tasks, Transformations and schedule the Workflows and Sessions.
Interacted with end-users and functional analysts to identify and develop Business Specification Documents (BSD) and transform it into technical requirements.
Experience with Informática tools - Source Analyzer, Warehouse designer. Mapping designer, Mapplet Designer, Transformations Developer, Informática Repository.
Developed efficient PL/SQL programs to access Oracle databases. Manage data retrieval for front-end applications.
Designed and created an interface between custom application and accounting application.
Mentored junior programmers in Oracle database design and development.
Assisted in setting up the Forms and Reports Services on standalone 1Og App Server.
Designed and developed Web-enabled Oracle Forms and Reports. Including Forms based on stored procedures.
Created MS Excel VBA custom application for Investment Finance.
Developed MS Access application for Corporate Finance.
Thorough knowledge of Progress or Progress 4GL programming, SDLC principles and practices, Linux and Unix OS, Progress database administration, code testing and debugging, software troubleshooting methods, application integration and UNIX scripting, Progress OpenEdge development, web programming and WebSpeed, requirement gathering and analysis, project management, SQL queries, Progress OpenEdge Architect, source control management systems, networking administration, OOPS concepts
Vatti-Manhattan Group, Trumbull, CT Nov 06 - Dec 06
Oracle PL/SQL Developer/Crystal Developer
Wrote Pl/SQL stored procedures and trigger.
Coded and debugged triggers at various levels and involved in testing of each module.
Responsible for writing necessary UNIX Scripts.
Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
Documentation of the Newly Developed ETL System
Another task that not assigned to help to accomplish important to IT department.
Bristol-Myers Squibb, Hopewell, NJ Aug 06 - Nov 06
Oracle PL/SQL Developer/Crystal Developer
Developed VBA Application on Excel Spreadsheet
Created reports like: Stock wise Report in Crystal Reports v.9. Used Discoverer/2000 to build and provides a business-like representation of the complex data held in the applications systems.
Wrote Pl/SQL stored procedures and trigger.
Coded and debugged triggers at various levels and involved in testing of each module.
Responsible for writing necessary UNIX Scripts.
Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
Another task that not assigned to help to accomplish important to IT department.
University of Michigan (M-CARE), Ann Arbor, MI Mar 06 - Aug 06
Oracle PL/SQL Developer
Wrote PL/SQL stored procedures and trigger.
Created Reports like: Customer Bill Invoice, Customer Transaction listing Report in Crystal Reports v.9
Coded and debugged triggers at various levels and involved in testing of each module.
Responsible for writing necessary UNIX Scripts.
Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
Wrote complex SQLs using joins, sub queries and correlated sub queries.
Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
Environment: Oracle 9i/10g, Crystal Reports v. 10, SQL, SQL*Navigator, PL/SQL, HP-UNIX, OADv.8.6, Visual Source Safe v. 6.0, WRQ-Reflection for HP-Unix v.9.0
Donnelley Marketing, Ames, IA Dec 2005-Mar 2006
Oracle PL/SQL Developer
UPS Supply Chain Solution, Oakville, Ontario, CANADA Jan 2005-Nov 2005
Systems Analyst (Data Modeling, Oracle, Cognos)
Russell Metals Inc., Mississauga, ON Jan 2001-Dec 2004
Application Support Analyst
EDUCATION:
Philippine Aeronautical Technical School, Bachelor of Science, 1984
CERTIFICATIONS:
MS Access Certified Professional (I-C0281039 7024)
TRAINING:
Oracle® PL/SQL Programming (Stored Procedure and Functions).
Oracle Forms Developer 1Og: Build Internet Applications.
Oracle Reports 1Og.
Oracle COE Products.
SQL*Plus 3.0/ I0g.
Administer Oracle (DBA) 7.0 - I.
Programming with .NET : A Comprehensive Hands-On.
JAVA Programming Language.
C# Programming Language.
C Language Programming.
Sybase DEV326 Data Modeling with PowerDesigner 12.
Data General Unix Administration.
Novel Netware Administration v.4.01.
TCP/IP Open Systems Networking Explained.
Client-Server Databases.
MS Access 2007NBA, Scripting.
Contact this candidate