SUMMARY:

• Certified Salesforce Administrator and Certified Salesforce App Builder
• Have 5 Salesforce full cycle implementation experience of Sales Cloud and Service Cloud
• Procured, implemented, and integrated numerous external Salesforce application through the AppExchange for various business functions
• Service Cloud - Case Management, Customer Portal, Console, Chatter Answers and Ideas
• Sales Cloud - Lead Management, Contact & Account Management, Opportunity Management, Asset Management
• Experience in agile software development, SAAS, and Salesforce API
• Designed and developed custom applications using Force.com Platform
• Experienced in creating and managing SFDC API and integration ETL tools such as Informatica and Jitterbit
• Engineered Salesforce Apex Data Development with VisualForce Pages and Components

TECHNICAL SKILLS:

• Salesforce Service
• Cloud Salesforce Sales
• Cloud Salesforce Business Logic and Concept
• APEX Triggers/Classes
• Visualforce App Exchange
• Wave Analytics
• Marketo Lightning
• App Builder
• Informatica ETL/Jitterbit MS SQL, MySQL JSON API Development
• CSS JavaScript HTML
• Project Management
• DevOps (Jira, Confluelnce, etc)
• Business object and Universe Power BI Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Salesforce CRM Administrator

• Plan, design, document all aspects of Salesforce platform application releases including integration with external Salesforce app acquired through AppExchange for multiple business functions
• Manage multiple Salesforce org in production and full sandbox environment
• Monitor and build custom case management and automation process to fit business requirement
• Design and build Lightning Custom Component, Lightning App Builder UI
• Construct custom event, data, and process automation in APEX Triggers, Classes, Visualforce and Lighting Components
• Create Custom Objects, Fields, Relationships, Formulas, Validation Rules, Process builder as process automation
• Handle field master-data relationship and look up with proper set up of user’s access and permission
• Manage custom configuration of Lead and Opportunity Management for Residential and Commercial Properties
• Set up Informatica Cloud, Jitterbit with Salesforce, MySQL and Intacct ERP
• Data Backup and Migration to/from SQL Server and Salesforce
• LiveOps configuration and integration for winning bidder call automation
• Configure and Support of Box, DocuSign, LiveOps, InsideSales, Apttus, CPQ, Pardot, Marketo, RealZips, and ActionGrid Salesforce AppExchange applications
• Perform SFDC administration function to support CRM operational process through automation process
• Document data quality and integrity maintenance across SFDC objects and records
• Gather, document, and socialize a valid and acceptable SFDC data governance policy that meets with business requirement and rules

Confidential, Aliso Viejo, CA

Salesforce Administrator/Process Analyst

• Gathered and wrote user and system requirement documentation as well as obtained sign-off from business sponsors according to Salesforce.com project roadmap
• Created, managed, and monitored Department’s Record Type, Page Lay Out, Custom Objects, Fields, Relationships, Formulas, Validation Rules, Process builder as process automation
• Handled field master-data relationship and look up with proper set up of user’s access and permission
• Managed 4 SFDC Orgs to align with different location of Corporate Structure of Business
• Documented complex approval process, assignment rules, workflow rules with process builder
• Wrote documentation about internal data management and de-duplication using applications such as Apex Data Loader, Microsoft Excel Connector and Demand Tools
• Created and maintained Sales and Support reports and dashboards
• Responsible for process of planning, managing, and executing changes to current business processes including change analysis and UAT testing on new and existing processes
• Performed reverse engineering day to day sales and support issues to document current and deprecated business processes and manage large case queues
• Documented all aspects of SFDC project requirement such as creating custom objects and fields, defining relationships with standard and custom objects, creating formulas for workflow rules, formula fields and validation rules
• Created integration of SFDC data with other Enterprise Application and documented process and data flow of all aspects of integration
• Designed and documented SFDC data flow diagram crossing other internal systems such as Oracle, Business Object, Intacct, Route and Maintenance data, and other databases
• Ensured data stewardship and all meta data were maintained properly, tuned in, and exchanged properly across various systems
• Worked closely with management, leadership, and business stakeholders in order to provide technical and functional support of Salesforce business flow

Confidential, Torrance, CA

Salesforce Business Systems Analyst

• Responsible for writing, reviewing, and maintaining all aspects of CRM migration documentation such as requirement document, high level design and low-level design document, UAT document from current process to future process in accordance to Salesforce.com standard and custom functionality
• Performed complex documentation efforts in order to have a successful CRM migration such as documenting existing processes within Phoenix CRM platform and recommended process improvements that could be done in Salesforce platform and its system capabilities
• Performed Salesforce administrative function during first set of deployment period such as user administration, data migration, lead and case routing rules, workflow and validation rules creation, reports and dashboard creation
• Provided functional expertise to the business community during proof of concept, requirement gathering, mock up establishment, data testing, design, and data migration
• Designed and implemented key matrix performance of newly implemented Salesforce CRM system in order to capture users satisfactory rate and other pertinent user’s feedback regarding the new Salesforce system
• Performed Salesforce Administrative function during implementation process to assist external SFDC consultants such as managing record types, creating workflow automation, analyzing org split requirement, and building new commission structure work flow
• Worked, communicated, and announced all aspects of project status, implementation progress, and other type or ‘must know’ information to all business sponsors and stakeholders, both technical and non-technical personnel
• Assisted with various project management activities that involved tasks qualification for all applicable phases of the project
• Coordinated and monitored concurrency test of the project implementation to identify any setback or defects and report problems found during User Acceptance Testing

Confidential, Irvine, CA

Dev Ops Engineer

• Developed API integration for new automation process for existing application of Tracksource and Clientsource with newly implemented Salesforce Sales Cloud
• Created Salesforce custom solution for process automation using process builder and workflow
• Created Salesforce application with best practice of SFDC architecture and CRM insurance business model
• Managed ETL jobs between Salesforce and Tracksource and ClientSource client database, schema, tables, batch jobs
• Designed, built data integration between shared clients application Clouds and physical application in house
• Effectively communicated and managed system maintenance schedules
• Continuously monitored system performance and addressed related challenges and issues
• Monitored related interfaces, handle exceptions, and proactively resolve integration errors
• Queried data for analysis as requested for ad hoc reporting

Confidential, Santa Ana, CA

SAP Solution Group

• Provided input and guidance on SAP BW functionalities and solutions, SAP BW system performance and BW roadmap evolution
• Provided global support and cube maintenance during monthly and quarterly closing activities for BW reporting purposes
• Extracted data using BW extraction structures such as LIS, LO Cockpit, CO-PA, FI and Generic Extractors
• Experienced in BI Performance Tuning by maintaining Aggregates, Compression, Partitioning, and Indexing of Info Cubes
• Performed Remodeling on already existing Info Cubes to add new Key figures and Characteristics
• Maintained and created various multiple and hotlink cubes that met business need
• Created BEx Reports providing insight of Business Intelligence to aid the analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Customer Exit
• Provided technical and business process knowledge in R/3 in the areas of CO/FI, MM, SD, to the business
• Administered SAP Security Provisioning in R/3, Portal, and Business Warehouse, security objects, authorizations, provisioning workflows, risk analysis, and batch jobs
• Liaised with the other application teams to ensure that the BW solutions are in synch with partner application changes
• Coordinated installations and upgrades for various users requesting new or updated access

Confidential, Agoura Hills, CA

System Analyst

• Created, wrote queries, maintained, and supported IBM Cognos reporting for financial reports, graphs, and dashboard
• Designed, configured, created SSRS reports including ETL configuration to manipulate data structure and data normalization
• Generated, put into successful production, and trained others in data validation / testing tool, using Data Services and SQL Server procedures and functions.
• Performed routine maintenance of queue, cubes, repositories
• Performed multiple database administration and configuration of multiple data stores and servers
• Maintained internal PTAI SQL Server 2005 Integration Services (SSIS) control flow elements: containers that provide structures in packages, tasks that provide functionality, and precedence constraints that connect the executable, containers, and tasks into an ordered control flow
• Developed, published, and scheduled batch and real-time jobs
• Produced contact duplicate checking ETL project, including match transforms and adjustable parameters
• Constructed dashboards to review data validation results
• Analyzed data flow and business requirements to create High Level Design and Low Level Design document
• Created documentation for training and Help Desk teams

Confidential, Aliso Viejo, CA

Business Analyst

• Designed and created specifications for various financial data and reporting for supporting corporate finance and central financial services such as budget information, statistical profit and loss by SBU or project control
• Provided business and functional requirements gathering, analysis, testing documentation, QA reviews mainly for the SAP ECC and Hyperion implementation process
• Validated financial system and reporting, process transaction, for which financial information can be flowed into the BW and run report within SAP functionality
• Tested Scope document sections: business case, functionality matrix, business project models and descriptions (As-Is and To-Be), business scenarios / use cases, detailed business requirements, glossary, and high level screen flow and visualization
• Updated the financial accounting case, including investment context, benefit quantification, issues, assumptions, and risks by using available system information
• Ensured the end-to-end process requirements are covered in the documentation produced by the participating project teams