Post Job Free

Resume

Sign in

Project Manager Power Bi

Location:
Houston, TX
Posted:
September 13, 2023

Contact this candidate

Resume:

Mahathi Dodda

346-***-**** adzolo@r.postjobfree.com

Overall, 5+ years of professional experience and 3+ years in salesforce.com CRM platform as an Administrator and Developer crosswise over different enterprises and Strong experience with Salesforce.com CRM full implementation, migration of Sales, Marketing, Service clouds, Health Cloud, Experience Cloud (Communities) and Force.com platform.

PROFESSIONAL SUMMARY

•Certified Salesforce.com Administrator and Developer with good knowledge of Apex programming language.

•Experience in Development, Administration, Configuration, Implementation and Support of Salesforce CRM based on Apex language and leveraging Force.com Platform.

•Proficiency in Data Migration and integration using Data Loader, Import Wizard.

•Expertise in deploying between the Production and Sandboxes by employing the Force.com Migration tools.

•Implemented Salesforce customizations using Apex Classes (Custom/Extension controllers), Triggers, Visualforce pages, created sites using Force.com Sites.

•Strong salesforce administrative skills with creating/customizing Profiles, Roles, Users, Lookup filters, Page Layouts, Search layouts, Validation rules, Email Services, Workflows, Approval process, Assignment, Escalation rules, Reports, Dashboards.

•In-depth experience in building Lightning Flows to create custom pages and applications.

•Experienced in data modeling using Salesforce standard/custom objects using Lookup, Master-detail, and Junction objects relationships.

•Experience in building User friendly Interface using Communities and flows with the help of LWC components and Process Builders.

•Experience working on HTML, CSS, AMP Script to update HTML based emails and landing pages.

•Implemented Web-to-lead, Email-to-case for Lead and Case object.

•Managed data visibility rules by configuring sharing rules at each object level using Criteria-based and Owner-based sharing rules.

•Strong experience in building salesforce standard Reports (summary reports, matric reports, pie charts, dashboards, and graphics), Report Folders & Dashboards against various objects for management visibility; developed custom reports using visualforce pages.

•Experience in working with Salesforce.com Sandbox and Production environments.

•Integrated salesforce and other external applications using Force.com SOAP API and developed salesforce apex SOAP and REST web service classes.

•Working experience with MVC patterns in salesforce, for separating User interface (Visualforce pages), Business logic (Apex controller classes) and Data Model (sObjects).

•Written apex test classes for unit testing and met 75% code coverage required for migration.

•Implemented best practices for Apex triggers, Apex classes to avoid governor limits.

•Well versed in writing SQL, PL/SQL queries with Oracle, MySQL databases.

•Strong analytical, de-bugging skills and documentation skills.

•Worked closely with Business Users to enable business process using SFDC.

•Developed Apex classes and VisualForce Pages using other platform-based technologies like Visual Studio Code, Force.com IDE, and Salesforce Developer Console.

•Experience in Data Migration using Import Wizard, Excel Connector, Workbench and other integration tools like Informatica Cloud, Apex Data Loader.

•Excellent communication and interpersonal skills; accustomed to working in both large and small team environments.

•Experienced in working in Agile Methodology, Scrum Methodology.

SKILLS & CERTIFICATIONS

Programming Languages: C, C++, Apex Code, Java, PL/SQL, SQL, Python

Frameworks and Tools: Power BI, MS Excel, SAS Enterprise Miner, Salesforce, AWS, Microsoft 365, SharePoint, Tableau, MySQL Workbench, Jira

Data Modeling: DAX, Power Query

Databases: Oracle, MySQL, MongoDB, PostgreSQL, Couch DB, Neo4j, SOQL, SOSL, Microsoft SQL Server

Web Technologies: Amazon Web Services, HTML, CSS, JavaScript, Einstein Chatbots, REST API

Certifications: Salesforce Admin 201, Platform Developer 1, Platform Developer 2 certifications in Salesforce CRM

EXPERIENCE

UNIVERSITY OF HOUSTON, C. T. BAUER COLLEGE OF BUSINESS, Houston, TX Aug 2021-Present

Instructional Assistant, Department of Management and Leadership

•Assist professor in managing 250 MIS students for Business Principles class, including Blackboard and Respondus browser support, leading to student satisfaction score 22% higher than previous year.

•Performed statistical analysis on the student data each semester using Salesforce tools.

•Teach business strategies in one-on-one meetings, and mentor student teams in developing case studies.

•Graded and assisted students in various project activities and deliverables as per the course requirement.

•Analyse student data every semester using Power BI reports and Dashboards to evaluate performance and effectiveness of the course.

•Worked with professors, faculty, and administration members to improve outcomes with help of data analysis using visualization tools.

•Utilize data cleansing strategies to guarantee data consistency and correctness in reporting.

•Transformed data to create a structured and unified data for easy analysis which includes learning management systems and student information systems.

•Created a Power BI dashboard to analyse student enrolment trends and identify potential areas for academic program expansion.

•Utilize Salesforce platform to transform and clean data for research and analysis.

•Assisted in data collection and preparation for analysis using SQL and Excel.

•Tutored or mentored students in small groups to prepare for exam and review results.

•Posting assignments and lab materials on Blackboard learning management system, coordinating with the faculty to ensure smooth functioning of the course, and serving as a liaison between faculty.

•Assist in the administration of student testing.

SALESFORCE DEVELOPER

ACCENTURE SOLUTIONS PRIVATE LIMITED, India

Software Engineer: Truist Bank Sept 2020-Sept 2021

Salesforce Lightning Developer

•Built Lightning Scheduler application on Financial Service Cloud to handle all the banking appointments.

•Created Apex triggers and classes, batch classes, schedule classes, and email services. Created lightning components, controllers, helper methods, CSS, and JavaScript. Developed Visualforce pages, components, and controllers for displaying documents in content.

•Maintained users, roles, profiles, sharing rules, Single sign-on (SSO) and public groups as part of managing security on SFDC.

•Implemented web-based case management automation: web-to-case and email-to-case on case object.

•Worked on governor limits while using SOQL, SOSL, and Visualforce pages.

•Built automation functionalities in Salesforce application using Apex Triggers and Apex Classes with more than 90% test coverage.

•Developed efficient Apex test classes enforced with all best practices and performed Code Reviews.

•Increased the customer interaction by 85% on Client's official website by developing and deploying the interactive Einstein Chatbots.

•Worked alongside of architects, scrum master to build the framework as per client requirement.

•Created communities, case creation pages and clone functionality of cases for fields in communities, giving proper access to users. Customized Salesforce.com fields, record types, page layouts and queues. Implemented field level security, sharing rules, OWS, object-level security, and record-level security.

•Created test scenarios on Sandbox to perform unit testing. Migrated code using data import wizard and Excel with VLOOKUP.

•Created a Case Management System using Lightning Components, Controllers, Helper Methods, CSS, and JavaScript.

•Worked with CRM business processes like Campaign Management, Lead Management, Account Management, and Case Management.

•Built Lightning Aura Component to fetch and utilize the data from a 3rd party system.

•Worked with Workbench and SQL queries for retrieving data from Salesforce.

•Worked on Integration of Salesforce application using REST API.

•Involved in end-to-end QA and UAT testing and validation of CPQ including Products, Pricing, Quoting etc.

•Worked with SharePoint along with data loader to migrate records form one sandbox to other.

•Customized the interface of Salesforce Communities using JavaScript, HTML and CSS.

•Involved in Solution Design & Documentation, worked with Application Architect in solution design.

•Written batch apex, schedule apex, Queueable apex to meet the client requirements.

•Worked in Scrum methodology to deliver the application.

Associate Software Engineer: Union Pacific Railroad Jul 2019-Aug 2020

Salesforce Administrator

•Worked with cross-functional teams to build required components and perform unit testing for client.

•Created workflow rules, validation rules, auto-response rules, approval processes, process builders, email alerts and templates, and filed updates, knowledge articles.

•Customized page layouts for cases, leads, opportunities, contacts, and accounts. Customized tabs, custom objects, page layouts and components to suit the needs of application.

•Worked on Email Alerts to send notifications to patients when required.

•Worked on Lightning Process builder flows, Connect API, Chatter, and quick Actions to automate the business processes.

•Worked on Sales Cloud, Service Cloud, Community and Education clouds in salesforce.

•Built various pages in Community Cloud that includes guided screens using Lightning Flow for customers to create requests.

•Deployed components from one org to another using Change Sets.

•Created test scenarios and test cases.

•Worked with testing team in Unit testing and UAT environment.

•Written transcripts for User stories and test cases.

RAPT MARBLE, Houston, TX Apr 2022-Aug 2022

Project Manager/Business Analyst

•Managed recruiting and processing employment for interns. Onboarded 5 new interns in span of 2 months.

•Project Manager for “Mutually Manifested,” a team of 4 that works with charity organizations.

•Provided Human resources services to the company.

•Provided administrative and clerical assistance to a team of 8 members.

•Gather and comprehend business requirements by working with stakeholders, including as management and cross-functional teams.

•Worked to offer data-driven insights for key performance indicators (KPIs) and business metrics, design and construct Power BI reports and dashboards.

•Created data visualizations that shows trends, patterns, and opportunities to help with strategic decision-making.

•Created Tableau dashboards to display customer segmentation and sales performance.

•worked together with the team to enhance report accuracy and data visualization procedures.

ACADEMIC PROJECTS

Create WordPress using AWS Spring 2023

•Create WordPress documents using AWS instances and lightning components. Created static website using AWS S3 bucket.

Crime Data Analysis using Postgres Fall 2022

•Used Neo4j, Power BI and Postgres to analyse U.S. hate crimes. Identified states more prone to hate crimes and reasons.

Data Visualization using Power BI for Fire Department Spring 2022

•Using real time data and Power BI, estimated average time taken to determine whether fire department met its target. Identified zones more prone to fire accidents.

•Built reports and dashboards using real-time data sets. Created measures and columns to create visuals.

Price Prediction using Stat Tools for Real Estate Investor Fall 2022

•Used multiple regression in Stat Tools to predict top prices of houses and find houses to invest in.

Investment Prediction using SAS Enterprise Miner Fall 2021

Utilized SAS to predict top 20 recommended purchases of homes in 100 records.

Applied knowledge of data mining to analyse real-time datasets.

Smart Car using Aurduino and Raspberry Pi Spring 2019

Created prototype model to reduce causes of accidents. Used sensors to alert driver when threats occur.

Used Aurduino and programming with motion sensors, IR sensors, LED diode, and motors to build model.

EDUCATION

UNIVERSITY OF HOUSTON, C. T. Bauer College of Business, Houston, TX May 2023

Master of Science in Management Information Systems, GPA 3.7/4.0

Relevant Courses: Cloud Collaboration (AWS), Cloud Data Visualisation (Power BI), Predictive Analysis (SAS Enterprise Miner)

VASAVI COLLEGE OF ENGINEERING, Hyderabad, India May 2019

Bachelor of Engineering in Electrical and Electronic Engineering



Contact this candidate