We provide IT Staff Augmentation Services!

Salesforce Administrator Resume

PROFESSIONAL SUMMARY:

  • 10 years of total IT experience of administration and maintain of Salesforce and Hyperion products.
  • Created, maintained and customized Salesforce.com scopes such as users, roles, profiles, groups, accounts, contacts, record types, sharing rules, custom objects, pick lists, new custom objects, assigned fields, custom tabs, components, custom reports also created custom reports based on business need and page layout customization to support vital business functions.
  • Imported accounts and contacts data through import wizard, worked on data migration from databases to SFDC using Data Loader and Workbench. Configured and administer of Salesforce.com enterprise editions. Cleansed duplicate data and defined dupe blocking parameters to maintain data integrity.
  • Experience with Sales cloud, Service cloud and Marketing cloud also with 3rd party vender like Eloqua and Introhive team.
  • Configured page layouts, workflows, approval process, document templates, record types, and data fields, implemented and maintained reports and dashboards. Customized company profile, security controls and communication templates of the organization as per the organization requirements. Managed multiple sandbox environments.
  • Superior Knowledge of maintaining the Hyperion Suite planning (capex, workforce, strategic finance), EAS, EIS, Essbase, Essbase Studio, Financial reporting, Interactive reporting, SQR, Dashboard, HFM, FDM, DRM, financial close management, disclosure management, performance score card, smart space of System 11 and System 9 under Windows and Unix environments.
  • Worked with client Installs/Issues with Excel add - in, smart view, FR, IR, workbench (FDM) and ODI. Knowledge of Hyperion System 11 (Oracle EPMA System 11), which is known as Fusion version.
  • Extensive experience on the installation, document installation and configuration of Hyperion products Suite on both Windows and UNIX environments. Also e xtensive knowledge of upgrade between different versions of Hyperion Suite.
  • Extensive knowledge with deployment using Web logic, Tomcat, IIS, Apache web server and Oracle application. Extensive knowledge of LCM (Life Cycle Management).
  • Strong understanding of Software Development Life Cycle (SDLC) in the Hyperion environment. Maintained SLA (Service Level Agreement)
  • Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Outstanding team player with an aptitude to learn.
  • Strong analytical, communication, interpersonal, customer interaction and problem solving skills in technology arena.

TECHNICAL SKILLS:

Salesforce Technology: Workflow and Approvals, Reports and Dashboards, Analytic Snapshots, Import Wizard, Case Management, Automation, Custom Objects, Data loader, Work bench, Managing Support Process, creating managing report type, merging client and lead, both in Classic and Lighting environment.

OLAP Development Tools: Hyperion System 11/9.3 BI+, Hyperion System 11/9.3 Analytic Administration Services, Hyperion Planning 11/9.3, HAL, Essbase 11/9.3, Hyperion Financial management(HFM) 11/9.3, Hyperion Essbase Administration Services console (EAS), EIS 11/9.3., Performance Score Card, Essbase studio, FDM 11/9.3, HFM 11/9.3, DRM 11/9.3, DIM. Dimension Modelling .

Reporting Tools: Hyperion Financial Reporting Studio 11.1/9.3, Web Analysis, Hyperion Reports 7.2/7.0, Hyperion Analyzer 7.2/7.0, Hyperion Essbase Excel Spreadsheet Add-in 9.3.3, Hyperion Smart View 11.1.X/9.3.3X, MS-Excel.

Database: Oralcle 8.2/9.1/10g, DB2 7.1/8.1, MS-SQL Server 7.0, SQL, JDBC.

Software and Internet Technology: J2EE, JAVA 1.6/1.7/1.8, XML, Java Script, HTML, VB Script, WebLogic 11g, Apache/HTTPServer 6.0/7.0.

Tools: DNS, SSH (putty), SSL, Firewall, LDAP, MS-Office, IBM Lotus Notes, IBM Sametime, Microsoft Outlook, Google Suite, Microsoft Lync, Mremote, Winscp, EXAMDIF, Sniping, Citrix, VMware Client.

Operating Systems: UNIX, AIX, Linux, Windows.

PROFESSIONAL EXPERIENCE:

Confidential

Salesforce Administrator

Responsibilities:

  • 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 in multiple sandbox environments.
  • Assist in performing and executing functional testing. Developing use cases, test scripts, and translate these for usage in automated regression testing.
  • Maintain data quality by identifying and deleting or merging duplicate records, cleansing and updating inaccurate data. Manage all ongoing projects related to Service Clou­­d including interfacing with development and/or IT teams.
  • Create profiles and permissions documentation, governance framework, data mapping, and reporting and dashboard building. Help is provide user access to different sandboxes as per requirement.
  • Create defects and work with Dev team as needed. Work on user stories and creating and fixing defects in pforce environment. Work on cases and incidents created by Salesforce and SM9 respectively.
  • Developed, launched and managed in-depth dashboards and reports for all team functions on both management and individual levels. Imported accounts and contacts data through import wizard. Worked on data migration from databases to SFDC using Data Loader.
  • Configuration and administration of Salesforce.com enterprise editions. Cleansed duplicate data and defined dupe blocking parameters to maintain data integrity.
  • Analyzed current processes and made recommendations for automated notifications to Sales Reps when maintenance renewals are due and when outstanding invoices need attention, standardized sales reps reports.
  • Configured page layouts, workflows, approval process, document templates, record types, and data fields. Implemented and maintained reports and dashboards. Created new custom objects, assigned fields, custom tabs, components, custom reports also created custom reports based on business need and associated them to dashboard.
  • Customizing company profile, security controls and communication templates of the organization as per the organization requirements. Develop, document, maintain and enforce data processes and procedures designed to improve and maintain a high level of data quality and integrity.
  • Responsible for Salesforce.com inquiries regarding issue resolution from all parts of the Sales and Product Marketing organization.
  • Keep up-to-date on technology trends, developments and best practices, completed work in timely manner and successfully participated in group projects. Completing task in a timely manner and meet the SAL, also escalate it to correct team as per needed.
  • Documented and conducted multiple training sessions across various team. Created training materials based on business requirements. Provide training for new users and updates for others per new releases/capabilities.

Environment: Workflow and Approvals, Cases, Defects, Reports, Dashboards, Analytic Snapshots, Import Wizard, Case Management Automation, Custom Objects, Data loader, Work bench.

Confidential

Salesforce Administrator

Responsibilities:

  • 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.
  • Provided support to 200 Salesforce users worldwide and acted as the primary point of contact for end-user support.
  • Developed, launched and managed in-depth dashboards and reports for all team functions on both management and individual levels. Imported accounts and contacts data through import wizard. Worked on data migration from databases to SFDC using Data Loader.
  • Configuration and administration of Salesforce.com enterprise editions. Cleansed duplicate data and defined dupe blocking parameters to maintain data integrity.
  • Analyzed current processes and made recommendations for automated notifications to Sales Reps when maintenance renewals are due and outstanding invoices need attention, standardized sales reps reports.
  • Configured page layouts, workflows, approval process, document templates, record types, and data fields. Implemented and maintained reports and dashboards. Created new custom objects, assigned fields, custom tabs, components, custom reports also created custom reports based on business need and associated them to dashboard.
  • Customizing company profile, security controls and communication templates of the organization as per the organization requirements. Managed multiple sandbox environments.
  • Develop, document, maintain and enforce data processes and procedures designed to improve and maintain a high level of data quality and integrity. Responsible for Salesforce.com inquiries regarding issue resolution from all parts of the Sales and Product Marketing organization.
  • Keep up-to-date on technology trends, developments and best practices, completed work in timely manner and successfully participated in group projects.
  • Documented and conducted multiple training sessions across various team. Created training materials based on business requirements and provided training for new users, updates for others per new releases/capabilities.

Environment: Workflow and Approvals, Reports, Dashboards, Analytic Snapshots, Import Wizard, case Management Automation, Custom Objects, Data loader, Work bench.

Confidential

Hyperion System Admin

Responsibilities:

  • Analysed Issues in Hyperion 11.1 and applied needed patch sets. Upgraded Hyperion from 11.1.2 to 11.1.2.3. Installation and configuration of Smart View. Knowledge of Improving Performance Tuning for all the Hyperion products.
  • Working on HFM application copy in same environment and also from one environment to other. Help users loading and posting journals as needed and consolidate and promote entities. Work on different enhancement projects as per business need. Provide the role and security class details to new users also help on assigning security.
  • Scheduled reports using batch scheduler after each HFM load. Supporting end users on client install issues. Tracking the issues with Incident management tickets. Open planning model each month for plan and forecast.
  • Creation and maintain of planning, essbase, HFM and FDM applications, performance tuning and optimization of the applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings.
  • Infrastructure Support - Server Maintenance like File system Space Management, moving backups to staging server, rename logs, exports and OS as well as Hyperion patches.
  • Functioning as a single point of contact for the clients/BPO's on all production related support and maintenance issues. Maintenance of user security and troubleshooting user access issues as they arise, monitoring the current Production environment servers for performance and stability.
  • Maintenance and support for Essbase, HFM and FDM, Planning Applications and Other Hyperion Products. Participated in the application testing, while monitoring the system performance, thereby reporting any anomalies in the application.
  • Defined and documented the steps for enhancement for all applications in the Hyperion Planning, Essbase, HFM and FDM between Prod, Test, and Dev environments.
  • Customized the knowledge modules as per the requirement. Scheduling the different automated jobs using UC4 scheduler. Very good experience with TRAM (Security issues finding). Knowledge of SOX compliance. Helping the users with testing and loading the data using Smart View.
  • Working on monthly maintenance to increase the application performance and release space. Developed Scripts for routine administration tasks like backup, purging app/server logs.
  • Performance tuning and Optimization of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas. Backup and recovery of Hyperion applications.
  • Experience on Disaster recovery and contingency. Experience with Change/Incident/Problem Management. Monitor UC4 Jobs and provided 24*7 On-Call support in troubleshooting and debugging.

Environment : Hyperion Essbase 11.1.2, Planning 11.1.2/11/1/2.303 , Hyperion Reporting & Analysis 11.1.2, Hyperion Shared Services 11.1.2, HFM 11.1.2/11.1.2.303 , FDM 11.1.2, WebLogic 11g, Oracle 9i/10g/11g, Windows 2003/2008 server, EIS 11.1.2, Essbase Studio 11.1, ODI 10.1.3.5/10.1.3.5.6/11 g,Toad 9.0, Putty, Smart view 11.1.2, Excel Add-In 11.1.2, DRM 11.1.2, IIS 6 and IIS 7.

Confidential

Hyperion Application Lead

Responsibilities:

  • Creation and maintain of Planning, Essbase, HFM and FDM applications, performance tuning and Optimization of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings.
  • Infrastructure Support - Server Maintenance like File system Space Management, moving Backups to staging server, Exports and OS as well as Hyperion Patches.
  • Maintenance of user security and troubleshooting user access issues as they arise. Backup and Recovery of Hyperion applications. Scheduling daily backups. Participated in the application testing, while monitoring the system performance, thereby reporting any anomalies in the application.
  • Worked on creating different new planning, Essbase and HFM application. Also migrated HBRs, Calcs, filters, security files from one environment to other.
  • Monitoring the current production environment servers for performance and stability. Maintenance and support for Essbase, Planning, HFM and FDM Applications.
  • Designed and managed applications using Hyperion System 9 BI+. Involved in installation and upgrading the Hyperion Essbase and Hyperion Reports. Worked on planning applications like Revenue, Budget, Consol and Analysis also called Financial Planning and Analytics (FPA).
  • Automated Hyperion Essbase Cubes to minimize manual entry through batch file using ESSCMD/MaxL Scripts. Removed errors occurring during the nightly dimension build and data load processes by referring to log files. Involved in performance tuning to minimize data load time using the Dense/Sparse settings, responsible for performance monitoring, backup and recovery of the cubes and also implemented various troubleshooting procedures to recover databases.
  • Created linked and transparent partitions between source and target cubes. Interacted with the users to gather report requirements and there upon designed reports and also involved in troubleshooting the user issues with the Essbase Excel add-in.

Environment: Hyperion Essbase 9.3/11.1, Planning 9.3/11.1/2, HFM 9.3/11.1, FDM 9.3, WebLogic 9.1/9.2/11g, Oracle 9i/10g/11g, Windows 03/08 server, EIS 9.3/11.1,Essbase Studio 11.2, Performance Score Card, HAL, Putty, Smart view 9.3/11.1, Excel Add-In 11.1, DRM 9.3/11.1, Clarity 6.x, Strategic Finance 9.3/11.1, IIS 6 and IIS 7.

Confidential, Decatur, IL

Hyperion Administrator

Responsibilities:

  • Creation and maintenance of Essbase cubes. Designed and managed applications using Hyperion System 9 BI+. Involved in installation and upgrading the Hyperion Essbase and Hyperion Reports.
  • Worked on Hyperion Application Link (HAL) routines to load data from PeopleSoft to Planning. HAL routines included metadata refresh, translation of metadata.
  • Created Hyperion Business Rules (HBR), Calc Scripts, Report Scripts, Security for HBR’s—Global Security Filters and Web forms. Salary script based on Headcounts, Rundown unit calculation, cost of sales were few of HBR’s.
  • Involved in Performance Tuning to minimize data load time using the Dense/Sparse settings, responsible for performance monitoring, backup and recovery of the cubes and also implemented various troubleshooting procedures to recover databases.
  • Interacted with the users to gather report requirements and there upon designed reports and also involved in troubleshooting the user issues with the Essbase Excel add-in.

Environment : Hyperion Essbase 9.3, Planning 9.3, Hyperion Reporting & Analysis 9.3, Hyperion Shared Services 9.3, HFM, FDM, Web logic 9.1, Oracle 9i/10g, Oracle Application Server 10g, Windows server IIS, EIS 9x/9.3 & HAL, Toad 9.0, Putty, Smart view, Excel Add-In 9.3.

Hire Now