BHAVIKA PARIKH
*******.********@*****.***
Phone # 303-***-****
EDUCATION:
University of Mumbai Mumbai, India
Bachelor of Engineering in Electronics June 2001 to May 2004
Govt. Engineering College Mumbai, India
Diploma in Industrial Electronics June 1998 to May 2001
CERTIFICATIONS:
ITIL foundation
Salesforce Admin 201
Salesforce Certified Platform Developer I
Salesforce Certified Platform Developer II
WORK EXPERIENCE:
Overall 14 years 5 months of IT experience in in every stage of software development, providing solutions to support. A team player with ability to design and develop structured software that adheres to well established software engineering standards. Proven ability to fix software bugs and problems quickly and effectively. Excellent communicator and team player.
Lead Salesforce Developer experienced in Salesforce CRM platform with Saleforce.com architecture, strategy, development and configuration, data migration and deployment of applications to Force.com platform for user groups.
Primary experience using Lightning Design System, Lightning Component Framework, Lightning Communities, Lightning experience, Lightning Connect and Lightning App Builder to build front end user interfaces for a Client projects (Informatica cloud) and Deloitte Digital studio internal project (Audit -POC, Salesforce Batch Accelerator).
Direct oversight of Continuous Integration process using Salesforce DX.
Experience in integrating SAP and Salesforce Service Cloud using Partner Communities
Experience using Salesforce out of the box capabilities for business process changes, development of various functionalities using point and click capabilities and Force.com features Apex, Apex Triggers, Apex class, Visualforce pages.
Hands on experience in Leading, Developing PL/SQL - Stored Procedure, functions, packages, PRO-C programming on Unix platform, Shell Scripting, Ab-initio based application.
Deloitte Digital Denver, CO
Salesforce Consultant Jan 18, 2016 – Present
Project:
Google - Vector
Role: Salesforce Technical Lead
Google project Vector is to help customers, partners and Googlers by providing better Sales process, data, opportunity life cycle management.
Implementing Sales and Service could solutions.
Setting up standard Salesforce features like page layouts, record types, profiles, permission sets, custom fields.
Provide architect guidance to team.
Helped decide branching and automate DevOps process for continuous integration.
Other responsibilities involve developing features in Salesforce using SFDX, working on building Proof of Concepts to present to the business, developing functionalities in community for PRM
Worked on Salesforce translation workbench to support multiple languages in Salesforce community.
Assigning user stories, helping and guiding the team on their development assignment along with the technical reviews and testing of the functionality, help team on technical blockers, solutions and discuss with Google client, technical team to get the final decision to move forward with the implementation.
Project:
Kohler
Role: Salesforce Technical Lead
SAP CRM to Salesforce integration using Salesforce Sales cloud, Service Cloud features and Lightning Communities
Implementing Sales and Service could solutions.
Setting up standard Salesforce features like page layouts, record types, profiles, permission sets, custom fields, workflows, outbound emails and email templates according to requirements.
Developing extensions to standard Sales and Service cloud implementations with Visualforce pages, Apex classes, triggers, lighting components etc.
Leveraging security features in platform and setting up security and access control around data.
Setting up reports to track key performance indicators.
Improving the implementation and process based on KPI reports and feedback from customers.
Project:
Anthem Modernization and Migrations
Role: Salesforce Technical Lead
Development and Automation of Migration Collaboration Tool to provide Account Management, workflow, dashboard, Issue management capabilities to migration stakeholders.
Extensive use of Lightning Components using Informatica cloud automation for Hierarchical Account loads with custom Apex solutions, ability to create Case upon loading of the Accounts in Salesforce to generate the list of pre-defined set of Tasks, ability for Users to re-assign the tasks within the same or cross-functional group so that users can prioritize the Tasks assigned to the related Account and work on each day.
Use of the chatter functionality for the Users to communicate any issues or roadblocks while completing their own task.
Automated reports and Dashboard creation capabilities for the Users to keep track of their Tasks within the tool.
Data modeling, High level and Technical Design, architecture and Solution for the Migration tool
Informatica cloud to load external CSV files into Salesforce
Custom Lightning components and Visualforce Apex page development
Visual Process flows and Process builder
Salesforce security model to create Profile, Roles and permission sets
ANT deployment (Package XML creation and deployment)
Deployment via Change sets
Data load using Data loader
Did Code review, mentored and provided solutions to the offshore team during End to end Development phase
Prepared presentation for Client demo and documentations for the Client IT team for transitions phase
Project:
Informatica – CPQ
Role: Salesforce Technical Lead
Informatica decided to move to a subscription-based model in order to sell their Products.
Since Informatica was already using Salesforce and Apttus for CPQ and was having a lot of issues with the Apttus Implementation, Informatica decided to use Steelbrick for its core CPQ functionalities.
In order to reach at the end goal of using Steelbrick CPQ and move all the Products in a subscription Model, Informatica decided to create a New Salesforce Org that will sell some of its subscription-based product using Steelbrick and eventually all the products would be moved to New salesforce org and they can finally retire the Existing Salesforce Org.
Deloitte helped Informatica in making this decision and currently is helping configuring a New Salesforce Org with Steelbrick CPQ to support subscription-based Products. Since, Informatica still have some Products that can only be sold via the existing Salesforce org, A new Lightning Interface is being implemented in the new org that will provide an easy and quick Process to the Sales Rep to filter/search and add different Type of Products on an Opportunity.
The Project is heavily supporting lightning as Deloitte got an instruction from Informatica Leadership team that the Users are utilizing Lightning view in salesforce. New Lightning Screens are being created to give user a better UI experience to support both Desktop as well as Mobile View in below functionalities:
Adding a Product on Opportunity.
Managing all Products on Opportunity Level.
Reviewing asset and entitlement details.
Designed and implemented custom Opportunity Page with customizable Products Related List to allow user to Add/Delete/Edit Products information using customizable features using Salesforce Lightning design system and compatible with Salesforce1
Project:
Internal Audit Prototype
Role: Salesforce Senior Developer
Development of lightning application for Global Audit Transformation.
Created custom lightning components and implementing on salesforce communities
Created event handlers
Created reusable lightning components
Created lightning controllers using JavaScript
created CSS for lightning components
created event handlers to handle application and component level events
Project:
DADS- RSSM
Role: Salesforce Lead
Worked with The Texas Department of Aging and Disability Services (DADS) which was created to administer long-term services and supports for people who are aging as well as for people with intellectual and physical disabilities It was a State-level project to rebuild system schema, changing paper-based forms to electronics forms and migrate data to support new business requirements. As a part of this project 40 different types/categories of disability forms were converted in to electronic form with Approval process.
Did Requirement Review and clarifications.
Apex Class, Visual force (Page, Component and Controllers), Test class Creation, Apex Data loader, Force.com Eclipse IDE Plug-in, Jira, HP Quality center (QC), Putty, WinSCP, IBM Data stewardship application, MDM, Citrix Metaframe, SOAP UI, Eclipse, Mavensmate, Java script, PL/SQL, HTML
Triggers and respective handler class creation.
Visual force page development using Java script/J query and HTML.
Coordinating with functional team Defect fixes and managing defects in Application Lifecycle Management (ALM)
Implemented Conga Solution for Document generation, PDF’s, Email templates with Attachments in both Salesforce Classic and Lightning
Generation of Batch documents for User through Conga Solutions using mail merge
ANT deployment (Package XML creation and deployment).
Deployment via Change sets.
Data load using Data loader.
Created Profile, Roles and permission sets.
Validation rule, work flow and formula field creation.
Story grooming and sizing.
Environment: Salesforce CRM, Salesforce Lightning Design System (SLDS), Lightning experience, Lightning Components, Apex, Apex Trigger, Apex Class, Visual force (Page, Component and Controllers), Apex Data loader, Force.com Eclipse IDE Plug-in, Jira, HP Quality center (QC), Putty, WinSCP, SOAP UI, Eclipse, Mavensmate, Java script, HTML
Avani Technology / Mastech Inc.
Project:
Cash - Financial System
Role: Senior Software Developer June 04, 2014 – Jan 15, 2016
Agile methodologies for this project, involved in planning, backlog grooming, daily stand-ups and showcase sessions
Developed stored procedures, functions, packages triggers to facilitate consistent data entry into the database
Written Package and Stored Procedures for common utilities
Developed database Triggers for audit and validation purpose. Writing validation packages using PL/SQL package
Developed Perl script to convert large XML files to CSV files to load it into Oracle table using SQL LOADER
Three weeks iteration (sprint) to complete design, development and testing
Closely work with product owner, business analyst and system architect
Involved in RDBMS design and developed ER-diagrams. Participated in code walkthroughs and review sessions with the development team
Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages
Code Review of other team member and developed Installation scripts for all the deliverables
Involved in performance tuning on SQL and Pl/SQL using AUTO TRACE, EXPLAIN PLAN utilities
Have performed various testing activities like Unit Testing, Integration-System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is ideal
Understanding the functional knowledge of ISIS CASH system
Communicate with the User, operation staffs and Subject Matter Experts to understand/ translate the requirements into programming action items.
Developing package, store procedure, function and call it through the program and scripts as per the client's specification using C, Pro*C, PL/SQL and Perl and UNIX shell scripts.
Creating and deploying packages using Harvest tool.
Write complex SQL queries using joins, sub queries and inline views to retrieve data from the Database and Monitored and Tuned Applications, SQL statements and databases.
Creation of database tables, table spaces and various database objects.
Use X window, Putty, TOAD, SQL Loader, DBX tools to develop and support for the existing application
Create and test the preliminary requirements and produce design documents and assist Business Analyst for functional test.
Using Perl Scripts for scheduling jobs and managing critical paths.
Obtain approval and deploy/integrate codes using Harvest tool into all environments and follow the rest of the process until task completion.
Provide peer-design and code review to make sure coding standards are being followed
Perform unit test on HP quality center tool.
Automate the regular manual work; resolve production issues, work on AR tickets and end-user query generate report using SQL and KSH.
Monitor the production jobs and processes, FTP jobs and fix it in a timely manner
Environment: PL/SQL, Oracle11g/12c, C, Pro*C, UNIX Ksh, Csh shell and Perl scripting, Toad, SQL*PLUS, JIRA
L&T Infotech
Role: Project/Application Support Lead Apr 30, 2012 – May 16, 2014
Worked for CITI Connect which is a file processing system used for bulk payment process for CITI Direct application and Global Trading Profit & Loss (GTPL) system is a P&L product processing system. The system is designed to calculate and post the P&L associated with the firm’s proprietary accounts, provide Financial Control positional data for validating the firm’s trade-date and settlement-date exposure, to determine the firm’s P&L from the facilitation of agency activity, and finally, provide position data to various downstream consumers. GTPL serves as the P&L calculation engine for all of Citigroup’s Firm Trading Accounts, central repository for Financial Control in terms of them performing their risk management function, repository for determining the revenue for the Firm via Agency trade and hub for providing position related data to other downstream consumers of the data. L1 & L2 support is to be provided 24*7 for the set of applications agreed
Providing L2/L3 Support to CitiDirect Online Banking global business users
Driving all High Severity Issue (Sev1/Sev2) on resolution bridge calls for service restoration, effective coordination, escalation, notification and resolution
Facilitate the support teams and Stakeholders on the bridge and ensuring that the issue is resolved within the assigned SLA window and supporting user queries
Close coordination with other Support groups like UNIX, Storage, Database, Service Desk, Tibco, WebSphere, Windows etc. for resolving all the infrastructure issues within SLA
Incident management, problem management – initiating platform of Daily Service review calls for discussing Sev1 & Sev2 incidents & actions, trend reports, RCA’s, Creation of Known Error Database
Following the Incident Management process cycle for every client specific Outages per ITIL compliance inculcating Change Management as per requirement and customer suggestion
Preparing application wellness reports, Outage report, application recovery, and disaster recovery for the applications
Participation in daily support review meetings discussing and sharing the incident occurred across shifts and domains
Managing/driving ITIL best practices/Service Delivery & Support for Global support center such as SLA/OLA driving RCA for clients. Creating weekly operations reports/dashboards and sharing it with Senior Management
Establish, monitor and evaluate system metrics to identify vulnerabilities and identify problem trends. Monitor disk status, system processes, and user process activity
Monitoring / Scheduling Jobs in the Autosys environments abiding by the Change & Audit guidelines. Troubleshooting of all scheduling / execution issues of the batches
Establish and practice disaster recovery procedures to ensure recovery capability. Properly organize and maintain data retention practices
Participate in design reviews to verify that design meets quality standards and functional/technical requirements provided by business users
Designed, reviewed, and performed code reviews and mentored other developers on the best practices in developing PL/SQL programs
Developed and automated the interfaces by using the PL/SQL
Wrote stored Procedures, Views and Triggers, to provide extra functionality, including loading and modifying of data and retroactive business rule changes
Creating Unix scripts to send automatic email for any rejects occurred while loading into ware house tables, to set new alert and modify the alert notifications for failure of the incoming Payment files in the application for Platinum clients like Google, Shell, Exxon to save the payment cut-off and in turn dollar value saving
Designed and Developed the graphs using the GDE with different Ab-Initio components
Experience in Dimensional Modeling using Star, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin
Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses using Power Connect as ETL tool on Oracle
Environment: Oracle 10g/11g, PL/SQL, Pro*C 3.0, Unix, Shell Scripting, Ab-Initio, Toad, SQL Developer 2.1, Putty, Windows 2003/XP, SSH- Secure Shell, WinSCP, SVN, Autosys R11.3, ServiceNow 2.0, ResolveIT, VirtualTech
Mphasis an HP Company Mumbai, India / Nashville, TN / Newark, DE
Delivery Senior Software Engineer Aug 28, 2006 – Apr 23, 2012
Project is to implement the Medicaid Management Information System (MMIS) for the US state government. Medicaid is a US government driven program to provide free medical assistance and health-related services to the poorest people with low incomes resources. It divides the application into components so that they process on different networked computers, leveraging the true power of client/server architecture. This design and supporting architecture deliver enhanced flexibility, scalability, and reliability. This Application is used by healthcare service recipients, providers (Physicians, hospitals etc.) and US government to manage and control the medical claims related processing and avoid fraudulent claims. We were involved in developing the application tier or the business logic tier, performing enhancement and maintenance activities for the various subsystems/modules of MMIS namely the EVS (Electronic verification system), Claims, Member, Provider, Eligibility, TPL (Third party liability) and Enrollment
Involved in development, enhancement and testing phase of different subsystems of the healthcare application
Involved in developing the business logic tier, performing enhancement and maintenance activities
Created Business Requirements Document (BRD), High Level Design Document (HLD), Unit test document of the client requirement and involved in complete SDLC cycle
Development and enhancement of the Pro*c code
Creating database tables, stored procedures, functions, triggers for different business processes as per the client requirement
Developed scripts and modified Pro*C program for automation of Claims processing to handle additional 1million recipients
Developing back-end PL/SQL packages, building UNIX shell scripts for data migration & batch processing
Data loads using the SQL loader, Imports & UTL files based on file formats
Created UML Diagrams like Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio
Experience with defect tracking tool JIRA
Involved in deployment of code in production as part of scheduled as well as emergency releases
Development in Java- Spring, Ibatis coding and Spring unit testing of HealthPayer – Member Management system
Implemented small framework for Erwin 7.3 data model validation
Extensive communication with the client to resolve any issues pertaining to the business requirements
Co-ordination with Business team, Production support team and Data center teams to solve the issues with production database. Enhancements, testing to implement the changes required by Clients
Preparation of status report Metrics to the Senior Management
Coordinating with BA's, Testers and DBA's to understand high level Business requirements
Designed, developed and successfully completed a POC to that Cost Based to Time Based Load Planning is possible within the resources. This assuaged the risk f prove actor associated with this project
Played the role of Business Analyst for Eligibility verification system, Claims subsystem of Tenncare Medicaid information management system
Environment: Oracle 10g, PL/SQL, Pro*C 3.0, Unix, Shell Scripting, Toad, SQL Developer 2.1, Java 1.6, Spring 2.0, IBatis 2.0, Weblogic10.3, SOAP UI, Spring Batch 2.0, Eclipse, Putty, Windows 2003/XP, SSH- Secure Shell, WinSCP, SVN, Autosys R11.3, ServiceNow 2.0, ResolveIT, VirtualTech
Company: Nucsoft Ltd Mumbai, India
Software Engineer Feb 28, 2005 – Aug 26, 2006
Financial Management System (FMS) is the financial data warehouse of Citibank-India. The prime objective of this system is to gather data from various satellite systems (Treasury, FTU, IBBS, GFTIDE, and RMDATAMART) and generate various overseas and local reports in the daily end of day activity. From FMS, Financial control unit and Internal control unit of Citibank in turn use reports, proofing module for submitting the proofs of the manual accounts. The scope of the project is to make the system generic so that it can be used by all the systems in the Citibank
Designed, developed and maintained application using Erwin, Oracle8i & 9i, Crystal reports, FTP, UTL files, PL/SQL & UNIX shell scripts.
Provided support and training to business analysts, maintained the application and database
Played major role in development of Citibank Financial, Reporting system from Development through production cycle
Developed the Unix scripts to automate jobs
Involved in coding, testing and implementation phase of different modules of FMS
Query Optimization to speed up the data extraction from FMS
Performing Extensive testing and fixing the bugs/errors if any
Writing SQL queries for generating reports based as per the client requirements
Data level testing including all banking functions
Used data de normalization to cut down the processing time of generating reports
Co-ordination with other Support groups and teams of Citibank for cut over, enhancements and for production issues
Requirement gathering and analysis with the Financial Control Unit of Citibank for the Internal and External MIS module
Preparing Functional Specification and Design Specification
Monitoring EOD activity for Citibank Financial Management System (FMS)
Leading a team of 6-8 team members
Environment: Pro*C 3.0, PL/SQL, C, Oracle 8i/9i, UNIX Scripting, Oracle Form 6i, Toad, Putty, SSH - Secure Shell
Intermix Media Mumbai, India
SQL/QA Developer Oct 1, 2004 – Jan 31, 2005
Project is to provide content via a network of websites including myspace, blends user-generated and proprietary online content to motivate its users to spend more time on its network
Did manual testing for websites
System integrated testing of the modules
Environment: SQL, UNIX, Manual testing, Image Content Review Tool