Senior Sfdc Business Analyst Resume
Collegeville, PA
SUMMARY:
- Self - motivated, highly skilled professional seeks to leverage extensive background in Finance, Siebel, OBIEE, SAP CRM, Microsoft Dynamics CRM, SFDC SAP ECC and RDBMS. Highly organized and dedicated, thorough, and detail-oriented. Creative yet analytical professional who thrives on a variety and challenges complemented by exceptional research, decision-making, and communication skills. Looking for a Senior business / Project Manager/ analyst position.
TECHNICAL SKILLS:
Technology and Tools: Senior Business: 8 years of experience as an Senior Business analyst 3 years as a Project Manager Developer: 5 years of configuration, Data migration from legacy applications: 3 years of experience. EIM, workflow, PL/SQL, interfaces and conversions experience 3 years working with Leads in Siebel Sales - Account, Opportunities, Leads, Assets(Install base), Quotes, Orders Experience with Agile Methodology, Scrum and Waterfall Define Future state process from current state Siebel analytics: 5 years of OBIEE/ Siebel analytics experience Siebel versions: Siebel 6.0, Siebel 7.7, Siebel 7.5, Siebel 7.7, Siebel 7.8, Siebel 8.0 Siebel verticals: Siebel Automotive, Siebel Call Center, Siebel Finance, Siebel UCM, Siebel sales, Siebel Marketing, Siebel Pharma, Siebel eclinical & Siebel analytics PMP Trained MBA Finance and IS SOX and COBIT Informatica (Extract, Transform, Load Process) Microsoft Office: Word, Excel, Visio and Power Point Agile: 3 years Siebel tools configuration: 8 years SAP CRM Architecture - SAP Net Weaver, Interaction Center, Plugins into SAP ECC 6.0, SAP BI, Sales, Marketing, Organizational Model, Account and Contact Management, Activity Management, Opportunity Management, and Territory Management. Microsoft Dynamics CRM, NAV, Sharepoint SFDC (2 + years): Sales Cloud, Service Cloud and Marketing Cloud HTML, Java, Java script, C#,.Net ( 2 years)
PROFESSIONAL EXPERIENCE:
Confidential
Senior SFDC business analyst
Responsibilities:
- Full understanding of Veeva systems iRep, Windows 8,Call Center, Customer portal,Approved Email.
- Veeva CRM (VOD Data model): Account, Address, Affiliations, Contacts, Call planning, Call Reporting, Products, Formulatory Product, Benefit Design, Benefit Design Line item, Sample Lot,Sample receipt, Sample Transaction, Sample Inventory.
- Validated production deployment of SalesForceDotCom system releases to ensure Sales and Marketing Operations business requirements were accomplished
- Conducted User Acceptance Testing for Marketing Campaigns to ensure that Call Centers had correct campaign details
- Performed system administration and user security within SalesForceDotCom for the Sales and Marketing organization
- Created department wide Standard Operating Procedure documentation for the SalesForceDotCom campaign system
- Developed materials and conducted classes for business users utilizing the SalesForceDotCom campaign system
- Involved in researching, analyzing and recommending Force.com platform features, capabilities and offerings like SalesForce Knowledge, Sales process, Chatter and SiteForce, Leads, Accounts, Contacts, Reports, Dashboards, Tasks
- Analyze and completes data manipulation through Data Loader and Workbench Tools for importing/updating/deleting records in multiple Salesforce.com Instances.
- Proposes/Presents Data Models based on business understanding provide a scalable solution around custom objects.
- Created custom objects, fields, validation rules, Workflow rules, criteria, actions like send emails to sender and personal tasks that are visible on home page
- Created communication templates for Letter heads and Email Templates. Edited applications to include additional tabs
- Performed Data management activities like import from outlook and csv file using via SFDC Data loaders
- Created users, set passwords, roles, Public groups.
Confidential
Senior Business Analyst
Responsibilities:
- Gathered requirements, performed functional design, communicated requirements associated with Sales Force Dot Com.
- Created users, profiles, permission sets and role hierarchies.
- Created Custom objects, fields (ex: Rollup, Formula fields). Enabled master detail relationship between parent and child objects.
- Created reports (Tabular, Summary, Matrix ) and dashboards (Component and data sources).
- Created workflows that will modify objects when a new record is created.
- Created validation rules on on fields associated with objects.
- Good understanding of Apex - Triggers that update objects, batch programs that perform data loads
- Good understanding of Visualforce pages and model, view and controller. Created visual force pages and exposed apex classes via standard controller through the Apex Page section on the visual force page.
Confidential, Collegeville, PA
Senior Siebel Business analyst
Responsibilities:
- Managed a Team of 5 developers and testers to test the Siebel eClinical. This is involved User Acceptance testing, System integration testing, performance testing and component integration testing.
- Created a testing process that involved creating testing process and recording defects in HP quality Center. Audited team members for testing scripts, defects and discrepancies between testing scripts and defects.
- Application testing - This included testing requirements against the application for different object types i.e. Screens, Views, Applets, Business Objects, scripts, State model & workflow. This testing was categorized into entities i.e. Accounts, Contacts, Partners, Opportunities, Activities & Documents.
- Data Conversion Testing - This involved testing data quality is as per requirements, renders the application, MVG testing and error records processing which included modifications to the staging records for successful load.
- Interface Testing - This involved testing the interface to the data warehouse, multiple systems and website.
- Performed system analysis associated with Siebel eclinical system. This involved documenting the business processes, entities and relationships, roles and responsibilities associated with different users in the organization, security rules with application access, application configuration, workflow rules, data conversion and interfaces strategy.
- Performed As-Is process, To- Be process with respect to Siebel 8.0.This was required for the Siebel upgrade. Produced a data mapping document for Siebel 8.0.This screen, views, business objects, business components, fields, tables and columns
- Gathered requirements associated with the Account Merge process. Conducted user sessions with users, business analyst and project managers.
- Performed analysis, design and development of the Account Merge process. This involved 3 categories of merges -Vertical merge between Accounts and Departments, Horizontal merge and Duplicate names related merge. The entities involved in the merge were accounts, professionals, activities, agreements, attachments, notes, and best times to call and account affiliations. This involved extensive use of EIM and oracle PL/SQL creating procedures, functions, staging tables. Business rules were created to decide between columns for survivors and victims.
- Created functional design documents for smart call templates and associated with an account call and contact call. Create process for a clinical program and clinical protocol. Setup document tracking at protocol, region and site levels for accounts and contacts. Setup revises subject templates for a protocol. Review payments made to the protocol, associated payments with a site, Rollup payments from sites to protocol level.
- Communicated, presented the functional design documents to the Business, project manager and Technical developer.
- Translated the functional design documents into data mapping documents involving Screen, View, Applet, Business component and table level mapping.
- Designed user acceptance scripts to test the requirements and process flows.
- Participated in Siebel 7.8 to Siebel 8.0 upgrade.
- Designed business rules using business rules developer. Invoked these rules through the run time events, workflows.
Confidential, Schaumburg, Illinois
Senior Business analyst
Responsibilities:
- Lead a Siebel 7.8 Marketing implementation involving loading data associated with Accounts, Contacts, Assets, Products, Campaigns, Surveys, Orders and Order items using PL/SQL and EIM.
- Installed and configured Siebel Marketing and OBIEE. Worked with Offshore team to install the software for QA and Production environment.
- Performed Sizing analysis for Siebel and OBIEE applications respectively.
- Worked with Siebel Architects to create performance metrics associated with Siebel Marketing.
- Loaded and launched Marketing Campaigns Planning & Budgeting. Created Lists and attached offers associated with the Campaigns
- Configured screens, views, applets, business objects, business components, tables.
- Gathered requirements, designed business process, performed functional and technical design.
- Siebel analytics Involved in defining requirements for Siebel Answers Ibots (delivers).
- Tested the ETL mappings between the OLTP and OLAP system. Designed the security administration for the Siebel Analytics.
- Performed analysis for consistency amongst Presentation layer, Business model and mapping layer and physical layer. Worked with Subject areas and physical tables within the subject area.
- Enabled component groups for Territory management - Assignment Management group - Batch assignment component, workflow management group - Workflow process manager component, Siebel RTI group, RTI batch component.
- Activating workflowsstarting associated with Territory alignment. Configured Siebel Assignmentmanager load splitter configuration. Created divisions and positions for Territory management. Setup territory hierarchy for Sales Quota assignmentand territory nodes. Created direct rules for Contact, Account and Assets. Created in direct rules for Geography, Geo zones, products and industries. Created position rules for positions. Created Global and local conditions. Setting up territory alignment for assignment of Sales rep. Running Territory alignments. Viewed results for Territory alignment runs. Create sales quota record and defining sales quota.
Confidential, Cherry Hill, NJ
Senior Business Analyst
Responsibilities:
- Conducted Sessions with the business users to gather requirements and identify As Is Business Process. Build the To-Be Business process along with the business analyst and user team. Mapped the To - Be business process to Siebel Screen, Views, Business objects, Business components and Siebel Tables. Performed data mapping between the legacy application tables and Siebel Tables. Communicated the requirements to the data conversion team, Configuration team and interfaces team.
- Performed technical design for the Siebel Application and mapping the design to the functional design and business process.
- Configured the Screens, Views, Business Objects, Business components and fields, State Models, Audit Trail, business component user properties as per specifications. Performed unit testing, functional testing and system testing for Siebel Application.
- Implemented background processes using escript and Siebel Workflow. Implemented Siebel Reports using Actuate.
- Gathered requirement associated with email response. Designed, configured and tested out of box email response workflows. These workflows were implemented with the Service Request module.
- Gathered requirements for the design of OBIEE dashboards. Configurednewsubject areas, business layer objects and physical layer using OBIEE Admin tool. These subject areas were designed to measure the marketing campaign effectiveness (% of responses)across different channels like web, email and direct offer. Converted data from Siebel Sales and Siebel Marketing into OBIEE using ETL and DAC client. Create ibots that send emails to a group based on certain effectiveness criteria of a campaign. Created dimension and fact tables for the Campaign related metrics.
- EAI - Created a workflow process using Siebel EAI Adapter and Data mapper to integrate Siebel business objects to Integration objects. The workflow was configured to accept XML/XSD data.
- Integrated Siebel Call Center, Siebel Marketing application with LDAP. This was used to implement single sign on from the company website.
- Performed normalized, dimensional and hybrid modeling techniques within OBIEE ADMIN tool.
- Installed email marketing server on the windows platform. Installed and configured Email Sending Daemon, Bounce Handler Daemon, Click through Daemon
- Configured Email Marketing Daemons to Communicate with the marketing component group.
- Tested the email marketing components by sending emails to contacts and launching the Campaigns.
- Gathered requirements associated with Field Service for service request and orders. This involved creating service request, verifying service agreements and entitlements, solutions, creating activities for a service request using Siebel scheduler, assigning and dispatching service engineers, provide parts inventories, provide detailed customer configuration, track parts consumption and logistics, manager inventory replenishment, integrated return materials authorizations and service orders, provided field service engineers with complete service details including the required skills, tools and parts, managed repair of defective parts, set up and manages preventive maintenance plans, track and analyzes service costs, prepare invoices for service and tracks payments.
- Mapped requirements to different basic field service modules - Call management, Account/Contact management, field activities management, warranty management, asset management, service order management, on-site services management, knowledge management, dispatch board and service inventory.
Confidential, Blue Bell, PA
Senior Analyst and Team Lead
Responsibilities:
- Implemented Siebel Marketing system that plans and tracks the Marketing expenditures throughout program lifecycle. The system enables analysis of forecasted spend vs. actual spend. Benefits can be measured by being able to plan for marketing expenditures downstream more effectively while allowing worldwide collaboration in the creation of marketing programs and campaigns.
- Implemented 7 releases as a Siebel Configurator - 1 implementation and 4 functional releases of Siebel 6.0 (Siebel 2000 - sales, marketing and call center), 1 release of Siebel 7.5.3 (Email Marketing) and 1 upgrade implementation release of Siebel 7.7. Involved in configuration of Applets, Applet web templates, controls, list columns, pick lists, business components, joins, fields, views, and view templates, list of values, multi-value applets and multi-value groups. Created a process to track the defects during testing - program unit testing, functional unit testing and system integration testing.
- Performed requirements gathering, analysis, design, development, documentation, program unit testing, functional testing, system integration testing and maintenance of interfaces, workflow and business services. Performed production support for Siebel 6.0, Siebel 7.5.3 and Siebel 77 involving workflow, business services, interfaces, oracle objects and data integrity. Implemented Conversions of data between legacy system and Siebel using Oracle procedures, functions and Siebel Enterprise Integration Manager.
- Created a software development lifecycle process to standardize Siebel development - define requirements, categorize the requirements into a service request, assess the impact on different systems, develop the service request, test and implement in production. Created a process to standardize installation of Siebel and oracle software for the Siebel developer role.
- Lead a team involved in off shoring of Siebel (77) eSales and eMarketing application. Responsibilities included facilitating sessions with team member and management to identify critical tasks associated with developing and supporting the application, mapped it to COBIT domains, created metrics for tasks, created deliverables that were used in the vendor service level agreements.
- Educated a team members on the auditing concepts of Sarbanes Oxley, lead a team to make Siebel SOX complaint, involved setting production system standard, performed an analysis of the data mapping and data analysis between the Siebel and Data warehouse system to avoid reporting of redundant data.
- Lead a team promoted by CIO of to promote knowledge sharing all across the global information technology department, created a deliverable that involved creating awareness for information sharing amongst different stake holders of organization, emphasized on cross and document sharing.