Project Portfolio

Role Automation Practice Lead and PM/BA
Responsibility  Helping Automation Framework designed in Playwright
 Writing Automation scripts for the sprint work done so far
 Creating Components used in Automation Testing
 Gathering requirements
 Updating Status
 Handling DSU (daily stand ups)
 Handling other scrum ceremonies

Project Brief Web solution developed to configure and pay tax returns for US and

Canada Jurisdictions.

Dormakaba
Domain Retail/E-commerce ( Security systems developed for schools and colleges)
Technology Java and Selenium Web driver
Role Automation Engineer and PM/BA
Responsibility  Automating the tech debt

 Resolving the Production Cycle issues for automated tests
 Automating new functionalities
 Automated new product configurations coming in from sales force
 Validating new feature updates on Website
 Handling Client calls
 Gathering requirements
 Story write ups

Project Brief Automated End-to-End flow right from product search to product in the
card and payment with dummy credit card. All the flows included like
removing the product increasing quantity and checking the amount
increased etc.

Online Medicines Sales
Domain Retail/E-commerce (Medicines sales online)
Technology Java and Selenium Web driver

Role Automation Engineer
Responsibility  Automating current sprint user stories

 Automated the work flow right from account creation till medicine
is ordered
 Add to the cart etc.

Project Brief Sell Generics medicines online based on the geographical regions and

connecting to nearby vendor. This was a startup.

Shipping Module System
Domain Logistics
Technology C# , Selenium Web Driver
Role Automation Engineer
Responsibility  Leading Automation efforts

 Creating Automation Frameworks used C# with Specflow Nunit
 Estimating Automation efforts
 Working on Mobile Automation Framework
 Automating Mobile App Regression Suite
Project Brief Project developed to manage the cargo space at ports

Live Advertising Bidding system
Domain Media and advertising
Technology C#, Selenium web driver
Role Automation Engineer
Responsibility  Automation and manual testing

 Leading Automation Efforts for application under test
 Helped Developing Automation framework using Selenium
 Collaborating between onshore and offshore team
 Attending all scrum ceremonies
 Working on task assignment and team velocity

Project Brief Live bidding system to place an advertisement on the space available on

different web sites and papers.

Financial Data Analysis
Domain Finance
Technology C#, Selenium, Python
Role

Senior Quality Engineer

Responsibility  Testing Web based solutions
 Testing using Selenium and C#
 Testing using Python (PyWinAuto,pytest-bdd,pyautogui)

Project Brief

Web solution showing the details and financial fact sheets for all the listed
companies in NYSE

Online Doctor Appointment Mobile Application
Domain Healthcare
Technology C# , Appium Web Driver
Role Automation Engineer
Responsibility  Help in developing automation framework using C# and Specflow

and Appium
 Automating Regression Suite cases
 Automating current sprint tasks

Project Brief Mobile app developed to book the doctors’ appointments in particular
hospitals those have taken the subscription for the application and system.

SMART Healthcare System
Domain Healthcare
Technology C#, Selenium
Role

Quality Analyst

Responsibilit
y

 Getting enhancements or changes on web pages in form of user
stories.
 Estimating QA efforts for PRBs and User Stories.
 Working on user stories manual and automation testing.

Project Brief SMART system was developed to record patients data right from he entered
in hospital till discharge. It was having all the modules like payment
processing and electronic claim generation.

Skill Set

• Automation
• Automation Tester
• QA

Project Portfolio

Skill Set

• React Native

Project Portfolio

Skill Set

• ServiceNow

Project Portfolio

Skill Set

• SFDC toolkit

Project Portfolio

Skill Set

• FourGen Computer-Aided Software Engineering (CASE) Tools

Project Portfolio

O PROJECT DETAILS
r
•

Project : Vodacom (Nov 2022 to till date)
Role and Responsibilities:
-

Involved in gathering and analysis of business requirements and then effectively took part in sprint
planning to achieve the requirement
-

Worked on Field dependency, Validation Rules, Triggers, Apex Classes, Data Security using different levels
of access, Page layouts. -Worked on the designing of custom objects, custom fields, custom Tabs,
leveraging declarative Tool such as workflows, Process Builder, Flows as per the client and application
requirements.
-

Worked on Batch Apex to automate complex business processes like Warehouse Inventory Management
and Service Activations. - We followed best practices by using trigger frameworks ,helper and handler
classes to ensure scalable and modular code architects.
•

Project : Liquid Telecom ( Jan 2020 to Oct 2022)
Role and Responsibilities:
-

Created and maintained page layouts, record types, validation rules, workflow rules, and approval
processes for business processes.
-

Configuring OWD, Profiles, Roles, Role hierarchy, sharing settings, Sharing rules, object level, field level
security.
-

Data Migration using Data Loader.
-

Provided KT and training to end users on Salesforce functionality and best practices.
-

To maintain the logs supported governance and compliance by managing field history tracking, login
history analysis, and audit trail review.

Skill Set

• Apex
• LWC
• Salesforce
• Salesforce Commerce Cloud

Project Portfolio

Name: Singer India (Mar 2020 – Feb 2022)
Responsbilities :
 Involved in identifying, planning and implementing new Salesforce.com features and functions, new screens,
workflow, force.com objects, reports, apex code to meet business requirements.
 Participated in solving day to day production issues/defects/incident management.
 Worked on deployment of components using Change Sets, Package across sandboxes to production org.
 Designed, developed and deployed Apex Classes, Apex Triggers, Visualforce pages for various functional
needs in the application.
 Debugging Apex scripts using Debug Logs and System Log Console to catch Exceptions and execute
Governors and Limits and writing Apex Test classes for Unit Testing to maintain the code coverage greater
than 80%. Developed Assignment rules, Escalation rules to enable proper routing of cases to the case team
members.
 Develop Variable Management system to maintain all agent invoice, customer invoice , deduction and detail
bills for all agents and customer
 All invoice and detail bill generated at end of month after accepting digital signature.

 Took care of salesforce production support, Customization / Enhancements.
 Develop the UI to order any spare part or product from their account.
 Integrated Google API for maintain Latitude and Longitude to calculate distance travelled for expense bill.
 Integrating Salesforce with NAV using SOAP API.
 App development which included the integration of API system with salesforce.
Tools/Technologies:
Apex, LWC, VF, Integration, VS Code, Google API, SOAP API, Trigger, Flow, Administrator features
Name: India Today (May 21 – Feb 22)
Responsbilities :
 Setup the custom Sales Process using Aura and LWC as oer business requirment for 5 department using one
salesforce App.
 Report and Dashboard maintaince for all user as per their role and department.
 Designed & implemented a configurable solution, customizable UI for the app according to the business
needs.
 Developed Target Management System for all user.
 Implemented exception handling, fixed the governor limit issues.
 Took care of salesforce production support, Customization / Enhancements.
 Performing functional testing of the new system and ensuring that it meets the user specifications; designing
test strategy, developing test plans and approving test cases
 Ensuring that customer deadlines are met within project budgets.
 Participating in the Software Development Lifecycle (SDLC) right from requirement analysis, documentation
(functional specifications, technical design and coding to maintenance of proposed applications)
Tools/Technologies:
Apex, LWC, AURA, Email alert, Web-to Lead, Report and Dashbaord
Name: Sanghi Cement (Jan 21- Feb 22)
Responsbilities :
 Took care of the Bulk processing of data into the salesforce system.
 Took care of the salesforce sandbox & the production orgs.
 Created template as per the style guide using CSS, HTML and typescript
 Integrated the Playstore published App with Salesforce.
 Setup Visit Managment, Schema Management, Payment Management system in Mobile App where user are
using Mobile and all real time API was setup to process the automation using Salesforce backend and
updating it on Mobile.
 Extensive business knowledge and customization experience on various Salesforce.com standard objects like
Accounts, Contacts, Opportunities, Products and Price books, Cases, Leads, Campaigns, Reports and
Dashboards.
 Setup custom dashboard as per their requirement on mobile.
Tools/Technologies:
Apex, React Native App, Integration, Automation
Name: Extramark/ Dampur (Sep 21 – Jan 22)
Responsbilities :
 Worked on Setting up various Analytic Dynamic Dashbaord as per their business requirement.

Tools/Technologies:
Einsten Dashboard, DataFlow, DataSet

Name: SCU (Jan 22 – Till now)
Responsbilities:
 Integrate Salesforce with Box for File Management.
 Developed functionality for sending the upload doc to Box.
 Designed custom solutions for clients and provided functionality for signing the docs digitally.
 Bulk processing of data into the system.
 Took care of salesforce production & sandbox environment
 Implemented exception handling, fixed the governor limit issues.
 Sync Contact and User data data bi-directly.
Tools/Technologies:
Apex, Integration, REST API, Test class, Admin features, Batch Apex, Triggers, Box
Name: Allaint University (Sept 2022 – Till now)
Responsbilities :
 Developed the functionality of document sync to their File Zilla from 3 object.
 Integrated the Sharepoint with Salesforce.
 Designed custom solutions for clients and provided functionality as per business requirements.
 Maintain documentation for all updates and changes done in salesforce.
 Took care of salesforce production & sandbox data.
Tools/Technologies:
Apex, Integration, REST API, Trigger, Batch, Schedular, Analytic Dashboard

Name: Matillion (June 22 – Till Now)
Responsbilities :
 Worked on Apex, LWC, Triggers, Admin features.
 Worked on the community cloud portal in salesforce.
 Designed custom solutions for clients and provided functionality for Community setup for user interactive.
 Took care of salesforce production & sandbox changes, day to day issues, deployment, document maintaince
for all changes, Client interaction.
 Worked on CPQ features.
 Worked on CLM management as per business requirement.
 Worked on customer support for setting up admin functionality, Einstein Dashbaord, Community add-on and
updates
 Experienced using Salesforce Lighting UI, Enabled Aura Framework, by adding Aura attributes and Aura Handlers for
Events to focus on Logic and Interactions in Lighting Applicaiton.
 Minimized code in Javascript Controllers by adding reusable functions in Helper Component. Updated the Apex
Controller and Helper functions regularly making the component context aware as per requirement.
Tools/Technologies:
Apex, LWC, VS Code,Github, CPQ, CLM, Trigger, Admin, Community

Name: HEALTH CLOUD PROJECT (Feb 24 – Till Now)
Responsbilities:
 Worked on the Health cloud portal in salesforce.
 Customization of the portal with patients and doctor’s details.
 Worked on the appointment generation also the UI designing part.
 Created triggers to on appointment generation based on the business needs
Tools/Technologies:
Apex, VS Code , Health

Skill Set

• LWC
• Salesforce
• Salesforce Commerce Cloud

Project Portfolio

Project:

IDFC First Bank – Higher education loan(Sales/Service/Community Cloud/Partner Portal)
Working on customization and configuration requests as per business needs.
Worked on Partner Portal for Management of Clients Loan Disbursal Process.
Tracking all the US on Jira board and as per the US, start our implementation either it depends on the coding
or the configuration part. Mostly used JS code for the customization part.
Worked on the salesforce Experience in creating a Community for Partner and Customer Profiles.
Developed GET and POST APIs for enhancement as per requirements.
Worked on bugs, CR, Apex Classes, Triggers, and Flows implementation.
Designed user journeys for the Partner Portal and Community Cloud interfaces using SLDS standards.
Created wireframes and prototypes in Figma to visualize LWC-based custom forms before implementation.
Focused on user-centered design while building interactive dashboards for loan tracking.
Worked on Lightning Web Components (LWC) to create Custom forms and dashboards.
Worked on Rest API using mulesoft.
IDFC First Bank – Skill Fee Financing & School Fee Financing
Developed lightning application to maintain Bank users’ records and take a loan as per their needs.

Development of project flow using various technologies like LWC, VF Page,, Salesforce Object
customization, Workflows, Process Builders, Triggers, Trigger Framework Implementation and other
Automation tools.
Collaborated with stakeholders to optimize UI components and enhance usability in the Experience Cloud
portal.
Applied UX principles to streamline loan request flow, improving user experience on Lightning apps.
Worked in Production Support as well as in Development.

Skill Set

• LWC
• Salesforce
• Salesforce Commerce Cloud
• UI/UX

Project Portfolio

PROJECTS
1. Atos Syntel - Power BI Reports & Tools Management
1 Worked with various tools like IBM Rational Tools, Jira, GitHub, and
Worksmart.
○ Collaborated with the reporting team to create, generate, and maintain
Power BI reports related to costing of different tools across multiple
countries.
○ Developed reports from scratch and maintained existing daily and monthly
reports.

2. Walgreens 340B Drug Pricing Program
1 Working on a US government program that allows eligible healthcare
providers to purchase outpatient drugs at discounted prices.
○ Utilizing Power BI, Tableau, MS Excel, and Salesforce to manage and
analyze healthcare provider information.
○ Generating and creating Power BI reports to maintain a healthcare provider
database received through Salesforce.
○ Managing, modifying, and updating reports based on client requests.
○ Worked extensively with Power Query, Data Modeling, Data Visualization,
and DAX in Power BI.

Skill Set

• PowerBI

Project Portfolio

Projects Summary:
1. Project: Paypal
Client : Paypal (US)
Role : Software Developer
Team size 8
Duration : July 2022 to till date
Environment : SQL Server , SSRS, Azure, POWERBI
Tools : Windows Server 2019, SQL Server 2017, SSRS (Visual Studio)
Domain : Health Care
Description:
Ally Align Health manages Private Health care within US and Medicare Advantage (MA)
institutional special need plans (I-SNPs) and we develop reports for Ally Align as per
requirements and changes request updates accordingly, Using visual Studio SSRS report
builder and SQL server 2017
Responsibilities:
⮚ Experience in maintaining and analyzing SQL databases, Stored Procedures, Functions &
views
⮚ Developed nearly 60+ new reports and updated 110+ change requests till date
⮚ Fixed layout and positioning issues for graph and visualization reports
⮚ Created COVID related visual & graphic reports by maintaining up to date records
⮚ After development of each report unit testing is done to all reports for rectifying layout and
minor issues and self QA in server performance
⮚ Included some of the Summations in Dataset query as to solve SSRS limitations
⮚ Maintained RDL’s in report Builder and checked in RDL’s to client server environment
⮚ Inventory is maintained up to date as per each week
⮚ Fixed some of the function and query issues in SQL Server
2. Project: KAISER PERMANENTE
Client : KAISER PERMANENTE(Us)
Role : Software Developer
Team size 14
Duration : Sep 2020 to July 2022
Environment : PL SQL (Oracle SQL Server 11G), SSRS
Tools : Windows Server 2008 R2, PL SQL 2008, SSRS
Domain : BFS (Investments)
Description:
Columbia Threadneedle Investments is a leading global asset manager. Columbia
Threadneedle Investments is the global asset management group of Ameriprise Financial, Inc.
Columbia Thread needle Investments is the global brand name of the Columbia and Thread
needle group of companies.
It’s a Migration Project where we need to Migrate SAP BO reports to SSRS using Report
Builder and Oracle SQL Server 2008.
Total Project Contains nearly 1500 SAP BO reports need to convert them into 510+ reports in

SSRS.
Responsibilities:
⮚ It Consists of three waves, Out of each wave each developer is allotted with nearly 20+
reports
⮚ I had developed some of the merged reports of having SAP BO’s up to max of 20 into a
single SSRS report.
⮚ Creation of various reports in SSRS drill down, drill through, tabular, matrix, tabbed and
merged reports as per the end users requirements (design documents).
⮚ Experience in maintaining and analyzing SQL databases, Stored Procedures, Functions in
SQL Server database
⮚ Merged nearly 8-10 queries into one Single query using Full outer join, Left & Right Outer
Join and Union
⮚ After development of each report unit testing is done to all reports for rectifying layout and
minor issues
⮚ Included some of the Summations in Dataset query as to solve SSRS limitations
⮚ Maintained RDL’s in report Builder and checked in RDL’s to GIT Tortoise environment
⮚ Inventory is maintained up to date as per each wave
⮚ Fixed some of the function and query issues in Oracle SQL Server
3. Project: Blue Shield of California(Excellus Helath Care)
Client : Blue Shield of California (Us)
Role : Software Developer
Team size : 11
Duration : Jan 2019 - Sep 2020
Environment: SQL Server, SSAS, SSRS, SSIS
Tools : Windows Server 2008 R2, MS Visual Studio 2017, MS SQL Server 2017
Domain : Energy and Utilities
Description:
Anglian Water Services is a big water supply body supplies safe drinking water to 4.3 million
customers in towns and villages in UK Serves mostly in East of England.To develop a web
application to maintain the monthly activities of the customer using Dot Net as a front end and
Microsoft SQL as the back end. Multiple reports created as per the customer’s requirement
using SSRS as to view and generate the daily, monthly and yearly records on basing individual
and combined activities performed.

Responsibilities:

⮚ I had been involved in UI part for the reports, I had developed reports like drilldown and drill
through, matrix and tabular models.

⮚ Have fixed some of the real time technical issues in reports such as column freeze, header
sorting.
⮚ I developed DLD documents.
⮚ I had fixed some of the challenges in the reports effectively.
⮚ Deployed the report RDL files to the application and maintained up to date.
⮚ I gained knowledge in T-SQL queries to develop stored procedures.
⮚ Gained knowledge to analyze the project requirements based on the UAC and BR documents

Skill Set

• PowerBI