Post Job Free
Sign in

Developer Oracle

Location:
Plymouth, MN
Posted:
November 06, 2014

Contact this candidate

Resume:

Career Objective

Seeking a position of an Application System Engineer, System Analyst, OBIEE

Developer/ Architect, PL/SQL Developer to utilize my experience and

technical knowledge in the full life cycle of application development

including requirement definition, prototyping, proof of concept, design,

interface implementation, testing, and maintenance.

Qualifications

. 10+ years experience in Information Technology.

. Expert in Application designing and development.

. Expert in Database design and development.

. Expert in ETL designing and development.

. Experience in application installation, upgrading, and maintenance.

. Extensive experience on interaction with system users on gathering

business requirements and involved in developing project use cases in

various projects.

. Experienced in full life cycle of project development especially with

SDLC (System Development Life Cycle) methodology.

. Experience working in a team or individual.

. Excellent communication skills.

. Ability to work in more than one project.

Technical Skills

PLATFORMS: Windows, AS400, and UNIX (Linux, Solaris, and SCO).

RDBMS: Oracle (8i/9i/10g/11g), MS SQL Server and MS Access.

LANGUAGES: Advanced PL/SQL, Java, HTML/JavaScript, XML, C/C++, Pro*C,

Visual Basic.Net, C#, SQL, Perl, and UNIX Shell

script.

DEVELOPMENT TOOLS: Oracle Developer Suite, SQL Plus, Visual Studio,

JBuilder, Oracle SQL Developer, Crystal Report 9.0,

JDeveloper, OBIEE Administration tool/Catalog OBIEE

Analytics, BI Publisher, Hyperion, WebCenter,

Microsoft SharePoint, SQL *Loader, ODI, Golden Gate,

SQR, TOAD, Microsoft Visual Source Safe, PVCS, APEX,

ERWin, FTP, Informatica (Power Center), Mercury

Quality Center, Apache Tomcat, Oracle Portal, HP

Application Lifecyle Management, Autosys, and CVS.

APPLICATIONS: Microsoft Office Suite, MS Visio, MS

Project, Microsoft

Outlook and Novell GroupWise

PROFESSIONAL EXPERIENCES

Technology Operations Group (TOG) - Wells Fargo, Minneapolis, MN

The Technology and Operation Group is responsible for providing most of

Wells Fargo's core technology and core support.

Application Engineer April 2012 - Current

Responsibilities:

. Development and administration of Oracle Business Intelligence

Enterprise Edition (OBIEE) reporting and analytics solutions within

Corporate Finance Technology Group.

. Gathering technical requirements design and develop business

analytical solutions, testing and implementing of Business

Intelligence requirements.

. Analyzes business requirements, designs and writes technical

specifications to design or redesign computer solutions

. Design Data model (Star Schema with Hierarchy) and develop ER

diagrams.

. Develop OBIEE Repository (Physical Layer, Business Logic and

Presentation Layer).

. Provide technical support to develop reports and dashboards.

. Use Linux shell scripts to create scheduled jobs and maintenance.

. Install OBIEE in Unix and Windows platforms.

. Implement security models in OBIEE platform (Authentication and

Authorization).

. Develops original and/or complex code or provides coding guidance to

less experienced staff.

. Leads and/or performs modeling, simulations and analysis efforts.

. Verifies program logic by overseeing the preparation of test data,

testing and debugging of programs.

. Participates in overall systems testing.

. Leads the migration of applications to production.

. Develops new documentation, participates in the development of

department technical procedures and designs user guides.

. Leads projects, including assignment of tasks, and provides direction

and guidance to less experienced staff.

. Implementing BI Publisher reporting using bursting technology.

. Perform training to other developers.

. Work as Business Continuity Administrator (BCA) for BI Supply Chain

application Business Continuity Plan (BCP).

. Work as Access Certification Tool Administrator (ACT) for BI Supply

Chain application. ACT is an enterprise solution used by managers and

their delegates to facilitate timely review and certification of user

access to application, shared drives and SharePoint sites, system

account, user profile, and access to facilities.

Environment: Oracle Database 10g/11g, PL/SQL, SQL *Plus, Microsoft Visual

SourceSafe, ToadV10, Oracle SQL Developer, Autosys, XML, HTML, ASP,

JavaScript, JSP, Servlet, HP Application Lifecyle Management, Microsoft

SharePoint, Visual Source Safe, MS Project, OBIEE Analytics 10/11g, and BI

Publisher 11g.

Office of Mental Health (OMH) - NYS, Albany, NY

The Office of Mental Health (OMH) operates psychiatric centers across the

State, and also regulates, certifies and oversees more than 2,500 programs,

which are operated by local governments and nonprofit agencies. These

programs include various inpatient and outpatient programs, emergency,

community support, residential and family care programs.

System Analyst/OBIEE Developer March

2008 - April 2012

Responsibilities:

. Participated in implementation of the OBIEE, BI Publisher and

WebCenter applications.

. Created Physical Layer and Business Model creation and build the

presentation layer.

. Developed analytics and dashboards in OBIEE based on user

specifications

. Designed and developed data model and BI Publisher reports.

. Defined security model for OBIEE, BI Publisher and WebCenter

applications.

. Designed and developed Analytical, Operational and Transactional

reports.

. Administered Web Logic server and BI Server.

. Wrote and modified Oracle PL/SQL, SQL statements procedures and

functions that are used in Crystal Reports.

. Created the extract, transform and load (ETL) architecture to move

the source data into an Oracle Data Warehouse data model using

Informatica.

. Involved in the development of crystal reports.

. Created and modified database objects like tables, table partitions,

views, functions, procedures, synonyms, and triggers.

. Performed SQL Tuning for various module and created indexes to

improve the performance.

. Rewrite SQL queries to improve the performance of the application.

. Integrated crystal reports using JAVA, JavaScript, Visual Basic 6.0

and Visual Basic .Net.

. Created Test cases for various modules.

. Responsible in unit testing and documentation.

. Performed the back-end and front of CAIRS application.

. Responsible for documentation of business and technical architecture

for reference.

. Used Scrum development method.

Environment: Oracle Database 10g/11g, PL/SQL, SQL *Plus, Crystal Reports

9.0, Visual Studio 6.0 and Visual Basic 6.0, Visual Studio .Net and Visual

Basic .Net, Microsoft Visual SourceSafe, ToadV10, Oracle Developer Reports,

Oracle Developer, XML, Informatica, Oracle Portal, JDeveloper, OBIEE

Analytics 10/11g, BI Publisher 11g, WebCenter 11g, and SQL *Loader.

StanCorp Financial Group, Inc., Portland, OR

StanCorp Financial Group, Inc., through its subsidiaries marketed as The

Standard - Standard Insurance Company, The Standard Life Insurance Company

of New York, Standard Retirement Services, StanCorp Mortgage Investors,

StanCorp Investment Advisers, StanCorp Equities, StanCorp Real Estate, and

StanCorp Trust Company - is a leading provider of financial products and

services. StanCorp's subsidiaries serve approximately 8.5 million customers

nationwide as of June 30, 2008, with group and individual disability

insurance, group life, AD&D and dental insurance; retirement plans products

and services, individual annuities and investment advice. As a consultant

in the development team, I was responsible on ETL (extract, transform and

load) retirement plan data from a database which StanCorp bought (IVR and

PRIZM application).

PL/SQL Developer December 2007 - March 2008

Responsibilities:

. Wrote and modified Oracle PL/SQL, SQL statements, stored procedures

and functions.

. Creating and managing schema objects like tables, indexes, views,

synonyms, clusters, etc.

. Used Dynamic SQL for DDL commands in PL/SQL.

. Migrated data to the new business retirement plan using PL/SQL

procedures with TOAD.

. Fine-tuned and re wrote existing packages to improve performance and

to meet new business requirements.

. Created 20 tables, Views, Synonyms, Packages, Triggers, and

Procedures.

. Developed database triggers to maintain audit tables.

. Performed SQL Tuning using Explain Plan.

. Created Advanced ETL

. Documented business and technical architecture for reference.

Environment: Oracle 10i, Toad V10, Oracle Developer Suite, UNIX, Sun

Solaris 9, XML, JSP, Java, C++, JDBC, SQL loader and PVCS

The Port Authority of NY & NJ

The Port Authority of New York and New Jersey manages and maintains the

bridges, tunnels, bus terminals, airports, PATH and seaport that are

critical to the bi-state region's trade and transportation capabilities.

As a Consultant on a technology services development team, I was

responsible for enhancing the CONFirm! Application by implementing The

North American Industry Classification System (NAICS) codes, created

inbound and outbound interface to the other applications to receive and

send bidding, contract awards and vendors' registration processes for

those who want to do business with Port Authority, and to create new

reports and enhance the existing reports. The user interface is developed

in Oracle Forms and Oracle Reports.

Oracle Report/Forms Developer April 2007 -

December 2007

Responsibilities:

. Responsible for designing, developing, reviewing, implementing,

testing of different modules.

. Wrote and modified Oracle PL/SQL, SQL statements procedures

and functions that are used in Oracle Forms and Reports.

. Involved in the development of custom forms and reports.

. Created and modified database objects like tables, views, functions,

procedures, synonyms, and triggers.

. Performed SQL Tuning for various module and created indexes to

improve the performance.

. Rewrite SQL queries to improve the performance of the application.

. Prepared Test Plans for various modules.

. Responsible in testing and documentation.

. Tested the CONFirm! application on Oracle 9.2.0.8.0 database

. Documented business and technical architecture for reference.

Environment: Oracle 9i (9.2.0.8.0), PL/SQL, SQL *Plus, Oracle Developer

Forms, Oracle Developer Reports, Oracle Developer, XML, and SQL *Loader.

Mount Vernon Neighborhood Health Center

The MTVNHC Network consists of 3 health center satellites located in Mount

Vernon, Yonkers and Greenburgh, NY; the Edward Williams School-Based

Health Program; MTVNHC serves as a healthcare home to thousands of

residents and families in lower-Westchester County and the Bronx

System Administrator April 2001

- April 2007

Responsibilities:

. Configuring and Administrating Windows 2000/2003 Servers, MS

Exchange Servers, SCO Servers, Internet Routers, and AS 400 Server.

. Installing Software and Hardware troubleshooting.

. Preparing special reports using Crystal Report Software or other

applications.

. Involved in the development of custom forms and reports.

. Using SQL to create reports.

Environment: Windows XP, Windows 2000 & 2003 servers, UNIX (SCO), IBM

AS400, MS Exchange, Microsoft Office Suite, and Crystal Report.

EDUCATION

Monroe College, New York

AAS Degree in Computer Science (2001)

Associate Degree/Computer Science

Monroe College, New York

Bachelor Degree/Computer Information Systems (2002)

BBA Degree in Computer Information Systems.

New York Institute of Technology, New York

Graduate Degree/Computer Science (2006)

Masters in Computer Science

CERTIFICATION

Oracle Advanced PL/SQL Developer Certified Associate (2009)

Oracle Advanced PL/SQL Developer Certified Professional (2010)

REFERENCE

Available upon request.



Contact this candidate