Senior Consultant / Administrator Resume
Tampa, FL
SUMMARY
- Over 7+years of overall professional Consulting Experience with strong Object Oriented Analysis, designing and modeling applications including 4+ years of extensive experience in Salesforce.com CRM and Force.com platform with proficiency as Administrator and Developer.
- Experienced in implementing/configuring Salesforce custom objects, Junction objects, master - detail relationships and lookup relationships.
- Extensive experience in analyzing organization processes,converting business workflows into exact Salesforce.com workflows and configuring Salesforce.comto meet business requirements.
- Experienced in Creating Roles, Profiles, Email Services, Page Layouts, Workflow Alerts and Actions, and Approval Processes.
- In-depth Understanding of Sales Cloud, Service Cloud and Collaboration cloud platforms.
- Designed Custom Formula Fields, Field Dependencies, Validation Rules, Page layouts, search layout.
- Extensive experience in lead, case management web-to-lead, Web-to case, Email-to-case.
- Experience in writing Visualforce pages and controllers and customize the look and feel of the page components.
- Develop Apex Triggers, Apex classes and controller classes and manage complex workows, approvals, data validation and system triggers.
- Experience in creating custom Reports and Dashboards for various business metrics.
- Experience in configuring the Security model per Organization needs and also managing Users in the Organization.
- Experience in creating Email Templates and Mail Merge Templates.
- Experience in creating detailed process documentation and deployment process on issues for Future Follow ups.
- Experience in debugging capabilities of Apex and Visualforce.
- Created and updated users, reports and dashboards to track pipeline/stages for management visibility, while integrating Apex (applications) to Salesforce account.
- Implemented security and sharing rules at object, field, and record level for different users at different levels of organization.
- Proficient in Data Migration from Traditional Applications to SalesForce using Import Wizard and Data Loader Utility.
- Experience in Content Management and also Currency Management.
- Experience with Data Integration tools like Informatica Data Loader and In-depth Understanding of ETL processes.
- Working knowledge using Informatica Power Center 8.6, 9.1 tool to design data conversions from wide Variety of source system.
- Experience in working with Salesforce.com sandbox and production environments.
- Experience in AppExchange tools like conga merges templates, Dupe blocker and geopointe.
- Experience in providing production support, analyzing the cause and fixing it.
TECHNICAL SKILLS
Confidential, Tampa, Fl
Senior Consultant / Administrator
Responsibilities:
- Streamlined the business process flow by leveraging out of the box features like workflows and approvals.
- Defined Security model and user access levels by leveraging OWD, Profiles and Roles.
- Designed, and developed Apex Controllers, extensions and Apex Triggers for various functional needs in the application.
- Developed Visual Force Pages for moderate level business use cases.
- Incorporated the current instance of Salesforce.com used by PWC Call Center group into a single fully enabled organization.
- Migrated the Legacy users to Salesforce Service Cloud
- Support PWC project personnel with Advisory Services for:
- Knowledge Setup
- Email template creation
- Developed a Robust Automated Case Management Solution that automatically assigns to the Support Reps using Round-Robin technique.
- Created Profiles, Roles based on Organization role hierarchy and implemented Record-Level and Field-Level security and configured the sharing settings.
- Created email templates and mail merge templates for use with conga.
- Built Custom Reports and Dashboards.
- Involved in Accounts Merging, maintaining Public Groups.
- Developed data migration scripts and also performed data loads for the salesforce schema.
Environment: Saleforce.com platform, Workflow & Approvals, Reports, Custom Objects, WSDL, Custom Tabs, Email Services, Security Controls, Dashboards
Confidential, South San Francisco, CA
Salesforce.com Consultant / Developer
Responsibilities:
- Entire SFA solution is built on custom code using Apex for backend and Visualforce, AJAX, jQuery, HTML, CSS,
- Designed Sales force Object Model and Created Custom Objects, fields, Custom Settings, Custom Labels.
- Converted the existing standard SFDC License to force.com platform for 3,500 user licenses for all major groups including MedAffairs, Managed Care, FRM and Pharma.
- As part of Veeva AppExchange product removal, deleted all references of Veeva in the code and modified the existing business logic to support the SFA solution.
- Was part of Deployment process creating Packages, IP documents
- Migrated components into other sandboxes using Change sets for adhoc usecases.
- Defined Object Model architecture, documenting technical requirements, and identifying success criteria.
- Maintaining test coverage for all the classes and triggers and supporting deployment activities.
- Worked on various Work.com standard objects like Accounts, Contacts, Cases, Opportunities, Products, Opportunity Line Items, Leads, Campaigns, Reports and Dashboard.
- Responsible for configuring My Patient Solutions, Lucentis Web Ordering customer portals and Case Management applications in gCOI ( Confidential commercial Informatics) division of Confidential .
- These are commercial applications at Confidential where direct Patient Enrollments happen and products are sold through web. Confidential is one of the largest installed code-bases on force.com platform.
Confidential, Denver, CO
Salesforce Developer/Administrator
Responsibilities:
- Performing the roles of Salesforce.com Administratorin the organization.
- Interacted with various business user groups forgatheringtheirquirements.
- Worked on various Salesforce.com Standard Objects including Accounts, Contacts, Reports, Dashboards, Events and Tasks.
- Developed variousCustom Objects, Tabs, validation rules, Components.
- Created variousProfiles,Roles,Page Layoutsand configured thePermissionsbased on the Organization hierarchy requirements.
- CreatedCustom Objectsandfieldsfor transactional and contractual information.
- Designed and deployedCustom tabs,validation rules,Approval Processesand Auto-Response for automating business logic.
- Createdworkflow rulesand defined relatedtasks, email alerts,andfield updates.
- Implementedpick lists, dependent pick lists, lookups, master detail relationships, validation and formula fields to the custom objects.
- Usedfield level securityalong with page layouts to manage access to certain fields.
- Developed severalCustom Reports&Dashboardsto better assist managers and also report folder to provide report accessibility to appropriate personnel.
- Provided thetrainingto the internal business users to use the application and develop their own custom reports.
Environment: Saleforce.com platform, Workflow & Approvals, Reports, Custom Objects, WSDL, Custom Tabs, Email Services, Security Controls, Dashboards.
Confidential
ETL Developer
Responsibilities:
- Designed entire architecture of the process to load data from data warehouse to Salesforce using Informatica cloud
- Installed and configured Informatica cloud engine
- Closely worked with network team and resolve the issues with pooled proxy and authentication to sales force
- Created Data synchronization jobs and Data replication jobs to push data into sales force and pull data from salesforce
- Implemented dynamically changed columns for rollover over months in salesforce using Informatica cloud
- Resolved the sales force lookup issues using data Related objects process.
- Automated the Informatica cloud jobs using Control-m and Curl script to implement the dependency on regular power center jobs
Environment: Informatica 9.1, Informatica cloud, DB2, UNIX, Neteeza 6.1, Business Objects XI R2, XI 3.1, and Control M
Confidential
ETL Developer
Responsibilities:
- Developed the new mappings and workflows to get Delta process
- Written automated parameter file for handling parameters
- Unit test the code and the data flow from the Landing Zone to Staging Area database to the Enterprise Data Warehouse
- Responsible for Peer testing the codes of other Informatica Developers.
- Created various active and passive transformations to support voluminous loading of data in target table using Informatica Power Center.
- Developed complex mappings using expression, aggregator, filter, normalizer, joiner, Lookup, router, update strategy and procedures to feed Data marts.
- Designing reusable transformations, mappings, and mapplets.
- Optimized and fine tune mappings for faster load
- Supported the Data mart in production
- Building the Informatica coding standard document (ETL specs) and design documents.
Environment: Informatica Power Center 8.6, Oracle 10g, Flat files, UNIX
Confidential
ETL Developer
Responsibilities:
- Analyzing the source data from each department to build data marts.
- Designing star schema, fact table, dimension table and hierarchies.
- Creating Repository, folders and managing users, groups and privileges.
- Creating Mappings and sessions to extract and load data in to target.
- Created various active and passive transformations to support voluminous loading of data in target table
- Developed complex mappings using expression, aggregator, filter, normalizer, joiner, Lookup, router, update strategy and procedures to feed Data marts.
- Designing reusable transformations, mappings, and mapplets.
- Optimized and fine tune mappings for faster load
- Supported the Data mart in production
- Building the Informatica coding standard document (ETL specs) and design documents.
Environment: Informatica Power Center 8.6, Oracle 10g, Flat files, UNIX