John Sarantakis Email & Phone Number

Silicon Valley, California, Us

Design and maintain non-bespoke web sites for small business clients and the self-employed.Consult, implement, and manage client advertising and social media strategy based upon best practices for their line of business, demographic, and psychographic profiles.

San Francisco, California, Us

Project Manager for the change request process for updates to the Basel-3 Calculator Application (Oracle Financial Services Analytical Application Infrastructure - OFSAAI).The Basel-3 Calculator Application supports Pillar 3, SEC Disclosures, FFIEC 101 and 102, FRY 14Q, HC-R, and RC-R.Managed quarterly queue of OFSAAI-application change requests opened by lines-of-business for changes to regulatory requirements for Basel 3 reporting.Managed interactions between functional business analysts and technical developers.Managed the migration of changes from the development environment through the production environment.Reported monthly results to senior management.

Oakland, Ca, Us

Managed the transition of the Cognos business intelligence reporting and data warehouse operations (known as the Enterprise Risk Management Information System) from the vendor (IBM) to the University of California’s Information Technology, Risk Services Group.Guided the newly-hired in-house team through the knowledge transfer phase of the transition plan ensuring that the roles of Cognos report developer and lead, Data-stage ETL developer and lead, DB2 DBA, System Administrator, and solutions architect are fully prepared to assume operational responsibility for the entire reporting and warehouse operations.Worked with IBM to complete decommission and clean-up of defunct Datastage jobs, defunct Cognos dashboard reports, and PERL/Shell script files that existed on ERMIS Windows and Linux machines.Managed the transition and implementation of the Jxplorer LDAP configuration tool from the original Tivoli tool.Managed the separation and transition of various Cognos-based reporting applications from the ERMIS platform to other non-risk-services platforms as appropriate.Performed other customary project manager duties such as the composition of project plans, project status reporting for various audiences, issues list management, ensure project scope, and on-time delivery of all scheduled milestones.

Oakland, Ca, Us

Managed the upgrade of the food bank’s MicroSoft Dynamics 2013 ERP.Designed the food bank’s CRM functionality into their upgraded ERP.Configured ERP for warehouse operations processes - receiving through general ledger.Re-Designed customer numbering methodology for the upgraded ERP processes.Provided leadership and structure to the teams through the upgrade process.Managed the cross-functional end-to-end (mock go-live) testing phase.Worked with vendors to ensure ERP integration with internal and external applications.

Oakland, California, Us

Served as the project manager for the defect & enhancement support model for the energy efficiency portion of the Customer Data Warehouse.Served as a business analyst for the customized development of a Salesforce.com CRM application designed to process energy efficiency applications for commercial and residential rebate programs.Composed functional system design documents for interfaces that integrated the customized Salesforce.com rebate-payment processing system with the Customer Data Warehouse.Served as the business analyst for the development of the Work-Paper Database for use by engineers to determine the energy savings applicable to new products offered by PG&E for the benefit of their commercial and residential customers.

San Francisco, Ca, Us

Provided data analyst support for the newly implemented NetSuite Release 2013.1 ERP for the May 2013 launch of their various brands on an international basis.Supported business analysts who required assistance with their data analysis tasks.The NetSuite modules included Accounting, Items and Inventory, Customer Order Management, and Purchase Order Management.Performed reconciliations of commercial invoices against known purchase orders to determine the SKU’s shipped without PO’s.Composed customized NetSuite User’s Guide for the accounting staff to acquaint them with the new NetSuite Accounting module.Composed a customized NetSuite Quick-Start User’s Guide for analysts who required immediate assistance with overall NetSuite functionality.Performed troubleshooting and alteration of legacy Excel VB-macro-based files for use in automating journal entries to accommodate the new organizational structure as the result of the newly opened international stores.

San Francisco, California, Us

Functional Analyst (Second of Two Engagements)Provide functional support to the technical team that provided analytical customer information systems for wholesale relationship managers.Reconcile and clean-up the technical group’s server inventory that resides on various wholesale support applications.Assist in the process of de-commissioning legacy wholesale applications.Business Analyst / Data Analyst / Project Manager (First of Two Engagements)Multiple roles in support the wholesale data-integration effort between Wells Fargo and Wachovia banks.Project manager for the implementation of Cognos BI tools for CustDW data warehouse.Coordinate the activities of cross-functional teams of analysts, developers, and other project managers in support of the CustDW data warehouse and the overall integration project.Compose weekly status reports, dependency graphs, and calendar-tracking for senior management.Contribute to the budgeting process for the CustDW and ADB roles on the integration project.Provide analyses to the technical team for development of the system/process to schedule migration of large wholesale banking customers.Utilize Toad (for Oracle) to determine exclusion criteria to apply to demand deposit & credit accounts for the migration to target systems-of-record.Analyze business requirements to determine appropriate SQL for the query of data feeds from source systems-of-record.Work with business to develop criteria for the segmentation of wholesale banking customers by income, location, size, and relationship for upcoming conversion dates.Compose BPMN process flows for the re-engineering of the inbound data feeds request and approval process.Configure Sharepoint as the application by which the request and approval process for inbound data feeds are entered and managed.Compose report specifications for development of Cognos reports.

San Jose, Ca, Us

Supported users of the beta-version of Cisco's web-based quoting & ordering application intended for distributors and resellers. Composed requirements/defects for the monthly enhancements to the quoting & ordering application.Worked with targeted Cisco distributors in the UK, Canada, and Australia to elicit feedback concerning the quoting & ordering application.Developed PowerPoint presentations to assist the launch of Cisco's small-business products & services line-of-business.

San Francisco, California, Us

Process analysis for claims adjudication project and enrollment project. Requirements elicitation and use-case development for contact center (IVR/CTI/to-system-of-record) project. Conducted and composed fit/gap analyses for contact management application.Diagrammed workflow processes with BPMN 1.1 using the Process Modeler 5 tool. Composed SDLC-compliant business requirements documents from detail elicitations. Composed SDLC-compliant functional specification documents for contact center/workflow/imaging/storage project. Conducted formal walkthroughs of requirements documents. Composed analyses of current processes and to-be processes. Produced context diagrams for various project-related documentation. Trained users to operate the CaliberRM requirements management application. Developed customized CaliberRM project models for Delta Dental’s integration projects, reporting projects, and various other business projects. Wrote use cases for requirements walkthroughs. Served in the role of team lead for the requirements management team. Project was to upgrade the contact management application which included document imaging, storage, and retrieval (known as EXP Macess from Sungard). This project was related to the implementation of a new claims adjudication system (known as Metavance from EDS). Provided guidance to the interface team on operational and data analysis and guidance for/between the EXP Macess and Metavance. Initiated development of Agile-methodology training materials for business analysts and developers.Composed report specifications for BOXI platform-based reports.

San Francisco, Ca, Us

Analyzed and documented legacy (Clarus) GL and AP application set-up. Conducted and composed fit/gap analyses for new Fiserv GL & AP applications. Evaluated legacy AP data model for conversion of AP historical transactions. Set-up new FiServ GL and AP applications in accordance with organizational requirements. Converted seven years of historical Clarus GL/AP data. Composed and maintained project-related documentation. Worked with technical resource to develop and fine tune middleware application. Troubleshoot all set-up issues related to application functionality. Troubleshoot all data conversion issues and provide solutions to load and report data. Assured smooth transition to new applications without business disruption.

Project management duties for policyholder database conversion project (to SQL platform). Manage and/or direct duties of functional and technical resources for project. Compose and maintain the project's plans. Serve as primary driver of the project's objectives and milestones. Assure quality of data and functionality for converted policyholder application. Manage relationships between IT and the business community. Ensure all parties are fully engaged in the project. Define scope and deliverables for IT and the business community. Manage project expectations. Provide overall leadership for technical and functional resources to ensure continuity of efforts. Business analyst duties as IT liaison to the business community-of-users. Quality assurance and testing roles as coordinator of detailed test cases and scenarios for testing of new SQL database platform. Lead the UAT effort by developing documentation in coordination with the business community. Manage the business community's time and labor to ensure quality UAT. Develop UAT plans. General systems operations support and troubleshooting.

Oakland, California, Us

Provide Kaiser's Solutions Design & Consulting (SD&C) group with guidance concerning their PeopleSoft financial applications (GL, AM, PC, EPM/Budgeting). Provide Kaiser's SD&C group with guidance concerning operational reporting (application-level nVision, Query, SQR) versus analytical reporting (warehouse-level Cognos PowerPlay and ReportNet). Elicit business requirements. Used Borland's CaliberRM tool to manage requirements. Organize and conduct requirements review meetings. Draft functional reporting specifications.

Walnut Creek, Ca, Us

This is the second of two engagements.Techno-Functional role for the ongoing operation of PeopleSoft Budgeting 8.3 (Enterprise Performance Management Data Warehouse - EPM/BAM). Techno-Functional project management role developing business requirements, user requirements, use-case requirements, functional attributes, and informational attributes in support of PMI’s effort to select and implement a new budgeting application. Budgeting application support for the current 2005 expense budgeting cycle. Troubleshoot delivered Informatica (ETL) mappings and establish proper procedures for validating and running Informatica maps. Troubleshoot application engine data integration processes and tie-out data in EPM tables. Troubleshoot PeopleSoft Application-Engine SQL+ code and apply fixes and bundles to update the application as necessary. Use SQL+ to retrieve data, move data, update and add data, and for ad hoc reporting.

Berkeley, Ca, Us

On behalf of the United States Department of Energy (DOE), conducted an accounting-based reconciliation of the scientific research contracts awarded to the Lab, and awards subcontracted to other national laboratories across the nation. Primarily focus was to evaluate the AR tables in PeopleSoft 7.5 to determine a methodology for retrieving AR transactional data related to specific DOE research-related contracts. Evaluated functional procedures for input and reporting of contracts billed, collected, and outstanding. Reconciliations involved using the PeopleSoft 7.5 query tool to compare transactional data from award tables versus the award-specific transactions in the general ledger.

Walnut Creek, Ca, Us

This permanent role was the first of two engagements.Responsible for corporate-wide expense budgeting. Techno-Functional Lead for the implementation and ongoing operation of PeopleSoft Budgeting 8.3 (Enterprise Performance Management Data Warehouse - EPM/BAM). Troubleshoot PeopleSoft Application-Engine SQL+ code and apply fixes and bundles to update the application as necessary. Use SQL+ to retrieve data, move data, update and add data, and for simple reporting. PeopleSoft functional experience started in March 1998 on the PS 5.12 and 6.0 platforms. Troubleshoot delivered Informatica (ETL) mappings and establish proper procedures for validating and running Informatica maps. Apply skill-set to troubleshoot and enhance PeopleSoft Financials 8.4 accounting applications such as general ledger, accounts receivable, accounts payable, and delivered reporting functionality. Techno-Functional Lead for the design and implementation of a custom, web-based budget application using Essbase/OLAP technology (prior to conversion to PeopleSoft 8.x platform). Provide guidance to executives, directors, and managers in support of their annual expense and capital budgeting responsibilities. Guidance includes issues such as payroll increases, incentives, head-counts, additions to staff, capital requirements such as computers, telecommunications, and other business-related cash-outlays. As part of these duties, it was my responsibility to train executives, directors, and managers on internal accounting matters concerning their lines of business. Examples of this training include how to interpret monthly expense and variance reports, and how to utilize the budgeting system to input and obtain reports related to their business groups. Senior Financial Analyst /(Senior Risk-Share Analyst), Accounting/Controller's Office Responsible for structured reinsurance transactions (risk-share). Development of analytical reports for contractual terms.