SOBHAN KUMAR SAHOO

Maryland Heights, Missouri ***43 +1-314-***-**** ad3zu1@r.postjobfree.com

Professional Summary

Dedicated and results-driven Senior Salesforce Developer with over 12 years of overall experience and success stories in analysis, design, and development for projects across multiple technologies which include both front-end technologies like Salesforce CRM and Field Service Edge MWM platforms to back-end technologies like Oracle, Teradata,PL/SQL,Mainframe and UNIX platforms. Known for delivering exceptional results and providing strategic consulting in the utilities industry.

Salesforce Certified Administrator and Developer with 8+ years of hands-on experience, leveraging expertise in APEX, Visual Force, LWC, JavaScript, HTML, and CSS to drive successful Salesforce implementations and customizations.

Skilled Salesforce CPQ Specialist Administrator with strong hands-on experience in pricing strategies and discounting rules, enabling streamlined product pricing, quote lines and templates

Proven expertise in Sales Cloud, Service Cloud, Field Service Lightning, CPQ, Experience Cloud with exposure and solid hands-on in NPSP, Finance and Revenue Clouds.

Adept in developing client-specific solutions on the SFDC platform, utilizing Apex classes, Apex Triggers, and Lightning Web Components (LWC) using Visual Studio Code and Lightning Studio, resulting in robust and scalable solutions.

Extensive experience in Service Cloud Case Management, including the implementation of case assignment rules, auto-response rules, and escalation rules, enhancing case management efficiency and customer support.

Strong background in Salesforce integration with external systems, leveraging SOAP API, REST API, and Force.com API to seamlessly connect Salesforce with external data sources.

Exceptional communication skills, adept at interacting with end clients for requirement gathering and proof of concepts (POCs), ensuring a clear understanding of client needs and delivering tailored solutions.

In-depth knowledge of SAAS architecture, CRM platforms, and Cloud version of Salesforce Click software (FSE - Field Service Edge), empowering efficient workforce management in the Energy Transmission and Distribution sector.

Expertise in admin modifications, including the creation of roles, profiles, email services, page layouts, workflow rules, validation rules, process builders, and approval workflows, ensuring optimal system configurations and streamlined business processes.

Expertise in querying the Salesforce database using SOQL & SOSL queries using Force.com Explorer.

Experienced in working with multiple vendors and geographically distributed teams. Worked on multiple projects involving development, deployment, documentation, database management and maintenance.

Strong design and coding skills, with a proven ability to tackle technical issues and provide timely resolutions, resulting in high levels of customer satisfaction.

Skilled at liaising with end-users from diverse backgrounds, effectively gathering requirements and translating them into technical specifications, ensuring alignment between business needs and technical solutions.

Skills

Key Domains -

Energy and Communication Services

Courteous with Strong Mindset

CRM

MWM - Mobile Workforce Management

Salesforce Filed Service Lightning Consultant

Customer Billing

Finance

Sales and Municipal taxation

Accounts payable

Collections

Automation

Technical skills -

Salesforce CRM

APEX

LWC

Sales Cloud

Service Cloud

Salesforce Click FSE for MWM

Field Service Lightning(FSL)

Java Script

Angular JS

Experience Clod

CPQ Specialist

SOAP/REST API

JIRA

JSON, HTML, SXP

Lightning Web Components (LWC)

CICS, JCL

COBOL and DB2

Oracle PLSQL and Stored Procedures

UNIX shell scripting

Teradata SQL Assistant

Java/OOP, C, C++, RDBMS

CSS(Cascading Style Sheets)

Database worked on -

Oracle DB

Teradata

IBM DB2

IMS DB

Operating Systems worked on –

Windows

Unix

Mainframe Z/OS

Work History

Senior Programmer Analyst 10/2022 to Current

End Client: Fisker

PreludeSys – Maryland Heights, MO

Client Synopsis: Fisker Inc. is an electric vehicle (EV) company that designs, manufactures, and sells EVs. The company was founded in 2014 and is based in Irvine, California. Fisker's products include zero-emission vehicles, electric cars, and electrification technologies. It is one of the world’s leading Electronic Vehicles manufacturer with sales in multiple counties including USA, Canada, UK and Europe.

Project Synopsis: In this project, Sales Cloud, Service Cloud and Experience Cloud were majorly used. The primary focus was to increase sales which included processes like generating Leads through campaigns, test ride events, online ads etc. while at the same time create a smooth experience for Salesforce Partner users using LWC customisations on experience cloud sites. LWC and Apex were used for customizations. System was integrated with Backend database and Frontend .net websites via Mulesoft.

Responsibilities:

Proficiently managed Salesforce roles, profiles, sharing rules, workflows, and groups to optimize user experience and enhance overall system efficiency.

Utilized data loader to efficiently import and integrate sales department leads, contacts, and other critical data, ensuring seamless data migration and integration.

Skillfully performed essential database maintenance tasks, including diagnostic tests and duplicate entry cleansing, leading to improved data accuracy and system performance.

Implemented pick lists, dependent pick lists, lookups, master detail relationships, validation and formula fields to the custom objects

Created page layouts, search layouts to organize fields, custom links, related lists and other

Components on a record detail and edit pages

Deployed more than 80 components to Prod using Change Sets and Flossum and performed post deployment activities

Integrate Salesforce application with external applications. Create their own custom application using APEX Expose there apex methods as REST web services

Extensively used Data Loader, workbench and dataloader.io for insert, update, and bulk import or export of data from Salesforce.com objects

Worked on more than 150 defects, 30 plus user stories and resolved them within SLA.

Successfully automated complex business processes using Flows, Process Builder, and out-of-the-box (OOTB) automation tools, streamlining operations and minimizing manual interventions.

Developed and implemented customized invocable Apex codes within Flows, effectively automating intricate business processes and enhancing overall system functionality.

Employed Apex triggers strategically to automate business processes wherever necessary, resulting in enhanced system responsiveness and efficiency.

Implemented comprehensive test classes to maximize code coverage, ensuring robustness and reliability of the developed solutions.

Expertly crafted Lightning Web Components (LWC) with seamless UI navigation and optimized data exchange between parent and child components, meeting specific project requirements.

Demonstrated proficiency in leveraging Salesforce governor limits to efficiently bulkify the code, enhancing application performance and scalability.

Collaborated effectively with Salesforce application developers, stakeholders, business staff, and customers, fostering a cohesive and productive work environment.

Employed Agile methodologies and insured timely completion of JIRA requests, including the attachment of proof and obtaining client sign-off, thereby streamlining project management and delivery.

Provided continuous support for key reports, dashboards, data administration, and data integrity, ensuring smooth system operation and data accuracy.

Environment: Saleforce.com platform, Apex Language, Lightning Web Components, Lightning Flows, Invocable Apex, REST API,Service Cloud, Sales Cloud, Experience Cloud, Configure Price Quote, NPSP, Revenue Cloud, SOQL, HTML, JavaScript, CSS, Bulk API, Metadata API, Test Class, Lightning Studio, Visual Studio Code, ANT Migration Tool, Copado, WorkBench, Salesforce Change Sets

Senior Salesforce Developer 02/2017 to 09/2022

End Client: Ameren Corporation

Infosys Ltd. – Maryland Heights, MO

Project Synopsis: Ameren Corporation is a leading electricity supply utility company in states of Missouri and Illinois. Digital Field Enablement (DFE) project in Ameren was a $1.5 million USD project where the field crews visiting sites/customers for electrical repairs were upgraded to use hand-held mobile devices like iPads which would implement Salesforce FSL to track and finish the work orders while staying connected and exchanging real-time data with the legacy systems. Earlier crews were using pen and paper for record keeping and later entering the data in mainframe systems which resulted in additional effort and was prone to errors.

Responsibilities:

Led requirements gathering sessions with business stakeholders, translating their needs into a comprehensive data model and building a robust schema in Salesforce, resulting in enhanced system functionality and improved user experience.

Implemented business rules and logic using advanced Salesforce features such as Validation rules, roll-up summary fields, and field dependencies, ensuring data integrity and streamlining business processes.

Successfully managed user profiles, sharing rules, and permission sets to ensure proper access and security for all users, contributing to a secure and efficient system environment.

Orchestrated API integrations between Legacy systems and Salesforce, leveraging Mulesoft as middleware, and meticulously planned and executed phased deployments, resulting in seamless data integration and improved system performance.

Introduced innovative ideas and optimized integrations and API usage, resulting in a remarkable 40% performance improvement, enhancing overall system responsiveness.

Provided detailed design instructions to the Mulesoft team, enabling them to develop optimized and high-performing integration solutions aligned with business requirements.

Collaborated with the middleware team and skillfully used Splunk to fine-tune the API calls performance in Mulesoft architecture, increasing system throughput and enabling the processing of more records per second, contributing to improved system performance. Got highly appreciated for the outcome and efforts.

Developed, tested and deployed 90+ Apex Triggers to automate complex business processes, leading to enhanced operational efficiency and streamlined workflows.

Developed test classes, peer-reviewed Apex codes for issues and ensured quality outcome.

Set up field service features, Field service Lightning and Field Service Lightning mobile app.

Set up FSL data models – Work Orders, Service Appointments, Service Resources, Territories, etc.

Leveraged Lightning Web Components (LWC) to deliver a highly customized and intuitive user interface, improving user experience and increasing user satisfaction for over 100+ JIRA stories.

Expertly utilized LWC Events, PubSub Model, Component Life Cycle, Public Properties, Lightning Data Service (LDS), Wire methods, and Apex Classes with Wire and imperative calls to deliver efficient and performant Lightning Web Components.

Implemented Service Cloud case management automations, including case assignment rules, auto-response rules, and case escalation rules, ensuring timely and accurate case handling and improved customer support.

Configured Service Cloud Live Agents, Email-to-Case, and Web-to-Case, enabling seamless communication channels and efficient case management processes.

Migrated and deployed Apex codes, LWC, Flows using Change Sets.

Designed and developed solutions using Service Cloud automation tools such as Flows, process builder, quick actions, macros, and quick text, improving service efficiency and enhancing agent productivity.

Conducted thorough debugging and auditing of fields using field history tracking and set up audit trails, contributing to data accuracy and compliance.

Automated business processes using workflow rules, process builder, and approval processes, streamlining operations and reducing manual efforts.

Leveraged SOQL queries within Apex codes to efficiently retrieve and manipulate data, ensuring optimal performance and effective data management.

Implemented Apex best practices in the development of complex controller classes, resulting in maintainable and scalable code.

Proactively recommended new features and improvements to optimize and expand the use of the Salesforce platform, driving continuous improvement and innovation.

Managed client applications through web services using SOAP protocol and REST architectural style, ensuring reliable and secure data exchange.

Employed critical thinking to break down complex problems, evaluate multiple solutions, and make informed decisions, ensuring effective problem resolution and optimal system performance.

Implemented innovative ideas, resulting in a 20% increase in efficiency in terms of time and effort savings, enhancing overall productivity and cost-effectiveness.

Highly appreciated by clients and end-users for delivering innovative solutions, enhancing user experience, and driving business growth.

Environment: Saleforce.com platform, Apex Language, Lightning Web Components, Workflow & Approvals, Flow Builder, Invocable Apex, REST API, Relationship with Custom Objects, Field Service, Service Cloud, Sales Cloud, Field Service Edge, Field Service Mobile, SOQL, HTML, JavaScript, CSS, Bulk API, Metadata API, Test Class, Lightning Studio, Visual Studio Code, ANT Migration Tool, Copado, WorkBench, Salesforce Change Sets, Postman

Salesforce Consultant 01/2014 to 01/2017

End Client: Milliman Care Guidelines

Infosys Ltd. – Bhubneswar, India

Description: Milliman is among the world's largest independent actuarial and consulting firms. This firm is involved in consolidating customer information companywide and streamline process. SFDC was integrated with different applications using and managing CRM solution for integrating sales, marketing, and support, while scaling to the company’s rapid growth.

Role: Salesforce Consultant

Responsibilities:

• Participated in requirements Gathering and definition of ER (Entity Relationship) diagrams using MS Visio.

• Involved in Salesforce.com Application Setup activities and customized the apps to match the functional needs of the organization in enterprise edition.

• Migrated Data from ACT and Microsoft access.

• Created page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.

• Implemented pick lists, dependent pick lists, lookups, junction objects, master detail relationships, validation and formula fields to the custom objects, Web to case, Email to case.

• Integrated SFDC system with IBM Lotus Notes.

• Designed, developed and deployed Apex Classes, Controller Classes, Extensions and Apex Triggers for various functional needs in the application using the Eclipse IDE.

• Created workflow rules and defined related tasks, time triggered tasks, email alerts, field updates to implement business logic.

• Develop Visual Force Pages, Visual Force Custom Controllers Components, Advanced Search Functionality, Custom Objects, Reports, Analytic Snapshots, Dashboards, Tabs, Tags and Components.

• Developed Custom Reports and Dashboards as per given requirements.

• Processed the data transformation from the legacy system to the SFDC application data schema with data cleanser, data analysis, data quality control, etc.

• Migrated Salesforce data both in/out bound using Cast Iron, Java, Web services.

• Created test scenarios on Sandbox environment, created packages and moved it between Sandboxes and Production environments to place final implementations.

Environment: Saleforce.com platform, Apex Language, Visual Force (Pages, Component & Controllers), Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Data Cleansing, Email Services, Security Controls, Eclipse IDE Plug-in, IBM Lotus notes, SOQL

Click FSE Consultant 03/2012 to 12/2013

End Client: Xcel Energy

Infosys Ltd. – Bhubaneswar, India

Project Aspire involves converting work and asset management functionalities from legacy (EMPRV) system to state-of-art Maximo 7.6 product, develop and support centralized scheduling organization utilizing Click Schedule FSE product and digitally enable field workforce with Click Mobile FSE for client's Substation, Relay and Transmission business Lines.

This is end-to-end product implementation project involving requirements Fit Gap Analysis, design, build, Unit testing, Deployment, System testing, Integration testing, User Acceptance Testing, Training and Go Live, Hyper Care.

Responsibilities:

Facilitated requirement gathering and design sessions to gather all business requirements from Legacy team.

Lead design sessions with internal Click FSE team.

Updated, maintained and monitored all design and build related artifacts developed by team in Sharepoint repository

Driven and lead field mapping sessions and requirement gathering sessions with seasoned legacy teams to define IFD/ITD roadmap for Click FSE architecture.

Designed and developed UI screens and tabs as per client requirements in Click FSE Schedule using Click Admin tool.

Created and reviewed Integration Functional Document (IFD) and Integration Technical Document(ITD) to make sure all requirements are captured in IFD and each requirement has corresponding technical solution in ITD.

Created complex agents and events in Click FSE admin tool to configure system in order to meet business requirements.

Customized mobile component modules in Angular JS and JQuery to implement complex business logic

Suggested integration solutions to middleware which helped in meeting business requirement and greatly enhanced performance of FSE Click mobile system.

Played vital role in importing prod data into sandbox cloud environments using import tools to facilitate unit testing.

Performed System Integration testing and User Acceptance testing using Qtest and JIRA tools.

Supported Go-Live process methodologies like import of static tables and configurations from sandbox to production environments to ensure seamless transition.

Configured automation events and triggers in Salesforce owned Click PAAS platform

Guided team in breaking down/resolving complex showstopper issues

Provided prod-support to end-users after go-live and played major role in resolving production issues with team's support

Increased system efficiency by 25% by suggesting simple messaging architectural change

Highly appreciated by client and end-users for providing innovative suggestions and timely support

Environment: Saleforce.com platform, Apex Language, Field Service Edge, Field Service Lightning, Angular JS, Work Orders, Tasks, Mulesoft, Splunk, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Postman, JSON, SOQL

PL/SQL Developer 08/2011 to 02/2012

End Client: Southern California Edison(SCE)

Infosys Ltd. – Bhubneswar, Odisha, India

This project dealt with enhancement of user account home page in, .com where in graphical projection of monthly electricity usage was represented based on current and past electricity consumption pattern.

Responsibilities:

Participate in onsite/offshore calls to requirement elicitation.

Prepare High Level Design documents and Low Level Design documents and get is approved from Tech Lead.

Convert requirement to PL/SQL stored procedures and ensuring that requirement is met with no existing LUW is impacted.

Apply DDL, DML processes to create and maintain all Customer Account and Service Account details in test environments

Develop and implement the SQL Server Integration Services (SSIS) packages to populate the data into the Enterprise Data Warehouse from various sources like Flat File Source, Excel Source into OLEDB Destination (SQL Server).

Use SQL Server Reporting Services (SSRS) to query the databases to generate different types of complex ad-hoc reports.

Be a Teradata SQL Assistant SME

Reverse engineer complex PL/SQL stored procedure into complex Teradata queries to achieve the same result in one long query in a report format.

Meticulously apply SDLC and Agile methodologies wherever necessary.

Preparing queries to fetch test accounts fit for each test scenario for all fellow team members.

Optimized code and performance, Transaction Management, Creation of scheduled jobs for purging the Data.

Wrote Scripts for automated database refreshes, automated backups, startup, shutdown or regular monitoring of databases.

Perform code review on SQL and related code as needed.

Act as a liaison to development teams to advice on database standards and best practices.

Perform production SQL release final verification procedure to production.

Document all database changes and follow and enforce change and release management processes.

Involve in co-ordination between On-site and off-shore teams member. Working effectively around the clock for resolving issues.

Documenting and bug fixes and resolution of Tickets.

Environment: SDLC, Agile, PL/SQL, Oracle SQL, Teradata, SSRS, SSIS, Stored Procedures, Billing, Finance, Collections, Web Services, WSDL, SOAP UI, SOAP API, XML, HTML, Relational Database

Systems Engineer 11/2010 to 07/2011

End Client: Southern California Edison(SCE)

Infosys Ltd. – Bhubneswar, Odisha,India

This project dealt with maintenance of bill payment transactions and monitoring the production error database on regular basis for customers of SCE so that root cause of the errors can be investigated and fixed.

Responsibilities:

Daily monitoring of error database tables by executing PL/SQL queries and documenting the results

Analyzing the errors and documenting the domain of the modules that caused the error like – Billing, Finance or Collections.

Proactively sending the results and analysis to offshore and onshore team for further action.

Apply simple automation like sending automated emails to a distribution list with the PL/SQL error report as an attached

Work independently to analyze the root cause of the errors starting from the cursor query in the stored procedures

Prepare design document and get approval from Lead

Employ SDLC methodology to create HLD, DLD, Test Plan and Test document within the stipulated time to adhere to timelines.

Write Scripts for automated database refreshes, automated backups, startup, shutdown or regular monitoring of databases.

Migrate test data suited for testing from Prod

Proactively use version control tools like VFS and TFS for checking out existing code and checking in the modified code.

Follow proper documentation standards of test results to get sign off from client Business analysts.

.

SQL Developer Trainee 05/2011 to 07/2011

End Client: Southern California Edison(SCE)

Infosys Ltd. – Bhubneswar, Odisha,India

This project dealt with maintenance of bill payment transactions on regular basis for customers of SCE which deals in electricity supply automation in California.

Responsibilities:

Performed specification implementation in technical language and making sure that requirements are met.

Performing data setup in local test region to replicate production scenario and making it ideal for testing.

Implementing design changes in code design document into back-end codes Work with front-end team to receive and send data across middle ware and RPC Preparation of Test documents.

Discuss and establish understanding of domain and problem statement with onsite counterpart to make sure inserted code is in line with solution.

Documenting results as per standards for proper sign off from customer Status Reporting and Responsible for final delivery.

Single handedly coded 3 complex modules, tested it to meet delivery timeline, was highly appreciated

Implementing company policies, technical procedures and standards for preserving integrity and security of data, reports and access.

Education

Bachelor of Technology: Information Technology 2010

Gandhi Institute of Technological Advancement(GITA) - Bhubaneswar, India

GPA: 7.7

XII 04/2006

CBSE Board, Madnawati Public School - Sambalpur, India

GPA: 74

Xth 04/2004

CBSE Board, Madnawati Public School - Sambalpur, India

GPA: 85

Additional Information

Personal Information Gender : Male, Marital Status : Married, Visa Details : H1B Visa – 356007942 valid till 05/07/2024

Certifications

Completed

Salesforce ADMIN 201

PD1 Developer Certification

Sales Cloud Consultant

App Builder certification

CPQ Specialist Certification

Service Cloud Consultant

Contact this candidate