Swetha Mekala

• Optimized day-to-day operations by creating workflow rules, approval processes, and process builders.
• Creating Validation Rules and Formulas based on requirements.
• Create Page layouts, Record types, and Field Sets and assign them to Profiles.
• Test Methods for Deploying Business Logic through Changeset.
• Build Reports and Dashboards as per requirements

• Assisted in Multi-factor Authentication testing using Okta for Salesforce.
• Report and Dashboard maintenance in Salesforce.
• Acted as lead to migrate OBIEE from 11g to 12c, worked on installation, Implemented SSL and Multi-factor Authentication using Okta for OBIEE 12c, migration, preliminary testing, worked with SMEs for advanced testing, Reiterated the process until go-live.
• Create and maintain coding standards and style guides for LookML development.
• Collaborated with business users to create/maintain data dictionary for acronyms/ calculations used in Looker dashboards.
• Consulted with users to assess their data needs to establish SLA to abide by.
• Develop/Maintain/Support BODS jobs to support operational and financial data needs.

• Worked Extensively on Data Modelling Workbench to create/modify customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and multiproviders.
• Enabled out of the box reports using BI Content.
• Scheduled DTP for loading Transactional Data into Info Provider using process chains.
• Developed Bex Reports using Query Designer.
• Extensively used Structures, cell definition, calculated key figures, restricted key figures, new selection, new formula, exceptions and conditions when creating queries in query designer.
• Developed reports for end users using SAP BI 4.0/4.1.
• Monitor and Support BO Dev, QA and Prod environments.
• Partnered with the team to implement upgrades to latest versions of Business Objects
• Helped in data migration/Testing from SAP BO 4.0 to SAP BO 4.1.
• Worked on BI tickets involving enhancement requests to existing/new universes and Reports, tool functionality questions and availability issue.

• Developed Reports and Interactive Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
• Schedule reports bursts as per the requirement in BI Publisher.
• Created Jobs, Work Flows, and Data Flows using various to successfully load data from multiple sources into ODS, Stage and Datamart targets.

· Developed a POC for a team using SAP BO 4.0 which is being used today to demo to highlight what is possible with WEBI

· Monitor and Support BO and OBIEE Dev, QA and Prod environments.

• ·Partnered with the team to implement upgrades to latest versions of Business Objects and OBIEE
• Created a Lead to Cash dashboard in OBIEE 11g which involved setting up the subject area (setting up joins, creating measure and dimensions) to support reporting.
• Researched tools like OBIEE Summary Advisor and Map Viewer.
• Worked on BI tickets involving enhancement requests to existing/new universes and Reports, tool functionality questions and availability issue.
• Analyzed and modeled Business Objects Audit data to move it to our database for better performance and accuracy.
• Designed DataFlows and Workflows to load Audit Data into the warehouse using Informatica Power Center 9.0

As a BI Consultant at Dunn Solutions, worked on a wide spectrum of projects in the world of data warehousing.

• WEBI Instructor - St. Jude's Medical, Marshfield Clinic, Ecolab
• WEBI Developer - TCFEF, DIGI
• BODS Developer - TCFEF
• Informatica Developer - Agenti Media Services
• BI Consultant (System Health Checks/Installs/Configurations) - Aspen Waste, Park Nicollet, Luther Midelfort

• Interacted with business users, business analysts and developers at all levels of the company.
• Project lead, worked to combine HR data and financial data into a database to develop universe/reports for EEO reporting mainly used for media surveys, client surveys.
• Created and determined the effectiveness of existing reports and new reports. Have automated a number of reports using Business Objects thin client/full client.
• For the first time at Faegre, we were able to deliver Audit reports on-time.
• Used Data Integrator to schedule, monitor and troubleshoot Warehouse builds.

• Collaborated with business analysts in gathering business/functional requirements, Documented and developed the Universes/Reports according to the requirements and ensured to get end user approval and signoff .

• Maintained up-to-date documentation of all developed objects, ensuring ease of reference for future enhancements or troubleshooting efforts.
• Communicated and explained business requirements to team members to understand and implement functional demands.
• Developed complex SAP Business Objects universes to support advanced reporting needs.