Heavily involved in the defined phase where we meet with the clients to gather requirements to understand the “AS-IS” business process and document the “TO-DO” process.Documenting Epics, Components, User stories and Acceptance criteria. Validate the User stories and Acceptance criteria with clients to ensure that we are all in sync.Configured standard and custom objects and fields as needed to support end-to-end implementations.Developed process builder and flows to support more advanced business processes, minimizing the use of code.Developed complex security structure using a combination of sharing rules, created profiles, roles based on Organization role hierarchy and implemented Record-Level and Field-Level security and configured their sharing settings.Managed profiles, roles, and customization of objects, fields, record types, page layouts and data validations.Designed, Implemented, and deployed the Custom Objects, Page Layouts, Custom Tabs and Components to suit the needs of the application.Create users, roles, profiles, groups, accounts, contacts, record types, sharing rules, custom objects, pick lists and page layout customization to meet our client needs.Configured Create case form component in the community and develop case assignment rules, global actions, case queues, case list view, and escalation rules to enable proper routing of cases to the appropriate queue.Extensive use of Data Loader for insert, update, and bulk import or export of data from Salesforce ObjectDevelop and maintain reports, dashboards, and processes to continuously monitor data quality and integrity for our clients.Create permission sets per request and assign the permission sets to users that require additional access to the org and communities.Create custom formula fields, email services, approval processes and field updates according to application and business requirements.Process Automation using flows.

Interact with various business users to gather requirements, document the requirements, and develop design documents to suit the business needs.Maintained and customized Salesforce.com scopes such as users, roles, profiles, groups, accounts, contacts, record types, sharing rules, custom objects, pick lists and page layout customization to support vital business functions.Develop reports, dashboards, and processes to continuously monitor data quality and integrity.Experience with Validation Rules, Workflows, Approval Processes, Process Builders, Field Updates and Email Generation per application requirements.Develop Assignment rules, Escalation rules to enable proper routing of cases to the appropriate team members.Create Custom Fields, Custom Reports, Triggers, Field help, Custom Formulas and Field History Tracking.Use Master-Detail relationship, Lookup relationship, Lookup filters, Roll-Up Summary in master detail relationships.Using Data Loader for insert, update, and bulk import or export of data from Salesforce ObjectImported data from excel sheets into Leads, Accounts, Contacts and Opportunities using Data Loader and Import Wizard.Designed, Implemented, and deployed Custom Objects, Custom tabs, Validation rules, Workflow rules, Auto-Response rules, Page layouts and related lists to suit the needs of the application.Create custom links, Formulas, Page layouts, Record types and perform Record level and Object level security.Experience in managing projects, including identifying requirements, determining priorities, and resolving issues.Implemented new changes and updates like application configuration, new functionality, reports, and dashboards.Developed workflows and approval processes for existing as well as new business rules pertaining to Case Management.Set-up email to case, web to case functionalities that ensured better Case Management.

Assisted in the definition of the database requirements, analyze existing models and reports, and look for opportunities to improve efficiency and troubleshoot various performance issues.Develop highly optimized stored procedures, functions, and database views to implement the business logic and create clustered and non-clustered indexes.Involved in performance monitoring, tuning and capacity planning.Created SSIS packages to load data from flat files, excel files, XML to data warehouse and report-data mart using look-up, derived columns, sort, aggregate. Pivot transformation and slowly changing dimension.Translate business requirements into business intelligence application designs and solutions.Design, deploy and maintain complex canned reports using SQL Server reporting services (SSRS) and Power BI.Assisted in converting business objects from SSRS to Power BI dashboard.Produced attractive dashboards and visuals that help convey the story inside the data.Create parameterized queries, generate Tabular reports, sub-reports, drill down reports using expressions, functions, charts, maps, sets, groupings, sorting the data, defining data sources and subtotals for the reports.Customize reports by adding filters, calculations, summaries, and functions. Created reports to retrieve data using stored procedures that accept parameters.Advised optimization of slow performance queries by looking at execution plan for better tuning of the database. Detailed documentation of all existing and new processes, converting business requirements into technical solutions.Business analysis, understanding requirements, developing user stories and documentation of the acceptance criteria. Use TFS version control to store codes, reports, and documents.