Data Migration Technical Lead Resume
Houston, TX
SUMMARY:
- An aggressive, results oriented, data driven executive with a strong sense of urgency and “hands - on” approach who thrives in a high paced environment seeks a position where strong situational leadership, facilitation, and motivation skills coupled with a collaborative negotiating style and technical expertise can be leveraged to challenge the “status quo”, reengineer processes and improve the bottom line.
TECHNICAL SKILLS:
Project Management: (10+ years), Data Migration, ERP, CRM, Trade Promotion Management (TPM), Web Development, Business Intelligence, Sales Force Automation (SFA); Data Migration; Master Data Governance, PeopleSoft, Gelco
ETL / Data Conversion / Data Migration / Data Integration: SAP Business Objects / Data Services 3.2, SAP Data Services 4.0, SAP Data Services 4.1 SAP Data Services 4.2 Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server 2008, Microsoft SQL Server 2012
SAP Certified Application Associate: Data Integration with SAP Data Services 4.x SAP LSMW, SAP IDOC, SAP BDC, SAP BAPI (8 years)
BackOffice / Cransoft Data Migration SAP Modules: (10+ years) Master Data, SD, MM, FICO GTS, CRM, BW, HCM, Vendavo, G/L, A/P, A/R, PS, P2P, PTP, FSCM
BI tools: (10+ years) SAP Business Warehouse, COGNOS, Micro-strategy, Brio, Crystal Reports, SQL Server
Personnel Management: (10+ years) Performance Plans, Incentive Plans, Salary Recommendations, Performance Reviews
Budget Management: (10+ years) Sales Force Automation, Sales Compensation and Trade Promotion Management
Presales Support: (3 years) Selling new Data Governance, ETL and Master Data Solutions
Industries: (10+ years) Consulting, Pharmaceuticals, Chemicals, Oil and Gas, Consumer Products (CPD), Publishing, Entertainment
Miscellaneous: Microsoft Office 1994-2014, Microsoft SharePoint, Microsoft Visio, Excel Macros, VBA, Microsoft Project '97-'10, SPSS, Minitab, AS400, UNIX, Linux, HP Quality, Solution Manager, Python, XML, JSON, HTML/CSS, PHP, JavaScript, jQuery, JD Edwards, Siebel, GitHub, Oracle8, Oracle 10g, Oracle 11g, Sybase, Microsoft Access, DQ, DQM, BODS, BOBJ, BODI, BO/DI, DI, DQ, Data Integrator, SAP HANA, SAP S4/HANA Activate Methodology, SAP Learning Hub / SuccessFactors, SAP S4/HANA 1511, R, RStudio, MapReduce, MapR, HBase, Spark, Pig, Hive, Hadoop, Yarn, Drill, NoSql, Couchbase, N1QL, Cassandra, CQL, MongoDB, IBM BigInsights, Ambari, Sqoop, Oozie, IBM Cloudant, IBM InfoSphere BigSheets, Scala, Solr, JAQL, AQL, Zookeeper, Data Scientist Workbench, Flume
PROFESSIONAL EXPERIENCE:
Confidential, Houston, TX
Data Migration Technical Lead
Responsibilities:
- Drove and implemented a Data Migration Methodology for the OTC Master data team and other teams on the Integration Project.
- Influenced stakeholders on best practices in Data Migration including the instantiated Data Migration Methodology and their role within its framework.
- Leveraged SAP Data Services SAP S4/HANA Best Practice Templates (BPDM) / Rapid Deployment Solutions (RDS).
- Augmented the SAP BPDM / RDS framework to align with the Data Migration Methodology and Client specific architecture for Materials, Customers and Vendors.
- Enhanced the SAP S4/HANA Best Practice Templates to mitigate the gaps around relevancy rules and harmonized data. This included incorporating feedback on data quality issues and mechanisms to improve performance.
- Developed the ETL architecture hardware recommendations, sizing requirements to upgrade the existing Data Services 4.2 environment to accommodate the data volumes and strategy on the Integration Project, a recommendation that SAP later affirmed.
- Evaluated ETL add-on software tools for Data Migration and Data Governance to determine their merit and use on the Integration Project.
- Established the multi-year OTC Master Data Integration and Governance Project Plan inception through each o roll-out phase.
- Identified risks, issues, dependencies and metrics against them.
- Provided weekly status reports on progress towards milestones on the Integration Plan.
- Produced resourcing plans throughout the project life cycle accounting for peaks and valleys.
- Created and delivered presentations on key steps in the Data Migration and Governance process such as Cleansing, Transformation and Validations to end users.
- Provided guidance and analyses to other teams such as the Customer Financial Services team on extraction, transformation, cleansing and reporting.
- Facilitated data requirements gathering sessions with both functional and technical teams during discovery.
- Formed comprehensive Functional and Technical Requirement documentation for business rules, mapping specifications, gaps and resolution proposals.
- Provided data mappings and analyses leveraging SAP Data Services 4.2.
- Mentored team members in design and development of complex data migration processes.
Confidential, Houston, TX
ETL / Data Architect
Responsibilities:
- Acted as a subject matter expert on SAP BODS capabilities for data delivery on the project including Hive integration.
- Facilitated architecture design planning sessions for the end to end solution.
- Helped define the technical vision and strategy for data ingestion into the Hadoop environment.
- Spearheaded an ETL tool assessment, validation and alignment to data delivery requirements.
- Worked with stakeholders translating business requirements, high level design and data requirements into requirement specs.
- Analyzed data-related system integration challenges and proposed appropriate solutions.
- Gathered data model requirements then collaborated with different teams to develop solutions.
- Facilitated brainstorming workshops and delivered a few presentations on Data Delivery.
- Performed Source System Data Analyses and assessments.
- Developed the ETL architecture hardware recommendations, sizing requirements for DS 4.2 to accommodate the Hadoop project.
Confidential, Houston, TX
SAP Data Services Lead
Responsibilities:
- Worked with Data Stewards on changes and enhancements to the SAP Well Master Data Governance business rules.
- Developed solutions using SAP Business Objects Data Services with an emphasis on data modeling in DS, ODS and SAP for Customer data, Third Party data, Well Master data, attributes and reporting.
- Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
- Performed reverse engineering of physical data models from databases and SQL scripts.
- Recommended changes to existing Dev/QA/Prod infrastructure to load balance some key ETL activities with Data Services.
- Redesigned architecture for the SAP Well Master Data Governance Solution for North America optimizing jobs and workflows in addition to integrating third party providers, state and federal Well Permit websites, and the SAP ERP system to enrich and standardize data.
- Performed heavy Data Profiling / Business Data Analyses on Master data and third party data leveraging Data Profiling, Data Quality, Data Migration, and Data Integration tools in SAP Data Services.
- Worked with large data sets in Data Services to identify, standardize, de-duplicate and cleanse dirty data using built in transforms as well as implemented user defined and text transforms to tackle more sophisticated match record challenges.
- Analyzed data using various features and functions of Microsoft EXCEL creating macros or VBA as necessary.
- Wrote custom user defined functions in Python in SAP Data Services for enhanced standardization and cleansing algorithms.
- Implemented base quality metrics to quantify and monitor overall master data governance process integrity.
- Provided a new roadmap and sizing requirements for their EIM Architecture (Hardware & Software) combining multiple versions and instances of Data Services to Data Services 4.2 to include SAP Information Steward and SAP Well Master Data Governance.
- Responsible for code review, recommendations, development and migration through the SAP landscape.
- Created a variety of requirements analyses and reports for Data Quality, Data Governance, and Business Intelligence.
- Possessed deep knowledge of relevant SAP tables, structures and inter-relations in key SAP modules.
- Used BODS to query source systems, map and validate data utilizing a strong, fundamental understanding of Database Concepts including: Queries, Nested Queries, Views, Joins, Reverse Pivot, validation transforms, etc.
- Implemented and enhanced BODS Best Practices for Data Migration (BPDM) / AIO templates for daily production loads into SAP.
- Tuned Data Services jobs, dataflows, and associated transforms along with troubleshooting DS components.
- Worked with Basis teams to modify existing extract programs to improve performance and memory outages.
- Worked with off-shore teams to balance workload and improve response time to the business.
- Assisted in defining application development project plans, project scoping, and project scheduling.
Confidential, New York City, NY
Solution Architect
Responsibilities:
- Led analysis of system landscape, application operation, technical issues, core business processes for all applications.
- Leveraged expert knowledge on customers’ business and migration activities and developed support services for new solution.
- Identified top issues of data quality reports and reporting gaps for critical modules in the Entota and Data Migration Framework.
- Recommended development to enhance/adapt existing services, business process, products and functions.
- Developed comprehensive “data” remediation plans for site teams and ‘in-house’ technical teams.
- Delivered onsite services as technical expert for broad area of topics related to the Data Migration Framework.
- Reported status, issues, and timelines to management staff and project teams.
- Directed site teams in problem resolution, evaluation and implementation of solutions.
- Provided support and training to other Business Analysts when needed and participated in site team review.
- Forged strong relationships within core business units.
Confidential New York City, NY
Project Manager / Delivery Manager
Responsibilities:
- Implemented new methodologies and procedures on the Data Migration team to stabilize the build for Record to Report / Revenue to Recognition (RTR), OTC, PTP, HCM, and PS.
- Conducted technology assessments for SAP and solutions in scope of the overall SAP ERP platform.
- Worked with the IT Finance function to ensure that accurate annual budgets are created, that finances are managed to meet the budget targets and for accurate expense tracking.
- Supported Application Benchmarking activities to ensure Total Cost of Ownership alignment within Confidential .
- Worked with the IT PMO function in order to consistently deliver SAP migration projects with a high level of quality and functionality that meets the business users’ requirements.
- Recommended changes to the ETL architecture and system landscape to meet Confidential ’s project’s migration, data analytics and data governance requirements in terms of performance, availability and reliability on a global basis for three years.
- Rearranged the team structure and developed resource recommendation plans for current and future implementations.
- Interpreted business requirements and translated them into technical requirements for the migration team to execute against.
- Led the cutover planning in terms of key tasks, precedence order of activities and deliverables in the Data Migration area.
- Executed a successful Go Live strategy with minimal issues for the Client’s LatAM implementation.
- Triaged and prioritized defects in HP QC based upon the new data migration methodology.
- Directed offshore resources to setup additional migration environments and support key load activities.
- Mentored members of the conversion team with Data Migration Best Practices and Procedures.
- Worked with Basis teams to modify existing load programs to improve performance and shrink the cutover window significantly.
- Partnered with the leaders of RTR, OTC, PS, and PTP within the Project Delivery Services organization, to leverage their expertise and to engage their resources needed for the programs approved by the business.
- Facilitated knowledge development for team-members in SAP Data Migration Best Practices and for third-party tools deployed at Confidential to support the business processes.
Confidential, New York City, NY
ETL / Data Architect
Responsibilities:
- Conducted system analysis while considering the business implications of the application of technology to the current and future business environment.
- Evaluated potential data migration tool providers for content, performance, gaps and expertise.
- Architected a new cleansing and ETL solution leveraging SAP Data Services for future data migration.
- Demonstrated the ability to plan, run, and support blueprint workshops/meetings with internal and external clients.
- Designed & developed the Data Integration framework for migration of disparate data from many non-enterprise legacy systems.
- Assimilated and directed application architecture and develop ETL components that properly integrate with it.
- Developed code that promotes reusability, maintainability and good, scalable performance.
- Addressed integration needs across process streams to design high quality solutions to meet the functional requirements
- Led end-to-end business focused strategic SAP transformation activities for Tier 1 and Tier 2 SAP solutions including organizational functions, governance, and implementation planning/road mapping.
- Developed full SDLC project plans to implement ETL solutions, as well as resource requirements both external and internal.
- Promote and deploy code using standard release management tools; must be comfortable with techniques that leverage
- Conducted code reviews and mentored junior resources.
- Supported application development through system testing and user acceptance testing, bridging the gap between business rules and technical implementation when necessary.
Confidential, New York City, NY
Global Data Conversion Lead / Project Manager
Responsibilities:
- Executed on the data conversion plans, strategy and methodologies as well as the cutover plan successfully for two Go Lives; the best Data Migration Go Lives the client had to date.
- Directed and tracked deliverables related to the SAP ECC 6.0 data conversion process.
- Drove the data cleansing, data governance, data testing, data load testing, and reconciliation process for multiple SAP wave rollouts, some of which were run in parallel to each other.
- Implemented active and passive master data governance routines.
- Managed the transformations, value mapping, and loads for customers, materials, vendors, RTR, RAR, P2P, FICO objects such as G/L, A/R, A/P, Revenue Recognition, Project Systems Long Texts, and Employees.
- Provided the project team updates to key stakeholders, leveraging strong presentation skills.
- Handled offshore resources to the deliverables and timelines for Data Loads and Data Mapping
- Mentored junior and senior members of the conversion team with Data Migration Best Practices and Procedures.
- Worked with Basis teams to modify existing load programs to improve performance and shrink the cutover window significantly.
- Clarified and validated data mapping and transformation specifications with the functional teams and agency.
- Created new business processes to engage the business and functional teams early and provide visibility and validation to the work being undertaken,
- Instantiated a process to review all mappings and make recommendations to the functional teams for business rule changes or data enrichment.
- Identified areas of risk and mitigated obstacles appropriately.
- Managed the extracts and connections to various legacy databases and files such as PeopleSoft, SAP, Excel, Hyperion, etc.
Confidential, Houston, TX
Team Lead / Senior Master Data Consultant
Responsibilities:
- Leveraged SAP Data Services Best Practice Templates (BPDM) / Rapid Deployment Solutions (RDS).
- Collaborated across the organization in all business segments in process design, optimization and management to direct data migration and master data governance processes across the enterprise with the ability to address technical and non-technical issues.
- Developed and aligned solutions effectively by leveraging technical function expertise within: architecture, blue-printing, data analysis, business modeling (logical and physical), functional design, technical design, application development, assessment, integration, and enablement.
- Utilized SAP Solution Manager to house and track all final documents.
- Performed hands on data assessments and mapping activities, and architected the underlying migration framework to extract, transform, validate, enrich and load the legacy source data from diverse repositories and technologies to SAP environments using Business Objects/Data Services.
- Clarified and validated data mapping and transformation specifications, and translated into a working and testable ETL implementation leveraging SAP Data Services.
- Designed, built and tested ETL components, including both common functions (e.g., surrogate key generation, error handling, audit, data cleansing, change data capture, data harmonization), and subject area-/extract-specific processing using Data Services.
- Developed several LSMW programs to load data to create augment and delete within SAP modules.
- Created LSMW programs for customers, materials, vendors, P2P, FICO objects, CMIRS, Long Texts, and Employees.
- Leveraged one or more leading ETL tools or platforms, such as SQL Server 2000, SQL Server 2005, SAP Data Insight and SAP/BOBJ Data Services for data migrations.
- Planned and managed the efforts of technical developers to include troubleshooting complex SQL code and data definitions and interface designs with the technical teams.
- Evaluated SAP Master Data Management solutions SAP MDM and SAP MDG solutions for the platform of Data Governance at Halliburton.
- Analyzed data contained in source/target databases and identify cross-system data integrity issues and identify business rules to build applicable queries and processes using Data Services Designer 3.2 and 4.0 Clients.
Confidential, MA
Senior Consultant / Team Lead
Responsibilities:
- Managed the SAP project activities, data implementation, and migration of SAP R2 and Inca data to SAP CRM 7.0 system with a WEBUI front end for eCommerce solutions to include fifteen months’ experience with the latest versions in SAP: CRM 7.0, and ECC 6.0.
- Provided consultative advice and support for SAP data migrations in the following areas of SAP: Sales and Distribution (SD); Customer Master-CRM; Customer Master-ECC-R/3; Customer Hierarchies; Points of Use; Supply Chain Sector/Territory Management; Employees; Trillium; Credit Management; Dunning Procedures, GTS, Vendavo, and Materials Management.
- Spearheaded the requirement documentation and data migration from legacy SAP CRM 6.0 to SAP CRM 7.0 for customer, contact, contact relationships, marketing attributes, customer roles, installed base and product catalog objects.
- Headed the Vendavo requirements gathering and data migration for SAP Vendavo system in relation to the new SAP ECC 6.0 Pricing module requirements and its impact on the data and synchronization for Vendavo.
- Guided the data migration from legacy SAP ECC for Order to Cash (OTC) Objects to include Material Exclusions, Batch Search Strategy Customer Material Information Records (CMIRS), Pricing Strategy and Sales Orders.
- Worked across cross -functional and cross-cultural teams with varying levels of the organization structure of multi-national corporations, often onsite, in various countries and regions.
- Oversaw customer master data migrations from legacy SAP ECC, Legacy CRM, and legacy Inca databases to the latest SAP ECC and CRM 7.0 solutions.
- Directed the data migration team for Sales and Distribution in SAP CRM 7.0 and ECC 6.0 for client’s multi-country consolidation of ECC R/2 and ECC R/3 systems for Batch Search Strategy, Material Exclusions, Customer Info Records, Contacts, Customers data, Customer Relationships, Employees, Vendors. Order to Cash, Materials Management, Product Hierarchies, Installed Base, Product Catalog, Pricing, Customer and Pricing Hierarchies, and SAP GTS data.
- Led the data migration team for Customer’s Sales Objects in SAP CRM 6.0 and ECC R/3 for client’s multi-country consolidation for Italy, Spain, Portugal, Denmark, Sweden, Norway, Finland, Iceland, Germany, Belgium, Export and Kay databases including new system commencement.
- Developed several LSMW programs to load data to create, augment and delete within SAP modules.
- Created interface programs for customers, Business Partners, Materials, Hierarchies, SalesOrgs, Relationships, CMIRS, Batch Search Strategy, Long Texts, Marketing Attributes, GTS Foreign Exchange, Territory Management, and Employees.
- Created and/or LSMW, BDC, direct load, BAPI, XML and sm35 sessions to load various data in SAP.
- Collaborated on the SAP GTS 6.0 data migration to GTS 8.0 migrations with the core ITO center in Europe regarding their ECN and HTS legal regulations for country dependent and country independent systems.
- Assisted the data migration for Customer’s Sales Objects in SAP CRM and R/3 for the client’s multi-country consolidation for Switzerland and Netherlands including Go Live.
- Trained client resources in BOA’s Software and Methodology to enable them to continue with project rollout to future countries.
- Exhibited strong knowledge and experience with SAP Data Quality, SAP Data Migration and SAP Data Governance Solutions.
Confidential Cranbury, NJ
Director, Sales Administration
Responsibilities:
- Directed the development and content of L’Oreal Paris’ Cognos Business Intelligence initiatives to include: setting Sales reporting strategy; convening internal and external task forces; gathering requirements; establishing key metrics; deciphering mission critical reports; reviewing data warehouse architecture development and subsequent reporting; providing for quality control testing; coordinating and evaluating system pilots, training, rollouts; monitoring progress and milestones.
- Led cross functional teams consisting of Field Sales, Commercial Finance, Information and Control, Claims, and Sales Administration for nine months to reengineer the existing Trade Promotion Management process by providing planning tools to scrutinize budget spending before it occurs to ensure conformity to financial metrics and business rules.
- Managed the Gelco Trade Promotion Management System, which included working closely with an outside vendor, maintaining data integrity in the system and providing the division with Trade Promotion management reports.
- Developed new Trade Promotion Planning tools using VBA in Access and Excel to improve data quality and data governance in managing multi-million dollar budgets for the field force with the ability to forecast their promotional activity and track their performance versus their plan.
- Worked to integrate third party data to include competitive ad tracking and syndicated data into databases and analyses.
- Introduced new tools and analytics leveraging Excel and Access VBA to standardize and automate account Business Development Plans to alleviate field manual entry, establish tracking mechanisms and providing ROI analyses in a dashboard format.
- Implemented new field sales incentive compensation programs that standardized incentives across the field organization, reduced lead times and improved the accuracy of quarterly payouts.
- Coordinated the division’s quarterly sales meetings, by recommending sites, working with hotel staffs and outside support groups, and ensuring that each aspect of every meeting is handled in a professional manner.
- Analyzed and computed quota requirements for the field sales team by developing forecasts using various mathematical methods while building consensus with Category Vice Presidents, Field Sales and Commercial Finance.
- Managed, developed and guided the management team in Sales Administration by instantiating development plans for all managers and subordinates and monitoring their progress monthly. Promoted three members of my team during that time to senior analyst, manager and assistant manager.
Confidential Manhattan, NY
Senior Manager, Sales Systems
Responsibilities:
- Spent eighteen months spearheading the SAP CRM and SAP Master Data Governance initiative to ensure CRM software applications, reporting solutions, help desk and hardware service levels fulfilled field sales force needs.
- Directed compensation processes to include timeline creation, program enhancements, and data quality safeguards.
- Overhauled compensation process by redesigning goal setting methodology to a web based data governance process, removing burden from field sales managers while increasing field confidence on compensation processes.
- Managed Sales Systems budget by monitoring costs and performing ROI analyses to justify budget increases.
- Implemented web enabled software solutions that significantly improved call data reporting accuracy and consistency within administration and operations, fostering cooperation among various groups.
- Restructured Sales Operations Department by evaluating vendors, negotiating pricing and contract, and implementing system (IQ, OQ, PQ), which improved compliance with PDMA guidelines and saved two million dollars over three years.
- Built consensus with internal departments (Marketing, Direct Mail, Informatics and Sample Compliance) to ensure integrated data, reports, and analyses met field sales force requirements.
- Negotiated and monitored service level metrics for all aspects of field automation and support services including helpdesk, hardware asset management, technical support, customer service, and database management.
- Recruited, trained, coached and mentored operations staff consisting of four managers, five business analysts, twelve customer service reps, fifteen data entry clerks and four technical coordinators. Promoted members of my team to analyst, senior analyst, supervisor, assistant manager, and manager over the three years of my tenure.
Confidential
Manager, Sales Force Automation and Call Reporting
Responsibilities:
- Lead the successful rollout and maintenance of five major CRM systems from 1998 to 2002 to include: convening CRM field task forces for managers and reps; spearheading evaluations; performing negotiations (service levels & software licenses); gathering requirements; hosting application design sessions; reviewing data warehouse architecture development and subsequent reporting; integrating home office systems; providing for quality control/unit testing; coordinating and evaluating system pilots, training, rollouts; monitoring timeline progress and milestones.
- Assumed management of legacy Sales Force Automation (SFA) system, increased system performance, data governance and vendor effectiveness while transitioning to a new platform.
- Increased sales rep confidence in compensation process by improving data integrity and data governance in the Physician Address Reassignment System through address standardization, deduplication and data cleansing intiatives.
- Implemented a paper scanning system for physician sample receipts to improve efficiencies and regulatory compliance.
- Managed the Sample Compliance and Internal Audit Departments to ensure compliance with the Prescription Drug Marketing Act, 21 CFR Part 11 and the FDA Final Rule in December 2000.
- Coordinated seven field sales force expansions to include project plans; POA changes; territory alignment changes; CRM system changes; SAP ERP Integration; VBA script updates; CRM training; PDMA training; territory management training; and report design changes.
Supervisor- Sales Reporting, Sales Compensation
Responsibilities:
- Implemented new Data Governance processes through organizational structures, documented performance standards and job functions that greatly increased the output of the Call Reporting, Internal Audit and Sample Compliance groups while meeting compliance with PDMA rules.
- Improved help desk and asset management service levels to field users by increasing the knowledge level of internal areas.
- Designed MS Access Business Intelligence reporting databases and applications for hospital sales managers to monitor sales rep call activity.
- Planned many new training programs for the hospital sales force executed at regional meetings.
- Trained sales reps on compensation processes, compensation reports, call activity reports, Microsoft Office and Windows.
- Developed extensive algorithms using VBA in MS Access to set quarterly territory sales goals by product and market.
- Created applications leveraging VBA to capture divisional hospital manager decisions to set quarterly hospital territory alignments.
- Re-engineered the compensation process by developing Microsoft Access applications in VBA to set physician address and territory alignments and improving Data Governance processes.
Sales Analyst
Responsibilities:
- Prepared, analyzed and disseminated product market share analyses for five pharmaceutical Rx markets.
- Engineered thorough analysis of weekly sales rep call activity that became company standard for call activity tracking.
- Wrote and published quarterly incentive plans and tracked sales rep and sales manager progress to those plans.
- Developed Excel applications using the VBA programming language to set compensation alignments based on IMS data.
- Created Excel applications to query Sybase SFA databases to extract data on a geographic basis to be used by field sales.
- Analyzed field sales call activity and impact on Rx growth.
Confidential, Plainview, NY
Sales Analyst
Responsibilities:
- Leveraged Lotus macros to set quarterly preliminary quotas based on high-level corporate allocations.
- Analyzed quarterly quota attainments.
- Submitted recommendations for quarterly budget allocations.
- Structured, maintained and approved commission paychecks for third party brokers.
- Prepared and distributed quarterly market share reports and analyses.
- Converted all spreadsheets from Lotus to Excel 5.0 macros streamlining internal processes.