Data Migration consultant to various airline operators guiding their IT staff to transition their legacy aircraft maintenance systems to the Swiss Aviation software platform named AMOS which specializes in aircraft maintenance.SQL Server Management Studio is used to import legacy data from the airline operator’s legacy system(s), transform the data into AMOS specifications and load transformed data into AMOS * Developed ETL standardization script templates and sample data… Show more Data Migration consultant to various airline operators guiding their IT staff to transition their legacy aircraft maintenance systems to the Swiss Aviation software platform named AMOS which specializes in aircraft maintenance.SQL Server Management Studio is used to import legacy data from the airline operator’s legacy system(s), transform the data into AMOS specifications and load transformed data into AMOS * Developed ETL standardization script templates and sample data architectures which enable airline operator IT staff to simplify business processes and data mappings needed to reduce data migration complexity* Developed scripting methodologies to track data manipulations, across migration iterations, to properly document transformations which help airline operators adapt their business processes to the newly migrated AMOS architecture* Provide migration training to IT staff and key business users to ensure data transformations are in line with airline industry standards* Provide ongoing data support to various airline operators by developing customized scripting to achieve data manipulations, at scale, to improve data quality Show less

Used SQL Server Management Studio to liaison between heritage HPE Software and heritage Micro Focus to fully integrate customer and product portfolios across the newly combined company* Aligned 70% of the heritage Micro Focus Customer Master data sets by developing ETL standardization scripts and performed similarity scoring using Levenshtein and Jaro-Winkler algorithms in MDS SQL Server to approximate relativity and reduce data migration complexity* Achieved a 50% process reduction… Show more Used SQL Server Management Studio to liaison between heritage HPE Software and heritage Micro Focus to fully integrate customer and product portfolios across the newly combined company* Aligned 70% of the heritage Micro Focus Customer Master data sets by developing ETL standardization scripts and performed similarity scoring using Levenshtein and Jaro-Winkler algorithms in MDS SQL Server to approximate relativity and reduce data migration complexity* Achieved a 50% process reduction in migrated asset records by developing SQL script to identify and realign customer asset record details for import within SalesForce Inspector “Upsert” functionality* Built a data mart in SQL Server from SalesForce objects by developing SOQL object scripts to troubleshoot operational issues attributed to the system migration* Transformed Legacy SAP data sources into SaaS based target system formats enabling the successful migration of approximately $3B of Software License Support revenue* Reconfigured SQL Server instance Collation and underlying database tables to ensure accurate record retrieval and analysis of the case sensitive SalesForce data objects Show less

Used SQL Server Management Studio to pull data from HPE legacy systems in Hyperion Interactive Reporting Studio and coordinated data migration efforts with the Deloitte consultancy teams to transition SAP business systems to various Cloud-based platforms* Aligned with consultancy team to define source to target mappings between Legacy systems and Cloud-based systems to support distinct data migration paths* Documented data mapping business rules, restructured SQL Server DML code to… Show more Used SQL Server Management Studio to pull data from HPE legacy systems in Hyperion Interactive Reporting Studio and coordinated data migration efforts with the Deloitte consultancy teams to transition SAP business systems to various Cloud-based platforms* Aligned with consultancy team to define source to target mappings between Legacy systems and Cloud-based systems to support distinct data migration paths* Documented data mapping business rules, restructured SQL Server DML code to maintain data integrity and ensure business continuity* Consulted on six distinct data migration paths including Quote to Order, Asset Management, Fulfillment, Software Support Subscription, Order Management and Revenue recognition* Optimized data migration data sets by developing indexing scripts, implementing server Raid configurations to achieve reductions in data restructuring time and keep data migration efforts on track and on time Show less

Collaborated with Statisticians to develop and implement a Machine Learning proof of concept which achieved a record-breaking 24% prediction accuracy rate of projected customers within the first three months of a yearlong forecast. Integral in migrating a legacy fulfillment system to an enhanced Software Entitlement and Fulfillment system.* Developed ETL scripts to systematically restate order data to facilitate predictive algorithm requirements (Naïve-Bayes, ADA Boost, Random Forest, and… Show more Collaborated with Statisticians to develop and implement a Machine Learning proof of concept which achieved a record-breaking 24% prediction accuracy rate of projected customers within the first three months of a yearlong forecast. Integral in migrating a legacy fulfillment system to an enhanced Software Entitlement and Fulfillment system.* Developed ETL scripts to systematically restate order data to facilitate predictive algorithm requirements (Naïve-Bayes, ADA Boost, Random Forest, and Decision Tree).* Analyzed support service attrition through identification of customer interaction patterns and implemented reporting to mitigate support cancellations.* Tasked with building a Business Intelligence team in Puerto Rico which included qualifying candidates, interviewing, training and mentoring.* Guided a flawless reporting transition from the Bucharest, Romania office, accurately documented reporting requirements and technical specifications, and continuously augmented capacity through automation scripts.* Personally invested in and configured HP servers from a hardware and software perspective to better understand information solution throughput and achieve a better understanding of downstream effect in data mining efforts. Show less

Restructured Support Renewals pipeline applications by using the SQL Server Management Studio platform to augmented data visibility to a Worldwide level and across acquisition portfolios. Enabled cross-acquisition collaboration to increase customer share of wallet and customer satisfaction indexes. Allowed trending dashboard metrics to gauge organizational effectiveness. Developed 3 tier Support Renewals pipeline reporting application for HP Software. Enabled management to right size… Show more Restructured Support Renewals pipeline applications by using the SQL Server Management Studio platform to augmented data visibility to a Worldwide level and across acquisition portfolios. Enabled cross-acquisition collaboration to increase customer share of wallet and customer satisfaction indexes. Allowed trending dashboard metrics to gauge organizational effectiveness. Developed 3 tier Support Renewals pipeline reporting application for HP Software. Enabled management to right size operations headcount, assign sales force renewals quota, outsource support renewals and identify potential incremental sales opportunities* Transformed systems data to business specific terms which reduced sales force administrative work by 35%, resulting in focused sales motions that increased the probability of a sale and increased customer satisfaction indexes* Consolidated regional support service forecasting functions by developing and implementing a standardized forecast model across all regions that reduced administrative headcount by 71%* Systematically identified data flaws in Software Fulfillment data migration logic which allowed the team to make the necessary corrections in time for the project to stay on track for superior launch* Continuously augmented scope, amending and implementing business requirement logic changes to surface an integrated reporting environment that touched on a varied set of data sources* Coordinated/documented numerous interviews with business process SMEs and developed reporting applications using PC SAS that extracted data directly from reporting systems like Oracle, Business Objects WebIntelligence, and NeoView* Connected various data sources to generate sales force pipelines, reconcile sales orders against the pipelines, and ensure sales force assignments were aligned according to quota in order to track Sales rep performance Show less

Designed an information system for an international employment agency which collected transactional data and digitized documents.* Architected back-end management reporting through PC SAS to provide management with categorical new hire trends among clients.* Modeled Data Flow Diagrams, Entity Relationship Diagrams via Visio based on business process requirements.* Eliminated 25% of data entry time and errors by implementing bar code technology into the user interfaces.

Developed a customized Supply Chain Data Warehouse that unified various Legacy reporting environments, from an Industrial Engineering perspective, to understand manufacturing operations and mitigate costs associated with manufacturing pace.* Developed a PC SAS ETL application that would acquire data from 25 different Legacy reporting environments to enable management reporting. Reporting consisted of varied topics ranging from mitigating potential inventory shortages to out-of-sequence… Show more Developed a customized Supply Chain Data Warehouse that unified various Legacy reporting environments, from an Industrial Engineering perspective, to understand manufacturing operations and mitigate costs associated with manufacturing pace.* Developed a PC SAS ETL application that would acquire data from 25 different Legacy reporting environments to enable management reporting. Reporting consisted of varied topics ranging from mitigating potential inventory shortages to out-of-sequence assembly work.* Enabled management to plan workforce requirements based on replicated airplane manufacturing sequence logic.* Identified the costliest of airplane parts that required lengthy manufacturing times to mitigate potential supplier conflicts/fines due to increases/decreases in manufacturing pace.* Designed a SAS OLAP interface that would depict airplane cost variations based on customer customizations.* Systematically decreased data acquisition time from 3 months to 12 hours by automating the acquisition of manufacturing data and eliminated an additional 20% of data update time by developing a systematic diagnosis routine that would disseminate SAS system return codes to portable handheld devices.* Developed report dissemination routines that would output metrics in a variety of management defined formats. Show less