SUMMARY:

• Seven years of professional experience as a Salesforce Business Sytem Analyst in Healthcare and Insurance domain.
• Extensively interacted with the QA Team in creation of the Test Plans, Providing Test Data, Creating Test Cases, and Issuing SRs upon detection of bugs and collecting the Test Metrics.
• Experience in Salesforce.com Customization, Security, Development Support, production Support and Testing.
• Excellent experience in conceptualisation of various features of CRM application and acted as a product owner for the product from concept initiation until product implementation.
• Experience on Sales force CRM platform Worked on different environment of SFDC such as Sales and Service Clouds.
• Experience in using Informatica to extract and transform data from various DB2 database to the data warehouse.
• Experienced in data integration, metadata management, ETL, data modeling tool sets.
• Extensive experience with User acceptance testing (UAT), System testing, Integration testing and build verification testing.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse.
• Experience in SFDC Integration using Web Service and Apex Programming, Salesforce Service Cloud expertise.
• Analysed Requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using Microsoft Visio.
• Experience in SOQL, SOSL and Integration of Salesforce.com with external application by using Web services API, Metadata API, WSDL, SOAP and REST protocols.
• Experience in ETL testing using tools like Informatica Power Center and reporting tools like Business Objects X1 3.1, Cognos 8.4.
• Experience in Leading, facilitating and conducting Joint Application Development (JAD) sessions among user community, stakeholders, and technical management.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering ERWIN diagrams, analyzing data sources and creating interface documents.
• Experience in owning all aspects of campaign management (trafficking, optimization, troubleshooting, and reporting) with a sustained focus on efficiency and scalability.
• Defined functional business tasks related to projects, maintained project priorities, conducted planning sessions, coordinated work of developers, testers and other business analysts, and estimated, managed and tracked activities to a timeline.
• Proficiency in analyzing and Creating Use cases, Use Case Diagrams, Activity diagrams, Data Flow Diagrams, Navigational flow diagram using MS Visio.
• Knowledge of Salesforce configuration, data migration, system integration and familiarity with Visualforce (Pages, Components, Controllers) MVC architecture and Apex (Classes, Controllers & Triggers).
• Basic Knowledge of call centre coverage to achieve service level targets in multiple lines of business.
• Experience in owning the product roadmap (writing Use cases/User stories) and Creating Use Case and Activity diagrams (UML).
• Expert in ERP implementation in salesforce domain.
• In - depth experience in CRM business processes like Forecasting, Campaign Management, Lead Management, Pipeline Management, Order Management, Account Management, and Case Management.
• Excellent conceptual and working knowledge of SDLC, Waterfall Model, Agile Model and UML Methodologies.
• Extensively interacted with the QA Team in creation of the Test Plans, Providing Test Data, Creating Test Cases, and Issuing SRs upon detection of bugs and collecting the Test Metrics.

TECHNICAL SKILL:

Programming Languages: Apex, Java, JavaScript, HTML, Bootstrap, Jquery, XML, BMI, SSIS, ETL, XHTML/DHTML PL/SQL, SQL, COBOL, PL/1, JCL

Salesforce Technologies: Salesforce CRM, Salesforce SFA, Apex Language, Classes/Controllers, Apex Triggers, Apex Data Loader, SOQL, SOSL, Visual Force Pages, Components, S Controls, Apex Web Services & Testing, AJAX, Workflow & Approvals, Dashboards, Analytic Snapshots Case Management Automation,CustomObjects.

Salesforce Tools: Eclipse, Force.com Eclipse IDE Plug-in, Apex Data Loader, Force.com, Workbench, Force.com Platform

Databases Oracle: DB2, VSAM, IMS DB, MS SQL Server, MS Access.

Other Tools: Apptus CPQ and CLM, App Exchange Tools, Informatica Cloud, Marketo.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Business Analyst

Responsibilities:

• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database/ Sales Force.
• Manage forecasts, contract management and pipeline maturity through the Sales Force.com CRM software.
• Successfully coordinated internally and with other teams to gather information and efficiently learned the system.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, Websphere and Cognos.
• Responsible for DBR generation and finished good stock management using O2C Order to cash framework.
• Implemented Salesforce Service cloud and Opportunity Management (Case management, Entitlement management, Product & price book, High volume customer portal, Partner portal, Visual force sites) for business support and technical support for its channel customers.
• Participated and contributed to the improvement of Campaign Management team by testing campaign's performance, creating flowcharts and process improvements.
• Involved in SQL-based data warehouse environments and created multiple custom database applications for data archiving, analysis, and reporting purposes.
• Incorporated the Informatica Velocity approach for Mapping design, development and Data Governance.
• Worked on creating the Business Requirement Document (BRD) and Software Requirement Specification (SRS) as well as Functional Requirement gathering (FRD).
• Involved in several SOQL & SOSL queries in the apex coding with consideration to Governor Limits for data manipulation needs of the application.
• Profound knowledge of Software Development Life Cycle (SDLC) especially in agile, Srum methodologies.
• Worked through the whole QTC (Quote to Cash) cycle and Service Contracts integrations with various Ibs.
• Leverage SaaS sales and marketing tools to generate new leads, routinely follow-up with established prospects.
• Facilitated several workshops, JAD sessions and meetings etc with both stakeholders locally and offshore also Identifying client organization's strengths and weaknesses and suggested areas of improvement.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database.
• Involved in Preparing a handbook of standards and Documented standards for Informatica code development.
• Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Used Visualforce in development mode to change the behavior and appearance of Visualforce components.
• Designed and presented a conflict management system fitting organization's needs and culture.
• Oversee the installation, customization and implementation of the ERP system.
• Configured Sales Force Automation (SFA) for Campaign management, Opportunity Management, Account and Contact Management, Data Quality Management,Lead management.
• Used MS VISIO to produce models like context, use case, sequence, activity etc.

Confidential, Atlanta, GA

Business Analyst

Responsibilities:

• Strong knowledge of Sales force configuration, data migration, system integration and familiarity with Visual force (Pages, Components, and Controllers) MVC architecture and Apex (Classes, Controllers & Triggers).
• Performed data migration from ACT CRM to SalesForce CRM for users spanning all over the world.
• Used SOQL & SOSL for data manipulation needs of the application using platform database objects.
• Performed Campaign Management Lead, Owner & Validation analyst roles.
• Involved in making screen designs, Use Cases and ER diagrams for the project using ERWIN and Visio.
• Responsible for physical/logical data modeling; metadata documentation; user documentation and production specs.
• Involved in C reating DTS and SSIS Packages to vendors in which records were loaded Daily, also to other data resources such as Excel, Access, flat file, and XML in order to Create and maintain a centralized data warehouse .
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Used data transformation tools such as DTS, SSIS, Informatica or DataStage.
• Involved in application setup activities and customized the apps to match the functional needs of the organization. Implemented Sales force.com platform and Force.com IDE Plug-in using Eclipse.
• Involved in Lead management, which is important part in HDD business and worked on workflows for updating leads based on the lead scoring from Eloqua.
• Participant in JAD sessions for requirement feasibility and risk analysis with various stakeholders to identify critical and high-risk areas of the application.
• Documenting Business Requirements (BRD) and Functional Requirement gathering (FRD) with information gathered from liaising with senior stakeholders, product owners and technical teams.
• Account management activities to understand, qualify and fulfillment of requirements.
• Assisted all the stakeholders throughout the SDLC life cycle from the requirements perspective.
• Guided the Order to Cash (O2C) team through the gathering of business requirements and configuration design to implement the new ERP system.
• Implemented and maintained Salesforce Service Cloud and Sales Cloud. Built custom solutions with Apex and VisualForce, which support most critical processes and workflows.

Confidential, NJ

Business System Analyst

Responsibilities:

• Worked as a Sales Force Chatter APP with the organization and regularly participated in the meetings and chatter community.
• Involved in Salesforce.com application setup activities and customized the apps to match the functional needs of the organization.
• Designed and implemented Salesforce Service Cloud to enable the Customer Service team to manage.
• Configured and integrated a wide range of SaaS applications including Salesforce.
• Establish ERP Planning Parameters for effective MRP suggestions.
• Involved in developing the ETL Informatica Mappings for importing data from ODS into subsequent data marts .
• Created the logical models and generated the physical models in the databases using Erwin.
• Involved in Logical & Physical Data Modeling.
• Used Salesforce Automation (SFA) for Sales Lead Management, Opportunity Management, Account and Contact Management, Data Quality Management, and Approvals to automate the process.
• Complete study of the in-house requirements for the data warehouse.
• System solution architecture with external consultancy organization - Full involvement in product SDLC.
• Implemented financial products requiring extensive knowledge in XML/PHP messaging, Web servicing and cross product/platform integration Salesforce integration, APEX, VisualForce.
• Developed business requirements document (BRD) and Functional Requirement gathering (FRD) for signoff with the project manager following requirements capture and analysis.
• Working with Dynamic Apex to access SObjects and Field describe information, execute dynamic SOQL, SOSL queries and DML operations.
• Worked closely with business partners to realize the full capabilities of Sales force CRM.
• Managed all aspects of day-to-day accounting and operations of order-to-cash (O2C)and revenue cycle, from contract review to invoicing and collections to month-end reporting.
• Created pixels, allocated budgets, implemented client ad tags and trafficked creative using NetSeer’s proprietary campaign management system.
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming and Rapid and Joint Application Development Sessions (RAD & JAD).

Customized, Mountain View, CA

Business Analyst

Responsibilities:

• Worked on various Sales force standard objects like Accounts, Contacts, Leads, Reports and Dashboards.
• Monitored and ran workflows on Informatica for loading data to Enterprise Data Warehouse.
• Worked on various Sales force.com standard objects like Cases, Accounts, Contacts and Account Junction Objects.
• Used SOQL and SOSL statements within the custom controllers, extensions and triggers properly to avoid Governor Limits.
• Involved in designing Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN.
• Involved in designing and implementing cases and service ticket management using salesforce Service cloud.
• Implemented Apex Data loader "Command Line Interface (CLI)" to automate the data loading process for the sand boxrefresh activity.
• Good knowledge in developing the documents for data model design in sales force CRM.
• Assisted in email marketing efforts including campaign management systems, reporting/analytics visibility, and testing.
• Conducted meetings for the Data Modeling and Analysis.
• Implemented SFDC web-to-lead functionality into the corporate site to make lead management simple and efficient.
• Prepared and constantly updated key Business Analysis artefacts such as BRD, FRD and Traceability Matrix for the Project Board, Project Sponsor or CAB.
• Created new Salesforce features (e.g. custom triggers and Visualforce), and reports for management.
• Led and design roadmap for the Order to Cash (O2C) cycle in M&A integration; collaborate effectively with IT, Product, Sales, Legal, Order Management, Tax, and Corporate Development.
• Effectively resolved bugs in the system, which resulted in a faster and smoother ERP implementation.
• Worked in project which used Agile and waterfall SDLC frameworks.
• Coordinsated JAD sessions to understand the user requirements and also their system's implementation.
• Performed Data extractions and manipulations related to the SaaS intake site as well as maintained dedicated/multi-tenant Databases for SaaS subdomain cleints.