| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateC o r e y O l i v e r H i l l 5680 Briarwood Way, Davie Florida, 33331PHONE NUMBER AVAILABLE EMAIL AVAILABLEBusiness Analyst, Senior Data Architect/Data Analyst and Data Migration LeadProfessional SummaryOver all 15 years of SAP Data Migration experience and have been a DM Lead for several projects for past 10 years.Over Ten years of development experience SAP BODS - Data Service and Informatica Power CenterWorked extensively with Data Extraction, Data Profiling, Data Cleansing, Data Enrichment, LS484MW, BDC, BAPI IDocs.Experienced in different SAP BODS BPDMs, Transforms Functions.Proficient in creating Jobs, Workflows, Dataflows, Query and other Transforms in SAP Data ServicesExcellent in implementing and testing of Stored Procedures, Views, Packages, Database triggers, cursors and functions at database level.Excellent Data Modeling and Data Warehouse DesignWorking on SAP BODS CertificationProfessional ProfileSQUIRE-HILL & ASSOCIATESBusiness Analyst Data Architect, Data Migration Lead in USA/Canada 1990 to PresentMphasis Corporation - Project Manager/BI Report Developer and Excel - Davie, Florida, Jan 2021 to present-Managed client engagement at JPMorganChase including:o Business Objects upgrade fixed price project and 8 consulting firm resourceso Excel and Excel VBA code to support the Asset and Risk Management Group and initiatives at JPMorganChase and used both Power BI and TableauSquire-Hill & Associates for Procom Toronto Canada, April 2020 Nov 2021-Oracle NetSuite Financials implementation, preforming requirements analysis, configuration, and data migration activities from existing systems to be replaced. Developing interfaces from existing customer systems and vendor management systems to NetSuite using Integrater.IO-SAP SuccessFactors implementation, leading data migration activities from existing mainframe systems to SAP. Requirements, functional specification and data migration program development. Using Informatica Power Center and Data QualityNu-Tech/Squire-Hill & Associates Data Migration Manager Toronto Canada/Atlanta Georgia, Feb 2012 to 2020Leading major data migration initiatives, including project planning and methodology implementationManaging all data mapping activities from source systems into various functional modules in SAP, including FICO, Sales and Distribution, SCM, Logistics and Project SystemsReviewed all work and mapping and development in SAP BODS, stored procedures and tiggers for all ETL activitiesLead development of all conversion programs using SAP BODS and LSMWManaged developments teams on site and in Mumbai, India and Singapore, MalaysiaCreated Master Data Management programs for successful integration of all key sap and non sap master data.Newmont Mining Data Migration Functional/Technical Project Lead - SAP FICO/PS Denver, CO Dec 2010 to January 2012Data Migration Lead for SAP FICO Project Systems, Fixed Assets, Customer/Vendor Master, Accounts Payable, General Ledger, Accounts Receivable tasks include:Identification of all legacy sources systems to be migrated to SAP.Source to Target Mapping for all FICO and Project systems areas to SAP.Development of ETL programs using Business Objects Data Services, LSMWs to load legacy data into SAP.Managed Team of 5 people onsite resources, developed project plans including all test cycles and cutover plans.Master Data Management to consolidate, synchronize and distribute master data objects for Finance across Newmont Mining.AC Neilsen Functional/Data Migration Lead - SAP FICO Markham, Ontario Nov 2008 to June 2010Functional Consultant for SAP FICO Project Systems, Accounts Payable, General Ledger, Accounts Receivable, Collections (FSCM), and Treasury/Banking tasks include:Functional User Acceptance Testing and Training for 4 major European Centers London, Frankfurt, Paris and Milan.Deliver of Business Process Training and Education for each country and Shared Services Centers in Budapest and Chennai, India.RECIF functional and technical specification development to support data migration and cutover activitiesManage Team of 30 onshore/10 offshore resources in the development of all data conversion activities that supported all functional configurationIntegration of Master Data finance data across AC Neilson using Master Data Management.Data migration using SAP BODS, LSMW, SQL stored procedures, triggersDHL SAP FICO Functional Lead Fort Lauderdale, Florida April 2008 to Nov 2008Functional Consultant for all SAP FICO Accounts Receivable, Collections (FSCM) and Treasury Tasks include:Configuration of Profit/Cost Center Hierarchies for DHLConfiguration of Customer Master Data for AR/Collection Processes and Travel and Expense Management for Caribbean RegionConfiguration of Bank setup, Electronic Bank Statement Cash Management for AR and Treasury Needs, using BAI2 and MT940 working with Scotiabank for 14 Caribbean Countires. Processing of Inter and Intra day EBS files with value-dating for Cash funding and investment.Development of Order to Cash Processes against Global Template Business Process Definitions for:Manage Collections -Bill RevenueProcess Receipts and apply CashInvoicingDevelopment of all data migration activities including source 2 target mapping, project and cutover plans for 14 Caribbean countriesDevelopment of Training Materials using InfoPack and Test ScriptsTraining and Education Delivery for 14 Caribbean Countries.Bearing Point/Globalpundits, Sales and Business Development SAP HR 4.6/ECC 6.0 Jan08 Mar 08Developed RFP/SOW (Statement of Work) engagement planning, project scoping, costing, project and resource plan for 2 RFP responses for:Associated Press - SAP HR 4.6 to ECC 6.0 Upgrade projectThe State of South Carolina SAP HR ECC 6.0 Project ImplementationMotorola/Symbol technologies, Data Migration Lead SAP HR 4.6/ECC 6.0 Chicago, IL Apr 07 to Jan 08Managed larger merger/acquisition project and integration of organizational structures for Symbol Technologies moving into Motorola, HR Function, duties, roles responsibilities aligned in SAP HR 4.6 and Upgrading to ECC 6.0 that included Major Data Conversion from 4.6 to 6.0.Developed all project plans, scheduling resources, managing deliverables and offshore development.Reviewed all data migration work using SAP BODS, LSMWMaster Data Management - integration, consolidation and distribution of SAP HR Master data across Motorola and Symbol TechnologiesCanada Post/Innovapost, Business Objects/Crystal Reports Development Lead SAP BW Ottawa, Ontario Canada Feb 07 to Apr 07SAP BW reporting architecture plan and delivery for Canada PostDeveloped reports using Business Objects/Crystal Reports for delivery operationsGoodYear Tires, Development Manager Interface/Data Conversion Lead SAP HR Akron, Ohio August 06 to Jan 07Lead Mumbai Development team (30 functional/development resources ) ofcreation of 300 interfaces INBOUND/OUTBOUND of SAP HR and data migration of 65K employees from mainframe to SAP HR:Functional Specification Documents inbound and outbound interfaces for Time/Earnings reporting from all Goodyear Plants including interfaces to FICO from payroll and benefits.Lead development of SAP Custom Program and XI Translation for all inbound to load SAP HR Infotypes and outbound to extract data for other various systems.Co-ordinate unit and integration testing of all 300 interfaces.Managed major Data Conversion efforts from mainframe into SAP HR 4.6C using SAP BODS, LSMW and MasterData Management for SAP HRWarner Bros Studios, Project Manager SAP Finance FICO and Treasury, Burbank, CA January 06 to July 06Lead functional integration of SAP FDinance FICO module, and implemented IMG configuration for SAP Treasury against:Sales and Distribution Order to Cash Process for Warner Home Video Products,Supply Chain MM, PP, Material Master and BOM for build of video productsPre-Production PS, cProjects, xRPM for the development and green-lighting of television and movie releasesFICO/Treasury provide configuration of cash management and bank account to manage order to cash processFICO integrated modules into corporate wide General Ledger and Chart of Accounts to support Warner Home Video business worldwideWeston Bakeries, Project Manager SAP BW, Mississauga, Ontario, Jan 03- Sept 06Developed and Delivered a Project Charter, Statement of Work, Project Plan and Proof of Concept prototype using existing software and hard ware environment for a $4 million dollar data warehouse implementation using SAP BW, Oracle and Informatica to design and document data warehouse information cubes and logical design.American Honda, Data Architect - Metadata Repository Los Angeles, CA, Jan 2002- April 2002Developed a Project Charter, Statement of Work and Project Plan for a $5 Million dollar data architecture implementation crossing all business division of American Honda Motors Corporation.Evaluated tools and techniques to support architecture using Erwin and Platinum Repository for Open Enterprise Edition.JPMorganChase, Data Migration lead, Miami, Fl and New York, NY, 2001Directed Project Planning, Business Analysis and Development activities for merging private banking operations and systems from Chase Manhattan Bank to JPMorgans operations and client servicing applications, including project plans, data migration activities, cutover plans and resourcesMigrated data from Chase Manhattan databases to JPMorgan using OracleCisco Systems, Analyst/Developer, San Jose, CA, 1999-2001Directed multi-functional teams and Instrumental in creating dynamic Web-based applications to support the contract management process for the Legal Services division and integration with other divisional units and outside customers and vendors.Cirrus Logic Corporation, SAP HR Functional Consultant, Fremont, CA, 1998 - 1999Directed functional implementation of SAP HR 4.5 that supported all human resource business processes, including administration, compensation, benefits, appraisal management, recruitment and training. Developed functional specification for interfaces from payroll to FICO and also Web Portal for Employee Self Service.Burger King Corporation Data Architect and Data Modeler Database Designer and Developer, Miami, FL, 1996 - 1998Managed large-scale development efforts for worldwide packaged based and custom systems: Restaurant application systems, information warehouse and e-business solutions. Created business process, data and application architectures and methodologies that enable business goals and objectives for the year 2000 and Y2K compliance.Functional/Technical lead on SAP FICO configuration of Master General Ledger to support BK operations worldwide and HR implementation of all modules including integration of payroll and benefits postings to FICO.Development of Corporate Data Model, Data warehouse design, Source2Target Mapping, data migration schedule, activities, resources and cutover plans.MCI Telecommunication, IT Strategy and Methodology Consultant, Colorado Springs, CO, 1996Spearheaded use of application development methodologies for the Commercial Accounts Receivable Division of MCI.Toronto Stock Exch, / Can. Investment Dealer's Assn / Ontario Securities, Data Migration Lead, 1995 1997Created data migration programs, extraction, transformation rules and load operations using MS Access and SQL ServerNorwest Mortgage Incorporated, Data Architect and Data Modeler, Des Moines, IA / Minneapolis, MN, 1995 1996Defined project, cost and scope using CSC Methodology, delivering a corporate data architecture as the foundation for all future information technology initiatives.IBM Education & Training Services, Programmer/Analyst, Toronto, ON / Atlanta, GA, 1990 1995Directed system implementation for worldwide enrollment, facility planning, instructor assignment and course/class scheduling. Introduced solutions to facilitate e-business between IBM and its customers.Peat Marwick, 1989 1990 Audit Manager, Toronto, ONPlanned, managed and executed audit engagements for customers in the brokerage, banking and insurance industry.Merrill Lynch, 1988 1989 Financial Analyst, Toronto, ON / New York, NYCompleted financial analyst training program and provided traders with research on specific industries.IBM, 1984-1987 Marketing Representative and Systems Engineer, Toronto, ONDeveloped new business through relationship-building in $4 million sales territory. Provided customized hardware/software solutions to enhance IBM's interface with public sector, manufacturing and brokerage industry. Teamed on product development.EducationBASc, Engineering, University of Waterloo, Ontario, CanadaPE, Professional Engineer, Ontario, CanadaCertification by SAP Partner Academy HR, FICO Treasury,IBM Account Marketing School and Project Management TrainingCertified Public Accountant NYTechnical SkillsBusiness Process and Modeling ToolsERWin BPWin Designer 2000 PowerDesigner Bachman/Groundworks ADWBusiness Intelligence and ETL ToolsInformatica Cognos PowerPlay/Reportnet Business ObjectsPackaged ERP and CRM SoftwareSAP FI/CO SAP HR SAP Treasury SAP Logistics SAP BW PeopleSoft HR Oracle Financials ClarifyDatabase SystemsIBM DB2/MVS DB/6000 SQLServer 6.5/7/2000 Sybase 11 Oracle 7/8/9i/10gComputer SystemsIBM MVS/VM Midrange Servers/UNIX Microsoft NT Networks Pier-to-Pier Private Virtual Networks |
