Mike Perlstein Email & Phone Number

Levittown, Pa, Us

Falls Church, Virginia, Us

• Serves as Project Lead recognized as a functional and business process subject matter expert formultiple DLA medical supply chain applications• Directs the day-to-day activities of the technical project team (.Net Developers, DatabaseDevelopers, Analysts) involved in Web-based application development• Manages multiple projects through the Application Development Lifecycle and all associatedManagement reviews• Authors advanced SQL/PLSQL to effectively query and navigate across multiple data domains to produce data analysis findings, utilizing complex joins, subqueries, analytical functions to return clean, comprehensive, and relevant datasets.• Experience with data collection through APIs and JSON/XML data• TOAD, Azure DevOps/Visual Studio, Visio, Project

Rockville, Maryland, Us

• Complex analysis and in-depth understanding of client functional business processes and data that enable the client’s business to be executed• Understanding the existing database design (logical/physical) that support complex business processes/applications• Authoring advanced SQL/PLSQL to effectively query and navigate across multiple data domains to produce data analysis findings, utilizing complex joins, subqueries, analytical functions to return clean, comprehensive, and relevant datasets.• TOAD, Azure DevOps/Visual Studio, Visio

Philadelphia, Pa, Us

• Lead Comcast's "Know Your Customer" Robocalling initiative to identify potential nuisance callers/spoofers/scammers at a Residential and Commercial level; identified customers sending Comcast poor quality/risk-laden traffic at the Wholesale level• Extracted, transformed, loaded (ETL), and analyzed data to prepare multiple internal and FCC/external reports including the FCC 477, Robocalling mitigation, EEO, Excludable Events, Must Carry, Urban Rate Survey, CRM Monitoring, and Complaint NLP analysis• Performed internal audits on other regulatory reports (FCC 499) and provides data/analysis for ad hoc state requests• Prepared a multitude of Tableau dashboards to illustrate information derived from large data warehouses/data lakes • Analyzed node boundary and census block GIS mapping to ensure accuracy of serviceability reporting• Utilized Advanced SQL, Alteryx, R, and Excel skills to extract and transform large data sets to retrieve valuable information

Toronto, On, Ca

• Leveraged Business Intelligence knowledge to identify process inefficiencies and proposed solutions backed by evidence derived by data analysis• Developed a multitude of weekly/monthly/quarterly Excel reports from a large ATS database and external databases containing VLOOKUPs, Pivot Tables/Charts, PowerPivot data validation, macros, conditional formatting, and many other formulas/functions• Provided ad hoc reporting to a wide audience ranging from associates to executives• Continually updated, optimized, and adjusted previously developed reports to adapt to changing needs• Monitored job catalog and reimbursement mailboxes to help ensure process efficiency and accuracy

Toronto, On, Ca

• Analyzed, manipulated, and tracked experienced hire recruiting operations data for various reports to adhere to OFCCP regulations and standards • Assured proper and accurate documentation within job requisitions and candidate profiles• Created partnerships between KPMG and Veterans and Disabilities centers nationwide• Developed and managed career events with Veterans and Disabilities centers to attract veterans and those with disabilities to career opportunities with KPMG

• Continued work from previous summer• Learned how to use BusinessWorks software efficiently

• Worked closely with management to understand logistics of company• Job cost all aspects of ongoing roofing projects, including labor, material, equipment, trash removal, warranties and overhead. • Forecasted profitability in ongoing projects and compared end costs against estimated costs, as projected by project estimator• In direct contact with the General Contractor(GC) in regards to required business procedures in billings, insurance requirements, safety requirements and release of lien waivers, as needed, per the Contract between RRR and the GC.

Master Of Science (M.Sc.), Business Intelligence & Data Analytics

Bachelor Of Science - Bs, Economics

Bachelor Of Science - Bs, Management

Education record