Home

Madhura - Salesforce Admin / Data Analyst

[email protected]

Location: Dallas, Texas, USA

Relocation: NO

Visa: H4-EAD

MADHURA KELKAR Email:- [email protected] Phone:- 717-441-4974 Professional Summary Over 8+ years of experience as Salesforce Developer in Software Development Life Cycle (SDLC) which involves requirement gathering, requirement analysis, design, development, implementation & enhancement of Projects in SalesForce.com Involved in building and developing Reports and Dashboard applying governance rule and drive them to the end process. Performs administrative responsibilities to include custom fields, workflows, validation rules, user management. Developed single lightning page Lightning Web Components using publish-subscribe pattern to communicate between components. Created LWC components of the Case Record Page (Email templates, Case close templates, Compact Views). Worked on Lightning for sales cloud service on Leads, Task, Activities. Strong experience in defining and managing custom Objects, creating page layouts, developing field validations, campaign Management, formulas and workflow rules using Salesforce.com and Eclipse IDE for Salesforce. Experience in Data Integration and Data Migration from legacy systems to Salesforce using Apex Data Loader. Maintained and supported various Functional areas like Opportunities, Forecasting, Accounts, Contacts, Leads, Campaigns, Quotes and Activities. Explicitly worked on custom object, custom field, Picklist, Page layout, Email Services, Approvals, Workflows, Task and Actions. Hands on experience in developing and configuring Reports, Custom Reports, Report folders, report extractions, Dashboards for different user profile bases on requirements. Strong quantitative & data analytical skills and strong interest in data analysis and management reporting. Responsible for generating different management reports using Microsoft excel e.g., hourly report, payment report, exception report etc. Review all payment arrangements and verify the payment arrangement are completed and accurate. EDUCATION Master in Computer Science, SRTMU Nanded University, India 2009 Bachelor in Computer Application, SRTMU Nanded University, India 2007 Certifications Salesforce certified Platform Developer-1 Salesforce certified Administrator Salesforce Certified Platform App Builder PROFESSIONAL EXPERIENCE Salesforce Admin/Data Analyst TrueBlue INC, Dallas, Texas (Nov 2021 - Present) Implemented Picklists, dependent pick lists, lookups, master- detail relationships, Validation and Formula fields to the custom Objects. Performs day to day administrative tasks and addressing production support issues (unlocking / re-setting passwords, modifying data, and creating ad hoc reports) Designed, setup and maintained Salesforce standard objects, custom objects and junction objects, while also structuring user roles, security profiles and workflow rules. Analyze current business processes and champion the Salesforce team's proven ability to provide business process solutions that increase accuracy and efficiency. Collaborate with cross-functional teams to understand business requirements and translate them into data-driven solutions. Used data loader for insert, update and bulk import or export of data from salesforce.com objects. Develops data structures and pipelines to organize, collect, cleanse, and standardize data to generate insights and address reporting needs. Handling Encrypted data by using data loader, check their accuracy and improve data quality. Used Apex Data Loader for insert, update, and bulk import or export of data from salesforce.com objects. Used it to read, extract, and load data from Comma Separated Values (csv) files. Develops data structures and pipelines to organize, collect, cleanse, and standardize data to generate insights and address reporting needs. Adding and deactivating users on salesforce; running the sales report to help forecast understanding data visualization principles. Working Knowledge with Service Now, Five9 and Tableau. Handling the Tableau Dashboard development Process. Salesforce Admin/Data Analyst Thermofisher Scientific, Buffalo, NY (Sep 2019 - Oct 2021) Successfully developed custom product forms to support 10 users. Developed 200 reports and analyzing 70 dashboards with monitoring data quality processes. Worked on various standard Objects like Leads, Accounts, Contact, Opportunities, Products and contracts that helps the company to maintain their information and make sales of the product. Created many of Roles and Profiles for the organization, which helps them in maintaining the Security for different individuals who are working in the organization. Developed Validation Rules for the Custom Objects and Approvals for some fields. Implemented field level Security, Profile, and audit trail setup. Customized several Formula fields, Workflow Rules, Validation Rules, Triggers, Apex classes. Created several Validation Rules, Custom buttons, and links on custom and standard objects. Create many of the custom controllers and custom Buttons which are used in the salesforce Visualforce pages. Developed APEX class, Controller class and APEX Triggers for various functional needs in the application. Created the many of the Reports and Dashboards, which helps the sales team in marketing their product. Created Visual Force pages and Components used repeatedly in Visual Force pages to reduce the case of overabundance whenever needed. QA Analyst Capital Management Service, Buffalo, NY (Apr 2016 - Sep 2019) Conducting hands on functional, and system integration testing; report, track and follow up on issues in a timely manner Working closely with technical and non technical peers and senior management to promote successful delivery of project. Having experience with Citibank, Barclays bank, Bank of America. Handling Payment Process with them. Work as part of a team to perform manual functional, regression and performance testing on all Technology projects Solid understanding of the software development life cycle (SDLC) with a proven ability to deliver quality software to client standards and on schedule Analyzed and Gathered requirements and provided support to the technical team in designing, developing and documenting MS Access databases and related system using VBA and SQL programming as per established standards and procedures. Utilized coding, database, and application development practices and established standards to design and execute appropriate software Designed accurate and detailed technical guides and training manuals for end-users and developers as required. Written and execute manual test cases during System Testing Integration testing and end to end testing. Design and execution of test Scripts for system and functional Project. Verification of various components integration of the application and end-to-end testing execution. Software Engineer/QA Specialist BSS Software Pvt. Ltd. India (Jan 2010 - Jan 2013) Responsible for managing Database related activities. Discuss & understand the requirement with the team. Extract, compile and analyze data to generate required reports. Knowledge of creating tables, writing SQL queries. Responsible for coordinating with Business Analyst, Development Team & Testing team. Performed Data validation and data manipulation required to make sure the data coming from source system is in required format. Performed Data analysis by using pivot table and Formulas to make sure all data inconsistencies/duplication issues are eliminated. Data analysis and shown in tabulated form, graphical format (bar-diagrams, pie-chart, graphs etc.) Developed SQL queries to create project table structure and required data manipulation. Keywords: quality analyst active directory information technology microsoft New York