We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

4.00/5 (Submit Your Rating)

Mountain View, CA

SUMMARY:

  • Sr. Business Systems Analyst with innovative expertise in Implementations, Design and Architecture, Development, Administration and Support of ERP / CRM systems, Cloud/Client - Server applications, Audit and SOX compliance, Data Warehouses and Interfaces between systems.
  • Sophisticated understanding of business and technology, recognized for problem solving, creative thinking and interpersonal skills.EDUCATION/STATUS Polytechnic University of Bucharest-Romania, Computer Science and Control Engineering, MS, BS in Computer Science

TECHNICAL SKILLS:

Operating Systems: Windows 7/8/10/XP/2000/NT, Unix, Ms-Dos

Programming Languages: JavaScript(NetSuite), SQL, PL/SQL, PHP, XML, Unix Shell Script, XSLT, BPEL, C, Java

Development Tools: NetSuite (ERP and CRM), Dell Boomi, Salesforce, FastPath (Audit tool) Oracle e-Business Suite (R12, 11.5.10), Oracle Server(11g), MySql, JDeveloper, Oracle SOA Suite and ESB, Oracle 10g Forms, Reports, Discoverer, OA Framework, SugarCRM, GTS Unison ERP, SilverPop, Cast Iron, Toad, RapidSql, Cygwin, Putty, Telnet-Ftp, MS Office, Office 365, Visio, Pardot, Pivotal Tracker

PROFESSIONAL EXPERIENCE:

Sr. Business Analyst

Confidential, Mountain View, CA

Responsibilities:
  • Designed and developed a Dell Boomi interface for Gigya client; performed the O2C integration (Sales Order and Customer) between SalesForce and NetSuite; performed the data load from Legacy on Cut-Over day (CSV Import), and scheduled the interface to reflect in NetSuite any new Sales Order / Customer created in Salesforce. Learned Dell Boomi software in a very short time-frame.
  • Worked on the full implementation of the Advanced Financial module in NetSuite for Google (Apigee subsidiary) client; gathered business requirements, created several Transaction Body/Colum fields in the Revenue Commitment form and populated them using SuiteScript to reflect the Legacy data gathered from user champions; developed test cases and performed UAT with user champions prior to deployment; assisted the acquisition by reflecting the new address in the PDF Advanced Transaction templates using HTML.
  • Helped PDF Solutions client in their IT Audit / SOX compliance process; created and analyzed all the NetSuite data extracts required by auditors and provided the SOD (Segregation of Duties) info by integration the FastPath tool in NetSuite.
  • Provided Post Go-Live support for Mulesoft, Velodyne Lidar, One Legal, SOA Projects clients through additional NetSuite configuration/customizations; management of NetSuite users, roles and permissions, workflows; used Suite Bundler to deploy solutions from SandBox into Production environment upon successful UAT; consolidated NetSuite reporting tool by creating/customizing NetSuite Saved Searches, key Reports (GL, Income Statement, Balance Sheet)and DashBoards following the requirements gathered from Finance team; trained different NetSuite teams and clearly exposed NetSuite efficiency and advantages as ERP system.
  • Assisted the P2P process (Purchasing module implementation) by creating Advanced PO PDF Templates (that include Watermarks, PO Terms and Conditions on multiple pages) using HTML for Iovance Biotherapeutics (ex Lion Bio), HDMI and Audentes Therapeutics clients.

Implementation Lead / Sr. NetSuite and SalesForce Admin

Confidential, San Francisco, CA

Responsibilities:
  • Deeply involved in NetSuite One World successful implementation across the company in a short timeframe.
  • Main NetSuite resource/contact person for company departments: primarily Finance, Operations, Sales and Customer Support.
  • Translated and redefined the company Order to Cash O2C process flow in NetSuite.
  • Integrations of DocuSign, Avalara, Celigo (Gmail, Amazon, eBay), Bill.com, ShoreTel, SPS eCommerce as bundles into NetSuite; Identified /fixed bug in DocuSign bundle.
  • Created, tested, scheduled the P2P main workflow (PO Approval process in TRX); created custom NetSuite forms, roles, transaction PDF templates, provided support and monitoring of existent scripts to successfully reflect company's channels structure/business rules.
  • Historical data migration from Salesforce / Great Plains into NetSuite (Customers, Transactions, Customer Support Cases).
  • Developed a strong relationship with NetSuite account managers / PS, NetSuite Support & partners (Bill.com, Avalara, Celigo).
  • Published DashBoards for Customer Support and Sales deps and created various reports for company's execs and upper management
  • Developed a rich area of expertise in supporting various NetSuite users; performed SalesForce system administrator role.
  • Strongly involved in system performance and tuning; reported bugs to NetSuite after each bi-annual NS upgrade, mass updates, leads managements and uploads received from Marketing; Merged accounts, cleaned duplicates; involved in all NS platform life after go-live.

Business Analyst / NetSuite Admin

Confidential, San Jose, CA

Responsibilities:
  • Weekly meetings with Confidential CEO, discussed and implemented new BRDs for the company, especially for Sales department (for ex. how to configure efficiently use Opportunities in NetSuite); created ~ 50 new reports for the CEO and configured his DashBoard.
  • Configured and administered NetSuite company-wide; created and maintained users, roles, permissions, performed mass updates and data loads (CSV Imports), NetSuite forms configuration, Customer / Contacts configuration and maintenance.
  • Hosted regular meetings with Sales, Finance, Marketing and Customer Support depts, redefined their process flow and identified needs.
  • Heavily involved in Training the above departments on NetSuite; started with customizing NetSuite’s standard reports and building a Saved Search to obtain complex Reports or Saved Searches, and showed the best ways to use them on users DashBoard (List mode / Graph - Reports, Snapshots or KPIs).
  • Created and maintained many NetSuite Workflows, such the new AP Workflow in the company that goes from accountant to CEO.
  • Created scripts using SuiteScript to support Technical Support department requirements.
  • Worked with NetSuite Support on various issues in the system and became very familiar with their process; active member in the NetSuite forums SuiteTalk; Admin of Pardot and Velaro (B2B Automation Marketing and Customer Chat tools).

ERP Consultant

Confidential, Alameda, CA

Responsibilities:
  • Designed, developed, UAT testing and implementation of Inventory Item Category update process using Oracle Open interface.
  • Migration of Oracle iExpenses to R12, customizations affected by Oracle patch OIE.K.
  • AR Invoice and OM Shipping reports from current format to BI XML Publisher, customized templates for each operating unit.
  • Enhancements, support, docs of Order to Cash flow from Siebel CRM to Order Mgmt and Service Contracts modules using SOA (BPEL).
  • Support, analysis and enhancements of Oracle Financials, MFG, HR, iExpenses, Projects modules and marketing applications.

Business Systems Analyst

Confidential, Brisbane, CA

Responsibilities:
  • Managed SugarCRM system upgrade project, from version 5.1 to 6.2.3. Performed the technical upgrade and coordinating with users, system and database administration go-live, tasks to be performed by each party, rollback plan (Php).
  • Designed and developed GTS AR/OM customers and sales orders automated load process for company’s partner the APIs are invoked through Web Services by passing XML strings (Php, SQL Loader, PLSQL, Reports); Item Schedule Generator process design in Forms6.0
  • Designed interface between the ERP and SugarCRM that creates opportunities in SugarCRM (based on the item subscription renewals weekly generated), attaches PDF reports to each opportunity and invoice in Sugar (Php, Plsql, Unix shell scripts)
  • ERP System administration, improving ATP’s End of Day and End of Month processes; Oracle DBA primary backup of Central DB apps.

Database Consultant

Confidential, Long Island, NY

Responsibilities:
  • Oracle MFG / Financials setups: new check numbers for Taiwan division, territory flexfield and item setups for Japan plant; Oracle INV, BOM loads; created Discoverer reports and provided Oracle Apps user support.
  • Cast Iron integrations, developed orchestrations between Oracle / MySql databases, Google Analytics and PivotLink, the company’s BI reporting tool. Created PLSQL package to accommodate the AR Revenue by day functionality in Oracle 11.5.10.2.
  • Database migration from MS Access to MySql; DB redesign and normalization; Customized the ‘search’ utilities of the website (PHP)

Business Systems Analyst

Confidential, San Jose, CA

Responsibilities:

  • Implemented a SOX 404 compliant version of the interfaces between Oracle (OM, WIP, INV, BOM) and COPS, ICON systems; New Web Services / ESB (SOA Suite) transportation method that uses queues, queue tables and XML payload format.
  • Saved $20 million of corporate tax during 7 fiscal years. Worked with KPMG, PWC and local Tax manager. Financials data extracts (AP, AR, GL) for all US plants, performed revenue/sales comparisons and full reconciliation with the GL reports; custom forms and reports.
  • Oracle Apps SysAdmin: Production support and performance; Month-End process; several Oracle ERP 10 and 11 migrations.
  • Designed and developed the Sales Order Outbound interface between Oracle and COPS/ICON systems (OM, Shipping). The system is implemented using Agile Data/Modeling methods and Test Driven Development practices in several plants working with HP, Sun, Nokia, IBM and EchoStar. Sales orders are sent via Ftp to COPS system where they are shipped, then returned to Oracle and validations.

We'd love your feedback!