Business Analyst Lead Designer
Resume:
Resume: Glen Silverman
*****.*********@*****.***
Work Summary:
A diverse background as business, systems, data analyst, developer and since the beginning of pandemic, assigned role as Morgan Stanley’s Lead SME Tier-3, Tier-4 Excel/VBA Global go-to support person.
Heavy experience as developer of complex Excel/VBA apps with embedded SQL that connect with all major DBMS’s to include live data-feeds with realtime internet information providers such as Bloomberg, Reuters, local internet web-farms and cloud based data.
Dependable, easy-going, adapt quickly, multi-task, and steady under pressure… Adept at stepping in, filling gaps, solving problems and remaining calm. Comfortable working with all levels of management and organization… Affinity for detail. Strong business acumen. Solid written, speaking, listening, presentation, and communication skill to include documentation, and technical writing…
Application Experience:
Extensive technical background working exclusively with Excel/VBA SQL technology platforms for much of my career... In health insurance industry, built what are considered next generation Risk, Rating, Pricing, and Reserve Projection applications. Financial apps to include GL, AP, AR, PNL, Planning, Budget, Spend, and Runout … Experience in all areas of investment banking to include Risk Management, Surveillance, Basel, AML, KYC, On-Boarding, Econometric Modeling. Trading Apps that support Equities, FX, Treasuries, Spreads, Rates, Yield-Curve, Fixed Income, and Derivatives. Also FO, MO, BO, Post-Trade (DTCC) apps.
In manufacturing, considerable understanding and expertise with all phases of ERP, S&OP, MRP, Supply-Chain, BOM, W/U, Demand Management, QC, Inventory Control, Warehousing, Distribution, and Logistics... Developer of rule-engines, statistical forecasting, and predictive modeling. Developed early warning capabilities across a broad spectrum of industry with sensitivities to live data that raise an alert when actual data trending skew with forecasts…
Performed work for TV Guide, a global RAD initiative to automate receipt of television schedules and programming information sent to us from local broadcasting companies from around the world in widely varied formats. All are transformed into a common format, a huge initiative that feeds all of this content to the "TV Guide" enterprise database, then to the TV Guide publication and then distributed digitally to cable set top boxes here in America, Europe, Asia-Pacific, and someday to every cable and set top box, everywhere... https://www.businessinsider.com/the-most-important-media-tech-company-you-dont-know-rovi-2011-1
Company Overview:
•Morgan Stanley (MS) – NYC. Contract/Fulltime, during COVID WFH. (onsite Sep 2015 to March 27, 2020, March 29 to Present WFH)
•Walmart ongong tasks (remote) IT MS Excel weekend projects during newest outbreaks of COVID-19 ( Oct 5 to Present)
•Walmart (Arkansas Hdqtrs) Remote; MS Excel weekend projects (July 13 to Oct 2, 2020 )
•Young Conaway Law, Wilmington weekends (May 4 2020 to Jun 26 2020 )
•MFX Fairfax / IronShore P&C – NYC, Morristown, NJ (May 2013 to Sep 2015)
•Merrell Lynch (November 2012 to May 2013)
•TV Guide (ROVI) (June 11, 2012 through November 2012)
•Bank of Tokyo, Mitsubishi Securities, NYC (February 6, 2012 thru early June 8, 2012)
•Teleflex Medical Implant and Instrumentation Corp (Sept 19, 2011 to Feb, 2012)
•EmblemHealth Insurance Companies, NYC (April 2009 to September 16, 2011)
•JP Morgan Chase / Bear Stearns, NYC (March 2008 to April 2009)
•Bear Stearns, NYC (October 2005 to March 2008)
•CitiGroup, NYC (June 2005 to October 2005)
•XL Capital and RE-Insurance, Stamford CT / NYC (March 2005 June 2005)
•Advent Capital Management, NYC (November 2004 to March 2005)
•Imperial Chemical Company Somerville, NJ (June 2000 to November 2004)
•Unilever, National Starch and Chemical Company, NSC (September 1999 to June 2000)
Education:
University of Pennsylvania. Bachelor of Science, Mathematics (Quantitative Methods), Computer Science…
Expert skill with Excel formula to include intricate array formula, VBA, VBScript, PivotTables, PivotCharts, PowerPivots, Spark-Lines, and HeatMaps. Heavy Experience with Shared Excel Workbooks and formula that connect large networks of externally linked workbooks. Developed workbook applications that support the culling and filtering of hundreds of thousands of rows of reference data where use of advanced performance and optimizing techniques essential in making this kind of workbook feasible to include trading applications with frequent real-time refresh rates of live ticker data. I developed Excel UI/UX (special effects), data visualization and productivity techniques not typical on Excel nor other BI platforms. An example might be an executive, the CEO, clicking a segment, a Y datapoint on a dashboard line-chart, and a small-sized window, a drilldown, is made visible that hovers above the chart containing the actual data attributed to the datapoint. Essentially it anticipates the typical questions and curiosities a CEO might have when viewing his/her dashboard especially a datapoint that appears skew... What caused it to be skew? Also with VBA, I developed ability to add content to the Excel Help Facility (on menu ribbon) as a way to meet documentation standards for the scores of in-house custom worksheet functions I was asked to develop. Essentially I leveraged the same API Excel uses when it presents How-To help information for it’s standard Excel formula. Doing these kinds of things with Excel and VBA generated much enthusiasm with the IT team I worked with. Helped client grasp what they believe are Excel’s boundless capabilities. That it could advance client’s effort to achieve a more seamless Excel UI/UX experience also appreciated…
Technical Skills: Advanced Excel/VBA/SQL, macros, VBScript, Add-Ins/API, Word VBA, Heavy SQL with ADO / ODBC connectivity with MSAccess, Oracle, Sql-Server, BI, Sybase, DB2, and SAS (with IOM), most every DBMS... JIRA, Scrum, Agile, ETL data migration, Cloud based apps (Azure, AWM), Heavy skill with ADO, CDO, QlikView, Adobe PDF ToolKit, Cognos, Tableau, XML, API, Sharepoint, Java, R, Python, VSTO,
.Net, VB, C#, MS-365, MS-Project, Word, Outlook, PowerPoint, Visio, OOP programming style … Note: Visual Basic aka VBA and VBScript
Heavy office-automation to include use of VBScript, Excel/VBA, Application.Ontime timer events, Task Scheduler, extensive Word/VBA (a very rare skillset) with sophisticated bookmarking to support mass communication, distribution of normal mail and eMail... Also with VBA and (OLE) Outlook from within Excel, developed ability to send large volume of meeting invitations, appointments, and customer promotional email along with attachments for one of world’s largest discount retailers, a high pressure role working under considerable time constraints during more recent regional spikes and outbreaks of COVID-19… Discussed in more detail on last page of resume.
Business Analyst :
A business, systems, data analyst, and developer with heavy experience in all phases of SDLC and adaptations of SDLC for RAD projects and strategic initiatives. Heavy experience writing clear, concise business need documents, BRDs, working directly with executive, senior management, stakeholders and the many operational areas, multi-tasking the many initiatives… Wrote Functional Requirement Documents, FRDs, using Agile, Scrum along w/ techniques such as Use-Case, DFDs, and functional decomposition. Heavy experience producing System Requirement Documents, SRDs, to include look-and-feel detailed models of solution, in many cases, I developed proofs of concept also known as concept cars, useable working models of solution with use of Excel working in RAD mode much of the time with connectivity to one or more backend databases and real-time information providers. Many SRDs include staffing plans and outlines of estimates for resources needed to carry out a project, extrapolating from this the costs with each approach, time-lines for each approach, and risks associated with each approach. Adept at obtaining consensus and sign-off with stakeholder(s) at each milestone and each phase of SDLC. Performed numerous Gap-Analysis as assurance important functionality if replacing an existing process (computerized or manual), not overlooked. All phases of SDLC, second nature to me. An experienced JAD facilitator on numerous projects.
Data Analyst :
Formal study of data normalization, data modeling, and database design and as an IT DBA considerable experience designing and building relational databases with considerable scale and complexity. Some examples of large initatives, data modeling and analysis follow…
In manufacturing built and performed studies with databases with millions of rows of historical data testing for trend, cycles, interval, amplitude, seasonality, a distinguishable signal. Built many automated model fitting and back-testing processes that determine which of many forecasting methodologies (triangles, time-series techniques, Bayesian Linear techniques, single, double, and triple exponential smoothing (choosing optimal smoothing constant sets) is best suited product-by-product to produce forecasts SKU specific, that feed a production planning process for multi-national company that manufactures 10s of millions of pounds of product each month. Knowing which products to make, when to make them, in what quantities to make them and where to inventory them (warehouse distribution) in an industry that is always capacity constrained, has direct impact on logistics costs and company’s bottom line. The accuracy of a forecast isn’t just a function of the arithmetic one uses to produce a forecast, it’s also a function of the preparation, organization and quality of the data it feeds from (described more fully below). I developed many fully automated data modeling and model fitting techniques to identify what specific forecasting method to use in each of the varied products company produces, sku specific, where each sku exhibits unique trend, cycles, and seasonality.
In a leading health insurance company it was my finding that of the millions of rows of claims history analyzed each month that in order to more accurately calculate future claim reserve projections, data must first be organized in homogeneous cohorts (projection cells) of data where each grouping of insureds share a like profile with common characteristics. This is a rigorous data analysis process using methods such as branching, segmentation, decomposition, multiple regression, and trend correlation of many datasets of data. Was able to demonstrate with empirical findings that data when organized in this manner produces greater correlation, stronger trend, is more predictive, and quantifiably does consistently produce accurate reserve projections. Projections are rational, sensible, explainable. Spin-off adaptations of this technique were carried forward into a new generation of risk, rating and pricing of insurance products as a secondary project at EmblemHealth, NYC...
And throughout my career, my experience with data conversions, mappings, data migrations, ETL during startup of new apps or ongoing feeds from-to legacy platforms, or handshakes with other systems is considerable. Some examples would be my experiences at Emblem- Health, Teleflex, the JP Morgan-Bear Stearns merger, TV-Guide, and here with Morgan Stanley. These are critical sometimes very complex processes that require sophisticated safeguards, control-reports, and exception detection (recycling capability) to assure data integrity. Described in detail on long version of resume, the complexities include language, coding differences (encoding/decoding), and currency transliterations...
Fast Response, Problem-solving and troubleshooting: Considerable experience as go-to person addressing urgent problems, such as broken spreadsheets on a trading floor and urgent RAD reporting needs with tools like Qlikview, Tableau, Cognos, Crystal, especially Excel, sometimes at the highest levels of an organization… A lead Excel/VBA global support SME at JP Morgan and Morgan Stanley…
Heavy experience addressing remediation, conversion and migration issues across Excel 97-2003, Excel-2007, Excel-2010, 2012, 2013, and 2016 platforms where multiple versions of Excel in concurrent use company-wide. Developed numerous Excel tools, some that solve performance issues, others that perform sophisticated workbook comparisons (current-to-prior version), fully-automated, that scan formula and all properties that live deeper inside the workbook, in worksheets, in cells, range-names, conditional formats, validation lists, data connections, pivot-tables, charts, spark-lines, and this includes comparisons of VBA code, using VBA code (VBA code that looks at VBA code) looking for modifications that may’ve caused or contributed to a broken, mis-behaving, and/or corrupted workbook. Many sophisticated tools and applications like this developed at Morgan Stanley… For me, a perfect blend of large development initiatives, desktop support, and rapid deployment as SME Excel/VBA go-to support person. This kind of role has always been a very fullfilling and rewarding part of my overall career and work experience…
HR/HCM Projects: Numerous projects as developer to assist HR with Budget, Staffing Plan, Salary Plan, Employee review/rating, census collection. A template, essentially, an Excel workbook, one per profit/cost center location allowing for cross border currency differences. Also salary increase and bonus funding pool attribution process using KPI as predicates. Developed payroll compliance reports with sensitivities to diversity and descrimination in its many forms…
Lead developer of Autonomous Self-learning (machine learn) robot RPA technology w/live instantaneous data feeds, real-time (Bloomberg, Reuters, amongst the many realtime internet information providers) on Excel/VBA SQL platform. Designed to self-install; attach to an existing Excel app; Essentially an Addin(API) that Is up and running wihin a matter of seconds. It Self-Study's live data using ANOVA, qualitative, quantitative, Bayesian, and algorithmic statistical methods. A true robot that replaces spotters, staffing that otherwise watch (stare at) computer monitors. Learns on its own "what normal looks like". Wherein it gains all by itself a familiarity w/live data, an innate ability to Identify anomaly, actionable events, new normal moments and communicates the observed event instantly to SMEs, stakeholders, and actionaries (the decision makers) with relevant charts, snapshots of cells (before/after), and artifacts that tell the story via email, of what triggered the alert. It does this with use of embedded HTML and Outlook object. It could be a trade opportunity that it spots instantly, reacts many moments faster than a person watching a live stock ticker. Considered essential, an important competitive advantage for company, risk management, and trading desks. http://www.linkedin.com/in/glen-silverman-4552bb114
Mail-Merge, Letters, eMail, Invitations, attachments notifications, Forms, artifacts, Contracts, and personalized document distribution Built numerous applications leveraging use of PDFs, PDF-ToolKit, VBScript, Excel/VBA, Microsoft Word, Outlook HTML(OLE), and sophisticated Bookmarking, using Excel/VBA, sometimes VBScript to produce volumes, sometimes thousands of important, time-sensitive, documents, email, invitations, and appointments with attachments in a wide range of industries.
Also use of heavy office-automation at major retailer with use of Excel/VBA, extensive Word/VBA (rare skillset), with sophisticated bookmarking for mass mail-merge to include sending 10’s of thousands of regular individualized mail, a real challenge w/ considerable pressure, also sending mass email also individualized with attachments, and Outlook meeting invitations w/ HTML also with attachments for Walmart (Arkansas), having one of world’s largest IT departments, a high pressure role working under considerable time constraints during regional peaks in COVID-19, spikes and outbreaks… I did this to assist Walmart’s massive IT Department, less skilled in this area, to get this done… And did this type of work many times at many companies such as Cenlar throughout my career.
Work Summary (other):
University of Pennsylvania. As student also worked as counselor to fellow students – This was the 1st year that Penn integrated scientific programming (PL1/Fortran) with math curricula... Also provided scientific computer programming support for research projects funded by Penn, the Federal Gov’t, NASA, and companies like GE and IBM at UCSC, 3401 Market St, Phila at that time the University’s campus-wide computer center also serving Drexel University …
Longer detailed version of resume available on request….
Contact this candidate