Oracle Developer Resume
Youngstown, OH
Profile:
- Salesforce .com Developer and Administrator.
- 6 + years of overall professional IT experience.
- 3 years of experience with Salesforce CRM and Force.com platform and Experience as Salesforce Developer, Salesforce administrator and providing Support for challenging CRM projects implementation.
- Expertise with analyzing business requirements and gathering information required for implementation.
- Experience in developing Apex Classes, Triggers, writing Workflows.
- Experience building Visual Force Pages, Visual Force Custom Controllers/ Components, Custom Objects, Reports, Dashboards, Tabs, Tags and Components.
- Identify relationships and converting to sales force custom objects, lookup relationships, junction objects, master-detail relationships.
- Expertise in Force.com technology stack: APEX, Visual Force, SOQL, SOSL.
- Extensive experience of using declarative features like validation rules, workflows, and approval processes, dynamic approval process, sharing rules automation for satisfying complex business process automations.
- Created page layouts, search layouts to organize fields, custom links, related lists and other components on a record detail and edit pages.
- Worked extensively on various salesforce.com standard objects like Accounts, Contacts, opportunities, Products, Price books, Cases, Leads, Campaigns, Reports and Dashboards
- Hand on experience with Apex Language, Apex Trigger, Apex Class & Apex Web Service, Visual Force (Page, Component & Controllers) and S-Control.
- Expert in system integrations and bulk data load process automation.
- Experience of software development projects, solution design
- Experience of working with diverse database platforms including Oracle, SQL server, MS Access.
- Extensively worked on Backend Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers, Cursors, Indexes , Exception Handling and collections for Oracle 10g/9i/8i and also SQL queries/reports and scripts
- Proficient in SQL*PLUS, SQL*LOADER, PL/SQL DEVELOPER and TOAD applications to manage database.
- Strong experience in Developing and Customizing Reports and Forms using Oracle Reports 6i/2.5, Forms 6i/4.5, Discoverer 4i and XML Publisher 5.6.
- Hands on Experience in Discoverer 4i/10g which include reports development, discoverer administration tasks like creating new business areas, folders and security management.
- Hands-on experience working with Oracle XML technologies (XML, XSL-T, XSL-FO) and knowledge of XML parsing technique (XML-DOM).
Skill Set:
- SFDC: Apex, VisualForce, Standard Salesforce platform and FLEX.
- Database: Oracle 9i/10g/11i and MS-Access, SQL Server.
- Languages: SQL, PL/SQL, Java, JSP, C ++ and C
- Web Tools: HTML, Java Scripting, CSS, Dreamweaver, XML, XSLT, XSL–FO and XML-DOM Development Tools: Eclipse.
- ETL Tools: Informatica 8.6
Experience:
Project 1
Duration : July 2011 – Present
Client/Customer : Confidential, Denver CO
Role : Salesforce Developer /Admin
Roles and Responsibilities:
- Performed the role of a Developer and Administrator.
- Interacted with team members to gather the requirements.
- Worked on Salesforce.com to setup the basic structure for the Organisation and migration from CRM.
- Worked on VF pages, Classes and Objects like Partner ,Account Contact role etc.
- Worked on enhancing the existing VF pages to add new functionality.
- Developed various Custom Objects, validation rules on the objects and tabs, Components and Custom links.
- Worked on Importing, Exporting data from Salesforce.
- Developed Batch jobs to run on hourly and daily basis.
- Worked in Informatica and coordinated with the ETL team.
- Experienced in Developing and Administrating projects on Salesforce platform.
- Data Load for SFDC Standard objects, Custom objects.
- Extensive experience over creating workflows, approval processes, validation rules and sharing & security rules.
- Worked and Coordinated with Offshore client with the requirements.
- Created user Roles and Profiles, security controls and shared settings.
- Implemented field level security, profiles setup.
- Coordinated and maintained Off shore team.
Environment: Salesforce.com / Visual Force, Custom/Standard Objects, Custom Tabs, Page Layouts, Workflow & Approvals, Reports, Eclipse, Force.com Eclipse Plug-in.
Project 2
Duration : May 2011 – June 2011
Client/Customer : Confidential, Youngstown OH
Role : Salesforce Developer
Roles and Responsibilities:
- Performed the role of a Developer.
- Interacted with business team members to gather the requirements and documented the requirements.
- Worked on Salesforce.com application to setup activities and customized it to match the functional needs of the organization.
- Used Force.com platform for developing feature-rich and user-friendly VisualForce pages for enhancing SFDC UI.
- Worked on enhancing the existing VF pages to add new functionality.
- Developed various Custom Objects, validation rules on the objects and tabs, Components and Custom links.
- Designed and developed applications on the Force.com platform using the Apex programming language for controller extensions, apex based triggers and, validation rules.
- Experienced in Developing and Administrating projects on Salesforce platform.
- Data Load for SFDC Standard objects, Custom objects
- Worked on trigger development (recursive triggers).
- Created various reports (summary reports, matrix reports, pie charts, dashboards) and setup report folders to authenticate users based on their profiles (permissions).
- Extensive experience over creating workflows, approval processes, validation rules and sharing & security rules.
- Worked and Coordinated with Offshore client with the requirements.
- Created user Roles and Profiles, security controls and shared settings.
- Implemented field level security, profiles setup.
- Coordinated and maintained Off shore team
Environment: Salesforce Enterprise Edition, Salesforce.com / Visual Force, Custom/Standard Objects, Custom Tabs, Page Layouts, Workflow & Approvals, Reports, Eclipse, Force.com Eclipse Plug-in, Security Controls.
Project 3
Duration : Jan 2011 – Apr 2011
Client/Customer : Confidential, Denver CO
Role : Salesforce Admin
Roles and Responsibilities:
- Worked as a Salesforce Administrator.
- Interacted with various business team members to gather the requirements and documented the requirements.
- Worked on Salesforce.com application to setup activities and customized it to match the functional needs of the organization.
- SFDC Configurations/Customizations – User Interface, Page Layouts, Tabs, Custom fields, Custom objects, Validation Rules.
- Extensive experience over creating workflows, approval processes, validation rules and sharing & security rules.
- Worked on Informatica Powercenter and ETL.
- Used Force.com platform for developing feature-rich and user-friendly VisualForce pages for enhancing SFDC UI.
- Developed various Custom Objects, validation rules on the objects and tabs, Components and Custom links.
- Designed and developed applications on the Force.com platform using the Apex programming language for controller extensions, apex based triggers and, validation rules.
- APEX/Trigger development.
- Added various new functionality to the business for enhancement.
- Created various reports (summary reports, matrix reports, pie charts, dashboards) and setup report folders to authenticate users based on their profiles (permissions).
- Created user Roles and Profiles, security controls and shared settings.
- Implemented field level security, profiles and audit trail setup.
- Coordinated and maintained Off shore team
Environment: Salesforce Enterprise Edition, Salesforce.com / Visual Force, Custom/Standard Objects, Custom Tabs, Page Layouts, Workflow & Approvals, Reports, Eclipse, Force.com Eclipse Plug-in, Security Controls.
Project 4
Duration : June 2010 – Jan 2011
Client/Customer : Confidential, Conshohocken PA
Role : Salesforce.com Developer
Roles and Responsibilities:
- Performed the roles of Salesforce.com Developer and in the organization.
- Designed, Implemented and deployed the Custom objects, Page layouts, Custom tabs and Components to suit to the needs of the application.
- Implemented the requirements on Salesforce.com platform and used Force.com IDE Plug-in using Eclipse to develop Apex classes and Triggers
- Created multiple Approval processes using Workflows to approve, reject or edit Records.
- Worked on Building Dynamic Approval processes.
- Customized dashboards to track opportunities.
- Customized Reports to track usage for productivity and performance of business centers and their sales teams.
- Supported end users and helped them in getting used to the application, generated reports and saved them for further access to the users.
- Built VisualForce Pages, embedded JavaScript into VF pages.
- Visualforce/S-Control development.
- APEX/Trigger development.
- Built Batch Apex jobs, Scheduler Apex Jobs.
- Developed Triggers which were bulk friendly.
- Written SOQL queries to fetch the data from the salesforce schema.
- Importing and exporting large volumes of data
- Creating and managing complex workflow rules, data validation, and system triggers
- Implementing and managing various complex sales and business processes within one org.
- Managing multiple users set up, profiles, roles, and teams
- Deploying the APEX code from the development to production sandbox.
- Writing the Design document for the module implemented in salesforce.
Environment: Salesforce Enterprise Edition, S-Controls, Salesforce.com / Visual Force,Custom/Standard Objects, Custom Tabs, Page Layouts, Workflow & Approvals, Reports, Eclipse, Force.com Eclipse Plug-in, SalesForce.com sandbox data load, Security Controls, Informatica 8.6.
Project 5
Client/Customer : Confidential, SFO CA
Duration : Nov 2009 – Apr 2010
Role : Salesforce Developer
Roles and Responsibilities:
- Used Force.com platform for developing feature rich and user friendly pages for enhancing Salesforce UI.
- Developed VisualForce pages to change the entire look and feel, tabs and views of the Salesforce.com UI in accordance with the company requirements.
- Created new custom objects, assigned fields, designed page layouts, custom tabs, components, custom reports
- Wrote triggers to process incoming service e-mail requests from customers to automatically create new case records
- Defined Assignment rules to enable proper routing of cases to the case team members.
- Created various Reports (summary reports, matrix reports, pie charts, and graphics) and Report Folders to assist Service managers to better utilize Sales force and configured various Reports and for different user profiles based on the need in the organization.
- Created Customized dashboards for the service representatives and case team members to keep track of the cases assigned to them and to share insight across the company.
- Created sliders, custom buttons, and auto-grow text areas and imported HTML editor into Visual Force pages.
- Extensively used the Firebug on the visualforce pages to navigate thru the Visualforce Tags.
- Involved in working with CSS and Java Scripting while designing the Visual Force Pages.
Environment: Salesforce Enterprise Edition, Salesforce.com Custom/Standard Objects, Custom Tabs, Page Layouts, Workflow & Approvals, Reports, Eclipse, Visual Force, Force.com Eclipse Plug-in, SalesForce.com Apex Data loader 17.0.
Project 6
Client/Customer :Confidential, Dallas TX
Duration : Aug 2008 – Sept 2009
Role : Salesforce.com Developer
Role & Responsibilities:
- Performed the roles of Salesforce.com Developer in the organization
- Interacted with various business user groups for gathering the requirements for CRM implementation
- Involved in Salesforce.com application setup activities and customized the UI to match the functional needs of the organization
- Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse
- Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns, Opportunities, Quotes, Activities, Dashboards and Reports
- Created new custom objects, assigned fields, designed page layouts, custom tabs, components, custom reports
- Created and deployed several reports for different user profiles based on the need in the organization.
- Customized the Dashboards to the track usage for productivity and performance of business centers and their sales teams
- Designed various HTML Email templates
- Installed and deployed OrgView, a Force.com AppExchange tool that allows users to create visual org charts and update them in Sales force CRM using drag-and-drop functionality.
Environment: Saleforce.com platform, Force.com API, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Apex Language, Visual Force,Salesforce.com Data Loader, Security Controls, HTML, Java Script, Web Services, WSDL, Sandbox, Eclipse IDE Plug-in.
Project 7
Client/Customer : Confidential
Duration : Jan 2007 – Dec 2007
Role : Oracle Developer
Roles and Responsibilities:
- Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
- Develop a form using Forms 6i from scratch using TEMPLATE.FMB.
- Worked on building Business Areas, Discoverer Workbooks and Parameterized reports using Discoverer 4i
- Created business areas, custom folders, summary folders, hierarchies and item classes in Discoverer Administration.
- Created ad hoc workbooks using Discoverer plus, Discoverer desktop and shared the workbooks with the designated users.
- Creating Stored Program Units in the Functions, Triggers, procedures and packages for implementing complex database intensive business rules.
- Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
- Involved in Creation of tables, Partitioning tables, Join conditions, correlated sub queries, and nested queries, views, sequences, synonyms for the business application development.
- Performance tuning of the application programs using EXPLAIN PLAN, TKPROF and SQL TRACE.
- Used the Cursor for Loop for unconditionally fetch all the rows into a single cursor.
- Used DBMS_PROFILER package to understand where the code is spending the most time, detect it and then optimize it.
- Developed reports using complex queries as per client request as a part of production support.
- Developed forms screens like Entering sales orders, Closing orders, Copying sales orders, Entering returns, Canceling orders and returns, Pricing orders, Item cross referencing, Outbound purchase order acknowledges.
- Wrote complex SQL queries including inline queries and subqueries for faster data retrieval from multiple tables.
- Developed LOV’s and Triggers for different data blocks.
Environment: Oracle 9.2.0.6, Oracle Forms 9i, PL/SQL, SQL*PLUS, TOAD, Informatica.
Project 8
Client/Customer : Confidential
Duration : Mar 2006 – Dec 2006
Role : Oracle Developer
Roles and Responsibilities:
- Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
- Involved in Writing Backend Packages extensively in PL/SQL.
- Involved in Code Reviews and preparing unit test cases.
- Maintained the data integrity and security using integrity constraints and database triggers
- Optimized and enhanced the existing procedures and SQL statements for the better performance.
- Defining and reviewing the coding standards, besides reviewing the code.
- Created, debugged, and modified stored procedures, triggers, tables, views, user-defined functions etc.
- Extensively Involved in Preparing Detailed technical documents from the functional specifications.
- Preparation of Checklists, identification of Test Cases, preparing Test Plans.
- Integrating and deploying in production
- Preparation of detail design documents.
- Customization of code as per the user requirements.
- Involved in the analysis of the existing database.
- Designed and extensively worked on project documentation.
- Extensive Use of Bulk Binds, Bulk Collect.
- Extensive Use of Pragma Autonomous Transactions.
- All the values that need to hard code extensively use parameters for better procedural development.
- Built Error management System for the Capturing all the Errors in the Packages and all the errors that belong to pl/sql are generated using error management system
- Extensive Use of External tables and Creating Sequences to generate numbers on the fly.
- Co-ordination between development, testing and production teams and attending bridge calls and technical. Discussions regarding future developments and releases.
Environment: Oracle 8i, SQL*plus, Forms 4.5, Reports 2.5, Windows 2000
EDUCATION:
Bachelors in Computer Science