PROFILE:

• Collaborative, people - oriented business and technology professional with an aptitude for solving complex problems and commitment to professional excellence.
• BS Information Systems, MBA Strategy & Entrepreneurship and 9+ years of experience managing a large and diverse vendor base, negotiate contracts and conduct global strategic sourcing for small, medium and large projects.
• Thrive in matrix environment and in organizations with a strategic, thorough and data driven mindset to decision making and analysis.

TECHNICAL SKILLS:

Microsoft Office: MS Project, Visio, Outlook, Sharepoint, Tableau, Snagit, RUP (UML), Remedy, Vantive

Software Packages: Crystal Reports (Business Objects), Seagate Analysis, ClearCase, ReqPro,Web Component Server, Cognos, PeopleSoft, Check Free ReconPlus, Solver / Storer, Hyperion Essbase, TIDAL Enterprise Scheduler, Cast Iron, Altiris, SAP MM, Salesforce, FileNet

Databases: SQL Server 95/97/2000/2005/2008/2010/2012, Oracle, MS-Access (Macros, VBA), Paradox, ETL, VMWARE, AWS, SQL Server Agent, SSIS, SSAS, SSRS, SOQL, DataLoaderLanguages: SQL, T-SQL, PL / SQL, Visual Basic 5.0/6.0/.NET, Visual Studio, SourceSafe, DTS, COM / DCOM, .NET, Java, JavaScript, VBScript, XML, HTML, ASP, UML, Perl, Python

EXPERIENCE:

Confidential

Business Analyst / Project Manager

Responsibilities:

• Expertise in BI/ Analytics/ reporting, sourcing, requirements definition and data model traceability.
• Provided business representation, contract negotiation, vendor liaison and strategic IT sourcing services in Asia (China and Singapore) and Europe (France, Belgium, UK).
• Advised and represented clients on practical business issues relating to technology; These often include software patents, copyrights, strategy for trade secret protection, ERP implementation projects, internet security, website business and innovation management, outsourcing and ecommerce.
• Created and analyzed LEAN business models and processes to assist antique dealers with listing their inventory on a web portal including advisement of ecommerce owners on payment, delivery and customer service issues on Amazon, Ebay, Etsy, Rubylane, Paypal, Square, GooglePay, USPS, UPS and Fedex.
• Strategic utilization of people, process and technology experience in payment processing and customer service for banking and securities matrix environment to advise business owners on selecting and liaising effectively with payment vendors. Examples include Visa, Mastercard and other third party vendors on Interchange and Swift transmission fee optimization, vendor and contract management and optimization.
• Collaborated with subject matter experts, developers and business partners to establish the technical vision and analyze tradeoffs between usability and performance needs.
• Align strategy to performance by developing KPIs through Balance Scorecard systems and performance management.
• Successfully created and managed content and marketing of websites, blogs and social media for online retail of antiques.

Confidential

Business Analyst

Responsibilities:

• Complex contract negotiation, vendor management and legal liaison; Assigned as central vendor liaison for Upstream and Downstream Procurement, Legal, Operations, Payables, Compliance, Scientific and Engineering communities.
• Handpicked by senior management for promotion to Senior Business/ Contract Analyst assigned to ExxonMobil Upstream Research Company (URC) within one year of successful performance of the role as follows:
• Consulted and advised junior employees on software license acquisition, distribution, modification or termination procedures. License reconciliation and license requirements in accordance with agreement terms that impact client Right to Use (RTU).
• Acted as the focal point to address contract and compliance issues and the import and export of software.
• Liaised with internal business representatives to develop requisitions for new software license agreements or amendments to existing agreements.
• Reviewed and summarized end user license agreements (EULAs) and open-source agreements in accordance with guidelines and communicated measures to ensure compliance. Interfaced with vendors as appropriate regarding: quotes, purchases, maintenance, delivery, license quality, counts, rates and questions.
• Analyzed purchase orders, RFPs, RFIs, entitlement documentation and discovery information in the SAM system and provided status reports to management and stakeholders.
• Identified contract optimization opportunities that reduced administrative efforts.

Confidential

SAP Business / Data Analyst (contract)

Responsibilities:

• Worked effectively with Operations, Database Administration(DBA), Subject Matter Experts (SME) and SAP implementation team to review, analyze and document data migration, conversion and ERP software requirement(s) using LSMW data loading method.
• Document approved data standards, structures and decision tree for material types to ensure compliance with current purchasing, manufacturing and supplier standards, rules, contents, formats and procedures required for the creation of master data in SAP.
• Ensure legal data standards for all internal and external names and trademarks are specified as naming criteria; Verify compliance with case law, regulations and enforcement agencies.
• Determine and document business owner’s data to ensure data security and accountability and management of data quality.
• Review database structure integrity for mapping to views, tables and fields.
• Successfully liaised with business expert(s) to document current business processes for Purchasing, Inventory Management, Branch Operations, Showsite Operations, Cross-Dock Operations, Corporate Distribution Center, Graphics and Fabrication as well as Audio-Visual Solutions processes, contracts and systems.
• Analyzed Material Master(MM), Bill of Materials(BOM) master and Show Master(SM) system data, contracts and database schema, in addition to Total Show System(TSS) - Parts Master legacy system, running on AS/400, Oracle and Lawson;
• Utilize mapping spreadsheets and LSMW to collate and load SAP data for scrubbing and cleansing to meet data quality metrics.

Confidential

Technical Business Analyst (Data Scientist) (contract)

Responsibilities:

• Successfully managed software implementation project(s) utilizing Agile Project Management Methodology and SDLC. Created and managed release plans, RACI and decision matrix, change control, in addition to scope, risk, communications, security, training, capacity and project planning, thereby reducing defect rate by more than 70%.
• Effectively interacted and liaised with software vendors, senior management, development managers, computer operations, quality assurance, configuration managers, software architects, data scientists, database and networking teams to successfully push iterations and releases through application and system lifecycle.
• Successfully gathered, translated and documented requirements between business and IS, proposed process improvements, in addition to documenting, automating and streamlining batch operations manual and complex processes by liaising with Computer Operations Group, thereby reducing security risk and improving SOX compliance by more than 80% (COSO and COBIT); reducing manual errors by 100%, batch operator processing hours by 40%. Additionally, improved customer service, SOX compliance, security, performance management and future reductions in planned operating costs by more than 40%.
• Successfully proposed, designed and engineered business processes necessary for moving the company towards being a requirement(s) driven organization.
• Effectively organized Requirement Gathering Sessions(RGS), JAD to gather, translate and document technical requirements for Windows, FTP and SQL 2000 database job and file dependencies across US utilizing Visio, T-SQL, Python, Perl and TIDAL Enterprise Scheduling System and Tidal Transporter.
• Created and implemented companywide job specification templates, workflow and request submission process for software packages.
• Created process flows, job requirement templates, request submission workflow and architecture diagrams using Visio, SharePoint and K2.
• Successfully created marketing plan and presentation to senior management, on behalf of Executive Sponsor (VP of Computer Operations), to help software package gain influence/buy-in in moving towards an enterprise level solution.
• Effectively performed software licensing contract analysis on current software license master level agreements and license schedule(s) to ensure proper asset management and utilization. Proposed the use of Altiris for contract asset management. Liaise with vendor(s) and team to ensure proper chain of communication for SOW agreements, payment and licensing terms, in addition to designing an effective licensing strategy for software project implementation; Part of team involved in negotiating the purchase of additional SQL and email adapters for use with Tidal, a third party job scheduling software.

Confidential

Business Analyst / International Consultant (contract)

Responsibilities:

• Successfully reduced manufacturing losses by more than 80% through effective outsourcing strategies, detailed reporting and cost analysis, purchasing/merchandising/inventory processes, requirement gathering and sessions (RGS), project management as well as implementing new processes and systems for intellectual property(IP) strategy and business model, to ensure an optimum balance between IP risk, choice of suppliers as well as price leverage.
• Represented client as a Purchasing Director to source distribution channels in China.
• Effectively analyzed and managed entire product lifecycle and gathered requirements for the manufacturing processes; Managed and worked closely with product designers, business client and suppliers to ensure that the product requirements are understood and implemented correctly.

Confidential

Business Analyst / International Consultant

Responsibilities:

• Successfully researched, translated and gathered business and product requirements for food packaging products for sale in the United States.
• Represented client as a manufacturer’s representative and helped company establish initial connection with big distribution companies in Texas.
• Involved with Requirements Gathering Sessions (RGS), writing use cases, training manuals during the development and deployment of a web-based application to handle the project design, vendor quotes and invoicing.

Confidential

Programmer/ Analyst

Responsibilities:

• Analytical Reporting, Data Warehousing, Automated Solutions, Relational Databases; Experience with Confidential is in the area of business intelligence analysis, project management, business process automation, accounting and financial reporting, IT Auditing as well as software programming (VB and .NET, SQL Server, Access, Financial and Accounting software and databases).
• Subject Matter Expert (SME) for Business Intelligence, Crystal Reporting, OO projects.
• Led support and creation role for all Crystal Reporting/Business Intelligence solutions; Well-versed in data manipulation and data analysis; Understand account reconciliation data structures, procedures and processes.
• Lead for Requirements Gathering Sessions (RGS), including JAD sessions.
• Conducted performance tuning of SQL stored procedures and structural changes due to SQL server upgrades.
• Enabled management to clear aging items, manage resource-leveling and other management concerns in 80% less time and cost savings in excess of 8 employees’ compensation via timely, accurate and highly reliable analytical reporting.
• Successfully upgraded and debugged run-time errors for BAI Check, used by system administrators in pulling out export and exception items from VB 5.0 to VB 6.0, thereby reducing total time to clear exceptions by 50%; Used Visual SourceSafe 6.0 for maintaining version control and used ADO for data accessing; Developed and tested COM components using VB 6.0.
• Designed and automated Tax/IRA Filing Application using Visual Basic and SQL Server 7.0; Conducted requirements gathering, analysis, screen prototyping, design, construction and testing for project; Completed ahead of schedule, which enabled mission-critical on-time tax filing.
• Designed and implemented cost and time effective automated solutions/applications for disbursement cleanup, Paradox conversions using Access VBA and Macros.
• Upgraded to SQL Server 7.0 for PeopleSoft, account reconciliation software (ReconPlus); Led and resolved all technical issues related to upgrade; Involved in Backup/Restore and User Management process using SQL Server 7.0 database.
• Performed system administration functions for ReconPlus; Provided prompt and quick resolution of mission-critical day-to-day reporting, training room set-up, connection, and database connectivity issues.
• Led efforts to resolve PeopleSoft printing issues; Created and deployed DOS batch executable to 100 workstations, achieving goal of printing journals on a timely basis.
• Successfully deployed online exception reporting system for SpeedPay, a credit payment processing system, on a platform of IIS 4.0, Crystal Reports Viewer, Crystal Reports 8.5 and SQL 2000, enabling customers to resolve conflicting site entries, thereby increasing audit accuracy by 80%; Successfully performed and coordinated technical writing, prototyping (screen and functions) and testing for developing of website content and interface.
• Successfully managed project, thus reducing retail payment rejects by 80% through reject analysis, IDS logic changes and implementing tolerance levels; Project Lead for Reject Analysis of all 10 lockbox processes across the country, with key role in recommending and proposing solutions; Created process, data flows and reports (data manipulation and analysis) using Excel, Crystal Reports, Access, Visio and Word.
• Efficiently created AIMS Payment History Reporting System for Transportation and Canada, resulting in cost savings in excess of $200,000 derived from customer service efficiencies and a reduction of labor; This project involved migration of data from legacy systems, pattern recognition, data manipulation and analysis using SQL Server, Access VBA and Macros, Excel and Crystal Reports.
• Reduced processing time from 60 days to 10 days for full life-cycle implementation of Solver / Storer, an escalation and records management system.
• Successfully analyzed and performed assessment of identified cash and non-cash systems that would require manual / systemic process changes the monthly processes / feeds to produce a Daily GL feed into the Peoplesoft or other future accounting system.
• Gathered and documented requirements from Operations and IT to identify systems that currently feed Peoplesoft; Worked with Operations and IT to review high-level requirements and provide response based on existing Project Management Methodology; Designed the current GL Data Flow Diagram in Visio and Word.
• Resolved and exceeded auditory requirements for Payment Processing Initiatives and Control Improvement Projects as well as devising and managing solutions to automate payment processes, streamlining functions and by reducing number of employees, resulting in a satisfactory audit rating.
• Led migrations of lockboxes from Confidential and Confidential and created customer notification processes, seamlessly resulting in 100% data transmission accuracy, 0% downtime and improved customer service efficiency.
• Engagement Manager for Overall Development Support of Payment Processing, Customer Service and Reconciliations.
• Updated, audited and ensured compliance of software licenses currently in use and work with legal department, business and technical team to resolve compliance and expiration issues.
• Effectively ran conversion project and real-time daily feed automation for Entitlement Enhancement Reporting System (EERS), a visible and high priority global information security system that tracks user entitlements across systems; Commended for quality feeds, dedicated project management, on-time delivery as well as meeting all budget constraints within a 5% deviation range.