Desmond P. Email & Phone Number

Claymont, De, Us

Delaware, United States

Miami

Washington D.C. Metro Area

Buffalo/Niagara, New York Area

• Query Optimization: Increased the data retrieval efficiency of the Maximo application up to 40%, by analyzing over 10,000 private SQL queries and replacing them with faster dynamic SQL queries.• Conceptualized the use cases and prototyped mobile application for facility management team using 2 different platforms, namely Microsoft PowerApps, Salesforce, and effectively communicated the findings to business.• Identified exceptional cases, outliers in production data and created reports on data trends using SQL.• Examined gaps in the existing data model and managed changes to meet requirements of various downstream business units.• Recommended technical feasibility solutions for process and technology improvement of Maximo 7.5.• Collaborated in design and development of a multi-page report for work order statistics using Eclipse Business Intelligence and Reporting Tools (BIRT).

Bengaluru Area, India

• Facilitated data management by collaborating with internal and external teams to extract, validate, aggregate, and manipulate the dataset containing 200 million business records to create reports, insights, recommendation, and predictive scores.• Liaised between the business users and development team to ensure proper decision-making on master data creation, data standardization, and data accuracy.• Involved in the creation and maintenance of file specifications, data modeling, data profiling; source to target data mapping and future data needs.• Analyzed technical requirements and translated it to highly analytical, technical solution for retrieval and analysis of data in the form of products like SBRPS, Data append, Market Insight, and Customer Insight.• Proactively implemented the automation of complex process using SAS and JCL, which processed up to 3 million records in short time, thus eliminating human errors (up to75%).• Automated the creation of monthly transactions processed source data using SAS, thus reducing the pre-processing time by 2 hours.• Utilized SAS and Tableau for effectively manipulating data to produce descriptive statistics and data dashboards.

Master’S Degree, Computer Science

Activities and Societies: Catholic campus ministry

Bachelor’S Degree, Electrical, Electronics And Communications Engineering, 73

Activities and Societies: Sports, Team Management and organizing, Music-Very active in sports, representing my college in Wrestling, JUDO.