Jyosthna Mandla

• Delivered data-driven solutions to improve decision-making processes.
• Executed SQL queries for data extraction, transformation, and loading into databases.
• Developed and implemented databases and data collection systems to enhance statistical efficiency.
• Utilized advanced analytics tools such as SAS, SPSS, and Excel PowerPivot for data manipulation.
• Conducted workshops and training sessions for non-technical staff on data analytics.
• Collaborated with IT and business process owners to refine system requirements for analytics.
• Provided technical support for reports, dashboards, and analytical tools.
• Maintained comprehensive documentation for all data analysis procedures.

• Developed training materials for effective use of new CRM features.
• Gathered stakeholder requirements and translated them into functional specifications.
• Performed data migration using tools such as Dataloader.io and Zapier.
• Configured custom objects, fields, and page layouts within Salesforce for various business units.
• Assisted users in troubleshooting Salesforce application issues and functionality.
• Created reports and dashboards to analyze customer data trends.
• Implemented workflow rules and email alerts to automate business logic.
• Developed diverse reports, including a summary, a matrix, pie charts, and dashboards tailored for user profiles.
• Utilized SOQL and SOSL for efficient data manipulation within the application.
• Tested thoroughly in a sandbox environment before migrating code to the deployment instance.
• Conducted User Acceptance Testing to ensure that system changes met requirements prior to release.
• Participated in an agile Scrum environment, delivering status updates during daily stand-up calls.

Conducted requirement gathering, analysis, and development for data integration interfaces among various policy and claim administration systems.

Created mappings and workflows in Informatica 9.x to extract data from SAP and load files.

Validated and cleansed data extracted from SAP to ensure accuracy.

Prepared test plans and reports to demonstrate accurate data loading through record counts and validations.

Automated scheduling of Informatica workflows to enhance efficiency.

Documented design approaches using flowcharts and visual aids while capturing test results.

Developed Oracle programs for complex transformations, including packages, procedures, functions, and tables.

Analyzed existing databases to create partitions for efficient data loading into Oracle.