SUMMARY:

• Confidential has an extensive background in software architecture & design, Oracle Products and SaaS implementations.

• Over 15 years of progressive software experience as a Solutions Architect, Lead Analyst and Expert programmer with emphasis on ERP and Confidential implementations for clients, revenue ranging from couple of Millions to $ 14 Billion Business.
• Versatile at playing multiple roles within an organization from B.A to Technical Architect.
• ADM 201, Dev 401 & Brainbench Certified in Programming Concepts and currently pursuing other Salesforce certifications.
• Expert at business process reengineering, performing and directing - Confidential setup and deployment, Confidential to back office integration, Confidential customizations specific to Salesforce.com.
• Ability to setup, customize and deploy Salesforce.com from the ground up for large user groups, perform hands on customizations using Apex, Salesforce.com Web Services API and Visualforce and train end users.
• Well versed with different Force.com platform add-ons like Up2Go, Import2, Conga Merge, APPTUS, DreamFactory, CloudPDF and Cloud9 Analytics.
• Expertise includes all Oracle Products, several BI tools, over 10 years of PL/SQL experience, forms, reports along with experience in using cutting edge ETL tools like Cast Iron, Informatica 8.x, PowerCenter, SAP BODS, SAP BOBJ, Salesforce.com Connectors, and a host of other applications.
• Experienced in leading teams through all stages of SDLC and expertise in Process Re-Engineering, Maintenance, Enhancements, Development, Data Interface projects and Data Conversion projects
• Expertise in On-site co-ordination USA from/to India & Philippines, production support, testing and documentation of application.
• 10 Years of experience in ensuring development standards, writing, reviewing, code inspecting, modularizing, Performance Tuning and Testing Stored Procedures, Functions, Database Triggers, and Packages.
• Confidential Modules: Worked in Salesforce.com implementations, APEX, Visual Force, customizations, integration for sales, forecasting, marketing and call center using informatica and Cast Iron.
• ERP Modules: Work in Process, Shipping, Inventory, Bill of Materials, Purchase Order, Application Object Library, Order Management, Advanced Supply Chain Management, Demand Planning
• Tuning & Performance: Sound experience in tuning application design, SQL queries and PL/SQL programs for better performance. Used Index - B*Tree Index & Bit Map Index, Cluster, Hints.
• Team player, self-starter, ability to work in multiple business features, detail oriented and good communication skills. Experience includes working with big consulting firms, international deployments and proficiency in 3 languages.

TECHNICAL SKILLS:

Hardware: IBM - PC (Intel Based Clients), SUN Solaris 2.6 System (Server), HP UNIX Server

O/S: MS Windows 8, Vista, XP, 2003, SunOS 5.0 and HP UX 11.22

Data Modeling Tool: ERwin 7.1, 4.x, 3.x

Front End: VF, Oracle Forms 6i, HTML 4.0, XML, Web PL/SQL, ASP 3.0, JavaScript, VBScript, Delphi

OLTP Reporting Tool: Salesforce Reports, Oracle Reports 6i, Crystal Reports 5.x, 4.6, Data Reports, Quick Reports, SQL Reports

IDE: TOAD 9.0.1.8, MS Visual Studio 6.0, Dream Weaver 3.x, MS FrontPage 2001, Eclipse - Kepler, PL/SQL Developer

Languages: Apex, Java, VB 6.0, 5.0, SQL, PL/SQL & T-SQL

Business Application: Fed Brands, DIVBUY, Oracle Applications 11i, NETSUITE, Oracle Small Business Suite, Salesforce Confidential, RTS, TOPS, PLM, MS Projects, PM insights

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Key fields in Master Parts, DLI Parts, Product Category, Projects, Line Items, Price Schedule were identified & evaluated with business users, generated data mapping files, defined and configured in TS Salesforce.com
• Prepared Requirement Definition document for CI orchestrations, External Identifiers were created for the data synchronizations, peer-reviewed Parallelization and Batch processing in Cast Iron Orchestrations
• Data Quality is ensured with the definitions of Validation rules and Account merging approval process flows
• Workflows created - Account Region (DD1, DD2, DD3), Part description display in Forecast screen.
• Data Security is maintained using OWD, Profiles and permission sets. Created Role Hierarchy for the Segment level access and Proxy login access
• Built asynchronous apex batch for determining Vehicle Start of Production Date and Vehicle End of Production Date from Volumes Linked
• Designed and developed access sharing solution using the Hierarchy of Territories from TED

Confidential

Responsibilities:

• Built Lead Routing custom code to assign and Route leads across the global Sales Users and LADD Team
• Mapped Up2Go template files with Oracle data elements and Constructed/Reviewed staging tables in Oracle
• Wrote Oracle Stored Procedures for extracting TOPS Opportunities, Part/Forecasts, Opportunity-Partners
• Wrote SQL queries with JOINS for Opportunity Part Program
• Confidence from percentage of confidence; Product Type
• Supplied Price determination from forecast quarters; Price discount percentage computation;
• Created VBA script to remove Korea Opportunities
• Developed 6 asynchronous Apex batch interfaces for bundling parts in DLI s, segregation among bundling based common denominator and separated currency specific bundling. This is to provide data for the innovative reduction of forecast data entry operations.
• Mapped Salesforce record identifier for Accounts in Account Tab and Partner Account Tab, Program, Master Parts using Excel VLOOKUP in Up2Go data file.

Confidential

Responsibilities:

• Territory Management - Structured and Non Structured Hierarchy
• Snapshot info, Signal to stop manufacturing
• Project Server Integration
• Profiles and Permission Set
• Data Extraction: Divided extraction for the Phased Global Roll-out using SQL and PL/SQL
• Built Approval Process flow in merging Proposal Account and TE Account records which helps in managing Opportunities from TE evaluated accounts.
• Public Groups
• Lead Routing
• Lead bi-directional collaboration
• Product Hierarchy, Master Part and Transactional Part definition, linkages, asynchronous Job, Key attributes identification, Self-referential integrity between GPL and Product Codes in Product Category, Field Mapping for orchestrations
• Parts upload Tool - Design, Testing and Review
• Customer SQL, Hierarchy SQL s, Product Manager Hierarchy SQL, Product SQL
• Requirement gathering sessions with Business Users
• Deployments using Package Manifest and change-sets

Environment: SFDC - Unlimited Edition, Force.com, APEX Data Loader, Salesforce Report Builder, Workbench, Developer Console, VF, Web Services, Oracle 10g, PL/SQL Developer 7.1, PL/SQL, SQL * Plus, MS Visio 2007, Data Loader, Eclipse Kepler with Force.com IDE, SOAP UI 3.0, Adobe Acrobat Pro 9.0, XML, SOAP UI, dsQuery, MS Excel, VBA, JDA, SAP BO WEBI, SAP BO Dashboards, SAP BODS, SAP Hana and SAP BOBJ, ACT, Import2

Confidential

Responsibilities:

• Solution Design, Process Flow Diagram, Data Flow Diagram and ERD
• Security: Profiles and Permission Set
• Data Model, Custom Object Definitions, Page Layouts, Apex Batch interface and Parameterized Reports from OOB detail page
• Deployment

Environment: SFDC - Unlimited Edition, Force.com, Salesforce Report Builder, Workbench, Developer Console, VF, MS Visio 2007, Eclipse Kepler with Force.com IDE, MS Excel

Confidential

Responsibilities:

• Solution Design, Process Flow Diagram, Data Flow Diagram and ERD
• Security: Profiles and Permission Set
• Salesforce-to-Salesforce Collaboration
• Data Model, Custom Object Definitions, Page Layouts, Apex Batch interfaces
• Lead Statistics MQL, SQL, SAL & CLD
• Deployment using Package Manifest and change-sets

Confidential

Technology Used: Salesforce to Salesforce

Responsibilities:

• Solution Design, Process Flow Diagram, Data Flow Diagram and ERD
• Security: Profiles and Permission Set
• Data Model, Custom Object Definitions, Page Layouts, Apex Batch interface
• Deployment using Package Manifest and change-sets

Confidential

Responsibilities:

• Solution Design, Process Flow Diagram, Data Flow Diagram and ERD
• Profiles and Permission Set
• Data Model, Custom Object Definitions, Page Layouts, Apex Batch interface, data validations - Business Unit validation, Country validation.
• Deployment using Package Manifest and change-sets

Confidential

Responsibilities:

• Solution Design, Process Flow Diagram, Data Flow Diagram and ERD
• Profiles and Permission Set
• Data Model, Custom Object Definitions, Page Layouts, Apex Batch interface, data validations - Landing Page.
• Deployment using Package Manifest and change-sets

Environment: SFDC - Unlimited Edition, Force.com, APEX Data Loader, Salesforce Report Builder, Workbench, Developer Console, VF, Oracle 10g, PL/SQL Developer 7.1, PL/SQL, SQL * Plus, MS Visio 2007, Data Loader, Eclipse Kepler with Force.com IDE, Adobe Acrobat Pro 9.0, MS Excel, dsQuery, XML, SOAP UI 3.0