SUMMARY

• 18+ years of experience in Information Technology with large scale and complex application development/Analyst/Consultant that includes 10+ years of experience in Salesforce.com CRM Platform and 8+ in Mainframe and DW/ETL Applications
• Experience in Insurance, Healthcare, Retail, Banking, Hospitality and Non - Profit/Teaching applications.
• Experience in full Software Development Life Cycle (SDLC) like requirement gathering, design, development, implementation, testing, releasing, support, maintenance and enhancement.
• Strong experience on working with agile development framework.
• Experience in Administration, Configuration, Implementation and Support of Salesforce CRM and Salesforce SFA applications based on Apex language and leveraging Force.com platform world’s first commercial Software as a Service (SAAS) application running in Cloud Computing Environments.
• Experience working with Force.com IDE, Data Loader, Apex Classes, Demand Tool and Force.com, CPQ, FSL, LWC Components, Web services API and Salesforce.com Sandbox environments.
• Created and managed new Products, Product Rules, Options, Features, Discount and Bundles options in CPQ
• Marketing Cloud Consultant experience
• Created multiple Journey and integration point for Marketing clouds of various Clients
• Experience in Community/Experience cloud for MyAccount and Portal Setup.
• Experience in designing and developing Visualforce, Apex Classes, Controller Classes, Extensions and Apex Triggers for various functional needs in the application.
• Experience in Debugging and fixing emergency bugs.
• Experience in supporting and monitoring operations queue.
• Involved in weekly and monthly change request, enhancements and implementing new features.
• Experience in writing stored procedures, functions, triggers, DDL & DML SQL queries.
• In-depth knowledge of project documentation especially preparing Requirement analysis document, complex test plans and design test cases.
• Involved in different levels of Testing: Unit Testing, System Testing, Integration Testing and Performance testing in both On-line and Batch environments.
• Expertise in developing applications using Flows, both Trigger and UI Based Flow and LWC Components based architecture.
• Involved in Production implementation upon successful user acceptance testing.
• Involved in Production support for mainframe applications and always given high priority for the production issues. Analyze the production problems and take the action immediately.
• Perform code changes or data patching if necessary and all the support documents to be updated accordingly. If the issues due to other teams, co-ordinate with the other teams to follow up to solve immediately.
• Highly proficient in understanding new technologies accomplishing projects goals successfully.
• Having vast experience, excellent communication and interpersonal skills which contribute to timely completion of project deliverable well ahead of schedule.

TECHNICAL SKILLS

SALESFORCE TECHNOLOGIES: Salesforce CRM, Salesforce SFA, Apex Language, Apex Classes/Controllers, Apex Triggers, Visualforce Pages/ Components, Apex Web Services, SOQL, SOSL, Workflow Approvals, Dashboards, Analytic Snapshots, Case Management Automation and Custom Objects, LWC, Flows, CPQ, FSL

SALESFORCE TOOLS: Eclipse, Force.com Eclipse IDE Plug-in, Force.com Explorer, Force.com Data Loader, Change Set, Workbench, ServiceNow, Demand Tool, SERENA Ticketing System and Force.com Platform (Sandbox and Production),Marketing Cloud with Journey building and Gainsight Experience

SALESFORCE Managed Package: Conga,DOCU-Sign, Jira Integration, CPQ,, K-Rise, FSL

IDE: SPUFI, PLATINUM, SOFTECH, QMF & ABEND-AID

OPERATING SYSTEM / ENVIRONMENT: MVS/ESA, Z/OS, OS/390, WINDOWS NT/XP, MS-DOS, WINDOWS XP, MS VISIO, & UNIX

LANGUAGES: COBOL, VS COBOL II, EZTRIEVE, JCL, SQL, JAVA, J2EE, JSP, HTML, Java Script C & C++

PROFESSIONAL EXPERIENCE

Salesforce Admin/Dev/Prod Support

Responsibilities:

• Working on Single Sign-On method.
• Working on Agile Methodologies.
• Created Journey and provided complex building an support of Marketing Cloud for Confidential
• Designed Custom Objects, Entity-Relationship data model, validation rules on the objects and tabs.
• Developed and configured various Custom Reports and Report Folders for different user profiles based on the need in the organization.
• Created several reports and dashboards on standard and custom objects.
• Customized Standard Objects like Lead, Accounts, Contacts, Opportunities, Campaigns and created custom objects for Quotes, Quote Line Items and Pricing data as per user requirements.
• Created complex workflow rules and approval process to auto update various fields, assign tasks and notify Group and individual Case owners.
• Developed application with Apex/Trigger, LWC and Flows
• Extensively working on different App exchange tools like Conga Sign,,Ivy Tek,K-Rise .
• Tracking tickets thru ServiceNow tool.
• Working on high priority bugs, trouble shooting and fixing emergency issues.
• Working on Validation Rules, Workflows Rules and Process Builders, Flow(UI and Trigger)
• Integrated external application with SFDC using SOAP.
• Created page layouts, search layouts to organize fields, Search Lookup, custom links, related lists, and other components on a record detail and edit pages.
• Designed and developed HTML email templates for users.
• Used SOQL and SOSL for Querying and Searching data from Salesforce platform.
• Created Journey Builder for Campaigns using Marketing Cloud.
• Interacting with the Salesforce.com customer support team on a regular basis.
• Working on migrating the code by using migration tool (Change Set).
• Managing CPQ/FSL and Marketing Cloud Automations
• Created and managed new Products, Product Rules, Options, Features, Discount and Bundles options in CPQ

Confidential, Phoenix, AZ

Sr. SFDC Administrator /Dev/Support

Responsibilities:

• Worked as a Dev and Administrator for IT team.
• Interacted with various business user groups to gather requirements for Salesforce implementation and documented the Business and Software Requirements.
• Worked on Single Sign-On method.
• Worked on Agile Methodologies.
• Designed Custom Objects, Entity-Relationship data model, validation rules on the objects and tabs.
• Developed and configured various Custom Reports and Report Folders for different user profiles based on the need in the organization.
• Created several reports and dashboards on standard and custom objects.
• Customized Standard Objects like Lead, Accounts, Contacts, Opportunities, Campaigns and created custom objects for Quotes, Quote Line Items and Pricing data as per user requirements.
• Created complex workflow rules and approval process to auto update various fields, assign tasks and notify Group and individual Case owners.
• Developing internal custom applications Using Apex Classes & Triggers.
• Worked on high priority bugs, trouble shooting and fixing emergency issues.
• Worked on Validation Rules, Workflows Rules and Process Builders.
• Worked on Round Robin Lead assignments.
• Integrated external application with SFDC using SOAP.
• Created page layouts, search layouts to organize fields, Search Lookup, custom links, related lists, and other components on a record detail and edit pages.
• Designed and developed Visualforce and HTML email templates for users.
• Used SOQL and SOSL for Querying and Searching data from Salesforce platform.
• Created Journey Builder for Campaigns using Marketing Cloud.
• Interacting with the Salesforce.com customer support team on a regular basis.
• Worked on migrating the code by using migration tool (Change Set).

Confidential, Phoenix, AZ

Salesforce Analyst

Responsibilities:

• Assess new technologies, software to improve and/or automatize some technical processes (code checking, tests, deployment…)
• Manage the environments and releases on technical aspects
• Define development strategy, standards and guidelines
• Marketing Cloud and Gainsight experience for 360 degree customer marketing and support
• Plan and do the follow-up of the developments and technical tasks
• Ensure quality of development done by internal or external teams
• Validate the technical architecture on Salesforce and between Salesforce and other applications (SAP, QlikView, Web…)
• Define the strategy and guidelines for the Salesforce technical landscape (CRM and other solutions on Salesforce)
• Production support of high critical issues.(Sev1,Sev2).
• Creating Apex Clasess/Process Builder/CPQ product configuration for their Global Sales and Franchise Sales org.

Confidential - New York City, NY

Salesforce QA/BA

Responsibilities:

• Coordinating with Product Owners in requirement analysis meetings to gather requirements
• Functional testing of the change request by verifying custom objects, custom fields, changing Page Layouts, Apex Classes, Visual force pages, Triggers, Workflow rules, Validation rules
• Working closing with BA/Users to finalize the User Acceptance Criteria(UAC)
• Worked on mostly standard objects like Account, Activities, Contacts, Case, Campaigns and few custom objects that related to business.
• Verified Profiles, Roles and configured permission settings according to the business.
• Verification of regression test cases and support BA/Users in ETL/DI verification.
• Creating user manual for release notes and halping end User understand the change
• Creating tickets for issues with Salesforce.com and tracking issues to closure for end users
• Worked in Agile methodology and had a good experience in Scrums - sprint planning.
• Good Experience in Deployment from sandbox to production.
• Created and maintained the documentation for Design, Migration and Integration.

Environment: SFDC, Informatica, Oracle, Mercury QC

Confidential -Hoboken, NJ

Salesforce QA/BA

Responsibilities:

• Involved in testing of both sales cloud and service cloud
• End-to-End testing of CRM application of SFDC which is GCForce, verified PaaS • Creating test strategy and planning for functional testing of GCForce application
• Support in both planning and execution of ETL/Data Integration testing.
• Creating user manual for Business user to accomplish their UAT
• Execution of ETL Jobs in Oracle warehouse builder and further testing end to end functionality
• Creating knowledge capture documents and other testing artifacts
• Integration testing of SFDC applications with other downstream applications
• Creating regression test suite for SFDC application
• Mentoring the offshore team on test deliverables
• Enhancing QA process for SFDC Application
• Involved right from requirement gathering phase to QA sign-off and further UAT support.

Environment: SFDC, StarTeam

Confidential, Jersey City, NJ

ETL QA Analyst

Responsibilities:

• Prepared Test Plans, which detailed the testing scope, testing requirements, success criteria, milestones, and necessary resources.
• Performed Black box, Integration, Regression, Systems, and Backend testing • Created, maintained and updated regression suites upon receiving new build.
• Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX shell scripting.
• Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation.
• Tested a number of complex ETL Ab-initio graphs, for initial and daily data loads.
• Efficiently used SQL queries to test whether required data properly loaded into the Target Data base.
• Tested Abintio graphs for various ETL functions and transformations.
• Extensively used Abintio GDE for mocking data using continuous flow graphs.
• Experience in SDLC and Agile methodologies such as SCRUM.
• Compared SQL results with application results by writing SQL queries.
• Used SQL queries to test the migrated database for Back End Testing.
• Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases using TOAD.

Environment: AbInitio, UNIX, Xml, Oracle 10g.Business Objects

Confidential

Data Analyst

Responsibilities:

• Data analysis of all PLAN and MPLAC which is in AS400 Config files
• Support end users for issues in configuration of PLAN files in AS400
• Create test plan and execution scripts for changes in UBS system.
• Providing test data for UAT support for both AS400 applications
• Creating AS400-DB SQL and further providing extensive data analysis research in UBS and Epsilon
• Execute DB2 batch jobs to bounce and refresh Data warehouse applications
• Integration testing with downstream application and upstream application
• Execution of jobs in AS400 COBOL and verification of all intermediate error files

Confidential

Data Analyst - SFDC

Responsibilities:

• Support of all ETL scheduled jobs for AES which were in Mainframe applications.
• Resolving issues for all the schedule and unscheduled deployment of mainframe and Teradata jobs and ensuring ETL/DW functionality is used by end users with zero down time
• Designed and deployed Custom tabs, validation rules, Approval Processes, workflow rules, email alerts, field updates, dependent pick lists, relationships, validations and Auto-Response Rules for automating business logic and provide support to SFDC Application
• Support in both planning and execution of UAT.
• Execute DB2 batch jobs to bounce and refresh Data warehouse applications
• Added Standard, bitmap, text, text Area, database checkpoints and synchronization points in test script to check the application by comparing its current behavior to its behavior in a previous version
• Support issues resolution and resolve queries raised by end users and providing support during production/UAT deployment
• Developed SQL queries to test the Database values for data Integrity
• Replaced fixed values with parameters, to check the functionality of the application with multiple sets of data.

Environment: IBM Mainframes, Teradata, MQC, HPSM.SFDC

Confidential

QA Tester

Responsibilities:

• Interacting with Clients to get the requirements and investigate the business.
• Creating Test Plan and conducting Walkthrough with clients.
• Verification of all the ETL Mapping logic by creating extensive test data files
• Execution of ETL jobs in COBOL and verification of all intermediate error and bypass files
• Creating SQL’s in Teradata for data analysis and providing detailed defect reports which is part of reverse engineering testing.
• Integration testing with downstream application and upstream application.
• Identifying the pain areas of manual testing and automating by creating COBOL modules.
• Perform re-engineering testing by creating complex SQL and building the reporting logic
• Automate the ETL jobs in REXX thus ensure 100% regression coverage

Environment: IBM Mainframes, Teradata, Mercury QC, Focus Reports, SAS Reports

Confidential

Cobol Developer

Responsibilities:

• Creating technical design and Impact analysis document
• Coding in IMS COBOL for the screen changes in Agribusiness policy issuance system.
• Review on the design and coding of peer programmers
• Implementation of change and UAT Support
• Explaining the business users about the changes done for that release Environment: COBOL, JCL, IMS-DC, File Aid, Endeavor, Expeditor